Skip to content

InnoDB Write Log efficiency: 3130.77% #820

@PieterAkkerman

Description

@PieterAkkerman

Running MySQLTuner 2.6.2:

The only issue that shows:
InnoDB Read buffer efficiency: 100.00% (7556313946 hits / 7556546693 total)
InnoDB Write Log efficiency: 3130.77% (2685605 hits / 85781 total)
InnoDB log waits: 0.00% (0 waits / 2771386 writes)

The following suggestion is given:
innodb_log_buffer_size (> 16M)

Have tried to increase it up to 512MB but the warning keeps showing.

How can the InnoDB Write Log efficiency be over 100%?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions