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 has to be with either the php-mysql module, PHP itself, MySQL or then it may be hardware related.
Thx, /mysteron
--- On Mon, 6/9/08, Lorenzo Martínez Rodríguez Lawwait@yahoo.es wrote:
From: Lorenzo Martínez Rodríguez Lawwait@yahoo.es Subject: Re: [CentOS] Help, PHP/Mysql connections are so slow. To: "CentOS mailing list" centos@centos.org Date: Monday, June 9, 2008, 1:30 PM 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?
Regards,
Peter Farrell escribió:
If it's a table listing check your MySQL settings.
How have you set up
my.cnf? What does your slow query log tell you? Have you logged into your MySQL server from another
machine and ran
queries from there? Have you enabled verbose logging
for PHP and
Apache? Are you tailing all 3 while you run the query
from phpadmin?
One of them will say something interesting.
I think your issue smells like something in how you
compiled PHP or a
setting in php.ini itself.
Put a test.php in the doc-root and see what it tells
you it's using.
(re; mysql & the php version & the location of
the php.ini)
I've done installs where I had conflicting libs
from both PHP and
MySQL. Also I get stupid locations for php.ini all the
time and have
to manaully move that file to the correct location.
[root@altair htdocs]# cat test.php
<?php phpinfo(); ?>
<? var_dump($GLOBALS['_PHPA']); ?>