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]
