There are a ton of things to check.
Check the amount of memory that can be used by each process;
add some time checks to the scripts to see where the hang ups are, if its db access or the webserver.
Monitor the amount of resources consumed by each process during a page creation/query.
Check the logs. Turn on slow-query log for mysql to see what queries(if any) could be tuned to gain performance.
Check to see that the webserver has all required permissions to write session files (if your app uses sessions) and other files as needed.
Check to see if you have indexes on the tables. We've migrated before and lost all the indexes and that can kill the app.
bastien
From: Andre Matos <andre.matos@xxxxxxxxxxxx> To: "'php-db@xxxxxxxxxxxxx'" <php-db@xxxxxxxxxxxxx> Subject: Slow access Apache + PHP + MySQL Date: Sat, 26 Mar 2005 10:47:18 -0500
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 andre.matos@xxxxxxxxxxxx
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
