# very accurate in calculating 'innodb_buffer_pool_chunk_size' 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; # Returns RIBS in GB # innodb_buffer_pool_chunk_size = 17G
To embed this program on your website, copy the following code and paste it into your website's HTML: