Skip to main content
added [slow-log] to 102 questions - Shog9 (Id=1924)
Link
Source Link
rsimoes
  • 233
  • 3
  • 8

MySQL slow query log: huge query time, no lock time, minuscule number of rows scanned

I have a slow query log item with the following:

Query_time: 55  Lock_time: 0  Rows_sent: 739  Rows_examined: 739

No one in my group can explain it besides a guess about packet loss. Is there a common cause or set of causes for result like the above?