I have a 13 GB mysql database and I would like to optimize my.cnf.
The db has 150 tables, 140 MyISAM tables and 10 InnoDB. The server now has 8GB RAM but I plan to increase it to 16 GB.
Mytop says that the key efficiency is 100%:
MySQL on localhost (5.0.22) up 0+04:28:26 [19:47:35]
Queries: 5.4M qps: 351 Slow: 0.0 Se/In/Up/De(%): 38/00/00/00
qps now: 382 Slow qps: 0.0 Threads: 23 ( 2/ 2) 45/00/00/00
Key Efficiency: 100.0% Bps in/out: 0.2/ 58.4 Now in/out: 8.4/ 1.5k
phpMyAdmin shows that I have 56 million rows on that table.
My current my.cnf is this:
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
Most of the times the Mysql is very fast, but some select queries are slow and slowing down other selects from the same table.
My question is: what should be my optimal my.cnf if I keep the existing 8GB RAM? What if I raise the RAM to 16 GB? Would it be OK to increase memory to 16 GB, this way, I could use the entire database from memory? Am I wrong? The server is only a MySQL server.