try getting 'mytop'.
Do a google on it... It's like the 'top' utility, but displays information
regarding mysql procs.
P
"Ronan Lucio" <[EMAIL PROTECTED]>
04/20/2004 06:58 PM
To: <[EMAIL PROTECTED]>
cc:
Subject: Process Monitoring
Hi,
We have a MySQL-Server-4.0.17 installed in our enterprise
working fine... :-)
Some times our application takes too bandwidth from the
database server.
So, Iīm trying to figure out what (perhaps what select) is taking
so manu bandwidth.
SHOW FULL PROCESSLIST shows me the follow:
mysql> show full processlist;
+------+-------------+-----------------------+-------------+---------+------
+-------+-----------------------+
| Id | User | Host | db | Command |
Time
| State | Info |
+------+-------------+-----------------------+-------------+---------+------
+-------+-----------------------+
| 3303 | filmeemcasa | 200.247.127.132:43570 | filmeemcasa | Sleep | 74
| | NULL |
| 4226 | filmeemcasa | 200.247.127.132:33898 | filmeemcasa | Sleep | 0
| | NULL |
| 4276 | filmeemcasa | 200.247.127.132:47532 | filmeemcasa | Sleep | 9
| | NULL |
| 4280 | filmeemcasa | 200.247.127.132:47918 | filmeemcasa | Sleep | 11
| | NULL |
| 4281 | filmeemcasa | 200.247.127.132:47933 | filmeemcasa | Sleep | 315
| | NULL |
| 4308 | filmeemcasa | 200.247.127.132:50119 | filmeemcasa | Sleep | 72
| | NULL |
| 4312 | filmeemcasa | 200.247.127.132:50284 | filmeemcasa | Sleep | 0
| | NULL |
| 4315 | filmeemcasa | 200.247.127.132:50287 | filmeemcasa | Sleep | 71
| | NULL |
| 4329 | spv | 200.247.127.132:54006 | spvvideo | Sleep | 76
| | NULL |
| 4330 | filmeemcasa | pardal:3180 | NULL | Sleep |
2163
| | NULL |
| 4331 | filmeemcasa | pardal:3184 | NULL | Sleep | 64
| | NULL |
| 4333 | filmeemcasa | 200.247.127.132:54025 | filmeemcasa | Sleep | 72
| | NULL |
| 4338 | filmeemcasa | 200.247.127.132:54640 | filmeemcasa | Sleep | 10
| | NULL |
| 4339 | root | localhost | NULL | Query | 0
| NULL | show full processlist |
+------+-------------+-----------------------+-------------+---------+------
+-------+-----------------------+
14 rows in set (0.00 sec)
but I canīt get to see the select that is being executed.
Does anyone knows how can I find it?
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
