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 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:

Reply via email to