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.