MySQLfront (www.mysqlfront.de) displays all the output from show status in the host tab when you connect.
-----Original Message----- From: Alex Pilson [mailto:[EMAIL PROTECTED]] Sent: 04 April 2002 07:15 To: John Klein Cc: [EMAIL PROTECTED] Subject: Re: Keeping MySQL Databases Heathly At 10:09 AM -0500 4/4/02, John Klein wrote: >[EMAIL PROTECTED] wrote: >> >> Do MySQL server administrators recommend running a cron script daily >> to isamchk? >> >> Is there any other things that should be run daily to keep MySQL >> running top-notch? If so, does anyone have any pointers to a script >> that has already been developed? > >I actually find it helpful to periodically run the 'SHOW STATUS' command >on the database and dump the results to a file. Examining this can give >all sorts of information on how much use the database is getting, whether >queries are optimized, etc. Documentation on the command is here: ><http://www.mysql.com/doc/S/H/SHOW_STATUS.html>. I'm actually running this >every half-hour, because I'm a freak. > >The script I use isn't exactly production quality (one of those ten-minute >jobs). I keep intending to fix it someday or just use some internal MySQL >statement that does the same thing, but I'm sure you know how it is. The >script takes one parameter (a filename to dump results to). If called >without one, it prints to STDOUT. Here's my code: Cool. I will give it whirl to see what information it reveals. -- <-------------------------------------------------> Alex Pilson FlagShip Interactive, Inc. [EMAIL PROTECTED] 404.728.4417 404.642.8225 CELL // Web Design // Lasso Application Development // Filemaker Pro / SQL Development // Sonic Solutions Creator Authoring // Apple DVD Studio Pro Authoring // Macromedia Director/Flash Authoring <-------------------------------------------------> --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
