Tags » Innodb

Main difference between InnoDB and MyISAM

The main differences between InnoDB and MyISAM (“with respect to designing a table or database” you asked about) are support for “referential integrity” and “transactions”. 205 more words

My Sql

MyISAM vs InnoDB....??

Storage Engines are the programs that are integrated with a MYSQL database management to manage the data tables. MYSQL supports different storage engines that handles different tables. 327 more words

Article

mysql cheatsheat

Database

Innodb Status

  • For checking innodb errors
    mysql> show innodb status\G
    

System Variables

     select * from INFORMATION_SCHEMA.GLOBAL_VARIABLES where VARIABLE_NAME like '%INNODB%';
     show variables like '%innodb%';
… 593 more words
Mysql

Visualizing the impact of ordered vs. random index insertion in InnoDB

Many DBAs know that building indexes in “random” order (or really any order that greatly differs from ordered by key) can be much less efficient. However, it’s often hard to really understand… 860 more words

MySQL