Category Archives: InnoDB

Running Sysbench 0.4.12 on Ubuntu 9.04

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

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 , , , , | 3 Comments

MySQL Storage Engine

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 , , , | 1 Comment
  • isisun photos

  • Categories

  • posidev.com

    Valid XHTML 1.0 Transitional

    Tracked by ClickAider

  • Charts

  • Visitors

    free counters