geek stuff - Entries from September 2011

  • September, 2011
  • audit for incorrect engine

    If you use innodb engine exclusively, and want to audit your databases for any tables that might have an incorrect engine, use the command below -

    mysql -u root -p  information_schema -e \
    "select TABLE_SCHEMA,TABLE_NAME, ENGINE from TABLES where\
     ENGINE != 'Innodb' \
     and TABLE_SCHEMA not in ('mysql','information_schema');"
    

Page 1 of 1, totaling 1 entries