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
5005
April 21, 2009 11:58PM
2313
April 22, 2009 02:10AM
2399
April 22, 2009 03:27AM
2279
April 22, 2009 07:02AM
2304
April 22, 2009 09:37AM
2282
April 22, 2009 10:31AM
2433
April 22, 2009 12:22PM
2261
April 23, 2009 12:16AM
Re: Please help with slow easy query
2093
April 23, 2009 03:27AM
2159
April 23, 2009 02:20AM
2933
April 23, 2009 03:25AM
2339
April 24, 2009 07:18AM
2195
April 25, 2009 01:42PM
2138
April 25, 2009 04:34PM
2305
April 27, 2009 09:28AM
2155
April 27, 2009 09:47PM
2049
April 28, 2009 09:16AM
2289
April 28, 2009 09:34AM
2175
April 29, 2009 09:44AM
2691
April 30, 2009 02:07PM
2143
April 30, 2009 10:54PM
2222
May 01, 2009 11:30AM
2124
May 01, 2009 09:52PM
2138
May 04, 2009 12:46PM
2361
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.