Vadim P. writes: > Mike, what kind of problem? What exactly goes wrong with PHP4? > > Thanks, > Vadim > > Mike Robinson wrote: > > > > > I am able to reproduce this problem very easily, including on > > Redhat-7.2. Basically, any app using the libmysqlclient.so > > compiled with gcc-2.96 connecting to a server compiled with > > gcc-2.96 will experience problems. This is particularly the case > > with PHP4. > >
In my case[s], compiling mysql with gcc-2.96 provides a libmysqlclient.so which in turn is used when compiling PHP4 with external mysql libs (as opposed to the internal libs bundled with PHP. Whether or not connecting to mysql with PHP, but particularly so, if there are more than [anywhere from] 10-25 concurrent connections, the php script making the connection will experience unexpected results. On some machines, I've seen 'connection timed out' errors written in the mysql error log. On other machines, I've seen nothing written to any log, the error is undetectable other than the php script not getting a connection. Just to throw a loop into the whole thing, about 1 in every 6 tests accepted a decent load, say 50-60 concurrent connections without a problem. I've just reproduced this problem on 7 machines, in 7 tries. So I'm batting a thousand on reproducing the problem. At first blush, I'd say the client wasn't releasing the connection handle, or it was doing something to it other than releasing it, and apps needing connections to mysql were hitting some artificial wall. Again, switching to the mysql.com binaries didn't provide the fix. I had to recompile PHP with the static mysql client libs supplied in the binary download. Then the problem went merrily away. I've not done the test with the client libs provided by PHP. I can't really try that configuration on my machines; I use other apps that use mysql so I have to use external libs. I have to wonder how many machines out there are affected by this. If one uses the mysql rpms supplied with their RedHat-7.x distribution, they're succeptible to this issue. Its a huge WTF. Best Regards Mike Robinson --------------------------------------------------------------------- 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
