1. Default timeout
MySQL has a default timeout of a session set to 8 hrs. You may want to reduce it to say 5 min
2. Persistent connection
Check whether you are using the persistent connection in PHP, while connecting to MySQL
(Although the advantages and disadvantages of Persistent connections are still not clear, but it does help in certain situation)
Do No 2 only as a test, because it may worsen the situation, if your MySQL setting are not properly set.
On a general note, you can always check the status and current running processes with the query
SHOW PROCESSLIST
Amit www.digitalamit.com
Bastien Koert wrote:
Do you have indexes on the searched columns? Are you searching on numeric links not text (numbers are easier to compare) What is your structure / data like?
Bastien
From: "Murat BIYIKLI" <admin@xxxxxxxxxxxxxxxxxxxx> To: php-db@xxxxxxxxxxxxx Subject: MySQL performance and crash Date: Fri, 1 Oct 2004 17:41:57 +0300
I use a Linux web server with PHP-MySQL. The hardware is good enough with
2GHz CPU and 1 GB RAM. and 7200 Cycle/min Serial ATA IDE HDD. Only one web
site is running on it and on every page of that site, it searchs for a value
in Users table including 78000 records and updates that value. The MySQL
crashes on everyweek and needs to be killed and restarted, sometimes the
server becomes unreachable and needs to be restarted.
Do you think MySQL is not stable or bad configured? How to optimize that and
monitor what goes wrong, or is it time for Oracle?
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
_________________________________________________________________
Take charge with a pop-up guard built on patented Microsoft® SmartScreen Technology http://join.msn.com/?pgmarket=en-ca&page=byoa/prem&xAPID=1994&DI=1034&SU=http://hotmail.com/enca&HL=Market_MSNIS_Taglines Start enjoying all the benefits of MSN® Premium right now and get the first two months FREE*.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
