3
votes
2answers
1k views

Picking the right innodb_buffer_pool_size

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 ...
1
vote
1answer
260 views

fine tuning of my.cnf for InnoDB tables fails with setting of: `innodb_log_file_size=256`

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 ...
6
votes
5answers
6k views

How to fine-tune our MySQL server?

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 ...