Are you logging slow queries? If so, have you looked in the slow query log?
-----Original Message----- From: Ronan Lucio To: [EMAIL PROTECTED] Sent: 4/20/04 1:58 PM 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]
