Re: Please help with slow easy query
Rick James Wrote:
-------------------------------------------------------
> Do you find the query in the Slowlog? If so, does
> it list a non-zero "lock time"?
so about query log there is some statements but their lock time is low (< 0.000198)
>
> load average: 13.50, 13.25, 11.97
> means that several things are hogging the CPU --
> probably not MySQL.
Only Apache and Mysql...
Subject
Views
Written By
Posted
4989
April 21, 2009 11:58PM
2309
April 22, 2009 02:10AM
2394
April 22, 2009 03:27AM
2277
April 22, 2009 07:02AM
2303
April 22, 2009 09:37AM
2277
April 22, 2009 10:31AM
2429
April 22, 2009 12:22PM
2260
April 23, 2009 12:16AM
Re: Please help with slow easy query
2090
April 23, 2009 03:27AM
2157
April 23, 2009 02:20AM
2930
April 23, 2009 03:25AM
2331
April 24, 2009 07:18AM
2187
April 25, 2009 01:42PM
2134
April 25, 2009 04:34PM
2300
April 27, 2009 09:28AM
2147
April 27, 2009 09:47PM
2046
April 28, 2009 09:16AM
2282
April 28, 2009 09:34AM
2170
April 29, 2009 09:44AM
2687
April 30, 2009 02:07PM
2137
April 30, 2009 10:54PM
2218
May 01, 2009 11:30AM
2120
May 01, 2009 09:52PM
2135
May 04, 2009 12:46PM
2358
April 22, 2009 10:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.