Query starts running slowly after a few days (no replies)
(MySQL.com) Hello!
After a few days of production our database starts hogging all CPU. The offending query seems to be this one:
mysql> explain extended select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where timer0_.ISSUSPENDED_<>1 and time