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]
