Timeline for mysql innodb_buffer_pool_size let me understand
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 13, 2014 at 18:24 | comment | added | vidyadhar | log_buffer size looks fine to me. you can consider increase the log file size to 1 GB. | |
| Oct 29, 2014 at 22:26 | history | edited | vidyadhar | CC BY-SA 3.0 |
deleted 2 characters in body
|
| Oct 29, 2014 at 22:20 | history | edited | vidyadhar | CC BY-SA 3.0 |
added 174 characters in body
|
| Oct 29, 2014 at 11:23 | comment | added | Tom | "Increasing innodb_log_buffer_size and innodb_log_file_size may help to gain the performance. But be careful if you increase the file size, it will increase the recovery time." Now I have innodb_log_file_size=128M and innodb_log_buffer_size=80M (default). Do you think it should be increased? What value should I aim? | |
| Oct 29, 2014 at 9:58 | comment | added | Tom | "As your data set is very small so you can keep most of the data in memory. Once the data is present in memory performance will increase." So you're telling that performance will increase after some time? Does mysql need some kind of warmup? Can I speed it up? | |
| Oct 29, 2014 at 0:50 | history | answered | vidyadhar | CC BY-SA 3.0 |