Re: Mysql timed actions... Confused

[Joshua J. Kugler]

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?
>

> 2004/03/09 02:00:00OK, 77585 bytes1 seconds
> 2004/03/09 02:05:01OK, 77591 bytes24 seconds
> 2004/03/09 02:10:00OK, 77591 bytes23 seconds
> 2004/03/09 02:15:00OK, 77585 bytes32 seconds
> 2004/03/09 02:20:00OK, 77591 bytes26 seconds
> 2004/03/09 02:25:00OK, 77591 bytes25 seconds
> 2004/03/09 02:30:00OK, 77579 bytes27 seconds
> 2004/03/09 02:35:00OK, 77585 bytes26 seconds
> 2004/03/09 02:40:00OK, 77585 bytes27 seconds
> 2004/03/09 02:45:00OK, 77572 bytes28 seconds
> 2004/03/09 02:50:00OK, 77578 bytes26 seconds
> 2004/03/09 02:55:00OK, 77578 bytes26 seconds
> 2004/03/09 03:00:00OK, 77572 bytes26 seconds
> 2004/03/09 03:05:00OK, 77578 bytes26 seconds
> 2004/03/09 03:10:00OK, 77572 bytes28 seconds
> 2004/03/09 03:15:00OK, 77572 bytes29 seconds
> 2004/03/09 03:20:00OK, 77572 bytes33 seconds
> 2004/03/09 03:25:00OK, 77572 bytes64 seconds
> 2004/03/09 03:30:01OK, 77532 bytes27 seconds
> 2004/03/09 03:35:01OK, 77526 bytes25 seconds
> 2004/03/09 03:40:01OK, 77532 bytes114 seconds
> 2004/03/09 03:45:01OK, 77532 bytes27 seconds
> 2004/03/09 03:50:00OK, 77526 bytes79 seconds
> 2004/03/09 03:55:00OK, 77532 bytes26 seconds
> 2004/03/09 04:00:01OK, 77532 bytes27 seconds
> 2004/03/09 04:05:00OK, 77526 bytes26 seconds
> 2004/03/09 04:10:00OK, 77526 bytes26 seconds
> 2004/03/09 04:15:00OK, 77526 bytes26 seconds
> 2004/03/09 04:20:00OK, 77532 bytes33 seconds
> 2004/03/09 04:25:00OK, 77532 bytes26 seconds
> 2004/03/09 04:30:01OK, 77526 bytes167 seconds
> 2004/03/09 04:35:01OK, 77532 bytes26 seconds
> 2004/03/09 04:40:00OK, 77526 bytes29 seconds
> 2004/03/09 04:45:00OK, 77532 bytes28 seconds
> 2004/03/09 04:50:00OK, 77526 bytes26 seconds
> 2004/03/09 04:55:01OK, 77526 bytes25 seconds
> 2004/03/09 05:00:00OK, 77532 bytes28 seconds
> 2004/03/09 05:05:00OK, 77526 bytes28 seconds
> 2004/03/09 05:10:00OK, 77526 bytes27 seconds
> 2004/03/09 05:15:00OK, 77526 bytes28 seconds
> 2004/03/09 05:20:00OK, 77532 bytes26 seconds
> 2004/03/09 05:25:01OK, 77526 bytes27 seconds
> 2004/03/09 05:30:00OK, 77532 bytes27 seconds
> 2004/03/09 05:35:01OK, 77526 bytes25 seconds
> 2004/03/09 05:40:00OK, 77526 bytes26 seconds
> 2004/03/09 05:45:01OK, 77526 bytes26 seconds
> 2004/03/09 05:50:01OK, 77526 bytes26 seconds
> 2004/03/09 05:55:00OK, 77526 bytes28 seconds
> 2004/03/09 06:00:01OK, 77532 bytes27 seconds
> 2004/03/09 06:05:01OK, 77526 bytes28 seconds
> 2004/03/09 06:10:00OK, 77532 bytes30 seconds
> 2004/03/09 06:15:00OK, 77532 bytes30 seconds
> 2004/03/09 06:20:01OK, 77532 bytes27 seconds
> 2004/03/09 06:25:00OK, 77526 bytes27 seconds
> 2004/03/09 06:30:00OK, 77526 bytes27 seconds
> 2004/03/09 06:35:00OK, 77526 bytes31 seconds
> 2004/03/09 06:40:00OK, 77532 bytes27 seconds
> 2004/03/09 06:45:00OK, 77526 bytes26 seconds
> 2004/03/09 06:50:01OK, 77526 bytes29 seconds
> 2004/03/09 06:55:00OK, 77526 bytes28 seconds
> 2004/03/09 07:00:00OK, 77532 bytes28 seconds
> 2004/03/09 07:05:00OK, 77526 bytes1 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]

Mysql timed actions... Confused

[Scott Haneda]

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?

2004/03/08 16:11:27OK, 77569 bytes0 seconds
2004/03/08 16:11:37OK, 77575 bytes0 seconds
2004/03/08 16:13:31OK, 77569 bytes1 seconds
2004/03/08 16:13:49OK, 77575 bytes1 seconds
2004/03/08 16:14:51OK, 77575 bytes1 seconds
2004/03/08 16:17:00OK, 77569 bytes1 seconds
2004/03/08 16:20:01OK, 77575 bytes0 seconds
2004/03/08 16:25:01OK, 77569 bytes1 seconds
2004/03/08 16:30:00OK, 77569 bytes1 seconds
2004/03/08 16:35:00OK, 77575 bytes1 seconds
2004/03/08 16:40:00OK, 77575 bytes0 seconds
2004/03/08 16:45:01OK, 77569 bytes0 seconds
2004/03/08 16:50:01OK, 77569 bytes0 seconds
2004/03/08 16:55:01OK, 77569 bytes1 seconds
2004/03/08 17:00:00OK, 77588 bytes1 seconds
2004/03/08 17:05:01OK, 77601 bytes3 seconds
2004/03/08 17:10:00OK, 77601 bytes1 seconds
2004/03/08 17:15:00OK, 77601 bytes1 seconds
2004/03/08 17:20:01OK, 77595 bytes0 seconds
2004/03/08 17:25:01OK, 77595 bytes1 seconds
2004/03/08 17:30:01OK, 77577 bytes1 seconds
2004/03/08 17:35:00OK, 77577 bytes1 seconds
2004/03/08 17:40:00OK, 77577 bytes1 seconds
2004/03/08 17:45:00OK, 77577 bytes1 seconds
2004/03/08 17:50:00OK, 77565 bytes1 seconds
2004/03/08 17:55:00OK, 77577 bytes1 seconds
2004/03/08 18:00:00OK, 77577 bytes1 seconds
2004/03/08 18:05:00OK, 77577 bytes1 seconds
2004/03/08 18:10:00OK, 77571 bytes1 seconds
2004/03/08 18:15:00OK, 77571 bytes1 seconds
2004/03/08 18:20:00OK, 77577 bytes2 seconds
2004/03/08 18:25:00OK, 77571 bytes1 seconds
2004/03/08 18:30:00OK, 77571 bytes1 seconds
2004/03/08 18:35:00OK, 77589 bytes1 seconds
2004/03/08 18:40:00OK, 77601 bytes1 seconds
2004/03/08 18:45:00OK, 77595 bytes2 seconds
2004/03/08 18:50:00OK, 77595 bytes1 seconds
2004/03/08 18:55:00OK, 77583 bytes1 seconds
2004/03/08 19:00:01OK, 77601 bytes1 seconds
2004/03/08 19:05:00OK, 77595 bytes1 seconds
2004/03/08 19:10:01OK, 77601 bytes1 seconds
2004/03/08 19:15:00OK, 77595 bytes1 seconds
2004/03/08 19:20:00OK, 77583 bytes1 seconds
2004/03/08 19:25:00OK, 77589 bytes1 seconds
2004/03/08 19:30:00OK, 77595 bytes1 seconds
2004/03/08 19:35:00OK, 77595 bytes1 seconds
2004/03/08 19:40:00OK, 77601 bytes1 seconds
2004/03/08 19:45:00OK, 77589 bytes1 seconds
2004/03/08 19:50:01OK, 77601 bytes1 seconds
2004/03/08 19:55:00OK, 77583 bytes2 seconds
2004/03/08 20:00:00OK, 77601 bytes1 seconds
2004/03/08 20:05:00OK, 77595 bytes1 seconds
2004/03/08 20:10:00OK, 77595 bytes1 seconds
2004/03/08 20:15:00OK, 77595 bytes1 seconds
2004/03/08 20:20:00OK, 77595 bytes0 seconds
2004/03/08 20:25:01OK, 77601 bytes0 seconds
2004/03/08 20:30:01OK, 77601 bytes1 seconds
2004/03/08 20:35:00OK, 77601 bytes1 seconds
2004/03/08 20:40:00OK, 77601 bytes1 seconds
2004/03/08 20:45:00OK, 77601 bytes1 seconds
2004/03/08 20:50:01OK, 77601 bytes0 seconds
2004/03/08 20:55:01OK, 77601 bytes0 seconds
2004/03/08 21:00:00OK, 77601 bytes1 seconds
2004/03/08 21:05:00OK, 77595 bytes1 seconds
2004/03/08 21:10:00OK, 77601 bytes1 seconds
2004/03/08 21:15:00OK, 77601 bytes1 seconds
2004/03/08 21:20:00OK, 77595 bytes1 seconds
2004/03/08 21:25:00OK, 77595 bytes1 seconds
2004/03/08 21:30:00OK, 77601 bytes2 seconds
2004/03/08 21:35:00OK, 77595 bytes1 seconds
2004/03/08 21:40:00OK, 77601 bytes1 seconds
2004/03/08 21:45:00OK, 77601 bytes0 seconds
2004/03/08 21:50:00OK, 77601 bytes1 seconds
2004/03/08 21:55:00OK, 77595 bytes1 seconds
2004/03/08 22:00:00OK, 77595 bytes1 seconds
2004/03/08 22:05:00OK, 77601 bytes1 seconds
2004/03/08 22:10:00OK, 77595 bytes1 seconds
2004/03/08 22:15:00OK, 77595 bytes1 seconds
2004/03/08 22:20:00OK, 77601 bytes1 seconds
2004/03/08 22:25:00OK, 77601 bytes1 seconds
2004/03/08 22:30:01OK, 77589 bytes2 seconds
2004/03/08 22:35:00OK, 77601 bytes1 seconds
2004/03/08 22:40:00OK, 77601 bytes1 seconds
2004/03/08 22:45:00OK, 77601 bytes1 seconds
2004/03/08 22:50:00OK, 77601 bytes1 seconds
2004/03/08 22:55:00OK, 77595 bytes1 seconds
2004/03/08 23:00:00OK, 77601 bytes1 seconds
2004/03/08 23:05:00OK, 77595 bytes1 seconds
2004/03/08 23:10:00OK, 77595 bytes1 seconds
2004/03/08 23:15:00OK, 77589 bytes0 seconds
2004/03/08 23:20:01OK, 77601 bytes0 seconds
2004/03/08 23:25:01OK, 77601 bytes0 seconds
2004/03/08 23:30:00OK, 77589 bytes1 seconds
2