Articles by PETER ZAITSEV

Training in London next week

I’m going to deliver MySQL Training next week (May 21-24) in London. This is a rare opportunity as I do not personally deliver a lot of Training, especially outside of US. There are still some places left if you want to sign up. You will also get a signed...

Load management Techniques for MySQL

By Peter Zaitsev

One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. Investigating them we find out what the cause is some batch jobs, reports and other non response time critical activities are overloading...

Joining many tables in MySQL – optimizer_search_depth

By Peter Zaitsev

Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by joining all tables connected with foreign keys just in case) which would take 5 seconds even though in the read less than 1000 rows and doing...

Community events around Percona Live MySQL Conference and Expo 2012

By Peter Zaitsev

We’re very pleased with community support for Percona Live MySQL Conference and Expo. We’ve got wonderful speakers providing content of phenomenal session lineup for the conference this year. We have community helping by spreading the world, about...

How FLUSH TABLES WITH READ LOCK works with Innodb Tables

By Peter Zaitsev

Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period for which server has to be made read only is very short, just few seconds, yet the impact of FLUSH...

Speaking at POSSCON

By Peter Zaitsev

I’m speaking at POSSCON in Columbia,SC next week (March 28). My talk will be about Open Source software Percona Produces – Percona Server, Percona Xtrabackup, Percona Toolkit, Percona XtraDB Cluster. If you want to get a birds eye view about Open...

Best kept MySQLDump Secret

By Peter Zaitsev

Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most cases it works, but did you know there are some cases when you can get table entirely missing from the backup if...

Troubleshooting MySQL Memory Usage

By Peter Zaitsev

One of the most painful troubleshooting tasks with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global buffers, such as innodb_buffer_size, key_buffer_size etc, you have reasonable...

MySQL Meetups in North Carolina this week

By Peter Zaitsev

A quick reminder. I’m speaking on two MySQL meetups in North Carolina this week. Tuesday,Feb 21 on Raleigh MySQL/PHP Meetup and when Wednesday, Feb 22 on Charlotte Queen City PHP Note the last meetup date has changed, it was originally planned for February...

Can we improve MySQL variable handling ?

By Peter Zaitsev

MySQL Settings (also known as Server Variables) have interesting property. When you set variable in running server this change is not persisted in any way and server will be back to old value upon restart. MySQL also does not have option to re-read config file...