We just upgraded a box (RH 7.2) to current Apache, PHP, and MySQL. We used the MySQL binary for 3.23.46. On the old box which was nearly identical we were running 3.23.43 (I think). The old box didn't have any problems w/ MySQL but this box is having problems. The only real thing that changed was the version of MySQL, PHP, RH, etc. Can someone offer some insight into what might be going on here? Any suggestions on how to fix the problem. The connections are PHP non-persistent connections for a very active web based message board system. Again, keep in mind that this very similar setup was working flawlessly the day before yesterday on a lesser box.
Current Box: Dual PIII 1G, w/ 2G of ram. Database is a message board database that is only 250,000 rows and only 57M in size. The problem is that mysqld is taking up all the CPU. Usually there are only a dozen mysqlds running sometimes there are as many as 200+. Regardless of how many daemons are running they take all the CPU and it appears that memory used is possibly growing. Sometimes the RSS will run up to 120M+ Please HELP, this is a live box (not so live now) and my users can't access the site. I can't turn up the old box because it's in transit via UPS back from my Co-location facility.1 TIA, Charlie Here's a sample from top PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 20395 mysql 17 0 58104 56M 1696 R 48.2 2.8 0:04 mysqld 20477 mysql 15 0 58108 56M 1696 R 30.1 2.8 0:02 mysqld 20338 mysql 16 0 58104 56M 1696 S 4.3 2.8 0:06 mysqld 20492 mysql 20 0 58712 57M 1696 R 4.2 2.8 0:01 mysqld 20265 mysql 17 0 58104 56M 1696 R 4.1 2.8 0:10 mysqld 20353 mysql 18 0 58104 56M 1696 R 4.1 2.8 0:04 mysqld 20359 mysql 16 0 58104 56M 1696 S 4.1 2.8 0:06 mysqld 20362 mysql 16 0 58104 56M 1696 R 4.1 2.8 0:05 mysqld 20413 mysql 18 0 58108 56M 1696 R 4.0 2.8 0:04 mysqld 20349 mysql 17 0 58104 56M 1696 R 3.9 2.8 0:06 mysqld 20496 mysql 17 0 58712 57M 1696 R 3.9 2.8 0:01 mysqld 19458 mysql 14 0 57724 56M 1696 S 3.8 2.8 0:08 mysqld 20437 mysql 16 0 58108 56M 1696 R 3.8 2.8 0:02 mysqld 20444 mysql 16 0 58108 56M 1696 R 3.8 2.8 0:03 mysqld 20445 mysql 17 0 58108 56M 1696 R 3.7 2.8 0:03 mysqld 20522 mysql 18 0 58712 57M 1696 R 3.7 2.8 0:01 mysqld 20335 mysql 14 0 58104 56M 1696 S 3.6 2.8 0:07 mysqld 20388 mysql 20 0 58652 57M 1696 R 3.6 2.8 0:05 mysqld 20391 mysql 20 0 58652 57M 1696 R 3.6 2.8 0:04 mysqld 20410 mysql 14 0 58108 56M 1696 R 3.5 2.8 0:04 mysqld 20474 mysql 15 0 58108 56M 1696 R 3.5 2.8 0:03 mysqld 20489 mysql 17 0 58152 56M 1696 R 3.5 2.8 0:01 mysqld 20527 mysql 20 0 58728 57M 1696 R 3.5 2.8 0:01 mysqld - --------------------------------------------------------------------- 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
