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@xxxxxxxx> wrote:
> From: Lorenzo Martínez Rodríguez <Lawwait@xxxxxxxx>
> Subject: Re: Help, PHP/Mysql connections are so slow.
> To: "CentOS mailing list" <centos@xxxxxxxxxx>
> 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']);
> > ?>
> >
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos
