Category Archives: InnoDB

Running Sysbench 0.4.12 on Ubuntu 9.04

By ivanov | Published: October 17, 2009

I decided to try benchmarking MySQL 5 with Sysbench 0.4.12 but as it turned out it was not so easy task.First I followed the steps as described by the dbadojo blog: Download last version of Sysbench tar -xzvf sysbench-0.4.XX.tar.gz cd sysbench-0.4.XX ./configure && make && make install But the compiling wasn’t done and I get a strange error: ../libtool: line 2412: [...]

Also posted in Benchmarks, MySQL, Sysbench | 2 Comments

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. [...]

Also posted in Benchmarks, Databases, MyISAM, MySQL | Tagged Benchmarks, Databases, InnoDB, 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 [...]

Also posted in Databases, MyISAM, MySQL | Tagged Databases, InnoDB, MyISAM, MySQL | 1 Comment