我有一个运行Mariadb 11.1.3的专用服务器。我试图使用mysqltuner.pl调优数据库。在结果中,我在Innodb上得到了这个结果:
-------- InnoDB Metrics ----------------------------------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB File per table is activated
[OK] InnoDB Buffer Pool size ( 1.0G ) under limit for 64 bits architecture: (17179869184.0G )
[OK] InnoDB buffer pool / data size: 1.0G / 493.0M
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 256.0M * 1/1.0G should be equal to 25%
[--] Number of InnoDB Buffer Pool Chunk: 64 for 1 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[!!] InnoDB Read buffer efficiency: 0% (-19040 hits / 0 total)
[!!] InnoDB Write Log efficiency: 88.69% (239467 hits / 270003 total)
[OK] InnoDB log waits: 0.00% (0 waits / 30536 writes)
字符串
我在互联网上搜索为什么读缓冲区效率为0%,但我找不到任何关于它的东西。
My my.cnf:
[client-server]
socket = /run/mysqld/mysqld.sock
[mysqld]
skip_name_resolve = ON
join_buffer_size = 1M
tmp_table_size = 64M
max_heap_table_size = 64M
table_definition_cache = 4096
performance_schema = ON
innodb_buffer_pool_size = 1024M
query_cache_limit=8M
query_cache_size=256M
query_cache_type=1
innodb_log_file_size = 256M
slow_query_log = 1
slow-query_log_file = /var/log/mysql-slow.log
long_query_time = 1
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/
型
有什么想法去哪里找这个问题吗?
我已经尝试了几种设置,并与现有的系统进行了比较。
谢谢,罗杰
1条答案
按热度按时间2nbm6dog1#
在11.1.3版本中是a bug,
Innodb_buffer_pool_read_requests
没有被增加,因此出现了负命中。它将在下一个版本11.1.4中得到修复。