Monthly Archives - September 2010

Diagnosing and fixing MySQL Performance Problems in Russian in Moscow, Russia

During my visit to Moscow, Russia next month I’m going to give a full day training/tutorial presentation on Diagnosing and Fixing MySQL Performance Problems . This even will be based on updated and expanded tutorial from MySQL Conference & Expo which was so popular it was sold out earlier this year. […]

Read more

Percona Server 5.1.50-rel11.4

Dear Community,
Percona Server version 5.1.50-rel11.4 is now available for download.
The changes in this release include:
New features
The primary purpose of this release is to update to the latest version of MySQL 5.1.

Percona Server 5.1.50-rel11.4 is now based on MySQL 5.1.50.

Fixed bugs

innodb_use_sys_stats_table – The

Shell

SYS_STATS

1

SYS_STATS

table is now used only for non-temporary tables.

The binary packages are […]

Read more

Instrumentation and the cost of Foreign Keys

I occasionally get in to light arguments healthy discussions with students about whether or not to use Foreign Key constraints on InnoDB tables.  My standard response has always been: “it depends on how much of a tradeoff you are willing to make for performance. In some situations the cost can be considerable”.
.. […]

Read more