Re: Strange server crashes with large table and myisamchk

2004-07-06 Thread Egor Egorov
Hanno Fietz [EMAIL PROTECTED] wrote: Jul 2 03:10:28 t56 kernel: hda: dma_intr: status=0x51 { DriveReadySeekComplete Error } Jul 2 03:10:28 t56 kernel: hda: dma_intr: error=0x40 { UncorrectableError }, LBAsect=429367, sector=316864 Jul 2 03:10:28 t56 kernel: end_request: I/O error, dev

Strange server crashes with large table and myisamchk

2004-07-02 Thread Hanno Fietz
Hello everybody, I'm experiencing problems with a 4.0.15 MySQL-Server running on a SuSE Linux 8.2 box with 512 MB RAM, some one-point-something GHz CPU and 40 GB IDE Harddisk. We have a database with some administrative tables and one large data table (now ~ 30 M rows, ~ 1GB index file and ~

Re: Strange server crashes with large table and myisamchk

2004-07-02 Thread gerald_clark
It is telling you that your hard drive is failing. Replace it. Hanno Fietz wrote: Hello everybody, I'm experiencing problems with a 4.0.15 MySQL-Server running on a SuSE Linux 8.2 box with 512 MB RAM, some one-point-something GHz CPU and 40 GB IDE Harddisk. We have a database with some

Re: Strange server crashes with large table and myisamchk

2004-07-02 Thread Hanno Fietz
Yes, I was suspecting that as well, but: Why do I get these messages whenever I run myisamchk and (almost) never at any other time? Is myisamchk using the hd more extensively than e. g. MySQL itself? Can the rather large demand for temporary disk space account for that? Thanks, Hanno

Re: Strange server crashes with large table and myisamchk

2004-07-02 Thread gerald_clark
Try this: dd if=/dev/hda of=/dev/null This will exercise the entire drive. You should see lots of errors if your drive is failing. Another possibility is a bad cable. Cables don't usually go bad if they are not disturbed. Drives do. A failing IDE contoller is another unlikely possibility. I