SHOW ENGINE INNODB STATUS;
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 135987200; in additional pool allocated 0
Dictionary memory allocated 1124711
Buffer pool size 8191
Free buffers 3303
Database pages 4833
Old database pages 1804
After changes
vi /etc/mysql/my.cnf
# Added
innodb_buffer_pool_size = 512M
/etc/init.d/mysql stop
/etc/init.d/mysql start
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 543948800; in additional pool allocated 0
Dictionary memory allocated 890055
Buffer pool size 32767
Free buffers 29924
Database pages 2840
Old database pages 1068
