commit ea66c01b2d454dda1115d343392343c4fcc311a4 parent 6ff94e7b52a5a91641250fd3cc94df06c4417bf6 Author: MTRNord <MTRNord@users.noreply.github.com> Date: Wed, 15 Oct 2025 09:31:55 +0200 tune Signed-off-by: MTRNord <MTRNord@users.noreply.github.com> Diffstat:
| M | apps/talos_cluster/blog/mysql-cm.yaml | | | 23 | ++++++++++++++++++++--- |
1 file changed, 20 insertions(+), 3 deletions(-)
diff --git a/apps/talos_cluster/blog/mysql-cm.yaml b/apps/talos_cluster/blog/mysql-cm.yaml @@ -17,12 +17,29 @@ metadata: data: performance.cnf: | [mysqld] - innodb_buffer_pool_size=1G + innodb_buffer_pool_size = 3G + innodb_buffer_pool_instances = 4 + innodb_io_capacity = 2000 + innodb_io_capacity_max = 4000 + innodb_read_io_threads = 4 + innodb_write_io_threads = 4 + innodb_file_per_table = 1 innodb_log_file_size = 512M thread_cache_size = 16 + thread_handling = pool-of-threads + thread_pool_size = 4 + thread_cache_size = 48 query_cache_size = 128M query_cache_type = 1 table_open_cache = 4096 + table_definition_cache = 1024 + table_open_cache_instances = 4 + join_buffer_size = 4M + sort_buffer_size = 6M + read_rnd_buffer_size = 2M + tmp_table_size = 64M + max_heap_table_size = 64M + max_allowed_packet = 64M + performance_schema = ON - max_connections = 500 - max_user_connections = 50 + max_connections = 150