Determine which storage type is used by a MySQL table

To determine which storage type (e.g. MyISAM, InnoDB) is being used by a table, use the mysqlshow command:

mysqlshow -i -u[username] -p [database]

Only use the -u and -p flags if you need to specify a username and enter a password to access the database.

Last modified: 10/06/2008 Tags: (none)

This website is a personal resource. Nothing here is guaranteed correct or complete, so use at your own risk and try not to delete the Internet. -Stephan

Site Info

Privacy policy

Go to top