Personally, I just run it whenever I delete any large quantity of rows. You could run it once a week, or day, or whatever. Up to you.
Matthew Walker Ecommerce Project Manager Mountain Top Herbs -----Original Message----- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 5:45 PM To: Matthew Walker; Scott Wang; [EMAIL PROTECTED] Subject: Re: Lost Data #2 If I run optimize on the table once - will I have to come back and so it again? If so - how often? Thanks Mark -----Original Message----- From: Matthew Walker <[EMAIL PROTECTED]> To: Mark Stringham <[EMAIL PROTECTED]>; Scott Wang <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, January 29, 2002 4:18 PM Subject: RE: Lost Data #2 >To get rid of overhead, run an OPTIMIZE TABLE on the table. > >Matthew Walker >Ecommerce Project Manager >Mountain Top Herbs > > >-----Original Message----- >From: Mark Stringham [mailto:[EMAIL PROTECTED]] >Sent: Tuesday, January 29, 2002 11:02 AM >To: Scott Wang; [EMAIL PROTECTED] >Subject: Re: Lost Data #2 > >Scott - >I recently had a similar problem with a JSP application I built using >MySQL >on the backend. >Don't know what the issue is/was but I did notice that if I was updating >rows in a table on a regular basis - PHPmyAdmin 2.2 says I have a lot >of >"overhead" in the table. I'm not sure what is causing the problem but I >think when the "overhead" reaches a limit - it dumps data in the row or >table. I can't say for sure- but I think "overhead" had something to do >with >it. I'm still looking for a workaround. > >In the meantime - a back-up is smart > >Mark > > >-----Original Message----- >From: Scott Wang <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> >Date: Tuesday, January 29, 2002 10:35 AM >Subject: Lost Data #2 > > >> >>{ Am I to assume there is no solution to my problem? } >> >>Greetings, >> >>I have two large tables in a database with a few million entries. >There is >only one column in each table. >> >>Everything was working okay until today. The size of the table files >is >1gb+ but PHPMyAdmin says it has no records. >> >>When I try to export 200,000 of the contents to a text file: >> >>mysql> select * from tbl_name limit 0,200000 into outfile >"outfilename.txt"; >> >>It takes a couple minutes of processing but the resulting file is still >0k >in size. PHPMyAdmin still says 0 records. But the table files are >huge - >800mb to 1gb. >> >>Before I noticed this, I transferred the tables to another computer >with >MySQL installed. It took a long time to transfer so I know the file >really >was huge. But now on both computers the results are the same - no >records. >> >>I ran: >> >>mysql>check table tbl_name; >> >>and it says that it's fine. >> >>mysql>restore table tbl_name; >> >>Only takes the 1gb table files and turns them into 10k files, still no >records. >> >>Thankfully I have a backup on the other computer now that the table >files >are 10k. The other computer still has the 1gb files. >> >>Is there any way to restore this data??? This happened suddenly with >two >different tables, at the same time. They were the two largest tables in >the >database - other unaffected tables are smaller. >> >>Thank you, >> >>- Scott Wang >>[EMAIL PROTECTED] >>http://www.scottscomputing.com >> >> >>--------------------------------------------------------------------- >>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 > > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 > > >--- >Outgoing mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 > > >--------------------------------------------------------------------- >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 > --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.317 / Virus Database: 176 - Release Date: 1/21/2002 --------------------------------------------------------------------- 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
