Home > Enterprise >  InnoDB Write Log efficiency is too high more than 100% (1953.15%)?
InnoDB Write Log efficiency is too high more than 100% (1953.15%)?

Time:04-28

I have MariaDB on my server with 16/32 CPU cores, Everything seems to be ok when running mysqltuner except InnoDB Write Log efficiency, taking 1953.15%, wondering if that's normal? or is there any solution how to fix that? Appreciate the advices!

-------- InnoDB Metrics --------
[--] InnoDB is enabled.
[--] InnoDB Thread Concurrency: 0
[OK] InnoDB File per table is activated
[OK] InnoDB buffer pool / data size: 16.0G/7.0G
[OK] Ratio InnoDB log file size / InnoDB Buffer pool size: 4.0G * 1/16.0G should be equal to 25%
[--] Number of InnoDB Buffer Pool Chunk : 128 for 1 Buffer Pool Instance(s)
[OK] Innodb_buffer_pool_size aligned with Innodb_buffer_pool_chunk_size & Innodb_buffer_pool_instances
[OK] InnoDB Read buffer efficiency: 99.89% (235648939 hits/ 235906897 total)
[!!] InnoDB Write Log efficiency: 1953.15% (24219 hits/ 1240 total)
[OK] InnoDB log waits: 0.00% (0 waits / 1447 writes)

Btw, The cpu usage for mariadb/mysql is more than 100% as well...

CodePudding user response:

Ignore this result in MySQLTuner when using MariaDB. The calculation is misleading due to a bug in MariaDB, according to the discussion in this issue: https://github.com/major/MySQLTuner-perl/issues/385

See also a similar issue to yours: https://dba.stackexchange.com/questions/194832/innodb-write-log-efficiency-above-100

It's not clear why "write log efficiency" is even a thing to pay attention to, even if it were calculated correctly. It lacks important context. What is the expected result? What is a bad result? What should one change if it is too high or too low?

There is even an issue asking these questions: https://github.com/major/MySQLTuner-perl/issues/291

The reply from the developer indicates to me that he doesn't understand what the InnoDB redo log is. He seems to think log writes are buffer pool writes, which is not the case.

I don't use MySQLTuner, because so frequently its advice is useless.

  • Related