Tags » Innodb

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

Using MySQL NDB with ruby on rails

Using NDB with ruby on rails is a big problem. Ruby generates table by its own script, but in default it generates the tables in InnoDB engine. 284 more words

InnoDB

Innodb Performance Tuning Tips and Research

 MySQL is an astonishing piece of software but its worth noting that it is complex and requires work to really take advantage of.  No where is this more true than in performance tuning. 141 more words

Mysql