MySQL – show storage engine used
This is a simple post, I’ve been benchmarking some MySQL storage engines at work, and sometimes from the command line I want to make sure I know what storage engine I’m using. Its actually very easy, but for some reason I keep forgetting the command. This post is for memory sake.
mysql> show table status;
mysql> show create table <table name>;