I don't know what this (below) is, but gee, it seems good :-)
Best wishes -- Pierre du Parté Final Filer Software 349 Worrigee Road Worrigee, NSW, Australia 2540 http://www.finalfiler.com Phone 61 2 44216374 Mobile 0413 483 066 "If it feels good, do it!" J Williamson wrote: > Would you not be better of just runing myisamchk from crontab? > > Simon > > ../myisamchk Ver 1.52 for unknown-freebsdelf4.1 at i386 > By Monty, for your professional use > This software comes with NO WARRANTY: see the PUBLIC for details. > > Description, check and repair of ISAM tables. > Used without options all tables on the command will be checked for errors > Usage: ./myisamchk [OPTIONS] tables[.MYI] > > Global options: > -#, --debug=... Output debug log. Often this is 'd:t:o,filename` > -?, --help Display this help and exit. > -O, --set-variable var=option > Change the value of a variable. > -s, --silent Only print errors. One can use two -s to make > myisamchk very silent > -v, --verbose Print more information. This can be used with > --describe and --check. Use many -v for more > verbosity! > -V, --version Print version and exit. > -w, --wait Wait if table is locked. > > Check options (check is the default action for myisamchk): > -c, --check Check table for errors > -e, --extend-check Check the table VERY throughly. Only use this in > extreme cases as myisamchk should normally be able to > find out if the table is ok even without this switch > -F, --fast Check only tables that hasn't been closed properly > -C, --check-only-changed > Check only tables that has changed since last check > -f, --force Restart with -r if there are any errors in the table. > States will be updated as with --update-state > -i, --information Print statistics information about table that is > checked > -m, --medium-check Faster than extended-check, but only finds 99.99% of > all errors. Should be good enough for most cases > -U --update-state Mark tables as crashed if you find any errors > -T, --read-only Don't mark table as checked > > Repair options (When using -r or -o) > -B, --backup Make a backup of the .MYD file as 'filename-time.BAK' > --correct-checksum Correct checksum information for table. > -D, --data-file-length=# Max length of data file (when recreating data > file when it's full) > -e, --extend-check Try to recover every possible row from the data file > Normally this will also find a lot of garbage rows; > Don't use this option if you are not totally desperate. > -f, --force Overwrite old temporary files. > -k, --keys-used=# Tell MyISAM to update only some specific keys. # is a > bit mask of which keys to use. This can be used to > get faster inserts! > -r, --recover Can fix almost anything except unique keys that aren't > unique. > -n, --sort-recover Force recovering with sorting even if the temporary > file would be very big. > -o, --safe-recover Uses old recovery method; Slower than '-r' but can > handle a couple of cases where '-r' reports that it > can't fix the data file. > --character-sets-dir=... > Directory where character sets are > --set-character-set=name > Change the character set used by the index > -t, --tmpdir=path Path for temporary files > -q, --quick Faster repair by not modifying the data file. > One can give a second '-q' to force myisamchk to > modify the original datafile in case of duplicate keys > -u, --unpack Unpack file packed with myisampack. > > Other actions: > -a, --analyze Analyze distribution of keys. Will make some joins in > MySQL faster. You can check the calculated distribution > by using '--describe --verbose table_name'. > -d, --description Prints some information about table. > -A, --set-auto-increment[=value] > Force auto_increment to start at this or higher value > If no value is given, then sets the next auto_increment > value to the highest used value for the auto key + 1. > -S, --sort-index Sort index blocks. This speeds up 'read-next' in > applications > -R, --sort-records=# > Sort records according to an index. This makes your > data much more localized and may speed up things > (It may be VERY slow to do a sort the first time!) > > Default options are read from the following files in the given order: > /etc/my.cnf /usr/local/mysql/var/my.cnf ~/.my.cnf > The following groups are read: myisamchk > The following options may be given as the first argument: > --print-defaults Print the program argument list and exit > --no-defaults Don't read default options from any options file > --defaults-file=# Only read default options from the given file # > --defaults-extra-file=# Read this file after the global files are read > > > -----Original Message----- > From: Peter Romianowski [mailto:[EMAIL PROTECTED]] > Sent: 09 April 2002 12:08 > To: [EMAIL PROTECTED] > Subject: check, analyze and optimize table > > > Hi, > > I am writing a maintenance-deamon which is executing > CHECK TABLE, ANALYZE TABLE and OPTIMIZE TABLE once at > night. > If CHECK TABLE fails for at least one table, then the > rest will be skipped. > The question is if the order of the statements is ok > this way. A second question would be, if I should run > a REPAIR statement automatically if CHECK fails. > Are there any more tasks that I should perform nightly > in order to keep my database healthy and in a "high > performance shape"? > And another general question: Do I have to take down > my Application that is using the MySQL-DB in order to > perform the CHECK, ANALYZE and OPTIMZE commands? > > thanks in advance, > Peter > > --------------------------------------------------------------------- > 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 > > > > > From - Tue Apr 09 21:29:33 2002 > X-UIDL: 1018351804.001 > X-Mozilla-Status: 0000 > X-Mozilla-Status2: 00000000 > Return-Path: <[EMAIL PROTECTED]> > Received: from hotmail.com ([216.33.237.84]) by ; Tue, 09 Apr 2002 06:28:33 -0500 > Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; > Tue, 9 Apr 2002 04:28:32 -0700 > Received: from 65.32.124.113 by lw7fd.law7.hotmail.msn.com with HTTP; > Tue, 09 Apr 2002 11:28:32 GMT > X-Originating-IP: [65.32.124.113] > From: "J Williamson" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Bcc: > Subject: Re: Free Quote > Date: Tue, 09 Apr 2002 07:28:32 -0400 > Mime-Version: 1.0 > Content-Type: text/html > Message-ID: <[EMAIL PROTECTED]> > X-OriginalArrivalTime: 09 Apr 2002 11:28:32.0473 (UTC) FILETIME=[AE071C90:01C1DFB9] > X-Rcpt-To: <[EMAIL PROTECTED]> > X-DPOP: DPOP Version 2.4a > X-UIDL: 1018351804.001 > Status: U > > <html><div style='background-color:'><DIV> > <P>My apologies, I thought I hit reply, not reply all..</P> > <P> Thanks for the reply though, I'll be more careful next time, just tired of >wading through 20 junk mails to find 1 that I actually wanted.</P> > <P> </P> > ><P> > J<BR><BR></P></DIV> > <DIV></DIV><BR><BR><BR> > <DIV></DIV> > <DIV></DIV>Jim > <DIV></DIV> > <DIV></DIV> > <DIV></DIV> > <DIV></DIV>>From: Pierre du Parte <[EMAIL PROTECTED]> > <DIV></DIV>>Reply-To: [EMAIL PROTECTED] > <DIV></DIV>>To: J Williamson <[EMAIL PROTECTED]> > <DIV></DIV>>Subject: Re: Free Quote > <DIV></DIV>>Date: Mon, 08 Apr 2002 11:40:15 +1000 > <DIV></DIV>>MIME-Version: 1.0 > <DIV></DIV>>Received: from [209.15.2.37] by hotmail.com (3.2) with ESMTP id >MHotMailBE7A402C00064136E822D10F022512E20; Sun, 07 Apr 2002 18:41:01 -0700 > <DIV></DIV>>Received: (qmail 24322 invoked from network); 8 Apr 2002 01:41:01 >-0000 > <DIV></DIV>>Received: from mercury.hosting4u.net (HELO finalfiler.com) >(209.15.2.5) by mail-gate.hosting4u.net with SMTP; 8 Apr 2002 01:41:01 -0000 > <DIV></DIV>>Received: from finalfiler.com ([210.10.218.102]) by finalfiler.com ; >Sun, 07 Apr 2002 20:40:57 -0500 > <DIV></DIV>>From [EMAIL PROTECTED] Sun, 07 Apr 2002 18:42:33 -0700 > <DIV></DIV>>Message-ID: <[EMAIL PROTECTED]> > <DIV></DIV>>Organization: Final Filer Software > <DIV></DIV>>User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:0.9.4) >Gecko/20011019 Netscape6/6.2 > <DIV></DIV>>X-Accept-Language: en-au, en-us > <DIV></DIV>>References: <[EMAIL PROTECTED]> > <DIV></DIV>>X-Rcpt-To: <[EMAIL PROTECTED]> > <DIV></DIV>> > <DIV></DIV>>G'day Jim, > <DIV></DIV>> > <DIV></DIV>>Know how you feel. But I reckon instead of "Dave"'s mailbox it went > <DIV></DIV>>to > <DIV></DIV>>everyone elses, including mine. > <DIV></DIV>> > <DIV></DIV>>SOmething's gotta be done about these bastards! > <DIV></DIV>> > <DIV></DIV>>All the best > <DIV></DIV>> > <DIV></DIV>>Pierre du Parté > <DIV></DIV>>Final Filer Software > <DIV></DIV>>349 Worrigee Road > <DIV></DIV>>Worrigee, NSW, Australia 2540 > <DIV></DIV>>http://www.finalfiler.com > <DIV></DIV>> > <DIV></DIV>>Phone 61 2 44216374 > <DIV></DIV>>Mobile 0413 483 066 > <DIV></DIV>> > <DIV></DIV>>"If it feels good, do it!" > <DIV></DIV>> > <DIV></DIV>> > <DIV></DIV>> > <DIV></DIV>> > <DIV></DIV>> > <DIV></DIV>>J Williamson wrote: > <DIV></DIV>> > <DIV></DIV>>>Hey Dave! You no good spamming, ignorant jackass. > <DIV></DIV>>> > <DIV></DIV>>>Take your BS tips and shove them up your stupid ass, I am sick of > <DIV></DIV>>>the > <DIV></DIV>>>spam, and I hope everyone else replies to you as well just so > <DIV></DIV>>>you're > <DIV></DIV>>>email box blows up :) > <DIV></DIV>>> > <DIV></DIV>>> > <DIV></DIV>>> > <DIV></DIV>>> > <DIV></DIV>>>Jim > <DIV></DIV>>> > <DIV></DIV>>> >From: [EMAIL PROTECTED] > <DIV></DIV>>> > <DIV></DIV>>> >Reply-To: [EMAIL PROTECTED] > <DIV></DIV>>> > <DIV></DIV>>> >To: [EMAIL PROTECTED] > <DIV></DIV>>> > <DIV></DIV>>> >CC: > ><DIV></DIV>>>[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED],[EMAIL PROTECTED] > > <DIV></DIV>>> > <DIV></DIV>>> > <DIV></DIV>>> >Subject: Free Quote > <DIV></DIV>>> > <DIV></DIV>>> >Date: Wed, 3 Apr 2002 22:50:50 -0800 > <DIV></DIV>>> > <DIV></DIV>>> >MIME-Version: 1.0 > <DIV></DIV>>> > <DIV></DIV>>> >Received: from [66.40.105.12] by hotmail.com (3.2) with >ESMTP id > <DIV></DIV>>>MHotMailBE754384001C400438984228690C091E0; Wed, 03 Apr 2002 > <DIV></DIV>>>22:53:57 -0800 > <DIV></DIV>>> > <DIV></DIV>>> >Received: from Home ([142.173.85.133]) by petsa-d212-1 with > <DIV></DIV>>>Microsoft > <DIV></DIV>>>SMTPSVC(5.0.2195.3779); Thu, 4 Apr 2002 01:47:50 -0500 > <DIV></DIV>>> > <DIV></DIV>>> >From [EMAIL PROTECTED] Wed, 03 Apr 2002 22:54:51 -0800 > <DIV></DIV>>> > <DIV></DIV>>> >Return-Path: [EMAIL PROTECTED] > <DIV></DIV>>> > <DIV></DIV>>> >Message-ID: > <DIV></DIV>>> > <DIV></DIV>>> >X-OriginalArrivalTime: 04 Apr 2002 06:47:50.0578 (UTC) > <DIV></DIV>>>FILETIME=[A3692120:01C1DBA4] > <DIV></DIV>>> > <DIV></DIV>>> > > <DIV></DIV>>> > <DIV></DIV>>> > ><DIV></DIV>>>------------------------------------------------------------------------ > > <DIV></DIV>>>Chat with friends online, try MSN Messenger: Click Here > <DIV></DIV>>><HTTP: 12 1HM505401 g.msn.com> > <DIV></DIV>>> > ><DIV></DIV>>>------------------------------------------------------------------------ > > <DIV></DIV>>> > <DIV></DIV>>>Subject: > <DIV></DIV>>> > <DIV></DIV>>>Free Quote > <DIV></DIV>>>From: > <DIV></DIV>>> > <DIV></DIV>>>[EMAIL PROTECTED] > <DIV></DIV>>>Date: > <DIV></DIV>>> > <DIV></DIV>>>Wed, 3 Apr 2002 22:50:50 -0800 > <DIV></DIV>>>To: > <DIV></DIV>>> > <DIV></DIV>>>[EMAIL PROTECTED] > <DIV></DIV>>> > <DIV></DIV>>> > <DIV></DIV>>>SPECIAL SITUATION ALERTS APRIL HOT PICK > <DIV></DIV>>> > <DIV></DIV>>>Powder River Basin Gas Corp. > <DIV></DIV>>> > <DIV></DIV>>>Symbol: (OTCBB: PRVB) > <DIV></DIV>>> > <DIV></DIV>>>Recent Price: $ .60 > <DIV></DIV>>> > <DIV></DIV>>>Sell Target: $1.75 > <DIV></DIV>>> > <DIV></DIV>>> > <DIV></DIV>>> > <DIV></DIV>>>Investor Alert: > <DIV></DIV>>> > <DIV></DIV>>>As Energy Prices Jump, PRVB Looks to Gain Substantial Profits. > <DIV></DIV>>> > <DIV></DIV>>>PRVB has reserves of 43 BILLION cubic feet of natural gas while > <DIV></DIV>>>they > <DIV></DIV>>>produce millions of cubic feet of gas per day. Their properties > <DIV></DIV>>>border > <DIV></DIV>>>those of industry leaders, Williams Coal Seam Gas (NYSE: WTU, >$12) > <DIV></DIV>>>and > <DIV></DIV>>>Western Gas Resources (NYSE: WGR, $37). > <DIV></DIV>>> > <DIV></DIV>>>A Powerful Energy Play: (OTCBB: PRVB) > <DIV></DIV>>> > <DIV></DIV>>>PRVB is a prosperous and under > --------------------------------------------------------------------- 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