I have just released version 1.0 of mytop, a "top"-like command for monitoring your MySQL server.
The mytop home page (with screenshot, docs, mailing list) is now here: http://jeremy.zawodny.com/mysql/mytop/ which is different than the old location, which also points to that URL now. Changes in version 1.0 ---------------------- Provided a fix for cases when we try remove the domain name from the display even if it is actually an IP address. Fixed a ton of formatting bugs and "use of uninitialized value" errors. Adjusted column widths and headinds a bit to fit the common cases that I usually see. Added "Now/Sec" to the header, next to "Avg/Sec". The former is the "real-time" queries per second since the last mytop refresh, while the later is the queries per second since the server was last reset. Added the `o' key to toggle the sort order. Changed the `h' key to `H' for toggling the header. Added the `h' key to filter based on hostname. Changed the "Query Info" colum to "Query or State" because if there is no query running (like when a slave is replicating off the master and you're watching the master), it'll show the state in that column. The real-time queries/sec are computed using Time::HiRes if it is available, making the numbers much more accurate. Added the `e' key to EXPLAIN a query. It works a lot like the `f' key to get the full SQL of a query. Also, if you're already looking at the full SQL (having pressed `f'), you can hit `e' to get it explained if you'd like. The web site has moved to: http://jeremy.zawodny.com/mysql/mytop/ Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 79 days, processed 2,068,381,093 queries (301/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
