And to add further, please check the following two setting in your PHP /
MySQL configuration.
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,
MySQL is stable enough. May be it'll be better to rewrite your code or
to add some indexes to Users?
I can help you with ideas of refactoring.
Murat BIYIKLI wrote:
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 HD
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" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL performance and crash
Date: Fri, 1 Oct 2004 1