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