[原创]把PROCESSLIST存放到表里

现在只能这样干，如果还有其他办法，请指导
把PROCESSLIST的结构存放到表里面，
这里用的是ROOT。
SOCKET是/TMP/MYSQL50.SOCK
[david_test~]# /usr/local/mysql/bin/mysql -uroot -p -S/tmp/mysql50.sock -s -e 'show processlist'> /tmp/processlist.txt
Enter password:
[david_test~]# ./entermysqlroot2
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 454
Server version: 5.0.45-log MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use david_test
Database changed
mysql> create table processlist(id int not null,User varchar(64) not null,host varchar(100) not null,db varchar(64) not null,command char(10) not null,time int, state varchar(255) not null,info text not null);
Query OK, 0 rows affected (0.00 sec)

mysql> load data infile '/tmp/processlist.txt' into table processlist;
Query OK, 14 rows affected (0.00 sec)
Records: 14  Deleted: 0  Skipped: 0  Warnings: 0

mysql> select * from processlist;
+-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+
| id  | User      | host               | db                       | command | time  | state | info             |
+-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+
|  73 | lisongtao | 192.168.0.50:12341 | colorful_site_lisongtao2 | Sleep   |     1 |       | NULL             |
| 312 | root      | 192.168.0.59:2183  | colorful_site_test       | Sleep   |  5905 |       | NULL             |
| 313 | root      | 192.168.0.59:2184  | NULL                     | Sleep   |  6715 |       | NULL             |
| 318 | webuser   | 192.168.0.23:1490  | colorful_lan             | Sleep   | 28402 |       | NULL             |
| 319 | webuser   | 192.168.0.23:1491  | NULL                     | Sleep   | 28423 |       | NULL             |
| 380 | lisongtao | 192.168.0.24:1065  | colorful_site_lisongtao2 | Sleep   |    30 |       | NULL             |
| 381 | lisongtao | 192.168.0.24:1066  | NULL                     | Sleep   | 23182 |       | NULL             |
| 422 | lisongtao | 192.168.0.24:2417  | colorful_faq             | Sleep   |   119 |       | NULL             |
| 439 | lisongtao | 192.168.0.10:2775  | colorful_site_lisongtao2 | Sleep   |  2281 |       | NULL             |
| 440 | webuser   | 192.168.0.29:3649  | colorful_lan             | Sleep   |  6639 |       | NULL             |
| 444 | lisongtao | 192.168.0.24:5921  | colorful_site_lisongtao2 | Sleep   |   581 |       | NULL             |
| 445 | lisongtao | 192.168.0.10:2889  | colorful_site_lisongtao2 | Sleep   |     0 |       | NULL             |
| 446 | lisongtao | 192.168.0.10:2892  | colorful_site_lisongtao2 | Sleep   |     0 |       | NULL             |
| 453 | root      | localhost          | NULL                     | Query   |     0 | NULL  | show processlist |
+-----+-----------+--------------------+--------------------------+---------+-------+-------+------------------+
14 rows in set (0.00 sec)

mysql> \q
Bye
[david_test~]#