[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: MYSQL Issues.

On Thu, 10 Feb 2005, Bourmistrov Maxim wrote:

> I'm having same issues even if 4.0.20 is recompiled from ports.
> Mysqld seems to crash every time I try to import/export databases.
> Server is Xeon.

This has come up a lot of times already. Starting mysqld_safe with the 
option --open-files=1000 (and making sure it is started by rc.local, so 
the process gets the daemon login class with a higher nofiles limit) fixes 
the problem.
There's no need to go back to an older version of MySQL.

You can also add a line to the MySQL config file to increase open_files.

	-Otto