Forum Stats

  • 3,815,049 Users
  • 2,258,952 Discussions
  • 7,892,913 Comments

Discussions

query suddenly go slow

keydbas
keydbas Member Posts: 27
edited Jul 30, 2020 9:50AM in MySQL Community Space

SELECT me.id FROM ActionRequests me WHERE ( ( action NOT IN ( 'R', 'r', 'q', 'u' ) AND ( ( host = 'uk-collection2' OR host IS NULL ) AND me.starttime IS NULL ) ) ) ORDER BY me.host DESC, me.priority DESC, me.job_id, me.id desc LIMIT 1 ;

this query getting in < 1 sec now taking 15 sec , nothing is changed so far

Answers