MySQL

Category to track posts in PlanetMySQL

Percona at WebConf Riga 2010

My colleague Aleksandr Kuzminsky will be speaking at WebConf Riga 2010 next month on XtraBackup: Hot Backups and More and Recovery of Lost or Corrupted InnoDB Tables.
WebConf is the first big conference of its kind in the Baltic states (Estonia, Latvia, Lithuania) and we are very happy to be participating.
In addition to Aleksandr’s talks, […]

Read more

Sharing an auto_increment value across multiple MySQL tables

The title is SEO bait – you can’t do it. We’ve seen a few recurring patterns trying to achieve similar – and I thought I would share with you my favorite two:
Option #1: Use a table to insert into, and grab the insert_id:

Shell

CREATE TABLE option1 (id int not null primary key auto_increment) engine=innodb;

# […]

Read more

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