Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
December 25, 2010
Spreading .ibd files across multiple disks; the optimization that isn’t
Inspired by Baron’s earlier post, here is one I hear quite frequently – “If you enable innodb_file_per_table, each table is [...]
December 22, 2010
How long is recovery from 8G innodb_log_file
In my previous posts I highlighted that one of improvements in Percona Server is support of innodb_log_file_size > 4G. This [...]
December 20, 2010
Impact of the number of idle connections in MySQL (version 2)
Last Friday I published results of DBT2 performance while varying the number of idle connections here, but I had compiled [...]
December 17, 2010
Impact of the number of idle connections in MySQL
Be careful with my findings, I appear to have compile in debug mode, I am redoing the benchmarks. Updated version [...]
December 11, 2010
MySQL Partitioning for Performance Optimization
I wanted for a while to write about using MySQL Partitioning for Performance Optimization and I just got a relevant [...]
December 9, 2010
How well does your table fits in innodb buffer pool ?
Understanding how well your tables and indexes fit to buffer pool are often very helpful to understand why some queries [...]
December 9, 2010
Using MySQL OPTIMIZE tables for InnoDB? Stop!
Innodb/XtraDB tables do benefit from being reorganized often. You can get data physically laid out in primary key order as [...]
December 8, 2010
Getting History of Table Sizes in MySQL
One data point which is very helpful but surprisingly few people have is the history of the table sizes. Projection [...]
December 7, 2010
Stripped MySQL builds, the optimization that isn’t
I usually tell people to use official MySQL builds from MySQL, or from their operating system distribution if they don’t [...]
November 19, 2010
Is there benefit from having more memory ?
My post back in April, https://www.percona.com/blog/2010/04/08/fast-ssd-or-more-memory/, caused quite interest, especially on topic SSD vs Memory. That time I used fairy [...]
November 11, 2010
Advanced index analysis with mk-index-usage
The new release of Maatkit has a useful feature in mk-index-usage to help you determine how indexes are used in [...]
November 9, 2010
Lost innodb tables, xfs and binary grep
Before I start a story about the data recovery case I worked on yesterday, here’s a quick tip – having [...]
November 8, 2010
Implementing Parallel Replication in MySQL
Based on discussions with several clients, we are strongly considering implementing a limited form of parallel replication. Single-threaded replication is [...]
November 8, 2010
An argument for not using mysqldump
I have a 5G mysqldump which takes 30 minutes to restore from backup. That means that when the database reaches [...]
October 22, 2010
High availability for MySQL on Amazon EC2 – Part 5 – The instance monitoring script
This post is the fifth of a series that started here. From the previous posts of this series, we now [...]
October 15, 2010
Replication of MEMORY (HEAP) Tables
Some Applications need to store some transient data which is frequently regenerated and MEMORY table look like a very good [...]
October 8, 2010
The story of one MySQL Upgrade
I recently worked on upgrading MySQL from one of very early MySQL 5.0 versions to Percona Server 5.1. This was [...]
September 2, 2010
How long Innodb Shutdown may take
How long it may take MySQL with Innodb tables to shut down ? It can be quite a while. In [...]
August 23, 2010
InnoDB memory allocation, ulimit, and OpenSUSE
I recently encountered an interesting case. A customer reported that mysqld crashed on start on OpenSUSE 11.2 kernel 2.6.31.12-0.2-desktop x86_64 [...]
August 19, 2010
High availability for MySQL on Amazon EC2 – Part 4 – The instance restart script
This post is the fourth of a series that started here. From the previous of this series, we now have [...]