Category 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 – [...]
Also posted in Benchmarks, DBT2, PostgreSQL | Tagged , , , , | Leave a comment

Database Virtualization

Following the series of virtualization posts today I dig up for some papers and articles on database virtualization which is another hot topic that is coming in near future.I found a bunch of good posts and a few papers , but still there is a lack of precise information and clear implementation.I even read some [...]
Also posted in Databases, SOAP, VMWare, Virtualization | Tagged , | 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 [...]
Also posted in Databases, InnoDB, MyISAM | Tagged , , , | 1 Comment
  • isisun photos

  • Categories

  • posidev.com

    Valid XHTML 1.0 Transitional

    Tracked by ClickAider

  • Charts

  • Visitors

    free counters