Re: MySQL performance and crash

["Mikhail U. Petrov" <mikhail@xxxxxxxx>]

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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php