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
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.
Have you tried other protocols? Is it really only http transfers that are slow?
Have you tried pinging 100 times and see
server-status in Apache and when the scripted site is being access the
cpu load is around 2.5%.
Regards,
/mysteron
--- On Mon, 6/9/08, Bent Terp [EMAIL PROTECTED] wrote:
From: Bent Terp [EMAIL PROTECTED]
Subject: Re: [CentOS] Help, PHP/Mysql connections are so slow.
To: CentOS mailing list
%.
Regards,
/mysteron
--- On Mon, 6/9/08, Bent Terp [EMAIL PROTECTED] wrote:
From: Bent Terp [EMAIL PROTECTED]
Subject: Re: [CentOS] Help, PHP/Mysql connections are so slow.
To: CentOS mailing list centos@centos.org
Date: Monday, June 9, 2008, 10:42 AM
communicate with MySQL5
PROTECTED] wrote:
From: Bent Terp [EMAIL PROTECTED]
Subject: Re: [CentOS] Help, PHP/Mysql connections are so slow.
To: CentOS mailing list centos@centos.org
Date: Monday, June 9, 2008, 10:42 AM
communicate with MySQL5. On this server, PHP/Mysql
connections are dead
slow
--- On Mon, 6/9/08, Peter Farrell [EMAIL PROTECTED] wrote:
From: Peter Farrell [EMAIL PROTECTED]
Subject: Re: [CentOS] Help, PHP/Mysql connections are so slow.
To: CentOS mailing list centos@centos.org
Date: Monday, June 9, 2008, 1:03 PM
If it's a table listing check your MySQL settings. How
have
that on the
server. I have It is a mystery ;)
I'm starting to wonder if this is a broken hardware issue...
Regards,
/mysteron
--- On Mon, 6/9/08, Peter Farrell [EMAIL PROTECTED] wrote:
From: Peter Farrell [EMAIL PROTECTED]
Subject: Re: [CentOS] Help, PHP/Mysql connections are so slow.
To: CentOS mailing
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/Mysql the connection
to the server takes forever.
What happens if you include a
On Mon, Jun 9, 2008 at 1:05 PM, Bent Terp [EMAIL PROTECTED] wrote:
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/Mysql the
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 [EMAIL PROTECTED] wrote:
From: Lorenzo Martínez Rodríguez [EMAIL PROTECTED]
Subject: Re: [CentOS] Help, PHP/Mysql connections are so
Pro Green European wrote on Mon, 9 Jun 2008 03:37:33 -0700 (PDT):
I also have the same identical site accessing the same database on
the same mysql server, running on a CentOS4 server without any problem.
How did you move the database? You moved from PHP4 to 5 and from MySQL4 to
5. You *have*
On Mon, 2008-06-09 at 04:28 -0700, Pro Green European wrote:
Delays in the connection to the db server is still around 20-30
seconds.
It sounds like the MySQL server is configured to do reverse DNS lookups
on incoming connections, and those DNS lookups are timing out. For
small systems (a
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):
I also have the same identical site
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Pro Green European wrote:
Thank you for all your time and replies :)
I solved the problem by switching to RHEL 5.2 x86_64 on the same server. Now
PHP/Mysql is working properly.
Strange thing though, every setting is identical to that of the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ralph Angenendt wrote:
5.0.45 AFAICS.
That would answer the upgrade to at least 5.0.30 part. :) Thanks, Ralph.
Regards,
Max
- --
# find . *imbecile -exec sed -ie s/stupidity/commonsense/g '{}' \;
-BEGIN PGP SIGNATURE-
Version: GnuPG
Erek Dyskant wrote:
It sounds like the MySQL server is configured to do reverse DNS lookups
on incoming connections, and those DNS lookups are timing out. For
small systems (a few web servers and a db server) I tend to add the web
servers to the system's hosts file, so the mysql server doesn't
16 matches
Mail list logo