Andrea, ----- Original Message ----- From: ""Andrea Forghieri"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, October 12, 2002 2:02 AM Subject: Mysql 4.0.4 + InnoDB leads to corrupted tables ?
> 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 ? this is the first case I hear that InnoDB could corrupt MyISAM tables. ... > 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. Do you access the SAME MyISAM table BOTH from that other database AND from the database to which it is linked? If yes, MySQL does not know that they are actually the same table, and you will get corruption if you update the table in both databases. MySQL caches MyISAM index pages to key_buffer. > Could this be the tricky combo ? Try putting a table to only one database. You can refer to a table in another database with databasename.tablename There is really no reason to link a table so that it is 'seen' in two databases. If this symlinking is not the bug, then the next step is to upgrade your Linux kernel. There appear to be lots of file i/o bugs in different Linux hardware/driver/kernel combinations. > 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. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query --------------------------------------------------------------------- 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
