Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- Check buffer pool usage SHOW STATUS LIKE 'Innodb_buffer_pool%'; -- Check hit ratio (should be > 99%) -- Hit ratio = Innodb_buffer_pool_read_requests / -- (Innodb_buffer_pool_read_requests + Innodb_buffer_pool_reads) -- Set in my.cnf -- innodb_buffer_pool_size = 4G
Result
Open