منتدى استراحات زايد - [استفسار] : أعداد my.cnf لهذا السيرفر

السلام عليكم
هذه الأعدادات المستخدمة
رمز PHP:

[mysqld]
skip-host-cache

skip-name-resolve
innodb_file_per_table=1
tmp_table_size = 384M
max_heap_table_size = 384M
query_cache_size=64M # increment by 32M, max of 384M if busy MySQL server
thread_cache_size=64 # can be increased on servers with large numbers of active users
key_buffer_size=32M
max_allowed_packet=16M # don't change unless required for large blobs
table_cache=1024 # can be increased if more Opened tables - SHOW STATUS LIKE 'Opened_tables';
table_definition_cache=8192 # increase by the same factor as table_cache
innodb_buffer_pool_size=128M # check mysql -e "SHOW GLOBAL STATUS LIKE 'Innodb_buffer_pool%';" - free vs total
innodb_flush_method=O_DIRECT
open_files_limit=16384
max_connections=200 # Should be between 100-150, increase *slowly* because it causes MySQL to consume more memory!
max_user_connections=200
wait_timeout=7200 # can be increased if using persistent connections
slow_query_log=1
log-output=TABLE # select * from mysql.general_log order by event_time desc limit 10;
long_query_time=20 # select * from mysql.slow_log order by start_time desc limit 10;
myisam_sort_buffer_size=2M # can be increased per sessions if needed for alter tables (indexes, repair)
thread_concurrency=12 # Number of physical + virtual CPU's, be careful of adding more

مواصفات السيرفر

CPU Intel Xeon
E5-1650v2 6c/12t 3,5 GHz+/3,9 GHz+
RAM 128 GB DDR3 ECC 1600MHz

للخبراء هل يمكن تحسين تلك الأعدادات ؟

رأيكم

شكرا لكم