Your request is just to broad to answer.  There are lots of places to look
but I doubt php is causing your slowdowns.  Poorly written php code will
cause slowdowns not the server compiled php though.

Lots of server monitoring script monitoring and logging you can start to
trace down problems like this.

You also missed an important part of any server with slowdowns and that is
the network itself can cause load and grief.

I can tell you that most default setups are very tight on resource use, and
the helpful information others will point you to on the web just wasn't
written for 4 gig ram and 64bit servers.  More along the line of a nice
high-performance PIII.  So be careful what you read.  Learn the math to do
it right and not the exampled settings you see in forums.

Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183


-----Original Message-----
From: Andre Matos [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 26, 2005 8:47 AM
To: 'mysql@lists.mysql.com '
Subject: Slow access Apache + PHP + MySQL


Hi List,

I have 4 web based systems developed using PHP4 and MySQL accessed for 10
users. The Web Server and Database Server were running ok on a Mac OS X 10.3
G4 dual. However, since we move to a new server, the access becomes very
slow. This was not expected since we move to a 64 bits high performance
machine.

Now, we are using MySQL version 4.1.9 with Apache 2.0.52 and PHP 4.3.10, all
compiled and running on a Linux Fedora X86_64.

My first thought was the systems, but since I have not changed 3 of the 4
systems, I start to look to the database. I monitored the MySQL using "MySQL
Administrator", but I couldn't identify any problem. It looks ok, but not
completely sure if really is.

The system administrator told me that could be the PHP session, but again,
he also was not complete sure about this.

It is a big problem since I need to check in 3 places: MySQL, Apache, or
PHP.

Does anyone had this kind of problem or has any suggestion or direction to
help me to identify and solve this issue?

Any help will be appreciated!!!

Thanks.

Andre

--
Andre Matos
[EMAIL PROTECTED]

--
Andre Matos
[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to