Hi, The mysql administrator tool is a lot better for this. They still seem to be working out some bugs, but there is a lot of flexibility with the graphs. I have been able to see peaks in bandwidth and queries that I never noticed before..
Thanks, Eric At 12:35 PM 4/20/2004, Peter J Milanese wrote: >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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
