Hi, We are having serious load problems suddenly at one of our MySQL-servers. There are running about 830 databases on this one. The machine was up for 40 days, running peacefully (load avg. of 2) but suddenly it went to an average of 25. We've been trying to find a reason, but SHOW PROCESSLIST didn't tell us much useful info. (No extreme query's, etc). I've run myisamchk on every table, and it fixed a few index problems on some, but no serious stuff (IMHO).
The server is a dual PIII/1000, with SCSI-Raid0 and 1024MB RAM. Running MySQL 3.23.40, since upgrading to both .41 and .42 increased the load when we tried it. I see a lot of processes, that are taking about 40 - 90% CPU, and 3 - 10% MEM (RSS 127M sometimes). It was running 2.4.8-ac12, and used a swap of 425MB of 1024MB. I just installed 2.4.12-ac5 on it, but no success (only the swap-usage is 0 again) in terms of improvement. If I do an strace -p <process-id> on those processes, it just return nothing. So I wonder why those things are eating CPU & Mem. Server is running RedHat 6.2, with glibc-2.1.3-22. (gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)) I'm really stuck (again). Last time this happened was about 6 months ago, upgrading to these hardware specs helped a lot. We are very curious about how FreeBSD is performing with SMP and MySQL. (Dual or Quad Xeon procs). Does anyone have a clue about what could be going on ? -- Met vriendelijke groet/With kind regards, Wouter de Jong [EMAIL PROTECTED] --------------------------------------------------------------------- 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
