RE: MyISAM rebuilding questions

2003-03-27 Thread Wynne Crisman
Thank you all for the responses, This information is useful in determining what direction to take in designing the application's use of the MySQL database. I am still a bit unsure how a log based reconsiliation works when the system crashes (using MyISAM tables). Does a lengthy reconstruction

Re: MyISAM rebuilding questions

2003-03-24 Thread Dan Nelson
In the last episode (Mar 24), Wynne Crisman said: I am trying to determine what would cause my needing to rebuild an MyISAM table in MySQL 4.0.x? By rebuild I assume you mean repair? Only a crash should require a table to be repaired. Make sure your OS doesn't crash, report any MySQL crashes,