Determining the correct InnoDB Pool Buffer Size for MySQL servers

For MySQL imports the innodb pool buffer size should be size of the largest table + 60%
created by on 2015-02-10

You can calculate correct value for your database using this command:

SELECT
    CEILING(Total_InnoDB_Bytes * 1.6 / POWER(1024, 3)) RIBPS
FROM
    (SELECT
        SUM(data_length + index_length) Total_InnoDB_Bytes
    FROM
        information_schema.tables
    WHERE
        engine = 'InnoDB') A;
Tags: