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

Reply via email to