Slow Mysql Queries

[George Chelidze]

On 06/06/2011 05:05 AM, OzSpots - Carl Sawers wrote:
> Thanks Guys,
>
> The slow query log has a lot of entry's in it. It's not obvious which
> are causing the most issues but I have found a script that was always
> slowish so have removed it. The line read
>
> # Query_time: 5  Lock_time: 0  Rows_sent: 3  Rows_examined: 17286222
>
> No idea where it thinks there are that may rows...
>
> A script which outputs all the active users from radcheck shows this in
> the slow query log
>
> # Query_time: 0  Lock_time: 0  Rows_sent: 84  Rows_examined: 32992
>
> Are all the slow query entries potentially a problem, I mean should
> there be any entries in there at all? While the scripts have changed
> slightly this DB worked fine on the last server - could it have been
> corrupted from the sql txt file import perhaps? (via phpadmin)
>
> Regards Carl

Hello Carl,

try:

"CHECK TABLE <table name>" to check whether it's corrupted */

Drop output from "SHOW CREATE TABLE <table name>" and a sample script 
which takes a long time to execute here.

Best Regards,

George Chelidze