Hi, I recently updated from 4.0.3 do 4.0.4 . everithing was running fast ans smooth (as always).
Then I enabled for the first time the InnoDB feature. I was surprised to find out that everithing worked fine from the very beginning. The next day I start having "handler error" on non-inno tables of other databases ! I ran myisamchk to check and fix the tables : there where the majority of the tables with index probles. I restarted mysql WITHOUT innodb support, everithing was OK again. I restarted mysql WITH innodb and I had the most of the tables (especially the big ones) corrupted again. I decided not use innodb :-( What could be wrong ? I set all the variables according to MySQL manual. I did not use extreme memory settings. I created all the requested directories. The only "peculiar" thing is that the db that (should) make use of innodb tables , has 2 MYISAM tables "linked" (ln -s) from another DB. Could this be the tricky combo ? The following is the configuration of the cpu that runs mysql : OS : Linux (Mandrake 8.2) kernel 2.4.3-20 Mysql : 4.0.4 CPU : Pentium III 800 RAM : 127 Mb Best Regards Andrea Forghieri Emmegi S.p.A. --------------------------------------------------------------------- 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
