mysql -u root -p -e "SHOW VARIABLES LIKE 'innodb_buffer_pool_size';"
Show the InnoDB buffer pool size
The buffer pool is InnoDB's main cache; a small value means heavy disk I/O. The classic sizing rule is 70 to 80 percent of available RAM on dedicated servers. Changing it requires a restart unless resized online.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.