Re: Corruptions like crazy

[John Bowles]

Hi Andrew, I have one last question.

Regarding:
--optimize flag which will defrag your table files and reorder your primary indexes, but is only beneficial if your tables are going through lots of changes such as inserts and deletes.

If I had have run this option once a week would these errors have occurred? I ask because speed is important to this website and I can simply rerun things to correct them (no need for rollbacks that InnoDB - provides at least as I see it now - although experience may change my mind I will admit). If running this option weekly/even-daily-during-off-hours-in-the-morning would have prevented the problem that may be a better direction for me to go to generate more speed with no problems. That is why I actually stuck with MyIsam because of the speed. At this point is is a bit of a guess because the speed becomes more important if the website becomes popular. The reason is that my webiste does a lot of multi-level loop processing with loops within loops within loops and matching records mixed in with that to help speed things up. If these go wrong it is simply run again to fix it (rolling back would be unwise speed wise). What do you think?