Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
June 22, 2012
DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
Suppose you have turned on innodb_file_per_table (which means that each table has its own tablespace), and you have to drop [...]
June 21, 2012
On Character Sets and Disappearing Tables
The MySQL manual tells us that regardless of whether or not we use “SET FOREIGN_KEY_CHECKS=0” before making schema changes, InnoDB [...]
June 21, 2012
pt-online-schema-change and default values
When I’m doing conventional ALTER TABLE in MySQL I can ignore default value and it will be assigned based on [...]
June 20, 2012
Find and remove duplicate indexes
Having duplicate keys in our schemas can hurt the performance of our database: They make the optimizer phase slower because [...]
June 19, 2012
Building Indexes by Sorting In Innodb (AKA Fast Index Creation)
Innodb can indexes built by sort since Innodb Plugin for MySQL 5.1 which is a lot faster than building them [...]
June 15, 2012
Using innodb_sys_tables and innodb_sys_indexes
I was playing with Percona Server today and found fast_index_creation does not work quite exactly like described in the manual. [...]
June 2, 2012
How expensive is USER_STATISTICS?
One of our customers asked me whether it’s safe to enable the so-called USER_STATISTICS features of Percona Server in a [...]
May 31, 2012
A case for MariaDB’s Hash Joins
MariaDB 5.3/5.5 has introduced a new join type “Hash Joins” which is an implementation of a Classic Block-based Hash Join [...]
May 30, 2012
Data Compression in InnoDB for Text and Blob Fields
Have you wanted to compress only certain types of columns in a table while leaving other columns uncompressed? While working [...]
May 27, 2012
Secure passwords being insecure
If you follow the general advices to create secure password the following ones seem to be secure, right? s11P$||!sh&2 pr0&!!ke0 [...]
May 24, 2012
Webinar – Migrating to Percona XtraDB Cluster
Whenever I learn about a new technology, I typically want to know the major administrative touch points more than I want [...]
May 24, 2012
Binary log file size matters (sometimes)
I used to think one should never look at max_binlog_size, however last year I had a couple of interesting cases [...]
May 16, 2012
Benchmarking single-row insert performance on Amazon EC2
I have been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that [...]
May 8, 2012
Zero-downtime schema changes webinar recording
The recording and slides for my webinar on zero-downtime schema changes with MySQL are available now. Don’t miss Vadim’s webinar [...]
May 6, 2012
Load management Techniques for MySQL
One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain [...]
May 3, 2012
Zero-Downtime Schema Changes In MySQL
The recording of yesterday’s webinar, as well as a PDF of my slide deck, is now available. You can watch [...]
April 20, 2012
Joining many tables in MySQL – optimizer_search_depth
Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by [...]
April 5, 2012
Percona Toolkit 2.1 with New Online Schema Change Tool
I’m proud to announce the GA release of version 2.1 of Percona Toolkit. Percona Toolkit is the essential suite of [...]
April 4, 2012
Join Optimizations in MySQL 5.6 and MariaDB 5.5
This is the third blog post in the series of blog posts leading up to the talk comparing the optimizer [...]
April 2, 2012
Diamond Keynote Panel, BOFs, Lightning Talks, and McAfee and AOL Sponsorships
I’m excited by all of the recent developments surrounding the Percona Live MySQL Conference and Expo! Our own Baron Schwartz [...]