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

Reply via email to