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

2008-06-09 Thread Karanbir Singh
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 h

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

2008-06-09 Thread Max Hetrick
-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

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

2008-06-09 Thread Ralph Angenendt
Max Hetrick wrote: > What version is RHEL 5.2 running? 5.0.45 AFAICS. Ralph pgplQgrEe1bgI.pgp Description: PGP signature ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos

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

2008-06-09 Thread Max Hetrick
-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

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

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

2008-06-09 Thread Erek Dyskant
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

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

2008-06-09 Thread Kai Schaetzl
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

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

2008-06-09 Thread Pro Green European
oblem 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

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

2008-06-09 Thread Bent Terp
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 co

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

2008-06-09 Thread Bent Terp
> 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

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

2008-06-09 Thread Peter Farrell
>> ;* extension=php_mysql.dll*ignore - >> it's for windows >> ;* extension=php_mysqli.dll*ignore - >> it's for windows >> >> =========================== >> >> >> -Peter >>

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

2008-06-09 Thread Pro Green European
n --- 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" > Date: Monday, June 9, 2008, 1:03 PM > If it's a tabl

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

2008-06-09 Thread Lorenzo Martínez Rodríguez
ccess 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" Date: Monday, June 9, 2008, 1

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

2008-06-09 Thread Peter Farrell
es? > > None. > > I am really baffeled with this problem. I have no idea what to do next. Have > enabled 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

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

2008-06-09 Thread Pro Green European
t to do next. Have enabled 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 co

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

2008-06-09 Thread Bent Terp
> 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

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

2008-06-09 Thread Pro Green European
: Pro Green European <[EMAIL PROTECTED]> Subject: [CentOS] Help, PHP/Mysql connections are so slow. To: centos@centos.org Date: Monday, June 9, 2008, 9:42 AM 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

[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