oli's blog

This MySQL Performance Tuning Key should give you a guide how to best tune you MySQL database systematically… It should also work similar for other RDBMS.

Core files under Linux

When dealing with MySQL crashes it is very useful to get the core files for further debugging. I have collected all the informations I found about it and wrote it together here:

As you probably have experienced yet MySQL does not always provide all internal information as you might want to have them and as you are used to have from other RDBMS.

Basic solutions (CLI)

Those solutions are run from the command line (CLI):

Performance Tuning, Benchmarking, Capacity Planning and Monitoring

MySQL Database Health Check for MySQL/MariaDB

Why is is data load with LOAD DATA INFILE so much faster?

Table of Contents

• What is a Materialized View?
• Implement your own Materialized Views
• Refreshing materialized views
• Hands on
• Create your own Materialized View:
• Refresh Materialized View on demand
• Refresh Materialized View immediate
• Materialized Views with snapshotting functionality
• Some performance benchmarks for our Materialized Views:
• Outlook
• Conclusion
• Literature

What is a Federated Table?

A Federated Table is a table which points to a table in an other MySQL database instance (mostly on an other server). It can be seen as a view to this remote database table. Other RDBMS have similar concepts for example database links.

The following tools we use sometimes for our consulting engagements…

Table of Contents

• Database Benchmark
• General Benchmarking Tools
• CPU Benchmarking
• Disk benchmarking
• Network Benchmarking
  • Tools
• Application Stress Testing
  • OwnCloud / NextCloud
  • Asterisk

Database Benchmark

• sysbench (filesystems and OS/HW tests), Sysbench source, sysbench v0.5, sysbench scripts
• OSDL Database Test Suite (download)
• DBT2 (TPC-C, OLTP), DBT2 Benchmark Tool for MySQL
• DBT3 (TPC-H, complex and long running queries, data warehouse (DWH))
• TM1 (3^rd party, ODBC, telecom benchmark)
• TPC Benchmarks
• TPCC-mysql
• db_STRESS
• HammerDB
• db_bench
• Acronis perfkit (benchmark, benchmark-db)
• Web3Bench (TiDB, MySQL written in Java/Python)
• Finch (Finch is a MySQL benchmark tool developed for software engineers and modern infrastructures.)

General Benchmarking Tools

• Apache JMeter: To test performance on static and dynamic resources (files, Servlets, Perl scripts, Java Objects, Data Bases and Queries, FTP Servers and more).
• Gatling: Gatling is a highly capable load testing tool. It is designed for ease of use, maintainability and high performance.
• Tsung: Open-source multi-protocol distributed load testing tool.
• Slamd Java-based Distributed Load Generation Engine application designed for stress testing and performance analysis of network-based applications.
• Grinder A Java load testing framework that makes it easy to run a distributed test using many load injector machines.
• mysqlslap mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. It works as if multiple clients are accessing the server.
• bm
• httperf
• apachebench (ab)

CPU Benchmarking

• CoreMark

Disk benchmarking

• FIO
• Filesystem Benchmark: IOzone, Bonnie
• Harddisk-Benchmark: Bonnie++, Iometer

# bonnie -s 2047 -S 10000

Bonnie 1.4: File './Bonnie.12330', size: 2146435072, volumes: 1
Writing with putc()...         done:  20440 kB/s  89.7 %CPU
Rewriting...                   done:  18940 kB/s  18.3 %CPU
Writing intelligently...       done:  46256 kB/s  28.8 %CPU
Reading with getc()...         done:  18771 kB/s  82.1 %CPU
Reading intelligently...       done:  32549 kB/s  17.3 %CPU

              ---Sequential Output (nosync)--- ---Sequential Input-- --Rnd Seek-
              -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --10k (03)-
Machine    MB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU   /sec %CPU
master 1*2047 20440 89.7 46256 28.8 18940 18.3 18771 82.1 32549 17.3  183.6  1.5

with fsync

One of the big advantages of MySQL is its concept of Pluggable Storage Engines. This means you can choose the most optimal Storage Engine for your needs. This also has a disadvantage: You have to know what you are doing…

Hello everybody,

One month earlier than planned we have the great pleasure to announce you that the company called FromDual goes operational today!

The following presentations are available:

If you want us to have a talk at your conference or event please let us know.

Neutral and vendor independent services for
MariaDB, Galera Cluster, MySQL and PostgreSQL!

FromDual offers trainings for MySQL, MySQL Enterprise, Galera Cluster, MariaDB or Percona Server.

Open job offers

We currently have no job opportunities open. If you are interested to work for FromDual leave us a note and we will inform you about our future job offerings…

FromDual delivers neutral and vendor independent on-site consulting services on MariaDB, MySQL, Galera Cluster, Percona Server and PostgreSQL. Our experienced consultants recommend you the best solutions fitting to your needs.

FromDual Performance Monitor

The FromDual Performance Monitor is a monitoring solution for MariaDB, Galera Cluster, MySQL, Percona Server and PostgreSQL databases.

You can get in contact with us as follows: