Re: [vchkpw] MySQL 4.0.x frequent database corruption?
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
Re: [vchkpw] MySQL 4.0.x frequent database corruption?
On Mon, 2005-11-07 at 16:04 -0700, 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? > > 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, I would be suspect of the hardware too. Ive been running this box with similar sorts of loads as your describing without issue for ~ 12 months and never had an issue. The database does nothing but vpopmail either. dpkg --list mysql-server ||/ Name VersionDescription +++-==-==- ii mysql-server 4.0.24-10sarge mysql database server binaries I run 4.1 on other boxes which are for user databases, but i see no reason or need to update to 4.1 just for vpopmail which doesnt need any of the new features which are in 4.1. Shane
[vchkpw] MySQL 4.0.x frequent database corruption?
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? 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