On Mon, Mar 11, 2002 at 09:30:27AM -0500, Dan Patnaude wrote: > 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.
In MySQL terms, that's not very big. Can you upgrade to the latest stable release and see if the problem persists? The one you are running is a bit old. A bug you're hitting may have been fixed already. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 38 days, processed 1,146,170,436 queries (343/sec. avg) --------------------------------------------------------------------- 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
