• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Question buffer pool recommendations

RB-design

New Pleskian
Hi, I've set up my first dedicated machine. I was wondering if you would have recommendations regarding the settings for the mysql server. I currently have the default settings.
MariaDB [psa]> show variables like 'innodb_buffer_pool%';
+-------------------------------------+----------------+
| Variable_name | Value |
+-------------------------------------+----------------+
| innodb_buffer_pool_chunk_size | 134217728 |
| innodb_buffer_pool_dump_at_shutdown | ON |
| innodb_buffer_pool_dump_now | OFF |
| innodb_buffer_pool_dump_pct | 25 |
| innodb_buffer_pool_filename | ib_buffer_pool |
| innodb_buffer_pool_instances | 1 |
| innodb_buffer_pool_load_abort | OFF |
| innodb_buffer_pool_load_at_startup | ON |
| innodb_buffer_pool_load_now | OFF |
| innodb_buffer_pool_size | 134217728 |
+-------------------------------------+----------------+

But my server has plenty of resources (16 x AMD Ryzen 7 3700X 8-Core Processor with 64 GB of RAM) so I was wondering if I should increase the pool_size and chunk_size, and if so, what would be the rule of thumb be for the amount I allocate to them?

Thanks
 
Did you make any changes to the MySQL configuration, I have a similar server and would love to see if you can share what you did to tune up the performance.

Thanks in advance.
 
Back
Top