[CentOS] Help, PHP/Mysql connections are so slow.
Pro Green European
pro_green_european at yahoo.com
Mon Jun 9 11:28:57 UTC 2008
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.
--- On Mon, 6/9/08, Lorenzo Martínez Rodríguez <Lawwait at yahoo.es> wrote:
> From: Lorenzo Martínez Rodríguez <Lawwait at yahoo.es>
> Subject: Re: [CentOS] Help, PHP/Mysql connections are so slow.
> To: "CentOS mailing list" <centos at 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
> directly in the code?
> 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 at altair htdocs]# cat test.php
> > <?php
> > phpinfo();
> > ?>
> > <?
> > var_dump($GLOBALS['_PHPA']);
> > ?>
More information about the CentOS