Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 [...]
March 26, 2012
How to diagnose errors in the MySQL error log
I frequently see questions about how to understand the nature of errors in MySQL’s error log. Now, there is a [...]
March 23, 2012
How MySQL FLUSH TABLES WITH READ LOCK works w/ Innodb Tables
Many backup tools including Percona Xtrabackup, MyLVMBackup, and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read-only. [...]
March 23, 2012
Best kept MySQLDump Secret
Many people use mysqldump –single-transaction to get consistent backup for their Innodb tables without making database read only. In most [...]
March 22, 2012
BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
The Percona Live MySQL Conference & Expo is going to be awesome! Great speakers, an A-list of sponsors, countless opportunities [...]
March 21, 2012
Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
This is the second blog post in the series of blog posts leading up to the talk comparing the optimizer [...]
March 13, 2012
Webinar “How to Turbocharge Your MySQL Performance Using Flash Storage”
Next Wednesday, March-21, 11:00am Pacific Time, Baron and me will be co-presenting with Virident webinar: “How to Turbocharge Your MySQL [...]
March 12, 2012
Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB [...]
February 23, 2012
Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
LVM snapshots is one powerful way of taking a consistent backup of your MySQL databases – but did you know [...]