Friday, October 22, 2010

How to check innodb is enabled or not?

Simply login into shell as root user and fire following command.


root@server[~]# mysqladmin variables | grep innodb
| have_innodb | YES |
| innodb_additional_mem_pool_size | 67108864 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 1073741824 |
| innodb_checksums | ON |


In above result shows "have_innodb" YES result then yes innodb is enabled on server.