[root@localhost root]# date; ps -el | grep my; date; mysqladmin -u root -p flush-tables; date; ps -el | grep my; date Sat Aug 6 21:12:49 PDT 2005 4 S 0 31193 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 31225 31193 0 75 0 - 608809 schedu ? 00:57:09 mysqld 1 S 27 31226 31225 0 75 0 - 608809 schedu ? 00:00:15 mysqld 1 S 27 31227 31226 0 75 0 - 608809 rt_sig ? 00:00:00 mysqld 1 S 27 31228 31226 0 75 0 - 608809 rt_sig ? 00:00:11 mysqld 1 S 27 31229 31226 0 75 0 - 608809 rt_sig ? 00:01:12 mysqld 1 S 27 31230 31226 0 75 0 - 608809 rt_sig ? 00:03:28 mysqld 1 S 27 31231 31226 0 75 0 - 608809 schedu ? 00:17:13 mysqld 1 S 27 31232 31226 0 75 0 - 608809 schedu ? 00:14:53 mysqld 1 S 27 31233 31226 0 75 0 - 608809 schedu ? 00:09:53 mysqld 1 S 27 31234 31226 0 75 0 - 608809 rt_sig ? 00:29:00 mysqld 1 S 27 13305 31226 0 75 0 - 608809 rt_sig ? 00:33:27 mysqld 1 S 27 15862 31226 0 75 0 - 608809 rt_sig ? 00:13:11 mysqld 1 S 27 18018 31226 1 75 0 - 608809 schedu ? 00:24:07 mysqld 1 S 27 18061 31226 1 75 0 - 608809 rt_sig ? 00:24:45 mysqld 1 R 27 18500 31226 1 76 0 - 608809 - ? 00:26:42 mysqld 1 S 27 18717 31226 1 75 0 - 608809 schedu ? 00:21:34 mysqld 1 S 27 18738 31226 0 76 0 - 608809 schedu ? 00:10:38 mysqld 1 S 27 19046 31226 1 75 0 - 608809 schedu ? 00:27:27 mysqld 1 S 27 20276 31226 0 75 0 - 608809 schedu ? 00:07:09 mysqld 1 S 27 20368 31226 0 75 0 - 608809 rt_sig ? 00:06:17 mysqld 1 S 27 20369 31226 2 75 0 - 608809 schedu ? 00:19:20 mysqld 1 S 27 20370 31226 0 75 0 - 608809 rt_sig ? 00:04:12 mysqld 1 S 27 20387 31226 1 76 0 - 608809 schedu ? 00:08:59 mysqld 1 S 27 20390 31226 0 75 0 - 608809 schedu ? 00:06:41 mysqld 1 S 27 20391 31226 0 75 0 - 608809 rt_sig ? 00:04:10 mysqld 1 S 27 20392 31226 0 75 0 - 608809 schedu ? 00:04:47 mysqld 1 S 27 20764 31226 0 75 0 - 608809 schedu ? 00:01:43 mysqld 1 S 27 20765 31226 0 75 0 - 608809 schedu ? 00:02:05 mysqld 1 S 27 20766 31226 2 75 0 - 608809 rt_sig ? 00:11:53 mysqld 1 S 27 20767 31226 0 75 0 - 608809 rt_sig ? 00:01:55 mysqld 1 S 27 20771 31226 0 75 0 - 608809 schedu ? 00:03:42 mysqld 1 S 27 20813 31226 0 75 0 - 608809 schedu ? 00:03:15 mysqld 1 S 27 20899 31226 0 75 0 - 608809 rt_sig ? 00:02:09 mysqld 1 S 27 20900 31226 0 75 0 - 608809 schedu ? 00:01:46 mysqld 1 S 27 20901 31226 0 75 0 - 608809 schedu ? 00:02:39 mysqld 1 S 27 20902 31226 0 75 0 - 608809 schedu ? 00:02:33 mysqld 1 S 27 20903 31226 2 75 0 - 608809 schedu ? 00:09:43 mysqld 1 S 27 20904 31226 0 75 0 - 608809 schedu ? 00:03:02 mysqld 1 S 27 20907 31226 0 75 0 - 608809 schedu ? 00:01:27 mysqld 1 S 27 20929 31226 0 75 0 - 608809 rt_sig ? 00:02:55 mysqld Sat Aug 6 21:12:49 PDT 2005 Enter password: Sat Aug 6 21:12:53 PDT 2005 4 S 0 31193 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 31225 31193 0 75 0 - 586016 schedu ? 00:57:09 mysqld 1 S 27 31226 31225 0 75 0 - 586016 schedu ? 00:00:15 mysqld 1 S 27 31227 31226 0 75 0 - 586016 rt_sig ? 00:00:00 mysqld 1 S 27 31228 31226 0 75 0 - 586016 rt_sig ? 00:00:11 mysqld 1 S 27 31229 31226 0 75 0 - 586016 rt_sig ? 00:01:12 mysqld 1 S 27 31230 31226 0 75 0 - 586016 rt_sig ? 00:03:28 mysqld 1 S 27 31231 31226 0 75 0 - 586016 schedu ? 00:17:13 mysqld 1 S 27 31232 31226 0 75 0 - 586016 schedu ? 00:14:53 mysqld 1 S 27 31233 31226 0 75 0 - 586016 schedu ? 00:09:53 mysqld 1 S 27 31234 31226 0 75 0 - 586016 rt_sig ? 00:29:00 mysqld 1 S 27 13305 31226 0 75 0 - 586016 rt_sig ? 00:33:27 mysqld 1 S 27 15862 31226 0 75 0 - 586016 rt_sig ? 00:13:11 mysqld 1 S 27 18018 31226 1 75 0 - 586016 schedu ? 00:24:07 mysqld 1 S 27 18061 31226 1 75 0 - 586016 rt_sig ? 00:24:45 mysqld 1 S 27 18500 31226 1 76 0 - 586016 schedu ? 00:26:42 mysqld 1 S 27 18717 31226 1 75 0 - 586016 schedu ? 00:21:34 mysqld 1 S 27 18738 31226 0 76 0 - 586016 schedu ? 00:10:38 mysqld 1 S 27 19046 31226 1 75 0 - 586016 schedu ? 00:27:27 mysqld 1 S 27 20276 31226 0 75 0 - 586016 schedu ? 00:07:09 mysqld 1 S 27 20368 31226 0 75 0 - 586016 rt_sig ? 00:06:17 mysqld 1 S 27 20369 31226 2 75 0 - 586016 schedu ? 00:19:20 mysqld 1 S 27 20370 31226 0 76 0 - 586016 rt_sig ? 00:04:12 mysqld 1 S 27 20387 31226 1 76 0 - 586016 schedu ? 00:08:59 mysqld 1 S 27 20390 31226 0 75 0 - 586016 schedu ? 00:06:41 mysqld 1 S 27 20391 31226 0 75 0 - 586016 rt_sig ? 00:04:10 mysqld 1 S 27 20392 31226 0 75 0 - 586016 schedu ? 00:04:47 mysqld 1 S 27 20764 31226 0 75 0 - 586016 schedu ? 00:01:43 mysqld 1 S 27 20765 31226 0 75 0 - 586016 schedu ? 00:02:05 mysqld 1 S 27 20766 31226 2 75 0 - 586016 rt_sig ? 00:11:53 mysqld 1 S 27 20767 31226 0 75 0 - 586016 rt_sig ? 00:01:55 mysqld 1 S 27 20771 31226 0 75 0 - 586016 schedu ? 00:03:42 mysqld 1 S 27 20813 31226 0 75 0 - 586016 schedu ? 00:03:15 mysqld 1 S 27 20899 31226 0 75 0 - 586016 rt_sig ? 00:02:09 mysqld 1 S 27 20900 31226 0 75 0 - 586016 schedu ? 00:01:46 mysqld 1 S 27 20901 31226 0 75 0 - 586016 schedu ? 00:02:39 mysqld 1 S 27 20902 31226 0 75 0 - 586016 schedu ? 00:02:33 mysqld 1 S 27 20903 31226 2 75 0 - 586016 schedu ? 00:09:43 mysqld 1 S 27 20904 31226 0 75 0 - 586016 schedu ? 00:03:02 mysqld 1 S 27 20907 31226 0 75 0 - 586016 schedu ? 00:01:27 mysqld 1 S 27 20929 31226 0 75 0 - 586016 rt_sig ? 00:02:55 mysqld Sat Aug 6 21:12:53 PDT 2005 [root@localhost root]# date; ps -el | grep my; date; mysqladmin -u root -p flush-threads; date; ps -el | grep my; date Sat Aug 6 21:14:13 PDT 2005 4 S 0 31193 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 31225 31193 0 75 0 - 586016 schedu ? 00:57:09 mysqld 1 S 27 31226 31225 0 75 0 - 586016 schedu ? 00:00:15 mysqld 1 S 27 31227 31226 0 75 0 - 586016 rt_sig ? 00:00:00 mysqld 1 S 27 31228 31226 0 75 0 - 586016 rt_sig ? 00:00:11 mysqld 1 S 27 31229 31226 0 75 0 - 586016 rt_sig ? 00:01:12 mysqld 1 S 27 31230 31226 0 75 0 - 586016 rt_sig ? 00:03:28 mysqld 1 S 27 31231 31226 0 75 0 - 586016 schedu ? 00:17:13 mysqld 1 S 27 31232 31226 0 75 0 - 586016 schedu ? 00:14:53 mysqld 1 S 27 31233 31226 0 75 0 - 586016 schedu ? 00:09:53 mysqld 1 S 27 31234 31226 0 75 0 - 586016 rt_sig ? 00:29:00 mysqld 1 S 27 13305 31226 0 75 0 - 586016 rt_sig ? 00:33:27 mysqld 1 S 27 15862 31226 0 75 0 - 586016 rt_sig ? 00:13:11 mysqld 1 S 27 18018 31226 1 75 0 - 586016 rt_sig ? 00:24:07 mysqld 1 S 27 18061 31226 1 75 0 - 586016 rt_sig ? 00:24:46 mysqld 1 S 27 18500 31226 1 75 0 - 586016 schedu ? 00:26:43 mysqld 1 S 27 18717 31226 1 75 0 - 586016 schedu ? 00:21:34 mysqld 1 S 27 18738 31226 0 75 0 - 586016 schedu ? 00:10:38 mysqld 1 S 27 19046 31226 1 76 0 - 586016 schedu ? 00:27:28 mysqld 1 S 27 20276 31226 0 75 0 - 586016 schedu ? 00:07:09 mysqld 1 S 27 20368 31226 0 75 0 - 586016 rt_sig ? 00:06:17 mysqld 1 S 27 20369 31226 2 75 0 - 586016 schedu ? 00:19:20 mysqld 1 S 27 20370 31226 0 76 0 - 586016 rt_sig ? 00:04:13 mysqld 1 S 27 20387 31226 1 75 0 - 586016 schedu ? 00:08:59 mysqld 1 S 27 20390 31226 0 75 0 - 586016 schedu ? 00:06:41 mysqld 1 S 27 20391 31226 0 75 0 - 586016 schedu ? 00:04:11 mysqld 1 S 27 20392 31226 0 75 0 - 586016 schedu ? 00:04:47 mysqld 1 S 27 20764 31226 0 75 0 - 586016 schedu ? 00:01:43 mysqld 1 S 27 20765 31226 0 75 0 - 586016 schedu ? 00:02:05 mysqld 1 S 27 20766 31226 2 76 0 - 586016 schedu ? 00:11:54 mysqld 1 S 27 20767 31226 0 75 0 - 586016 rt_sig ? 00:01:55 mysqld 1 S 27 20771 31226 0 76 0 - 586016 rt_sig ? 00:03:43 mysqld 1 S 27 20813 31226 0 75 0 - 586016 schedu ? 00:03:15 mysqld 1 S 27 20899 31226 0 75 0 - 586016 rt_sig ? 00:02:09 mysqld 1 S 27 20900 31226 0 75 0 - 586016 schedu ? 00:01:46 mysqld 1 S 27 20901 31226 0 75 0 - 586016 schedu ? 00:02:39 mysqld 1 S 27 20902 31226 0 75 0 - 586016 rt_sig ? 00:02:33 mysqld 1 S 27 20903 31226 2 75 0 - 586016 schedu ? 00:09:43 mysqld 1 S 27 20904 31226 0 75 0 - 586016 schedu ? 00:03:02 mysqld 1 S 27 20907 31226 0 75 0 - 586016 schedu ? 00:01:27 mysqld 1 S 27 20929 31226 0 75 0 - 586016 schedu ? 00:02:56 mysqld Sat Aug 6 21:14:13 PDT 2005 Enter password: Sat Aug 6 21:14:16 PDT 2005 4 S 0 31193 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 31225 31193 0 75 0 - 585792 schedu ? 00:57:09 mysqld 1 S 27 31226 31225 0 75 0 - 585792 schedu ? 00:00:15 mysqld 1 S 27 31227 31226 0 75 0 - 585792 rt_sig ? 00:00:00 mysqld 1 S 27 31228 31226 0 75 0 - 585792 rt_sig ? 00:00:11 mysqld 1 S 27 31229 31226 0 75 0 - 585792 rt_sig ? 00:01:12 mysqld 1 S 27 31230 31226 0 75 0 - 585792 rt_sig ? 00:03:28 mysqld 1 S 27 31231 31226 0 75 0 - 585792 schedu ? 00:17:13 mysqld 1 S 27 31232 31226 0 75 0 - 585792 schedu ? 00:14:53 mysqld 1 S 27 31233 31226 0 75 0 - 585792 schedu ? 00:09:53 mysqld 1 S 27 31234 31226 0 75 0 - 585792 rt_sig ? 00:29:00 mysqld 1 S 27 13305 31226 0 75 0 - 585792 rt_sig ? 00:33:27 mysqld 1 S 27 18500 31226 1 75 0 - 585792 schedu ? 00:26:43 mysqld 1 S 27 18717 31226 1 75 0 - 585792 schedu ? 00:21:34 mysqld 1 S 27 18738 31226 0 75 0 - 585792 schedu ? 00:10:38 mysqld 1 S 27 19046 31226 1 76 0 - 585792 schedu ? 00:27:28 mysqld 1 S 27 20276 31226 0 75 0 - 585792 schedu ? 00:07:09 mysqld 1 S 27 20368 31226 0 75 0 - 585792 rt_sig ? 00:06:17 mysqld 1 S 27 20369 31226 2 75 0 - 585792 schedu ? 00:19:20 mysqld 1 S 27 20387 31226 1 75 0 - 585792 schedu ? 00:08:59 mysqld 1 S 27 20390 31226 0 75 0 - 585792 schedu ? 00:06:41 mysqld 1 S 27 20391 31226 0 76 0 - 585792 schedu ? 00:04:11 mysqld 1 S 27 20392 31226 0 75 0 - 585792 schedu ? 00:04:47 mysqld 1 S 27 20764 31226 0 75 0 - 585792 schedu ? 00:01:43 mysqld 1 S 27 20765 31226 0 75 0 - 585792 schedu ? 00:02:05 mysqld 1 S 27 20766 31226 2 76 0 - 585792 schedu ? 00:11:54 mysqld 1 S 27 20813 31226 0 75 0 - 585792 schedu ? 00:03:15 mysqld 1 S 27 20900 31226 0 75 0 - 585792 schedu ? 00:01:46 mysqld 1 S 27 20901 31226 0 75 0 - 585792 schedu ? 00:02:39 mysqld 1 S 27 20902 31226 0 75 0 - 585792 rt_sig ? 00:02:33 mysqld 1 S 27 20903 31226 2 75 0 - 585792 schedu ? 00:09:43 mysqld 1 S 27 20904 31226 0 75 0 - 585792 schedu ? 00:03:02 mysqld 1 S 27 20907 31226 0 75 0 - 585792 schedu ? 00:01:27 mysqld 1 S 27 20929 31226 0 75 0 - 585792 schedu ? 00:02:56 mysqld Sat Aug 6 21:14:16 PDT 2005 [root@localhost root]# date; mysqladmin -u root -p processlist; date; ps -el | grep my Sat Aug 6 21:15:20 PDT 2005 Enter password: +----------+------+------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----------+------+------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------+ | 7315174 | repl | db.somehost.com:44491 | | Binlog Dump | 1078524 | Has sent all binlog to slave; waiting for binlog to be updated | | | 51579761 | repl | db2.somehost.com:40522 | | Binlog Dump | 4675 | Has sent all binlog to slave; waiting for binlog to be updated | | | 51605675 | db | app.somehost.com:47596 | newco | Sleep | 2660 | | | | 51605676 | db | app.somehost.com:47597 | newco | Sleep | 2660 | | | | 51605677 | db | app.somehost.com:47598 | newco | Sleep | 2660 | | | | 51605679 | db | app.somehost.com:47599 | newco | Sleep | 2660 | | | | 51605680 | db | app.somehost.com:47600 | newco | Sleep | 2660 | | | | 51605682 | db | app.somehost.com:47601 | newco | Sleep | 411 | | | | 51605684 | db | app.somehost.com:47602 | newco | Sleep | 102 | | | | 51605685 | db | app.somehost.com:47603 | newco | Sleep | 87 | | | | 51605687 | db | app.somehost.com:47604 | newco | Sleep | 87 | | | | 51605689 | db | app.somehost.com:47605 | newco | Sleep | 27 | | | | 51607343 | db | app.somehost.com:47622 | newco | Sleep | 102 | | | | 51607345 | db | app.somehost.com:47623 | newco | Sleep | 102 | | | | 51619052 | db | app.somehost.com:47682 | newco | Sleep | 102 | | | | 51619053 | db | app.somehost.com:47683 | newco | Sleep | 102 | | | | 51619054 | db | app.somehost.com:47684 | newco | Sleep | 101 | | | | 51619055 | db | app.somehost.com:47685 | newco | Sleep | 101 | | | | 51619056 | db | app.somehost.com:47686 | newco | Sleep | 38 | | | | 51640949 | db | app.somehost.com:47793 | newco | Sleep | 38 | | | | 51640951 | db | app.somehost.com:47794 | newco | Sleep | 9 | | | | 51640953 | db | app.somehost.com:47795 | newco | Sleep | 1 | | | | 51643595 | root | localhost | | Query | 0 | | show processlist | +----------+------+------------------------+-------+-------------+---------+----------------------------------------------------------------+------------------+ Sat Aug 6 21:15:23 PDT 2005 4 S 0 31193 1 0 85 0 - 1062 wait4 ? 00:00:00 mysqld_safe 4 S 27 31225 31193 0 75 0 - 585856 schedu ? 00:57:09 mysqld 1 S 27 31226 31225 0 75 0 - 585856 schedu ? 00:00:15 mysqld 1 S 27 31227 31226 0 75 0 - 585856 rt_sig ? 00:00:00 mysqld 1 S 27 31228 31226 0 75 0 - 585856 rt_sig ? 00:00:11 mysqld 1 S 27 31229 31226 0 75 0 - 585856 rt_sig ? 00:01:12 mysqld 1 S 27 31230 31226 0 75 0 - 585856 rt_sig ? 00:03:28 mysqld 1 S 27 31231 31226 0 75 0 - 585856 schedu ? 00:17:13 mysqld 1 S 27 31232 31226 0 75 0 - 585856 schedu ? 00:14:53 mysqld 1 S 27 31233 31226 0 75 0 - 585856 schedu ? 00:09:53 mysqld 1 S 27 31234 31226 0 75 0 - 585856 rt_sig ? 00:29:00 mysqld 1 S 27 13305 31226 0 75 0 - 585856 rt_sig ? 00:33:27 mysqld 1 S 27 18500 31226 1 76 0 - 585856 schedu ? 00:26:43 mysqld 1 S 27 18717 31226 1 75 0 - 585856 schedu ? 00:21:34 mysqld 1 S 27 18738 31226 0 75 0 - 585856 schedu ? 00:10:38 mysqld 1 S 27 19046 31226 1 76 0 - 585856 schedu ? 00:27:28 mysqld 1 S 27 20276 31226 0 75 0 - 585856 schedu ? 00:07:09 mysqld 1 S 27 20368 31226 0 75 0 - 585856 rt_sig ? 00:06:17 mysqld 1 S 27 20369 31226 2 75 0 - 585856 schedu ? 00:19:20 mysqld 1 S 27 20387 31226 1 75 0 - 585856 schedu ? 00:08:59 mysqld 1 S 27 20390 31226 0 75 0 - 585856 schedu ? 00:06:41 mysqld 1 S 27 20391 31226 0 75 0 - 585856 schedu ? 00:04:12 mysqld 1 S 27 20392 31226 0 75 0 - 585856 schedu ? 00:04:47 mysqld 1 S 27 20764 31226 0 75 0 - 585856 schedu ? 00:01:43 mysqld 1 S 27 20765 31226 0 75 0 - 585856 schedu ? 00:02:05 mysqld 1 S 27 20766 31226 2 75 0 - 585856 schedu ? 00:11:54 mysqld 1 S 27 20813 31226 0 75 0 - 585856 schedu ? 00:03:15 mysqld 1 S 27 20900 31226 0 75 0 - 585856 schedu ? 00:01:46 mysqld 1 S 27 20901 31226 0 75 0 - 585856 schedu ? 00:02:39 mysqld 1 S 27 20902 31226 0 75 0 - 585856 rt_sig ? 00:02:34 mysqld 1 S 27 20903 31226 2 75 0 - 585856 schedu ? 00:09:43 mysqld 1 S 27 20904 31226 0 75 0 - 585856 schedu ? 00:03:02 mysqld 1 S 27 20907 31226 0 75 0 - 585856 schedu ? 00:01:27 mysqld 1 S 27 20929 31226 0 75 0 - 585856 schedu ? 00:02:56 mysqld 1 S 27 21366 31226 1 75 0 - 585856 rt_sig ? 00:00:01 mysqld 1 S 27 21367 31226 2 76 0 - 585856 rt_sig ? 00:00:00 mysqld [root@localhost root]# date Sat Aug 6 21:15:30 PDT 2005 [root@localhost root]# mysqladmin -u root -p status Enter password: Uptime: 1369637 Threads: 23 Questions: 1223821149 Slow queries: 36456 Opens: 9967393 Flush tables: 12 Open tables: 161 Queries per second avg: 893.537 [root@localhost root]# [root@localhost root]# date Sat Aug 6 21:18:25 PDT 2005