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
