Xrvel

Tag: InnoDB

  • Setting MySQL innodb_buffer_pool_size

    I was confused how big i should set my “innodb_buffer_pool_size” value.

    Then i find this post in stackexchange.

    I can run this query to get what is the suggestion of “innodb_buffer_pool_size” value.

    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;

    The result will be in GB.