Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
February 7, 2011
White Paper: “Scaling MySQL Deployments Efficiently” from Percona and Virident
Percona was working closely with Virident on evaluating tachIOn as solution for MySQL, and as result you can find whitepaper [...]
February 7, 2011
White Paper: Preventing MySQL Emergencies
About a year ago, I started a study of emergency incidents that our customers filed with us. What I found [...]
February 4, 2011
Fixing MySQL with a comment in the config file
A customer called with an emergency issue: A server that normally runs many MySQL instances wouldn’t start them up. Not [...]
February 3, 2011
Performance problem with Innodb and DROP TABLE
I’ve been working with an application which does a lot of CREATE and DROP table for Innodb tables and we’ve [...]
February 3, 2011
How InnoDB handles REDO logging
Xaprb (Baron) recently blogged about how InnoDB performs a checkpoint , I thought it might be useful to explain another [...]
January 31, 2011
What is exec_time in binary logs?
If you’ve used MySQL’s mysqlbinlog tool, you’ve probably seen something like the following in the output: “exec_time=0” What is the [...]
January 12, 2011
Innodb undo segment size and transaction isolation
You might know if you have long running transactions you’re risking having a lot of “garbage” accumulated in undo segment [...]
January 12, 2011
Conflict Avoidance with auto_increment_increment and auto_increment_offset
A lot of people are running MySQL Master-Master replication pairs in Active-Passive mode for purpose of high availabilities using MMM [...]
January 8, 2011
Ultimate MySQL variable and status reference list
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, [...]
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 [...]