brotherhood_of_LAN - 3:28 pm on Mar 18, 2013 (gmt 0)
how would one tell if they're using InnoDB or MyISAM
For a whole database, something like
SELECT table_name,engine FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'databasename';
Or on a per table basis
SHOW CREATE TABLE tablename
Is it easy using PHPMyAdmin or is this a command line type of check
Whichever you prefer, both will show the same output. I prefer the command line as phpmyadmin will perform an extra query for pagination on the ui.