I've a Dual Xeon 2.4 with 1gb RAM and I'use the server for my website only. Being a Search Engine, it has to fetch results from other providers via xml using MySQL Database. As a result, MySQL is busy almost all the time and the db is crashed many times a day.
If I restart MySQL every 1hr, things go smoothly but the db crashes if I dont restart it often.
What do I need to do to improve MySQL Performance?
Increase RAM, Add another server for load balancing, have a database server etc..?
