我正在运行一个Magento网站,访问量为100人/小时,内存64 i7,采用英特尔酷睿i7处理器。当我运行mysqltuner时,我收到消息“MySQL的最大内存使用率非常高”。
我需要帮助来调整MySQL以满足我的需求,并清除警告。
这是my.cnf文件:
key_buffer = 32M
max_allowed_packet = 16M
thread_stack = 256K
thread_cache_size = 100
table_open_cache = 4000
table_definition_cache = 8192
tmp_table_size = 512M
max_heap_table_size = 512M
innodb_buffer_pool_instances = 24
innodb_flush_log_at_trx_commit = 0
innodb_read_io_threads = 64
innodb_write_io_threads = 64
innodb_io_capacity = 50000
innodb_flush_method = O_DIRECT
innodb_file_per_table
innodb_additional_mem_pool_size = 16M
transaction-isolation = READ-COMMITTED
innodb_support_xa = 0
innodb_commit_concurrency = 8
innodb_old_blocks_time = 1000
innodb_lock_wait_timeout = 120
innodb_buffer_pool_size = 40G
thread_concurrency = 10
max_connections = 64
innodb_thread_concurrency = 18
thread_cache_size = 64
table_cache = 2000
query_cache_type = 1
query_cache_size = 128M
query_cache_limit = 3M
key_buffer_size = 8G
sort_buffer_size = 64M
read_buffer_size = 64M
read_rnd_buffer_size = 64M
join_buffer_size = 128M
我该怎么做才能让mysqltuner警告消失?
发布于 2018-06-16 07:36:52
要考虑的my.cnf-ini mysqld部分的建议
以#开头或删除它们将允许使用MySQL默认值,并在很大程度上消除该消息。
sort_buffer_size = 64M
read_buffer_size = 64M
read_rnd_buffer_size = 64M
join_buffer_size = 128M
你会发现响应时间要快得多。
请张贴MySQL调谐器报告的完整文本。
其他建议2018年7月14日
innodb_buffer_pool_instances=8 # from 24 minimize overhead
innodb_lru_scan_depth=128 # from 1024 to conserve CPU every second
要获得更多帮助,请查看我的个人资料,clk网络个人资料以获取联系信息。谢谢
https://stackoverflow.com/questions/35896119
复制相似问题