mysql – find table information

Published by

Posted on April 26, 2008

mysqlshow –status db_name   * show engine type , and some other info

mysqlcheck -r dbname – repairs a table/database

describe tablename

reference

http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

innodb engine

http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html

http://dev.mysql.com/doc/refman/5.0/en/innodb-monitor.html

Categories: MySQL