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]
