FromDual launches its database Performance Monitoring solution for MySQL / MariaDB. This solution provides monitoring capabilities for most MySQL Storage Engines (Aria, InnoDB, MyISAM, NDB, PBXT and XtraDB). Further you can monitor MySQL Master - Slave replication set-ups, UNIX processes (mysqld, ndbd) and MySQL/MariaDB specific information.

FromDual veröffentlicht seine Datenbank Performance Monitoring Lösung für MySQL / MariaDB. Diese Lösung verfügt über Monitoringmöglichkeiten für die meisten MySQL Storage Engines (Aria, InnoDB, MyISAM, NDB, PBXT und XtraDB). Im Weiteren können MySQL Master - Slave Replikationen, UNIX Prozesse (mysqld, ndbd) und MySQL/MariaDB spezifische Informationen überwacht werden.

What is the FromDual Performance Monitor for MySQL/MariaDB?

The FromDual Performance Monitor for MySQL/MariaDB is a Monitoring Solution based on the Enterprise open source Monitor Zabbix.
It provides all the necessary modules to monitor MySQL performance metrics in detail an let you display them graphically.
Thus it is a good alternative to the MySQL Enterprise Monitor which is only available for paying Oracle/MySQL customers.

Henrik Ingo from the Open Database Alliance (ODBA) did an interview with Oli Sennhauser of FromDual about the European MySQL database landscape and its future.

Bei einem Kunden sind wir auf ein nettes Beispiel gestossen, wie der MySQL Optimizer schummelt, wenn er mit dem MySQL Cluster zusammen arbeiten sollte. Dieser Kunde hat Abfragen, welche auf dem Entwicklungssystem nicht sonderlich langsam gelaufen sind. Aber wenn er diese Abfragen auf dem Abnahmetest-System (mit wesentlich mehr Daten) ausführt, benötigen diese viel zu viel Zeit, was für ihn nicht akzeptabel ist, da diese Abfragen mehrmals pro Sekunde abgesetzt werden können.

At a customer we had a nice example of how the MySQL Optimizer is cheating when used in combination with the MySQL Cluster. The customer had queries running not too slow in the development environment but when he tried them on the acceptance test environment (with more data) the query was running much too long which was unacceptable because this query can occur many times per second.

Uster, Switzerland -- June 1, 2010 -- FromDual seeks Senior Database Consultant for MySQL/MariaDB

FromDual is the leading vendor independent and neutral MySQL database consulting company in Europe with its Head Quarter close to Zürich (Switzerland).
Our customers are mostly located in Europe spread over all branches and reach from very small companies up to some of the top-500 companies of Europe.

Uster, Schweiz -- 26. April 2010 - FromDual ist eine Dienstleistungspartnerschaft mit der Open Database Alliance (ODBA) eingegangen.

FromDual ist der erste offizielle ODBA Dienstleistungspartner in Europa. Die wachsende Zahl der Downloads und die stetig zunehmende Nutzung von MariaDB, eines verbesserten und erweiterten Abkömmlings der MySQL Datenbank, erfordert zunehmend auch Beratungsdienstleistungen für MariaDB in Europa.

Uster, Switzerland -- April 26, 2010 -- FromDual has signed the Service Provider Partnership Agreement of the Open Database Alliance (ODBA).

FromDual is the first official ODBA consulting partner in Europe. The growing number of downloads and use of MariaDB, an improved and enhanced derivation of the MySQL database, also requires consultancy services for MariaDB in Europe.

Uster, Switzerland -- April 26, 2010 -- FromDual has signed the Service Provider Partnership Agreement of the Open Database Alliance (ODBA).

FromDual is the first official ODBA consulting partner in Europe. The growing number of downloads and use of MariaDB, an improved and enhanced derivation of the MySQL database, also requires consultancy services for MariaDB in Europe.

Our presentation "MySQL, where are you going?" of March 25 at the OpenExpo in Bern is now available in German and English.

When you have missed it, you can download it now from here...

The video recording should be available as well soon.

Unsere Präsentation "MySQL, wohin gehst Du?" vom 25. März an der OpenExpo in Bern steht jetzt sowohl auf deutsch als auch auf englisch zur Verfügung.

Falls Sie diese verpasst haben, könne Sie sie hier herunterladen...

Database Architecture & Design

Application logic in the middle tier?

Reduce money spent on software licenses by moving logic to the middle tier. This means moving stored procedures into the application server or web server layer where it is much cheaper to scale out. Reducing or eliminating business logic running in the DB may reduce Database CPU utilisation and hence save support costs for the DB Portability is key! [1]

This page should contain sometime in the future information about MySQL new features.

Content

• Result set with temporary sequence
• Determination of optimal length of prefixed indexes
• Using MySQL keywords in table or columm names
• Missing Primary Key Index

Result set with temporary sequence

Sometimes you would like to have a result set with something like a rownum. You can do this at least in the following two ways:

Content

• max_open_files warning during mysqld startup
• Troubles after NON recommended upgrade path
• Com_* counters not updated in SHOW STATUS
• ERROR 1300 (HY000): Invalid utf8 character string
• MySQL crashes during import
• MySQL workbench gives an openGL error

Often asked but informations are spread around: The limitations of MySQL.

If you know any other MySQL limitations, please let us know.

Because I do a lot of Performance Tuning gigs I get often in contact with these status variables. In the beginning I had a problem to understand them and now I have a problem to memorize the relation of the name and the meaning. Therefore I wrote this little summary:

Prepare the example

To show you the effect I have worked out a little example:

For a pure database system tuning please go first here: Database Health Check for MySQL.

See also MySQL Performance Tuning Primer.

This document is still under construction! Thus it is still a little chaotic. Please feel free to mail recommendations, suggestions, etc. to us.

Basic solutions (CLI)

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

• top (man)
• vmstat (man)
• iostat (man), mpstat (man), in package sysstat

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:

Content

• 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

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...

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

General things about benchmarking

• RAID, bm and bonnie Benchmarks
• xCAT HPC Benchmark HOWTO (WIP)
• Speeding up Linux Using hdparm

General benchmarks

• bm

Disk benchmarking

• Filesystem Benchmark: IOzone
• Bonnie
• Harddisk-Benchmark: Bonnie++
• [http://www.