TK wrote:
My MySQL server (4.0.20, Linux) was running slowly. I checked the slow queries
log, and found many of these during the problem period:
# Time: 060730 20:44:40
# [EMAIL PROTECTED]: xxx []
# Query_time: 68 Lock_time: 0 Rows_sent: 0 Rows_examined: 2
# administrator command: Quit;
# [EMAIL PROTECTED]: xxx []
# Query_time: 67 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
# administrator command: Quit;
# [EMAIL PROTECTED]: xxx []
# Query_time: 67 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
# administrator command: Quit;
Any idea what these "administrator commands" refer to? What would be trying to
quit, and why would it be taking 67 seconds?
That's the only thing in the logs?
I get a different format (v 4.0.24):
# Time: 060731 5:46:48
# [EMAIL PROTECTED]: blah
# Query_time: 56 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use dbname;
CHECK TABLE `tablename`;
ie the command isn't commented out (maybe that's a cut/paste error).
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
