Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
August 28, 2012
Hidden columns of query_review_history table
You can use pt-query-digest to process a MySQL slow query log and store historical values for review trend analysis into [...]
August 16, 2012
MySQL Indexing Best Practices: Webinar Questions Followup
I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) [...]
August 10, 2012
Recovery deleted ibdata1
Recently I had a case when a customer deleted the InnoDB main table space – ibdata1 – and redo logs [...]
July 31, 2012
Innodb Table Locks
Innodb uses row level locks right ? So if you see locked tables reported in SHOW ENGINE INNODB STATUS you [...]
July 1, 2012
Why ALTER TABLE shows as two transactions in SHOW ENGINE INNODB STATUS
When executing an ALTER TABLE, InnoDB (and XtraDB) will create two InnoDB transactions: One transaction is created when the table [...]
June 30, 2012
Find unused indexes
I wrote one week ago about how to find duplicate indexes. This time we’ll learn how to find unused indexes [...]
June 28, 2012
MySQL Upgrade Webinar Questions Followup
I did a Webinar about MySQL Upgrade – Best Practices Yesterday and there were some questions we could not answer [...]
June 27, 2012
ALTER TABLE: Creating Index by Sort and Buffer Pool Size
Today I was looking at the ALTER TABLE performance with fast index creation and without it with different buffer pool [...]
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 [...]