I have a 24GB machine running MySQL (only InnoDB tables). My innodb data set is 11.5GB big, and i have set my innodb_buffer_pool_size to 14GB to allow some growth. So the entire innodb data set is ...
I read some fine tuning recommendations on the mysqlperfomanceblog and tryed to adapt them. I added to my.cnf: innodb_buffer_pool_size = 1000M innodb_log_file_size = 256M After ...
MySQL is not my thing, yet I need to fine-tune one of our servers. Here are the requirements/specs: The MySQL server has only one significant database We only have one "type" of application ...