Neuigkeiten

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.

Also check our MySQL Performance Monitor

For a database configuration tuning only please look first at our MySQL database health check.

If this MySQL Database Health Check does NOT solve your problem our specialized Performance Tuning and Architecture Consultants can help you for sure!

Caution: Some recommendations are dangerous! Dangerous means …

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:

Find core files

# find $HOME -name "core*"
/home/oli/core.6440

# file core
core:      ELF 32-bit LSB core file Intel 80386, version 1 (SYSV), SVR4-style

See who caused the core file:

# strings core.6440 | head
CORE
CORE
mysqld
/home/mysql/product/mysql-5.1.30/bin/mysqld …

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.

MySQL plans to improve this implementing the/a performance schema and its probably already partly done in MySQL 5.4. But who knows when this will be finished and what it contains at all…

What is not provided to me I want to gather myself… But how? Other RDBMS provide interfaces to attach applications directly to their memory to …

Basic solutions (CLI)

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

• top (man)
• vmstat (man)
• iostat (man), mpstat (man), pidstat in package sysstat
• mytop, a Mytop Introduction
• dstat
• free (man)
• procinfo (man)
• mpstat (man)
• mTop
• InnoTop

Advanced solutions

More advanced MySQL database and host monitoring solutions with graphs and/or history and/or hints are:

Performance Tuning, Benchmarking, Capacity Planning and Monitoring

MySQL Database Health Check for MySQL/MariaDB

MySQL Performance Monitor

MySQL monitoring solutions

MySQL Performance Tuning Key

Wie der MySQL Optimizer schummelt, wenn es um MySQL Cluster geht…

How the MySQL Optimizer with MySQL Cluster is cheating you…

MySQL Benchmarking

Some more benchmarks added

My thoughts about MySQL (Cluster) replication

My wish for the New Year: MySQL DBA’s, please install iostat on your servers! …

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

Probably the answer to this question is already known. But we want to prove it and by the way learn to deal with oprofile.

For the test MySQL 5.0.28 was used and 100k rows were loaded into a table sales which looks as follows:

CREATE TABLE sales (
    sales_id       INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
  , product_name   VARCHAR(128) NOT NULL
  , product_price  DECIMAL(8,2) NOT NULL
  , product_amount SMALLINT     NOT NULL
) ENGINE = …

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 Materialized View?

A Materialized View (MV) is the pre-calculated (materialized) result of a query. Unlike a simple VIEW the result …

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.

What can I do with a Federated Table?

To show what you can do with a federated table let us assume the following constellation: Two MySQL databases on two different servers. The first one called provider (it provides the data) the second one called …

The following tools we use sometimes for our consulting engagements…

Caution: These tools are NOT for production use! Use with care!

Other tools

FromDual also provides some other tools:

• Database Health Check for MySQL
• FromDual consulting tools for MySQL
• Performance Tuning Key for MySQL
• MyEnv MySQL Environment (Multi Instance operation scripts)

3^rd party tools for MySQL

Other 3^rd party tools for MySQL you should consider are:

• Maatkit
• mylvmbackup
• mytop
• innotop
• InnoDB recovery tools
• mysql-snmp …

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 …

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…

If you need some help deciding which is the right Storage Engine or even strategy for you or if you want us to make an independent and vendor neutral comparison of those Storage Engines consider our FromDual Consulting Services!

MySQL provides the following storage engines:

mysql> …

Hello everybody,

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

We are excited about this step and it is an new era in our personal evolution to get back in full-contact with customers and solve their real life day-to-day MySQL problems.

So we are happy hearing from you and to help you solving your individual MySQL problems…

You can find us at FromDual or you can drop us a line.

Regards,
Oli Sennhauser (aka Shinguz) …

The following presentations are available:

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

Services for MariaDB, Galera, MySQL and PostgreSQL

We offer the following services:

• Neutral and vendor independent on-site or remote consulting for MariaDB, Galera Cluster, MySQL, Percona Server and PostgreSQL.
• Enterprise support subscriptions for MariaDB, Galera Cluster and MySQL.
• MariaDB, Galera and MySQL training for database administrators (DBAs) and developers.
• With our remote DBA services we help you to …

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

We offer our MySQL, Galera Cluster and MariaDB trainings together with well-respected training organizations: The Linuxhotel in Essen (Germany), the Heinlein Academy in Berlin (Germany) and GFU Cyrus AG in Cologne (Germany).

If you prefer a MySQL, Galera Cluster or MariaDB in-house training at your location and if you provide the infrastructure we are happy to train you on-site either in German or English as …

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…

Old job offers

MySQL DBA for FromDual Support Line (open until September 30^th 2015)!

MySQL DBA for FromDual Support Line (open until January 31^st 2014)

MySQL DBA for FromDual Support Line (open until May 31^st 2013)

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.

We help you in delicate matters as:

• Getting the maximum out of your current hardware through Performance Tuning and SQL Query Tuning by adding indexes where necessary.
• Evaluating more advanced Database Architectures like Master/Slave Replication or synchronous multi-Master …

FromDual Performance Monitor

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

It is based on the monitoring solution Zabbix.

The FromDual Performance Monitor supports monitoring the following MariaDB/MySQL storage engines: InnoDB, Aria and MyISAM.

Further you can monitor:

• Galera Cluster topologies
• Master/Slave replication topoligies
• Unix processes (mariadbd/mysqld)
• MariaDB/MySQL/Percona server specific information
• etc. …

You can get in contact with us as follows: