isisun photos
Categories
Charts
Visitors
Tag Archives: MySQL
Benchmarking with DBT2
DBT2 is an open source benchmark like TPC-C for databases (mainly MySQL and PostgreSql ). The goal of this post is to list some links on DBT2 usage:
DBT2 report example
DBT2 scores
Jenny Chen’s Weblog on Performance
DBT2 Core Dev Team
MySQL Cluster Database 7: Performance Benchmark
PostgreSql Git repository with all materials
PostgreSQL Portland Performance Practice Project – [...]
Posted in Benchmarks, DBT2, MySQL, PostgreSQL Also tagged Benchmarks, Databases, DBT2, PostgreSQL Leave a comment
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 [...]

Tunning MySQL InnoDB performance