Question buffer pool recommendations

[RB-design]

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

 

[afuego]

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.

 

[Peter Debik]

Hi @afuego, MySQL optimization is a very individual task. There is no "one fits all" size. Instead, you can use GitHub - major/MySQLTuner-perl: MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. for analyzing performance and getting recommendations on your own server.