Hi all, 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. Does anyone else note these types of issues? Sincerely, Steven Roussey http://Network54.com/?pp=e --------------------------------------------------------------------- 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
