Judging from the times on the clock (03:00 to 07:00) I would guess that the server on which MySQL is running is doing some scheduled activity. Cron jobs for backup, slocate updates, security checks, etc. MySQL doesn't do scheduled maintenance, especially not for four hours.
j----- k----- On Tuesday 09 March 2004 01:49 pm, Scott Haneda wrote: > Here is a log of query times I made when a certain page is loaded that uses > php and mysql, does mysql 4 do some sort of scheduled maintenance I am not > aware of? > <SNIP> > 2004/03/09 02:00:00 OK, 77585 bytes 1 seconds > 2004/03/09 02:05:01 OK, 77591 bytes 24 seconds > 2004/03/09 02:10:00 OK, 77591 bytes 23 seconds > 2004/03/09 02:15:00 OK, 77585 bytes 32 seconds > 2004/03/09 02:20:00 OK, 77591 bytes 26 seconds > 2004/03/09 02:25:00 OK, 77591 bytes 25 seconds > 2004/03/09 02:30:00 OK, 77579 bytes 27 seconds > 2004/03/09 02:35:00 OK, 77585 bytes 26 seconds > 2004/03/09 02:40:00 OK, 77585 bytes 27 seconds > 2004/03/09 02:45:00 OK, 77572 bytes 28 seconds > 2004/03/09 02:50:00 OK, 77578 bytes 26 seconds > 2004/03/09 02:55:00 OK, 77578 bytes 26 seconds > 2004/03/09 03:00:00 OK, 77572 bytes 26 seconds > 2004/03/09 03:05:00 OK, 77578 bytes 26 seconds > 2004/03/09 03:10:00 OK, 77572 bytes 28 seconds > 2004/03/09 03:15:00 OK, 77572 bytes 29 seconds > 2004/03/09 03:20:00 OK, 77572 bytes 33 seconds > 2004/03/09 03:25:00 OK, 77572 bytes 64 seconds > 2004/03/09 03:30:01 OK, 77532 bytes 27 seconds > 2004/03/09 03:35:01 OK, 77526 bytes 25 seconds > 2004/03/09 03:40:01 OK, 77532 bytes 114 seconds > 2004/03/09 03:45:01 OK, 77532 bytes 27 seconds > 2004/03/09 03:50:00 OK, 77526 bytes 79 seconds > 2004/03/09 03:55:00 OK, 77532 bytes 26 seconds > 2004/03/09 04:00:01 OK, 77532 bytes 27 seconds > 2004/03/09 04:05:00 OK, 77526 bytes 26 seconds > 2004/03/09 04:10:00 OK, 77526 bytes 26 seconds > 2004/03/09 04:15:00 OK, 77526 bytes 26 seconds > 2004/03/09 04:20:00 OK, 77532 bytes 33 seconds > 2004/03/09 04:25:00 OK, 77532 bytes 26 seconds > 2004/03/09 04:30:01 OK, 77526 bytes 167 seconds > 2004/03/09 04:35:01 OK, 77532 bytes 26 seconds > 2004/03/09 04:40:00 OK, 77526 bytes 29 seconds > 2004/03/09 04:45:00 OK, 77532 bytes 28 seconds > 2004/03/09 04:50:00 OK, 77526 bytes 26 seconds > 2004/03/09 04:55:01 OK, 77526 bytes 25 seconds > 2004/03/09 05:00:00 OK, 77532 bytes 28 seconds > 2004/03/09 05:05:00 OK, 77526 bytes 28 seconds > 2004/03/09 05:10:00 OK, 77526 bytes 27 seconds > 2004/03/09 05:15:00 OK, 77526 bytes 28 seconds > 2004/03/09 05:20:00 OK, 77532 bytes 26 seconds > 2004/03/09 05:25:01 OK, 77526 bytes 27 seconds > 2004/03/09 05:30:00 OK, 77532 bytes 27 seconds > 2004/03/09 05:35:01 OK, 77526 bytes 25 seconds > 2004/03/09 05:40:00 OK, 77526 bytes 26 seconds > 2004/03/09 05:45:01 OK, 77526 bytes 26 seconds > 2004/03/09 05:50:01 OK, 77526 bytes 26 seconds > 2004/03/09 05:55:00 OK, 77526 bytes 28 seconds > 2004/03/09 06:00:01 OK, 77532 bytes 27 seconds > 2004/03/09 06:05:01 OK, 77526 bytes 28 seconds > 2004/03/09 06:10:00 OK, 77532 bytes 30 seconds > 2004/03/09 06:15:00 OK, 77532 bytes 30 seconds > 2004/03/09 06:20:01 OK, 77532 bytes 27 seconds > 2004/03/09 06:25:00 OK, 77526 bytes 27 seconds > 2004/03/09 06:30:00 OK, 77526 bytes 27 seconds > 2004/03/09 06:35:00 OK, 77526 bytes 31 seconds > 2004/03/09 06:40:00 OK, 77532 bytes 27 seconds > 2004/03/09 06:45:00 OK, 77526 bytes 26 seconds > 2004/03/09 06:50:01 OK, 77526 bytes 29 seconds > 2004/03/09 06:55:00 OK, 77526 bytes 28 seconds > 2004/03/09 07:00:00 OK, 77532 bytes 28 seconds > 2004/03/09 07:05:00 OK, 77526 bytes 1 seconds -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... .... ..- .- -.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
