Hello,
Jack Kerouac wrote:
I've got a Debian stable box (Sarge) with vpopmail-5.4.10 and MySQL
version 4.0.24-10serge1. About 1,000 users and a few dozen domains.
The MySQL database is frequently (several times a month) getting
corrupted - which of course makes for very angry users. I have run
Vpopmail and MySQL for years and never seen such problems; so my
suspicions are more hardware related than software, but to cover my
bases I shall ask here:
Has anyone else had similar problems, especially using debian stable
and the debian binaries of MySQL?
Type dmesg and make sure there are no drive errors that may show up. I
have seen similar issues that resulted from a bad IDE kernel driver/hard
drive combination. Once we updated the kernel the IDE driver was fixed
and the system began to work perfectly without the database corruption.
I also started to use innodb so that I could recover more effectivly
when the system came back online just in case.
Does anyone know of a good reason to recommend an upgrade to MySQL
4.1.x and/or 5.0.x? Would this possibly fix my problems?
Thanks in advance for any thoughts you may have on the subject,
--
Jack
