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 Version Description +++-==============-==============-============================================ 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