Serial benchmarks in Mysql, Oracle and PostgreSQL

1
MySQL and PostgreSQL Evaluation
Past tests, tools and highlights
António Amorim, Carlos Jesus. CU1 - First
Database Testing Meeting, 20/Nov/08
2
Test objectives

• Past studies evaluated the architecture and
  performance of MySQL Cluster and PostgreSQL
  solutions for the Gaia Databases.
• MySQL Cluster
• MySQL-Cluster
• Poor performance
• Redundancy benefits
• PostgreSQL
• Sends 2x more data than MySQL
• Poor Bytea performance

Network load(400K objects)? PostgreSQL
2072M MYSQL 1050 Mb ORACLE-XE 520 Mb
António Amorim, Carlos Jesus. CU1 - First
Database Testing Meeting, 20/Nov/08
3
Single MySQL Server
In order to pinpoint bottlenecks associated with
MySQL, a series of basic tests were performed,
these new tests made use of the available
MDBExtractorIngestor package. Control and
Monitor Available at the local infrastructure
was the SMS (Supervisor Monitor Scheduler) batch
system, we deployed in one node the database and
in another the Ingestor. At the local
infrastructure was available the SMS (Supervisor
Monitor Scheduler) batch system. The tests
basic 2 node client server model the nodes where
as following
Hardware setup
António Amorim, Carlos Jesus. CU1 - First
Database Testing Meeting, 20/Nov/08
4
The Tests
JdbcObjectUpdater.java
MySQL Ingestor, Old and new JdbcObjectUpdater
António Amorim, Carlos Jesus. CU1 - First
Database Testing Meeting, 20/Nov/08
5
The MDBExtractorIngestor
António Amorim, Carlos Jesus. CU1 - First
Database Testing Meeting, 20/Nov/08
6
QA

• For more informationMore on MySQL-cluster and
  other studiesSIM Studies at the GAIA WIKIThe
  technical noteGAIA-C1-TN-SIM-CDJ-001-1.pdf
• GAIA-C1-TN-SIM-AAB-001-01.pdf

António Amorim, Carlos Jesus. CU1 - First
Database Testing Meeting, 20/Nov/08