Tag Archives: InnoDB

Tunning MySQL InnoDB performance

By ivanov | Published: June 30, 2009

Tunning MySQL InnoDB storage engine is not an easy task. It’s more like a game where you set mini goals and then try to find the right value and achieve them. Playing with the InnoDB variables is an art where you have to check your performance results each time you change a configuration parameter. [...]

Posted in Benchmarks, Databases, InnoDB, MyISAM, MySQL | Also tagged Benchmarks, Databases, MyISAM, MySQL | 3 Comments

MySQL Storage Engine

By ivanov | Published: April 5, 2007

Storage Engines MyISAM table type is mature, stable, and simple to manage -MyISAM Static -MyISAM Dynamic -MyISAM Compressed InnoDB -a modern alternative to MyISAM, which above all offers the following additional functions: -Transactions -Row Level Locking -Foreign Key Constraints -Crash Recovery Limitations and Drawbacks: -Tablespace Administration:the InnoDB table driver stores all data and indexes in a tablespace, comprising one or more files, that [...]

Posted in Databases, InnoDB, MyISAM, MySQL | Also tagged Databases, MyISAM, MySQL | 1 Comment