Hi list, Same thing here, mysql 3.23.51 works well during about 2 hours then suddently load average grow up to 200 and more ... Load average is less than 4 with 3.23.49.
We're using binary tar.gz non max versions from Mysql.com OS : Linux Red hat 7.2 kernel : 2.4.10 1 Go RAM 2 * Intel 1 Ghz During the load pic i've run a ps -eo pid,tt,user,fname,tmout,f,wchan and that's an extract of the output : [...] 29309 ? mysql mysqld - 040 rt_sigsuspend 29347 ? mysql mysqld - 040 rt_sigsuspend 29390 ? mysql mysqld - 040 rt_sigsuspend 29391 ? mysql mysqld - 040 - 29417 ? mysql mysqld - 040 rt_sigsuspend 29418 ? mysql mysqld - 040 rt_sigsuspend 29420 ? mysql mysqld - 040 rt_sigsuspend 29423 ? mysql mysqld - 040 rt_sigsuspend 29424 ? mysql mysqld - 040 rt_sigsuspend 29425 ? mysql mysqld - 040 rt_sigsuspend 29428 ? mysql mysqld - 040 rt_sigsuspend 29432 ? mysql mysqld - 040 - 29433 ? mysql mysqld - 040 rt_sigsuspend 29434 ? mysql mysqld - 040 rt_sigsuspend 29436 ? mysql mysqld - 040 rt_sigsuspend 29439 ? mysql mysqld - 040 rt_sigsuspend 29442 ? mysql mysqld - 040 rt_sigsuspend 29443 ? mysql mysqld - 040 rt_sigsuspend 29445 ? mysql mysqld - 040 rt_sigsuspend 29448 ? mysql mysqld - 040 rt_sigsuspend 29450 ? mysql mysqld - 040 rt_sigsuspend 29451 ? mysql mysqld - 040 rt_sigsuspend 29453 ? mysql mysqld - 040 rt_sigsuspend 29454 ? mysql mysqld - 040 rt_sigsuspend 29455 ? mysql mysqld - 040 rt_sigsuspend 29458 ? mysql mysqld - 040 rt_sigsuspend 29462 ? mysql mysqld - 040 rt_sigsuspend 29463 ? mysql mysqld - 040 rt_sigsuspend 29464 ? mysql mysqld - 040 rt_sigsuspend 29465 ? mysql mysqld - 040 rt_sigsuspend 29468 ? mysql mysqld - 040 rt_sigsuspend [...] So we come back to 3.23.49 wich have a glibc bug and memory eating bug but we can't upgrade to 3.23.51 :( Thanks again. David NB : this is the my.cnf : [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve set-variable = key_buffer=128M set-variable = back_log=100 set-variable = record_buffer=1M set-variable = sort_buffer=1M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = max_connections=700 set-variable = max_connect_errors=100 set-variable = table_cache=256 set-variable = net_read_timeout=180 set-variable = net_write_timeout=180 set-variable = wait_timeout=3600 # Start logging # log [...] ----- Original Message ----- From: "Steven Roussey" <[EMAIL PROTECTED]> To: "'Mysql'" < [EMAIL PROTECTED] > Sent: Friday, July 12, 2002 6:17 PM Subject: RE: Load problems with 3.23.51 > Just a note: I tried MySQL 4.0.2 and it works fine. Seems to be only > 3.23.51 built by MySQL itself that has the issue. Releases before, and > now a release after (albeit a 4.0.x version) work fine. > > Sincerely, > Steven Roussey > http://Network54.com/?pp=e > > > > > I have MySQL 3.23.47 running on our sever. I skipped 48 through 50 and > > tried 51. No dice. It does not handle load, CPU and the load average > go > > through the roof. I'm using Red Hat Linux 7.2 and the official mysql > > binaries. It appears to be slow to connect, causing 0.5 to 1.0 second > > delay on connection. Using persistent connections from PHP does not > make > > much of a difference. I thought it might be the hostname lookup > changes so > > I chose skip-grant-tables. This doesn't actually skip the hostname > lookup > > though and had no effect. > > > > Most queries are shorter than 1 second so this problem causes > catastrophic > > problems by making queries last a multiple times longer, which make > the > > number of concurrent queries jump exponentially. This is a bad thing. > And > > sadly makes 3.23.51 unusable. > --------------------------------------------------------------------- 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
