[root@mydb3 root]# tail /var/log/mysqld.log 050829 8:38:59 [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted 050829 8:40:00 [ERROR] /usr/local/mysql/bin/mysqld: Got error 12 from storage engine 050829 8:40:00 [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted 050829 8:40:19 [ERROR] Got error 12 when reading table './newco/io_export_message_blob' 050829 8:40:19 [ERROR] Got error 12 when reading table './newco/io_export_message_blob' 050829 8:43:13 [ERROR] Got error 12 when reading table './mail/inbox' 050829 8:43:40 [ERROR] /usr/local/mysql/bin/mysqld: Got error 12 from storage engine 050829 8:43:40 [ERROR] /usr/local/mysql/bin/mysqld: Sort aborted 050829 10:45:26 [ERROR] Got error 12 when reading table './newco/data_file_blob' 050829 10:55:28 [ERROR] Got error 12 when reading table './newco/data_file_blob' [root@mydb3 root]# date; ps -el | grep my; date; mysqladmin -u root -p flush-tables; date; ps -el | grep my; date Tue Aug 30 00:26:29 PDT 2005 4 S 0 22345 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 22377 22345 0 75 0 - 659328 schedu ? 00:44:36 mysqld 1 S 27 22378 22377 0 75 0 - 659328 schedu ? 00:02:53 mysqld 1 S 27 22379 22378 0 85 0 - 659328 rt_sig ? 00:00:00 mysqld 1 S 27 22380 22378 0 75 0 - 659328 rt_sig ? 00:00:12 mysqld 1 S 27 22381 22378 0 75 0 - 659328 rt_sig ? 00:00:04 mysqld 1 S 27 22382 22378 0 75 0 - 659328 rt_sig ? 00:03:37 mysqld 1 S 27 22385 22378 0 75 0 - 659328 schedu ? 00:18:18 mysqld 1 S 27 22386 22378 0 75 0 - 659328 schedu ? 00:15:48 mysqld 1 S 27 22387 22378 0 75 0 - 659328 schedu ? 00:10:16 mysqld 1 S 27 22388 22378 0 75 0 - 659328 rt_sig ? 00:22:23 mysqld 1 S 27 5541 22378 0 75 0 - 659328 rt_sig ? 00:38:03 mysqld 1 S 27 4848 22378 0 75 0 - 659328 schedu ? 00:05:18 mysqld 1 S 27 5157 22378 0 75 0 - 659328 rt_sig ? 00:04:42 mysqld 1 S 27 5244 22378 0 75 0 - 659328 schedu ? 00:01:22 mysqld 1 S 27 5259 22378 0 75 0 - 659328 schedu ? 00:00:32 mysqld 1 S 27 5260 22378 0 75 0 - 659328 schedu ? 00:03:26 mysqld 1 S 27 5275 22378 0 76 0 - 659328 schedu ? 00:03:00 mysqld 1 S 27 5280 22378 0 75 0 - 659328 schedu ? 00:01:31 mysqld 1 S 27 5324 22378 1 77 0 - 659328 schedu ? 00:04:48 mysqld 1 S 27 5348 22378 0 76 0 - 659328 schedu ? 00:01:31 mysqld 1 S 27 5416 22378 0 75 0 - 659328 schedu ? 00:00:12 mysqld 1 S 27 5471 22378 0 75 0 - 659328 schedu ? 00:01:14 mysqld 1 S 27 5479 22378 0 75 0 - 659328 rt_sig ? 00:00:07 mysqld 1 S 27 5480 22378 0 76 0 - 659328 rt_sig ? 00:01:34 mysqld 1 S 27 5565 22378 0 75 0 - 659328 schedu ? 00:01:02 mysqld 1 S 27 5600 22378 0 75 0 - 659328 rt_sig ? 00:00:41 mysqld 1 S 27 5629 22378 0 76 0 - 659328 schedu ? 00:00:11 mysqld 1 S 27 5630 22378 0 75 0 - 659328 schedu ? 00:00:12 mysqld 1 S 27 5666 22378 0 75 0 - 659328 schedu ? 00:00:30 mysqld 1 S 27 5678 22378 0 75 0 - 659328 schedu ? 00:00:32 mysqld 1 S 27 5681 22378 0 75 0 - 659328 schedu ? 00:00:24 mysqld 1 S 27 5715 22378 1 75 0 - 659328 schedu ? 00:00:36 mysqld 1 S 27 5743 22378 1 75 0 - 659328 schedu ? 00:00:28 mysqld 1 S 27 5755 22378 1 75 0 - 659328 schedu ? 00:00:22 mysqld 1 S 27 5756 22378 1 75 0 - 659328 schedu ? 00:00:23 mysqld Tue Aug 30 00:26:29 PDT 2005 Enter password: Tue Aug 30 00:26:31 PDT 2005 4 S 0 22345 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 22377 22345 0 75 0 - 659328 schedu ? 00:44:36 mysqld 1 S 27 22378 22377 0 75 0 - 659328 schedu ? 00:02:53 mysqld 1 S 27 22379 22378 0 85 0 - 659328 rt_sig ? 00:00:00 mysqld 1 S 27 22380 22378 0 75 0 - 659328 rt_sig ? 00:00:12 mysqld 1 S 27 22381 22378 0 75 0 - 659328 rt_sig ? 00:00:04 mysqld 1 S 27 22382 22378 0 75 0 - 659328 rt_sig ? 00:03:37 mysqld 1 S 27 22385 22378 0 75 0 - 659328 schedu ? 00:18:18 mysqld 1 S 27 22386 22378 0 75 0 - 659328 schedu ? 00:15:48 mysqld 1 S 27 22387 22378 0 75 0 - 659328 schedu ? 00:10:16 mysqld 1 S 27 22388 22378 0 75 0 - 659328 rt_sig ? 00:22:23 mysqld 1 S 27 5541 22378 0 75 0 - 659328 rt_sig ? 00:38:03 mysqld 1 S 27 4848 22378 0 75 0 - 659328 schedu ? 00:05:18 mysqld 1 S 27 5157 22378 0 75 0 - 659328 rt_sig ? 00:04:42 mysqld 1 S 27 5244 22378 0 75 0 - 659328 schedu ? 00:01:22 mysqld 1 S 27 5259 22378 0 75 0 - 659328 schedu ? 00:00:32 mysqld 1 S 27 5260 22378 0 75 0 - 659328 schedu ? 00:03:26 mysqld 1 S 27 5275 22378 0 76 0 - 659328 schedu ? 00:03:00 mysqld 1 S 27 5280 22378 0 75 0 - 659328 schedu ? 00:01:31 mysqld 1 S 27 5324 22378 1 77 0 - 659328 schedu ? 00:04:48 mysqld 1 S 27 5348 22378 0 76 0 - 659328 schedu ? 00:01:31 mysqld 1 S 27 5416 22378 0 75 0 - 659328 schedu ? 00:00:12 mysqld 1 S 27 5471 22378 0 75 0 - 659328 schedu ? 00:01:14 mysqld 1 S 27 5479 22378 0 75 0 - 659328 rt_sig ? 00:00:07 mysqld 1 S 27 5480 22378 0 75 0 - 659328 rt_sig ? 00:01:34 mysqld 1 S 27 5565 22378 0 75 0 - 659328 schedu ? 00:01:02 mysqld 1 S 27 5600 22378 0 75 0 - 659328 schedu ? 00:00:41 mysqld 1 S 27 5629 22378 0 76 0 - 659328 schedu ? 00:00:11 mysqld 1 S 27 5630 22378 0 75 0 - 659328 schedu ? 00:00:12 mysqld 1 S 27 5666 22378 0 75 0 - 659328 schedu ? 00:00:30 mysqld 1 S 27 5678 22378 0 75 0 - 659328 schedu ? 00:00:32 mysqld 1 S 27 5681 22378 0 75 0 - 659328 schedu ? 00:00:24 mysqld 1 S 27 5715 22378 1 75 0 - 659328 schedu ? 00:00:36 mysqld 1 S 27 5743 22378 1 75 0 - 659328 rt_sig ? 00:00:29 mysqld 1 S 27 5755 22378 1 75 0 - 659328 schedu ? 00:00:22 mysqld 1 S 27 5756 22378 1 75 0 - 659328 schedu ? 00:00:23 mysqld Tue Aug 30 00:26:31 PDT 2005 [root@mydb3 root]# date; ps -el | grep my; date; mysqladmin -u root -p flush-threads; date; ps -el | grep my; date Tue Aug 30 00:28:51 PDT 2005 4 S 0 22345 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 22377 22345 0 75 0 - 659330 schedu ? 00:44:37 mysqld 1 S 27 22378 22377 0 75 0 - 659330 schedu ? 00:02:53 mysqld 1 S 27 22379 22378 0 85 0 - 659330 rt_sig ? 00:00:00 mysqld 1 S 27 22380 22378 0 75 0 - 659330 rt_sig ? 00:00:12 mysqld 1 S 27 22381 22378 0 75 0 - 659330 rt_sig ? 00:00:04 mysqld 1 S 27 22382 22378 0 75 0 - 659330 rt_sig ? 00:03:37 mysqld 1 S 27 22385 22378 0 75 0 - 659330 schedu ? 00:18:18 mysqld 1 S 27 22386 22378 0 75 0 - 659330 schedu ? 00:15:48 mysqld 1 S 27 22387 22378 0 75 0 - 659330 schedu ? 00:10:16 mysqld 1 S 27 22388 22378 0 75 0 - 659330 rt_sig ? 00:22:23 mysqld 1 S 27 5541 22378 0 75 0 - 659330 rt_sig ? 00:38:03 mysqld 1 S 27 4848 22378 0 75 0 - 659330 schedu ? 00:05:18 mysqld 1 S 27 5157 22378 0 75 0 - 659330 rt_sig ? 00:04:45 mysqld 1 S 27 5244 22378 0 75 0 - 659330 schedu ? 00:01:22 mysqld 1 S 27 5259 22378 0 75 0 - 659330 schedu ? 00:00:32 mysqld 1 S 27 5260 22378 0 75 0 - 659330 schedu ? 00:03:26 mysqld 1 S 27 5275 22378 0 76 0 - 659330 schedu ? 00:03:00 mysqld 1 S 27 5280 22378 0 75 0 - 659330 schedu ? 00:01:31 mysqld 1 S 27 5324 22378 1 75 0 - 659330 schedu ? 00:04:48 mysqld 1 S 27 5348 22378 0 76 0 - 659330 schedu ? 00:01:31 mysqld 1 S 27 5416 22378 0 75 0 - 659330 schedu ? 00:00:12 mysqld 1 S 27 5471 22378 0 75 0 - 659330 schedu ? 00:01:16 mysqld 1 S 27 5479 22378 0 75 0 - 659330 rt_sig ? 00:00:07 mysqld 1 S 27 5480 22378 0 76 0 - 659330 rt_sig ? 00:01:37 mysqld 1 S 27 5565 22378 0 75 0 - 659330 schedu ? 00:01:02 mysqld 1 S 27 5600 22378 0 76 0 - 659330 rt_sig ? 00:00:43 mysqld 1 S 27 5629 22378 0 76 0 - 659330 schedu ? 00:00:11 mysqld 1 S 27 5630 22378 0 75 0 - 659330 schedu ? 00:00:12 mysqld 1 S 27 5666 22378 0 75 0 - 659330 schedu ? 00:00:30 mysqld 1 S 27 5678 22378 0 75 0 - 659330 schedu ? 00:00:32 mysqld 1 S 27 5681 22378 0 75 0 - 659330 schedu ? 00:00:24 mysqld 1 S 27 5715 22378 1 75 0 - 659330 schedu ? 00:00:36 mysqld 1 S 27 5743 22378 1 76 0 - 659330 rt_sig ? 00:00:31 mysqld 1 S 27 5755 22378 1 75 0 - 659330 schedu ? 00:00:22 mysqld 1 S 27 5756 22378 1 76 0 - 659330 schedu ? 00:00:23 mysqld Tue Aug 30 00:28:51 PDT 2005 Enter password: Tue Aug 30 00:28:54 PDT 2005 4 S 0 22345 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 22377 22345 0 75 0 - 659234 schedu ? 00:44:37 mysqld 1 S 27 22378 22377 0 75 0 - 659234 schedu ? 00:02:53 mysqld 1 S 27 22379 22378 0 85 0 - 659234 rt_sig ? 00:00:00 mysqld 1 S 27 22380 22378 0 75 0 - 659234 rt_sig ? 00:00:12 mysqld 1 S 27 22381 22378 0 75 0 - 659234 rt_sig ? 00:00:04 mysqld 1 S 27 22382 22378 0 75 0 - 659234 rt_sig ? 00:03:37 mysqld 1 S 27 22385 22378 0 75 0 - 659234 schedu ? 00:18:18 mysqld 1 S 27 22386 22378 0 75 0 - 659234 schedu ? 00:15:48 mysqld 1 S 27 22387 22378 0 75 0 - 659234 schedu ? 00:10:16 mysqld 1 S 27 22388 22378 0 75 0 - 659234 rt_sig ? 00:22:23 mysqld 1 S 27 5541 22378 0 75 0 - 659234 rt_sig ? 00:38:03 mysqld 1 S 27 4848 22378 0 75 0 - 659234 schedu ? 00:05:18 mysqld 1 S 27 5157 22378 0 75 0 - 659234 rt_sig ? 00:04:45 mysqld 1 S 27 5244 22378 0 75 0 - 659234 schedu ? 00:01:22 mysqld 1 S 27 5259 22378 0 75 0 - 659234 schedu ? 00:00:32 mysqld 1 S 27 5260 22378 0 75 0 - 659234 schedu ? 00:03:26 mysqld 1 S 27 5275 22378 0 76 0 - 659234 schedu ? 00:03:00 mysqld 1 S 27 5280 22378 0 75 0 - 659234 schedu ? 00:01:31 mysqld 1 S 27 5324 22378 1 75 0 - 659234 schedu ? 00:04:48 mysqld 1 S 27 5348 22378 0 76 0 - 659234 schedu ? 00:01:31 mysqld 1 S 27 5416 22378 0 75 0 - 659234 schedu ? 00:00:12 mysqld 1 S 27 5471 22378 0 75 0 - 659234 schedu ? 00:01:16 mysqld 1 S 27 5479 22378 0 75 0 - 659234 rt_sig ? 00:00:07 mysqld 1 S 27 5565 22378 0 75 0 - 659234 schedu ? 00:01:02 mysqld 1 S 27 5629 22378 0 76 0 - 659234 schedu ? 00:00:11 mysqld 1 S 27 5630 22378 0 75 0 - 659234 schedu ? 00:00:12 mysqld 1 S 27 5666 22378 0 75 0 - 659234 schedu ? 00:00:30 mysqld 1 S 27 5678 22378 0 75 0 - 659234 schedu ? 00:00:32 mysqld 1 S 27 5681 22378 0 75 0 - 659234 schedu ? 00:00:24 mysqld 1 S 27 5715 22378 1 75 0 - 659234 schedu ? 00:00:36 mysqld 1 S 27 5755 22378 1 75 0 - 659234 schedu ? 00:00:22 mysqld 1 S 27 5756 22378 1 76 0 - 659234 schedu ? 00:00:23 mysqld Tue Aug 30 00:28:54 PDT 2005 [root@mydb3 root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 42280988 to server version: 4.1.13-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> show processlist; +----------+------+------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----------+------+------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------+ | 10866957 | repl | mydb1.aserver.net:44878 | NULL | Binlog Dump | 1131755 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 41726289 | repl | mydb4.aserver.net:40843 | NULL | Binlog Dump | 15852 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 42150170 | db | myapp1.aserver.net:39120 | newco | Sleep | 214 | | NULL | | 42150171 | db | myapp1.aserver.net:39121 | newco | Sleep | 214 | | NULL | | 42153307 | db | myapp1.aserver.net:39123 | newco | Sleep | 214 | | NULL | | 42160361 | db | myapp1.aserver.net:39126 | newco | Sleep | 214 | | NULL | | 42160362 | db | myapp1.aserver.net:39127 | newco | Sleep | 206 | | NULL | | 42174191 | db | myapp1.aserver.net:39133 | newco | Sleep | 205 | | NULL | | 42186554 | db | myapp1.aserver.net:39151 | newco | Sleep | 7 | | NULL | | 42186557 | db | myapp1.aserver.net:39152 | newco | Sleep | 7 | | NULL | | 42186558 | db | myapp1.aserver.net:39153 | newco | Sleep | 0 | | NULL | | 42272697 | db | myapp1.aserver.net:39242 | newco | Sleep | 255 | | NULL | | 42272699 | db | myapp1.aserver.net:39243 | newco | Sleep | 255 | | NULL | | 42272701 | db | myapp1.aserver.net:39244 | newco | Sleep | 255 | | NULL | | 42272702 | db | myapp1.aserver.net:39245 | newco | Sleep | 255 | | NULL | | 42272704 | db | myapp1.aserver.net:39246 | newco | Sleep | 255 | | NULL | | 42272705 | db | myapp1.aserver.net:39247 | newco | Sleep | 255 | | NULL | | 42272706 | db | myapp1.aserver.net:39248 | newco | Sleep | 255 | | NULL | | 42272707 | db | myapp1.aserver.net:39249 | newco | Sleep | 207 | | NULL | | 42272709 | db | myapp1.aserver.net:39250 | newco | Sleep | 207 | | NULL | | 42272711 | db | myapp1.aserver.net:39251 | newco | Sleep | 8 | | NULL | | 42280988 | root | localhost | NULL | Query | 0 | NULL | show processlist | +----------+------+------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------+ 22 rows in set (0.00 sec) mysql> show processlist; +----------+------------+--------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----------+------------+--------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | 10866957 | repl | mydb1.aserver.net:44878 | NULL | Binlog Dump | 1132053 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 41726289 | repl | mydb4.aserver.net:40843 | NULL | Binlog Dump | 16150 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 42150170 | db | myapp1.aserver.net:39120 | newco | Sleep | 512 | | NULL | | 42150171 | db | myapp1.aserver.net:39121 | newco | Sleep | 192 | | NULL | | 42153307 | db | myapp1.aserver.net:39123 | newco | Sleep | 192 | | NULL | | 42160361 | db | myapp1.aserver.net:39126 | newco | Sleep | 191 | | NULL | | 42160362 | db | myapp1.aserver.net:39127 | newco | Sleep | 191 | | NULL | | 42174191 | db | myapp1.aserver.net:39133 | newco | Sleep | 189 | | NULL | | 42186554 | db | myapp1.aserver.net:39151 | newco | Sleep | 189 | | NULL | | 42186557 | db | myapp1.aserver.net:39152 | newco | Sleep | 13 | | NULL | | 42186558 | db | myapp1.aserver.net:39153 | newco | Execute | 0 | Sending data | SELECT COUNT( DISTINCT vehicle_id) AS total FROM acl_account AS a LEFT JOIN data_shared_inventory AS | | 42272697 | db | myapp1.aserver.net:39242 | newco | Sleep | 553 | | NULL | | 42272699 | db | myapp1.aserver.net:39243 | newco | Sleep | 553 | | NULL | | 42272701 | db | myapp1.aserver.net:39244 | newco | Sleep | 553 | | NULL | | 42272702 | db | myapp1.aserver.net:39245 | newco | Sleep | 553 | | NULL | | 42272704 | db | myapp1.aserver.net:39246 | newco | Sleep | 553 | | NULL | | 42272705 | db | myapp1.aserver.net:39247 | newco | Sleep | 553 | | NULL | | 42272706 | db | myapp1.aserver.net:39248 | newco | Sleep | 553 | | NULL | | 42272707 | db | myapp1.aserver.net:39249 | newco | Sleep | 41 | | NULL | | 42272709 | db | myapp1.aserver.net:39250 | newco | Sleep | 41 | | NULL | | 42272711 | db | myapp1.aserver.net:39251 | newco | Sleep | 41 | | NULL | | 42280988 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 42291626 | james_user | myemail1.aserver.net:46861 | mail | Sleep | 0 | | NULL | +----------+------------+--------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ 23 rows in set (0.00 sec) mysql> show processlist; +----------+------------+--------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----------+------------+--------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------+ | 10866957 | repl | mydb1.aserver.net:44878 | NULL | Binlog Dump | 1132056 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 41726289 | repl | mydb4.aserver.net:40843 | NULL | Binlog Dump | 16153 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 42150170 | db | myapp1.aserver.net:39120 | newco | Sleep | 515 | | NULL | | 42150171 | db | myapp1.aserver.net:39121 | newco | Sleep | 195 | | NULL | | 42153307 | db | myapp1.aserver.net:39123 | newco | Sleep | 195 | | NULL | | 42160361 | db | myapp1.aserver.net:39126 | newco | Sleep | 194 | | NULL | | 42160362 | db | myapp1.aserver.net:39127 | newco | Sleep | 194 | | NULL | | 42174191 | db | myapp1.aserver.net:39133 | newco | Sleep | 192 | | NULL | | 42186554 | db | myapp1.aserver.net:39151 | newco | Sleep | 192 | | NULL | | 42186557 | db | myapp1.aserver.net:39152 | newco | Sleep | 16 | | NULL | | 42186558 | db | myapp1.aserver.net:39153 | newco | Sleep | 2 | | NULL | | 42272697 | db | myapp1.aserver.net:39242 | newco | Sleep | 556 | | NULL | | 42272699 | db | myapp1.aserver.net:39243 | newco | Sleep | 556 | | NULL | | 42272701 | db | myapp1.aserver.net:39244 | newco | Sleep | 556 | | NULL | | 42272702 | db | myapp1.aserver.net:39245 | newco | Sleep | 556 | | NULL | | 42272704 | db | myapp1.aserver.net:39246 | newco | Sleep | 556 | | NULL | | 42272705 | db | myapp1.aserver.net:39247 | newco | Sleep | 556 | | NULL | | 42272706 | db | myapp1.aserver.net:39248 | newco | Sleep | 556 | | NULL | | 42272707 | db | myapp1.aserver.net:39249 | newco | Sleep | 44 | | NULL | | 42272709 | db | myapp1.aserver.net:39250 | newco | Sleep | 2 | | NULL | | 42272711 | db | myapp1.aserver.net:39251 | newco | Sleep | 2 | | NULL | | 42280988 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 42291770 | james_user | myemail1.aserver.net:47006 | mail | Sleep | 0 | | NULL | +----------+------------+--------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------+ 23 rows in set (0.00 sec) ****************************************************** *** NOTE - HERE I TURN OFF THE APP AND EMAIL SERVERS ****************************************************** mysql> show processlist; +----------+------+-----------------------+------+-------------+---------+----------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----------+------+-----------------------+------+-------------+---------+----------------------------------------------------------------+------------------+ | 10866957 | repl | mydb1.aserver.net:44878 | NULL | Binlog Dump | 1132875 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 41726289 | repl | mydb4.aserver.net:40843 | NULL | Binlog Dump | 16972 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 42280988 | root | localhost | NULL | Query | 0 | NULL | show processlist | +----------+------+-----------------------+------+-------------+---------+----------------------------------------------------------------+------------------+ 3 rows in set (0.00 sec) mysql> exit Bye [root@mydb3 root]# date; ps -el | grep my; date; mysqladmin -u root -p flush-tables; date; ps -el | grep my; date Tue Aug 30 00:48:08 PDT 2005 4 S 0 22345 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 22377 22345 0 75 0 - 647325 schedu ? 00:44:39 mysqld 1 S 27 22378 22377 0 75 0 - 647325 schedu ? 00:02:53 mysqld 1 S 27 22379 22378 0 85 0 - 647325 rt_sig ? 00:00:00 mysqld 1 S 27 22380 22378 0 75 0 - 647325 rt_sig ? 00:00:12 mysqld 1 S 27 22381 22378 0 75 0 - 647325 rt_sig ? 00:00:04 mysqld 1 S 27 22382 22378 0 75 0 - 647325 rt_sig ? 00:03:37 mysqld 1 S 27 22385 22378 0 75 0 - 647325 schedu ? 00:18:19 mysqld 1 S 27 22386 22378 0 75 0 - 647325 schedu ? 00:15:49 mysqld 1 S 27 22387 22378 0 75 0 - 647325 rt_sig ? 00:10:16 mysqld 1 S 27 22388 22378 0 75 0 - 647325 rt_sig ? 00:22:24 mysqld 1 S 27 5541 22378 0 75 0 - 647325 rt_sig ? 00:38:04 mysqld 1 S 27 5259 22378 0 75 0 - 647325 rt_sig ? 00:00:33 mysqld 1 S 27 5324 22378 1 75 0 - 647325 rt_sig ? 00:04:57 mysqld 1 S 27 5348 22378 0 75 0 - 647325 rt_sig ? 00:01:37 mysqld 1 S 27 5471 22378 0 75 0 - 647325 rt_sig ? 00:01:38 mysqld 1 S 27 5479 22378 0 75 0 - 647325 rt_sig ? 00:00:07 mysqld 1 S 27 5565 22378 0 75 0 - 647325 rt_sig ? 00:01:02 mysqld 1 S 27 5629 22378 0 75 0 - 647325 rt_sig ? 00:00:12 mysqld 1 S 27 5630 22378 0 75 0 - 647325 rt_sig ? 00:00:13 mysqld 1 S 27 5666 22378 0 75 0 - 647325 rt_sig ? 00:00:31 mysqld 1 S 27 5681 22378 0 75 0 - 647325 rt_sig ? 00:00:25 mysqld 1 S 27 5715 22378 1 75 0 - 647325 rt_sig ? 00:00:37 mysqld 1 S 27 5755 22378 0 75 0 - 647325 rt_sig ? 00:00:23 mysqld 1 S 27 5756 22378 1 75 0 - 647325 rt_sig ? 00:00:35 mysqld 1 S 27 5847 22378 1 75 0 - 647325 rt_sig ? 00:00:19 mysqld 1 S 27 5848 22378 1 75 0 - 647325 rt_sig ? 00:00:19 mysqld 1 S 27 5849 22378 1 75 0 - 647325 rt_sig ? 00:00:18 mysqld 1 S 27 5857 22378 1 75 0 - 647325 rt_sig ? 00:00:15 mysqld Tue Aug 30 00:48:08 PDT 2005 Enter password: Tue Aug 30 00:48:10 PDT 2005 4 S 0 22345 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 22377 22345 0 75 0 - 623003 schedu ? 00:44:39 mysqld 1 S 27 22378 22377 0 75 0 - 623003 schedu ? 00:02:53 mysqld 1 S 27 22379 22378 0 85 0 - 623003 rt_sig ? 00:00:00 mysqld 1 S 27 22380 22378 0 75 0 - 623003 rt_sig ? 00:00:12 mysqld 1 S 27 22381 22378 0 75 0 - 623003 rt_sig ? 00:00:04 mysqld 1 S 27 22382 22378 0 75 0 - 623003 rt_sig ? 00:03:37 mysqld 1 S 27 22385 22378 0 75 0 - 623003 schedu ? 00:18:19 mysqld 1 S 27 22386 22378 0 76 0 - 623003 schedu ? 00:15:49 mysqld 1 S 27 22387 22378 0 75 0 - 623003 schedu ? 00:10:16 mysqld 1 S 27 22388 22378 0 75 0 - 623003 rt_sig ? 00:22:24 mysqld 1 S 27 5541 22378 0 75 0 - 623003 rt_sig ? 00:38:04 mysqld 1 S 27 5259 22378 0 75 0 - 623003 rt_sig ? 00:00:33 mysqld 1 S 27 5324 22378 1 75 0 - 623003 rt_sig ? 00:04:57 mysqld 1 S 27 5348 22378 0 75 0 - 623003 rt_sig ? 00:01:37 mysqld 1 S 27 5471 22378 0 75 0 - 623003 rt_sig ? 00:01:38 mysqld 1 S 27 5479 22378 0 75 0 - 623003 rt_sig ? 00:00:07 mysqld 1 S 27 5565 22378 0 75 0 - 623003 rt_sig ? 00:01:02 mysqld 1 S 27 5629 22378 0 75 0 - 623003 rt_sig ? 00:00:12 mysqld 1 S 27 5630 22378 0 75 0 - 623003 rt_sig ? 00:00:13 mysqld 1 S 27 5666 22378 0 75 0 - 623003 rt_sig ? 00:00:31 mysqld 1 S 27 5681 22378 0 75 0 - 623003 rt_sig ? 00:00:25 mysqld 1 S 27 5715 22378 1 75 0 - 623003 rt_sig ? 00:00:37 mysqld 1 S 27 5755 22378 0 75 0 - 623003 rt_sig ? 00:00:23 mysqld 1 S 27 5756 22378 1 75 0 - 623003 rt_sig ? 00:00:35 mysqld 1 S 27 5847 22378 1 75 0 - 623003 rt_sig ? 00:00:19 mysqld 1 S 27 5848 22378 1 75 0 - 623003 rt_sig ? 00:00:19 mysqld 1 S 27 5849 22378 1 75 0 - 623003 rt_sig ? 00:00:18 mysqld 1 S 27 5857 22378 1 75 0 - 623003 rt_sig ? 00:00:15 mysqld Tue Aug 30 00:48:10 PDT 2005 [root@mydb3 root]# date; ps -el | grep my; date; mysqladmin -u root -p flush-threads; date; ps -el | grep my; date Tue Aug 30 00:48:15 PDT 2005 4 S 0 22345 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 22377 22345 0 75 0 - 623003 schedu ? 00:44:39 mysqld 1 S 27 22378 22377 0 75 0 - 623003 schedu ? 00:02:53 mysqld 1 S 27 22379 22378 0 85 0 - 623003 rt_sig ? 00:00:00 mysqld 1 S 27 22380 22378 0 75 0 - 623003 rt_sig ? 00:00:12 mysqld 1 S 27 22381 22378 0 75 0 - 623003 rt_sig ? 00:00:04 mysqld 1 S 27 22382 22378 0 75 0 - 623003 rt_sig ? 00:03:37 mysqld 1 S 27 22385 22378 0 75 0 - 623003 schedu ? 00:18:19 mysqld 1 S 27 22386 22378 0 75 0 - 623003 schedu ? 00:15:49 mysqld 1 S 27 22387 22378 0 75 0 - 623003 schedu ? 00:10:16 mysqld 1 S 27 22388 22378 0 75 0 - 623003 rt_sig ? 00:22:24 mysqld 1 S 27 5541 22378 0 75 0 - 623003 rt_sig ? 00:38:04 mysqld 1 S 27 5259 22378 0 75 0 - 623003 rt_sig ? 00:00:33 mysqld 1 S 27 5324 22378 1 75 0 - 623003 rt_sig ? 00:04:57 mysqld 1 S 27 5348 22378 0 75 0 - 623003 rt_sig ? 00:01:37 mysqld 1 S 27 5471 22378 0 75 0 - 623003 rt_sig ? 00:01:38 mysqld 1 S 27 5479 22378 0 75 0 - 623003 rt_sig ? 00:00:07 mysqld 1 S 27 5565 22378 0 75 0 - 623003 rt_sig ? 00:01:02 mysqld 1 S 27 5629 22378 0 75 0 - 623003 rt_sig ? 00:00:12 mysqld 1 S 27 5630 22378 0 75 0 - 623003 rt_sig ? 00:00:13 mysqld 1 S 27 5666 22378 0 75 0 - 623003 rt_sig ? 00:00:31 mysqld 1 S 27 5681 22378 0 75 0 - 623003 rt_sig ? 00:00:25 mysqld 1 S 27 5715 22378 1 75 0 - 623003 rt_sig ? 00:00:37 mysqld 1 S 27 5755 22378 0 75 0 - 623003 rt_sig ? 00:00:23 mysqld 1 S 27 5756 22378 1 75 0 - 623003 rt_sig ? 00:00:35 mysqld 1 S 27 5847 22378 1 75 0 - 623003 rt_sig ? 00:00:19 mysqld 1 S 27 5848 22378 1 75 0 - 623003 rt_sig ? 00:00:19 mysqld 1 S 27 5849 22378 1 75 0 - 623003 rt_sig ? 00:00:18 mysqld 1 S 27 5857 22378 1 75 0 - 623003 rt_sig ? 00:00:15 mysqld Tue Aug 30 00:48:15 PDT 2005 Enter password: Tue Aug 30 00:48:17 PDT 2005 4 S 0 22345 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 22377 22345 0 75 0 - 622523 schedu ? 00:44:39 mysqld 1 S 27 22378 22377 0 75 0 - 622523 schedu ? 00:02:53 mysqld 1 S 27 22379 22378 0 85 0 - 622523 rt_sig ? 00:00:00 mysqld 1 S 27 22380 22378 0 75 0 - 622523 rt_sig ? 00:00:12 mysqld 1 S 27 22381 22378 0 75 0 - 622523 rt_sig ? 00:00:04 mysqld 1 S 27 22382 22378 0 75 0 - 622523 rt_sig ? 00:03:37 mysqld 1 S 27 22385 22378 0 75 0 - 622523 schedu ? 00:18:19 mysqld 1 S 27 22386 22378 0 75 0 - 622523 schedu ? 00:15:49 mysqld 1 S 27 22387 22378 0 75 0 - 622523 schedu ? 00:10:16 mysqld 1 S 27 22388 22378 0 75 0 - 622523 rt_sig ? 00:22:24 mysqld 1 S 27 5541 22378 0 75 0 - 622523 rt_sig ? 00:38:04 mysqld 1 S 27 5479 22378 0 75 0 - 622523 rt_sig ? 00:00:07 mysqld 1 S 27 5849 22378 1 75 0 - 622523 rt_sig ? 00:00:18 mysqld Tue Aug 30 00:48:17 PDT 2005 [root@mydb3 root]# service mysqld restart Shutting down MySQL........ [ OK ] Starting MySQL. [ OK ] [root@mydb3 root]# date; ps -el | grep my; date; mysqladmin -u root -p flush-threads; date; ps -el | grep my; date Tue Aug 30 00:48:40 PDT 2005 4 S 0 5951 1 0 85 0 - 1061 wait4 pts/0 00:00:00 mysqld_safe 4 S 27 5983 5951 11 85 0 - 418559 schedu pts/0 00:00:00 mysqld 1 S 27 5984 5983 0 81 0 - 418559 schedu pts/0 00:00:00 mysqld 1 S 27 5985 5984 0 85 0 - 418559 rt_sig pts/0 00:00:00 mysqld 1 S 27 5986 5984 0 84 0 - 418559 rt_sig pts/0 00:00:00 mysqld 1 S 27 5987 5984 0 85 0 - 418559 rt_sig pts/0 00:00:00 mysqld 1 S 27 5988 5984 0 84 0 - 418559 rt_sig pts/0 00:00:00 mysqld 1 S 27 5989 5984 0 79 0 - 418559 schedu pts/0 00:00:00 mysqld 1 S 27 5990 5984 0 79 0 - 418559 schedu pts/0 00:00:00 mysqld 1 S 27 5993 5984 0 84 0 - 418559 rt_sig pts/0 00:00:00 mysqld 1 S 27 5994 5984 0 80 0 - 418559 rt_sig pts/0 00:00:00 mysqld Tue Aug 30 00:48:40 PDT 2005 Enter password: Tue Aug 30 00:48:43 PDT 2005 4 S 0 5951 1 0 85 0 - 1061 wait4 pts/0 00:00:00 mysqld_safe 4 S 27 5983 5951 7 77 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5984 5983 0 76 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5985 5984 0 85 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5986 5984 0 84 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5987 5984 0 85 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5988 5984 0 84 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5989 5984 0 76 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5990 5984 0 77 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5993 5984 0 84 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5994 5984 0 76 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 6005 5984 0 81 0 - 418596 rt_sig pts/0 00:00:00 mysqld Tue Aug 30 00:48:43 PDT 2005 [root@mydb3 root]# date; ps -el | grep my; date; mysqladmin -u root -p flush-tables; date; ps -el | grep my; date Tue Aug 30 00:48:46 PDT 2005 4 S 0 5951 1 0 85 0 - 1061 wait4 pts/0 00:00:00 mysqld_safe 4 S 27 5983 5951 5 77 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5984 5983 0 75 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5985 5984 0 85 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5986 5984 0 84 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5987 5984 0 85 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5988 5984 0 84 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5989 5984 0 75 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5990 5984 0 75 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5993 5984 0 84 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5994 5984 0 76 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 6005 5984 0 81 0 - 418596 rt_sig pts/0 00:00:00 mysqld Tue Aug 30 00:48:46 PDT 2005 Enter password: Tue Aug 30 00:48:48 PDT 2005 4 S 0 5951 1 0 85 0 - 1061 wait4 pts/0 00:00:00 mysqld_safe 4 S 27 5983 5951 5 75 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5984 5983 0 75 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5985 5984 0 85 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5986 5984 0 84 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5987 5984 0 85 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5988 5984 0 84 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5989 5984 0 75 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5990 5984 0 75 0 - 418596 schedu pts/0 00:00:00 mysqld 1 S 27 5993 5984 0 84 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 5994 5984 0 75 0 - 418596 rt_sig pts/0 00:00:00 mysqld 1 S 27 6005 5984 0 76 0 - 418596 rt_sig pts/0 00:00:00 mysqld Tue Aug 30 00:48:48 PDT 2005 ****************************************************** *** NOTE - HERE I TURN ON THE EMAIL SERVER ****************************************************** [root@mydb3 root]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5897 to server version: 4.1.13-standard-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use newco Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show processlist -> ; +------+------------+--------------------------+-------+-------------+------+----------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------------+--------------------------+-------+-------------+------+----------------------------------------------------------------+------------------+ | 3 | repl | mydb4.aserver.net:40847 | NULL | Binlog Dump | 244 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 4 | repl | mydb1.aserver.net:45334 | NULL | Binlog Dump | 244 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 5897 | root | localhost | newco | Query | 0 | NULL | show processlist | | 6883 | james_user | myemail1.aserver.net:57781 | mail | Sleep | 0 | | NULL | +------+------------+--------------------------+-------+-------------+------+----------------------------------------------------------------+------------------+ 4 rows in set (0.00 sec) ****************************************************** *** NOTE - HERE I TURN ON THE APP SERVER ****************************************************** mysql> show processlist; +-------+------+------------------------+-------+-------------+------+----------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+------+------------------------+-------+-------------+------+----------------------------------------------------------------+------------------+ | 3 | repl | mydb4.aserver.net:40847 | NULL | Binlog Dump | 652 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 4 | repl | mydb1.aserver.net:45334 | NULL | Binlog Dump | 652 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 5897 | root | localhost | newco | Query | 0 | NULL | show processlist | | 20126 | db | myapp1.aserver.net:39332 | newco | Sleep | 44 | | NULL | | 20150 | db | myapp1.aserver.net:39333 | newco | Sleep | 44 | | NULL | | 20154 | db | myapp1.aserver.net:39334 | newco | Sleep | 44 | | NULL | | 20157 | db | myapp1.aserver.net:39335 | newco | Sleep | 44 | | NULL | | 20159 | db | myapp1.aserver.net:39336 | newco | Sleep | 44 | | NULL | | 20162 | db | myapp1.aserver.net:39337 | newco | Sleep | 44 | | NULL | | 20165 | db | myapp1.aserver.net:39338 | newco | Sleep | 44 | | NULL | | 20168 | db | myapp1.aserver.net:39339 | newco | Sleep | 44 | | NULL | | 20174 | db | myapp1.aserver.net:39340 | newco | Sleep | 5 | | NULL | | 20177 | db | myapp1.aserver.net:39341 | newco | Sleep | 1 | | NULL | | 20195 | db | myapp1.aserver.net:39342 | newco | Sleep | 43 | | NULL | | 20214 | db | myapp1.aserver.net:39343 | newco | Sleep | 43 | | NULL | | 20218 | db | myapp1.aserver.net:39344 | newco | Sleep | 43 | | NULL | | 20222 | db | myapp1.aserver.net:39345 | newco | Sleep | 43 | | NULL | | 20228 | db | myapp1.aserver.net:39346 | newco | Sleep | 43 | | NULL | | 20230 | db | myapp1.aserver.net:39347 | newco | Sleep | 16 | | NULL | | 20232 | db | myapp1.aserver.net:39348 | newco | Sleep | 1 | | NULL | | 20235 | db | myapp1.aserver.net:39349 | newco | Sleep | 1 | | NULL | | 20238 | db | myapp1.aserver.net:39350 | newco | Sleep | 1 | | NULL | | 20240 | db | myapp1.aserver.net:39351 | newco | Sleep | 1 | | NULL | +-------+------+------------------------+-------+-------------+------+----------------------------------------------------------------+------------------+ 23 rows in set (0.00 sec) mysql> show processlist; +-------+------+------------------------+-------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+------+------------------------+-------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ | 3 | repl | mydb4.aserver.net:40847 | NULL | Binlog Dump | 667 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 4 | repl | mydb1.aserver.net:45334 | NULL | Binlog Dump | 667 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 5897 | root | localhost | newco | Query | 0 | NULL | show processlist | | 20126 | db | myapp1.aserver.net:39332 | newco | Sleep | 59 | | NULL | | 20150 | db | myapp1.aserver.net:39333 | newco | Sleep | 59 | | NULL | | 20154 | db | myapp1.aserver.net:39334 | newco | Sleep | 59 | | NULL | | 20157 | db | myapp1.aserver.net:39335 | newco | Sleep | 59 | | NULL | | 20159 | db | myapp1.aserver.net:39336 | newco | Sleep | 59 | | NULL | | 20162 | db | myapp1.aserver.net:39337 | newco | Sleep | 59 | | NULL | | 20165 | db | myapp1.aserver.net:39338 | newco | Sleep | 59 | | NULL | | 20168 | db | myapp1.aserver.net:39339 | newco | Sleep | 59 | | NULL | | 20174 | db | myapp1.aserver.net:39340 | newco | Sleep | 20 | | NULL | | 20177 | db | myapp1.aserver.net:39341 | newco | Sleep | 0 | | NULL | | 20195 | db | myapp1.aserver.net:39342 | newco | Sleep | 58 | | NULL | | 20214 | db | myapp1.aserver.net:39343 | newco | Sleep | 58 | | NULL | | 20218 | db | myapp1.aserver.net:39344 | newco | Sleep | 58 | | NULL | | 20222 | db | myapp1.aserver.net:39345 | newco | Sleep | 58 | | NULL | | 20228 | db | myapp1.aserver.net:39346 | newco | Sleep | 58 | | NULL | | 20230 | db | myapp1.aserver.net:39347 | newco | Sleep | 31 | | NULL | | 20232 | db | myapp1.aserver.net:39348 | newco | Sleep | 5 | | NULL | | 20235 | db | myapp1.aserver.net:39349 | newco | Sleep | 0 | | NULL | | 20238 | db | myapp1.aserver.net:39350 | newco | Execute | 1 | Copying to tmp table | SELECT STRAIGHT_JOIN DISTINCT UCASE( v.make ) AS make, UCASE( v.model ) AS model FROM ( SELECT STR | | 20240 | db | myapp1.aserver.net:39351 | newco | Sleep | 0 | | NULL | +-------+------+------------------------+-------+-------------+------+----------------------------------------------------------------+------------------------------------------------------------------------------------------------------+ 23 rows in set (0.00 sec) mysql> show processlist; +-------+------------+--------------------------+-------+-------------+------+----------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+------------+--------------------------+-------+-------------+------+----------------------------------------------------------------+------------------+ | 3 | repl | mydb4.aserver.net:40847 | NULL | Binlog Dump | 969 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 4 | repl | mydb1.aserver.net:45334 | NULL | Binlog Dump | 969 | Has sent all binlog to slave; waiting for binlog to be updated | NULL | | 5897 | root | localhost | newco | Query | 0 | NULL | show processlist | | 20126 | db | myapp1.aserver.net:39332 | newco | Sleep | 361 | | NULL | | 20150 | db | myapp1.aserver.net:39333 | newco | Sleep | 361 | | NULL | | 20154 | db | myapp1.aserver.net:39334 | newco | Sleep | 361 | | NULL | | 20157 | db | myapp1.aserver.net:39335 | newco | Sleep | 361 | | NULL | | 20159 | db | myapp1.aserver.net:39336 | newco | Sleep | 361 | | NULL | | 20162 | db | myapp1.aserver.net:39337 | newco | Sleep | 361 | | NULL | | 20165 | db | myapp1.aserver.net:39338 | newco | Sleep | 361 | | NULL | | 20168 | db | myapp1.aserver.net:39339 | newco | Sleep | 228 | | NULL | | 20174 | db | myapp1.aserver.net:39340 | newco | Sleep | 212 | | NULL | | 20177 | db | myapp1.aserver.net:39341 | newco | Sleep | 4 | | NULL | | 20195 | db | myapp1.aserver.net:39342 | newco | Sleep | 360 | | NULL | | 20214 | db | myapp1.aserver.net:39343 | newco | Sleep | 360 | | NULL | | 20218 | db | myapp1.aserver.net:39344 | newco | Sleep | 360 | | NULL | | 20222 | db | myapp1.aserver.net:39345 | newco | Sleep | 360 | | NULL | | 20228 | db | myapp1.aserver.net:39346 | newco | Sleep | 293 | | NULL | | 20230 | db | myapp1.aserver.net:39347 | newco | Sleep | 291 | | NULL | | 20232 | db | myapp1.aserver.net:39348 | newco | Sleep | 289 | | NULL | | 20235 | db | myapp1.aserver.net:39349 | newco | Sleep | 25 | | NULL | | 20238 | db | myapp1.aserver.net:39350 | newco | Sleep | 6 | | NULL | | 20240 | db | myapp1.aserver.net:39351 | newco | Sleep | 1 | | NULL | | 33553 | james_user | myemail1.aserver.net:56210 | mail | Sleep | 0 | | NULL | +-------+------------+--------------------------+-------+-------------+------+----------------------------------------------------------------+------------------+ 24 rows in set (0.00 sec) mysql> exit Bye [root@mydb3 root]# date; ps -el | grep my; date; mysqladmin -u root -p flush-tables; date; ps -el | grep my; date Tue Aug 30 01:05:15 PDT 2005 4 S 0 5951 1 0 85 0 - 1061 wait4 pts/0 00:00:00 mysqld_safe 4 S 27 5983 5951 0 75 0 - 421109 schedu pts/0 00:00:02 mysqld 1 S 27 5984 5983 0 75 0 - 421109 schedu pts/0 00:00:00 mysqld 1 S 27 5985 5984 0 85 0 - 421109 rt_sig pts/0 00:00:00 mysqld 1 S 27 5986 5984 0 75 0 - 421109 rt_sig pts/0 00:00:00 mysqld 1 S 27 5987 5984 0 75 0 - 421109 rt_sig pts/0 00:00:01 mysqld 1 S 27 5988 5984 0 75 0 - 421109 rt_sig pts/0 00:00:00 mysqld 1 S 27 5989 5984 0 75 0 - 421109 schedu pts/0 00:00:00 mysqld 1 S 27 5990 5984 0 76 0 - 421109 schedu pts/0 00:00:00 mysqld 1 S 27 5993 5984 0 75 0 - 421109 schedu pts/0 00:00:00 mysqld 1 S 27 5994 5984 0 75 0 - 421109 rt_sig pts/0 00:00:01 mysqld 1 S 27 6005 5984 0 75 0 - 421109 rt_sig pts/0 00:00:00 mysqld 1 S 27 6019 5984 0 75 0 - 421109 rt_sig pts/0 00:00:00 mysqld 1 S 27 6023 5984 0 75 0 - 421109 schedu pts/0 00:00:02 mysqld 1 S 27 6025 5984 0 75 0 - 421109 schedu pts/0 00:00:02 mysqld 1 S 27 6027 5984 0 75 0 - 421109 schedu pts/0 00:00:02 mysqld 1 S 27 6029 5984 0 75 0 - 421109 schedu pts/0 00:00:02 mysqld 1 S 27 6030 5984 0 75 0 - 421109 schedu pts/0 00:00:02 mysqld 1 S 27 6031 5984 0 75 0 - 421109 schedu pts/0 00:00:00 mysqld 1 S 27 6032 5984 0 75 0 - 421109 schedu pts/0 00:00:02 mysqld 1 S 27 6035 5984 0 75 0 - 421109 schedu pts/0 00:00:01 mysqld 1 S 27 6037 5984 0 77 0 - 421109 schedu pts/0 00:00:03 mysqld 1 S 27 6038 5984 0 75 0 - 421109 schedu pts/0 00:00:01 mysqld 1 S 27 6040 5984 0 75 0 - 421109 schedu pts/0 00:00:02 mysqld 1 S 27 6041 5984 0 75 0 - 421109 schedu pts/0 00:00:04 mysqld 1 S 27 6042 5984 0 75 0 - 421109 schedu pts/0 00:00:06 mysqld 1 S 27 6043 5984 0 75 0 - 421109 schedu pts/0 00:00:04 mysqld 1 S 27 6045 5984 0 75 0 - 421109 schedu pts/0 00:00:04 mysqld 1 S 27 6046 5984 0 76 0 - 421109 schedu pts/0 00:00:04 mysqld 1 S 27 6055 5984 0 76 0 - 421109 schedu pts/0 00:00:03 mysqld 1 S 27 6056 5984 0 76 0 - 421109 schedu pts/0 00:00:02 mysqld 1 S 27 6057 5984 4 76 0 - 421109 schedu pts/0 00:00:15 mysqld 1 S 27 6058 5984 2 75 0 - 421109 schedu pts/0 00:00:08 mysqld 1 S 27 6059 5984 1 75 0 - 421109 schedu pts/0 00:00:06 mysqld 1 S 27 6061 5984 2 75 0 - 421109 rt_sig pts/0 00:00:09 mysqld 1 S 27 6069 5984 2 75 0 - 421112 rt_sig pts/0 00:00:07 mysqld 1 S 27 6070 5984 2 75 0 - 421109 rt_sig pts/0 00:00:07 mysqld Tue Aug 30 01:05:15 PDT 2005 Enter password: Tue Aug 30 01:05:17 PDT 2005 4 S 0 5951 1 0 85 0 - 1061 wait4 pts/0 00:00:00 mysqld_safe 4 S 27 5983 5951 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 5984 5983 0 75 0 - 421071 schedu pts/0 00:00:00 mysqld 1 S 27 5985 5984 0 85 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 5986 5984 0 75 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 5987 5984 0 75 0 - 421071 rt_sig pts/0 00:00:01 mysqld 1 S 27 5988 5984 0 75 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 5989 5984 0 75 0 - 421071 schedu pts/0 00:00:00 mysqld 1 S 27 5990 5984 0 75 0 - 421071 schedu pts/0 00:00:00 mysqld 1 S 27 5993 5984 0 75 0 - 421071 schedu pts/0 00:00:00 mysqld 1 S 27 5994 5984 0 75 0 - 421071 rt_sig pts/0 00:00:01 mysqld 1 S 27 6005 5984 0 75 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 6019 5984 0 75 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 6023 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6025 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6027 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6029 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6030 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6031 5984 0 75 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 6032 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6035 5984 0 75 0 - 421071 schedu pts/0 00:00:01 mysqld 1 S 27 6037 5984 0 77 0 - 421071 schedu pts/0 00:00:03 mysqld 1 S 27 6038 5984 0 75 0 - 421071 schedu pts/0 00:00:01 mysqld 1 S 27 6040 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6041 5984 0 75 0 - 421071 schedu pts/0 00:00:04 mysqld 1 S 27 6042 5984 0 75 0 - 421071 schedu pts/0 00:00:06 mysqld 1 S 27 6043 5984 0 75 0 - 421071 schedu pts/0 00:00:04 mysqld 1 S 27 6045 5984 0 75 0 - 421071 schedu pts/0 00:00:04 mysqld 1 S 27 6046 5984 0 76 0 - 421071 schedu pts/0 00:00:04 mysqld 1 S 27 6055 5984 0 76 0 - 421071 schedu pts/0 00:00:03 mysqld 1 S 27 6056 5984 0 76 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6057 5984 4 75 0 - 421071 schedu pts/0 00:00:15 mysqld 1 S 27 6058 5984 2 75 0 - 421071 schedu pts/0 00:00:08 mysqld 1 S 27 6059 5984 1 75 0 - 421071 schedu pts/0 00:00:06 mysqld 1 S 27 6061 5984 2 75 0 - 421071 schedu pts/0 00:00:09 mysqld 1 S 27 6069 5984 2 75 0 - 421071 rt_sig pts/0 00:00:07 mysqld 1 S 27 6070 5984 2 75 0 - 421071 rt_sig pts/0 00:00:07 mysqld Tue Aug 30 01:05:17 PDT 2005 [root@mydb3 root]# date; ps -el | grep my; date; mysqladmin -u root -p flush-threads; date; ps -el | grep my; date Tue Aug 30 01:05:22 PDT 2005 4 S 0 5951 1 0 85 0 - 1061 wait4 pts/0 00:00:00 mysqld_safe 4 S 27 5983 5951 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 5984 5983 0 75 0 - 421071 schedu pts/0 00:00:00 mysqld 1 S 27 5985 5984 0 85 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 5986 5984 0 75 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 5987 5984 0 75 0 - 421071 rt_sig pts/0 00:00:01 mysqld 1 S 27 5988 5984 0 75 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 5989 5984 0 75 0 - 421071 schedu pts/0 00:00:00 mysqld 1 S 27 5990 5984 0 75 0 - 421071 schedu pts/0 00:00:00 mysqld 1 S 27 5993 5984 0 75 0 - 421071 schedu pts/0 00:00:00 mysqld 1 S 27 5994 5984 0 75 0 - 421071 rt_sig pts/0 00:00:01 mysqld 1 S 27 6005 5984 0 75 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 6019 5984 0 75 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 6023 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6025 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6027 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6029 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6030 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6031 5984 0 76 0 - 421071 rt_sig pts/0 00:00:00 mysqld 1 S 27 6032 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6035 5984 0 75 0 - 421071 schedu pts/0 00:00:01 mysqld 1 S 27 6037 5984 0 77 0 - 421071 schedu pts/0 00:00:03 mysqld 1 S 27 6038 5984 0 75 0 - 421071 schedu pts/0 00:00:01 mysqld 1 S 27 6040 5984 0 75 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6041 5984 0 75 0 - 421071 schedu pts/0 00:00:04 mysqld 1 S 27 6042 5984 0 75 0 - 421071 schedu pts/0 00:00:06 mysqld 1 S 27 6043 5984 0 75 0 - 421071 schedu pts/0 00:00:04 mysqld 1 S 27 6045 5984 0 75 0 - 421071 schedu pts/0 00:00:04 mysqld 1 S 27 6046 5984 0 76 0 - 421071 schedu pts/0 00:00:04 mysqld 1 S 27 6055 5984 0 76 0 - 421071 schedu pts/0 00:00:03 mysqld 1 S 27 6056 5984 0 76 0 - 421071 schedu pts/0 00:00:02 mysqld 1 S 27 6057 5984 4 75 0 - 421071 schedu pts/0 00:00:15 mysqld 1 S 27 6058 5984 2 75 0 - 421071 schedu pts/0 00:00:08 mysqld 1 S 27 6059 5984 1 75 0 - 421071 schedu pts/0 00:00:06 mysqld 1 S 27 6061 5984 2 75 0 - 421071 rt_sig pts/0 00:00:09 mysqld 1 S 27 6069 5984 2 75 0 - 421071 rt_sig pts/0 00:00:07 mysqld 1 S 27 6070 5984 2 75 0 - 421071 schedu pts/0 00:00:07 mysqld Tue Aug 30 01:05:22 PDT 2005 Enter password: Tue Aug 30 01:05:24 PDT 2005 4 S 0 5951 1 0 85 0 - 1061 wait4 pts/0 00:00:00 mysqld_safe 4 S 27 5983 5951 0 75 0 - 421008 schedu pts/0 00:00:02 mysqld 1 S 27 5984 5983 0 75 0 - 421008 schedu pts/0 00:00:00 mysqld 1 S 27 5985 5984 0 85 0 - 421008 rt_sig pts/0 00:00:00 mysqld 1 S 27 5986 5984 0 75 0 - 421008 rt_sig pts/0 00:00:00 mysqld 1 S 27 5987 5984 0 75 0 - 421008 rt_sig pts/0 00:00:01 mysqld 1 S 27 5988 5984 0 75 0 - 421008 rt_sig pts/0 00:00:00 mysqld 1 S 27 5989 5984 0 75 0 - 421008 schedu pts/0 00:00:00 mysqld 1 S 27 5990 5984 0 75 0 - 421008 schedu pts/0 00:00:00 mysqld 1 S 27 5993 5984 0 75 0 - 421008 schedu pts/0 00:00:00 mysqld 1 S 27 5994 5984 0 75 0 - 421008 rt_sig pts/0 00:00:01 mysqld 1 S 27 6005 5984 0 75 0 - 421008 rt_sig pts/0 00:00:00 mysqld 1 S 27 6019 5984 0 75 0 - 421008 rt_sig pts/0 00:00:00 mysqld 1 S 27 6023 5984 0 75 0 - 421008 schedu pts/0 00:00:02 mysqld 1 S 27 6025 5984 0 75 0 - 421008 schedu pts/0 00:00:02 mysqld 1 S 27 6027 5984 0 75 0 - 421008 schedu pts/0 00:00:02 mysqld 1 S 27 6029 5984 0 75 0 - 421008 schedu pts/0 00:00:02 mysqld 1 S 27 6030 5984 0 75 0 - 421008 schedu pts/0 00:00:02 mysqld 1 S 27 6032 5984 0 75 0 - 421008 schedu pts/0 00:00:02 mysqld 1 S 27 6035 5984 0 75 0 - 421008 schedu pts/0 00:00:01 mysqld 1 S 27 6037 5984 0 77 0 - 421008 schedu pts/0 00:00:03 mysqld 1 S 27 6038 5984 0 75 0 - 421008 schedu pts/0 00:00:01 mysqld 1 S 27 6040 5984 0 75 0 - 421008 schedu pts/0 00:00:02 mysqld 1 S 27 6041 5984 0 75 0 - 421008 schedu pts/0 00:00:04 mysqld 1 S 27 6042 5984 0 75 0 - 421008 schedu pts/0 00:00:06 mysqld 1 S 27 6043 5984 0 75 0 - 421008 schedu pts/0 00:00:04 mysqld 1 S 27 6045 5984 0 75 0 - 421008 schedu pts/0 00:00:04 mysqld 1 S 27 6046 5984 0 76 0 - 421008 schedu pts/0 00:00:04 mysqld 1 S 27 6055 5984 0 76 0 - 421008 schedu pts/0 00:00:03 mysqld 1 S 27 6056 5984 0 76 0 - 421008 schedu pts/0 00:00:02 mysqld 1 S 27 6057 5984 3 75 0 - 421008 schedu pts/0 00:00:15 mysqld 1 S 27 6058 5984 2 75 0 - 421008 schedu pts/0 00:00:08 mysqld 1 S 27 6059 5984 1 75 0 - 421008 schedu pts/0 00:00:06 mysqld 1 S 27 6069 5984 2 75 0 - 421008 schedu pts/0 00:00:07 mysqld 1 S 27 6070 5984 2 75 0 - 421008 rt_sig pts/0 00:00:08 mysqld Tue Aug 30 01:05:24 PDT 2005 [root@mydb3 root]# [root@mydb3 root]#