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

Scenarios where TokuDB’s Loader is Used

TokuDB’s loader uses the available multicore computing resources of the machine to presort and insert the data. In the last couple of posts (here and here), Rich and Dave presented performance results of TokuDB’s loader. Comparing load times with TokuDB 2.1.0, Rich found a 2.1x speedup on a 2 core machine, and a 4.2x […]

Read more

Percona Server 5.1.49-rel12.0

Dear Community,
Starting with this release, we introduce a new release model for Percona Server. From now on, we will have both Stable and Release Candidate releases. Release Candidates will introduce new features not yet available in Stable releases.
Along with new features, our new 5.1.49-12.0 RC contains a couple of patches from the Facebook-MySQL tree […]

Read more

Percona Server 5.1.49-rel11.3

Dear Community,
Percona Server version 5.1.49-rel11.3 is now available for download.
The changes in this release include:
New features

Percona Server 5.1.49-rel11.3 is based on MySQL 5.1.49.

A new variable was introduced: innodb_use_sys_stats_table. If ON, the table’s statistics are stored statically in the internal table SYS_STATS. The table is populated with the ANALYZE TABLE command.

A new session variable was […]

Read more

First Sphinx Conference is Announced

The First ever Sphinx Users Conference is announced to take place in Moscow, Russia on October 24th,
which is the Sunday before Highload.ru conference, so if you’re attending that you may just drop by to this event too.
this is going to be free technically focused event, close in spirit to Percona Performance Conference, we organized […]

Read more