To show the storage engines used by each tables in a database



1. Login to Mysql as root user.

2. Use db_name;

3. Execute the query "show table status ; ". It'll show the engine used by each tables in the database you have selected.

Popular posts from this blog

Qmail cheat sheet

Open VZ cheat Sheet

Enable TUN/TAP and PPD in VM on open VZ