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?


Subject: [PHP-DB] 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 (
To unsubscribe, visit:

Take charge with a pop-up guard built on patented Microsoft® SmartScreen Technology Start enjoying all the benefits of MSN® Premium right now and get the first two months FREE*.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to