[CentOS] Help, PHP/Mysql connections are so slow.

2008-06-08 Thread Pro Green European
Hi. I've got a new Centos 5.1 x86-64 server that uses PHP to communicate with MySQL5. On this server, PHP/Mysql connections are dead slow and unresponsive. It takes sometimes up to a minute to list tables in phpmyadmin for example. I've verified on the server that the issue has to be PHP/Mysql re

Re: [CentOS] Help, PHP/Mysql connections are so slow.

2008-06-09 Thread Pro Green European
Now I've also tried running a MySQL server on the webserver, and setting for example phpmyadmin to connect to localhost does not change any kind of behaviour. PHP/Mysql connections are still very slow. /PGE --- On Mon, 6/9/08, Pro Green European <[EMAIL PROTECTED]> wrote: From

Re: [CentOS] Help, PHP/Mysql connections are so slow.

2008-06-09 Thread Pro Green European
Hi. > Have you tried other protocols? Is it really only http > transfers that are slow? Yes. Ftp works perfectly, and regular http with cgi/perl connections to the same database server works perfectly. Also rendering of standard HTML works as it should. It is only when a scripted site uses PHP/

Re: [CentOS] Help, PHP/Mysql connections are so slow.

2008-06-09 Thread Pro Green European
* allow_call_time_reference = On > ;* log_errors = Off*again, stupid - > ignore > ; * short_open_tag= On*again, why the code > is a bit > crap in vtiger that we'd need to enable this. > ;* extension=php_gd2.dll*ignore - it's > for windows >

[CentOS] RE

2008-06-09 Thread Pro Green European
> Maybe if you trust DNS resolution names to make the connection to the > Database servers could be a problem. Did you try to use IP addresses > directly in the code? > Yes, I have tried that too, no difference. I've even tried running MySQL with a database populated with identical data on loc

Re: [CentOS] Help, PHP/Mysql connections are so slow.

2008-06-09 Thread Pro Green European
Hi. Yes, I have tried that too, no difference. I've even tried running MySQL with a database populated with identical data on localhost (even tried 127.0.0.1), but there is no difference in performance. Delays in the connection to the db server is still around 20-30 seconds. So, the problem ha

Re: [CentOS] Help, PHP/Mysql connections are so slow.

2008-06-09 Thread Pro Green European
Schaetzl <[EMAIL PROTECTED]> wrote: > From: Kai Schaetzl <[EMAIL PROTECTED]> > Subject: Re: [CentOS] Help, PHP/Mysql connections are so slow. > To: centos@centos.org > Date: Monday, June 9, 2008, 2:51 PM > Pro Green European wrote on Mon, 9 Jun 2008 03:37:33 -0700 > (PDT