Hi- We are running mysql version 3.23.33, along with resin. The tables we are using are large, but not overly so. We also, for reasons I cannot comprehend, but for which my manager thinks is a good idea, have index files that are as big as the data files themselves. So, here is the problem:
Every now and then (say once every two weeks), our table crashes, saying that there is an invalid key file. I can repair the table, but it is troubling that it happens so frequently. So, is the problem with the size of the table (900,000 records =~ 220 MB), or is it the overly large indexes my boss has set up. Also, could it be resin not closing its sessions nicely? I know that this is vague, but any help would be useful. Again the problem is: what causes a table to lose its keyfile. Thanks, -Dan --------------------------------------------------------------------- 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
