MR> We run MySQL on a 2xP3 1Ghz (Coppermine), 1 GB RAM, 1 software RAID1 (2 x MR> SCSI), Linux 2.4.9-31 (RedHat patched kernel). We have run a older version MR> of MySQL (we run only binary releases) for a long time (6 months) with MR> great success. We had uptimes like 100 days and almost 200 queries / MR> second (as reported by "status"). MR> MR> We had to reinstall the OS and MySQL software along with it (but the MR> "data" dir of MySQL has not been touched). We installed a binary release MR> of last MySQL (3.23.52). We use the "huge" configuration file (the one for MR> 1-2GB systems), with only change of the "thread-concurency" from 8 we made MR> it 4 ( 2 x number of CPUs ). We even increased the priority of MySQL using MR> (re)nice commands (made it max with -20 value). Problem is that from time MR> to time (once a day) MySQL stops working properly. It starts to increase MR> the load average of the system, a "ps ax" show almost all mysqld processes MR> in state of R (running). The system is dedicated MySQL only so it seems to MR> be problems related to mysqld. We dont have the my.cnf used in the old MR> installation (we dont know for sure which version we used at that time, MR> but we know it was 3.23.49 or 3.23.48). The "solution" for now is a MR> watchdog script which checks for system load and restarts mysql MR> (mysqladmin shutdown) when load is "too high" :(
MR> Can somebody give us any hint ? Also if I need to give more info about the MR> configuration of this server please ask. Hi, This problem occurs to several people like me. I have quite the same hardware than you. In fact it's a problem with the binary version of mysql. Solution for me was to downgrade mysql to version prior than 3.23.49 ... And still waiting for a working binary version ... David --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
