1 GB of RAM is really not much for an SQL server, especially one where the database is over 1GB. By default, MySQL will try to hold the entire database in RAM for the best performance. It will also frequently be creating join products when a query asks to join two tables, which will consume further ...