Steve Ellenoff wrote: > If you're getting a lot of hits on the MyISAM table I'd definitely > see if making it InnoDB solves the problem as that's the simplest > change (no coding changes) and likely will help your corruption issues.
Exactly. I thought the same thing. And, the MySQL link I referenced said that doing so (switching from MyISAM to InnoDB) worked for them. Also, the webmaster at my ISP who runs the servers said that he agreed that it might help also. I'm going to add some code to my app to do a REPAIR TABLE and even a DROP TABLE and rebuild sql for some of them that are just ancillary tables (like SQLTIMES). _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
