Hi We run MySQL on a 2xP3 1Ghz (Coppermine), 1 GB RAM, 1 software RAID1 (2 x SCSI), Linux 2.4.9-31 (RedHat patched kernel). We have run a older version of MySQL (we run only binary releases) for a long time (6 months) with great success. We had uptimes like 100 days and almost 200 queries / second (as reported by "status").
We had to reinstall the OS and MySQL software along with it (but the "data" dir of MySQL has not been touched). We installed a binary release of last MySQL (3.23.52). We use the "huge" configuration file (the one for 1-2GB systems), with only change of the "thread-concurency" from 8 we made it 4 ( 2 x number of CPUs ). We even increased the priority of MySQL using (re)nice commands (made it max with -20 value). Problem is that from time to time (once a day) MySQL stops working properly. It starts to increase the load average of the system, a "ps ax" show almost all mysqld processes in state of R (running). The system is dedicated MySQL only so it seems to be problems related to mysqld. We dont have the my.cnf used in the old installation (we dont know for sure which version we used at that time, but we know it was 3.23.49 or 3.23.48). The "solution" for now is a watchdog script which checks for system load and restarts mysql (mysqladmin shutdown) when load is "too high" :( Can somebody give us any hint ? Also if I need to give more info about the configuration of this server please ask. Thank you ---------------------------- Mihai RUSU Disclaimer: Any views or opinions presented within this e-mail are solely those of the author and do not necessarily represent those of any company, unless otherwise specifically stated. --------------------------------------------------------------------- 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
