mariadb,0% innodb读缓冲区效率

kqhtkvqz  于 5个月前  发布在  其他
关注(0)|答案(1)|浏览(47)

我有一个运行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/


有什么想法去哪里找这个问题吗?
我已经尝试了几种设置,并与现有的系统进行了比较。
谢谢,罗杰

2nbm6dog

2nbm6dog1#

在11.1.3版本中是a bugInnodb_buffer_pool_read_requests没有被增加,因此出现了负命中。它将在下一个版本11.1.4中得到修复。

相关问题