Hi,
I am currently experiencing problems with MySQL. The application I am using is simple. Its basically a directory type feature that enables users to add their links and information on to the database. The database however crashes frequently! I don't know why? The traffic generated on the site(s) is considerable about 1.5 million a month but the hits on the pages that use that database is lower, about 600,000 per month. The application is built using php. The version of mysql I am using is 3.2338. I am trying to figure out if it is a problem with the database (that it cannot handle the load) or whether it is a problem with the code or that the server needs to be simply upgraded. The application did not cause any problem in the first few months when traffic was lower. And the database seems to work when traffic is low, otherwise its extremely slow or crashes!
Will upgrading the server help? The server currently has 1GB RAM.
Or should Mysql be capable of handling the current load? By the way max connections is set to 100.
I would appreciate your help. Thanks.
Rajen
