Featured
MySQL 5.7
Support
Compare Percona to Leading Database Solutions
Percona Products
Percona Services
Use Cases
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 12, 2011
Percona Live Keynote Speaker: Mark Callaghan
Mark Callaghan has graciously accepted to be the closing keynote speaker for Percona Live: San Francisco! Mark is best known [...]
January 11, 2011
When does Innodb Start Transaction ?
When does Innodb Start Transaction ? The answer looks obvious – when you issue “BEGIN” command. This is however wrong [...]
January 11, 2011
Bad weather strikes Meetup in Charlotte,NC
Due to bad weather my flight to Charlotte was canceled today and the only time they could rebook me was [...]
January 11, 2011
Percona Server 5.1.54-12.5
Percona Server version 5.1.54-12.5 is now available for download. It is now the current stable release version. Functionality Added or [...]
January 10, 2011
How to Identify Bad Queries in MySQL
Finding bad queries is a big part of optimization. A scientific optimization process can be simplified to “can anything be [...]
January 10, 2011
Percona Server Fast-Restart White Paper Posted
I’ve posted a new white paper about the implementation and benefits of Percona Server’s fast-restart capabilities. Briefly, after shutting down [...]
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, [...]
January 7, 2011
Upcoming Webinar on HA solutions for MySQL
On January 31st, I’ll be giving a webinar whose title is “Choosing a High-Availability Solution”. Although the subject is not [...]
January 7, 2011
High Rate insertion with MySQL and Innodb
I again work with the system which needs high insertion rate for data which generally fits in memory. Last time [...]
January 5, 2011
Announcing Percona Live: San Francisco February 16th
Today we’re announcing Percona Live – a one day event to be held at the Bently Reserve on February 16th [...]
January 3, 2011
Speaking on MySQL/PHP Meetup in Charlotte, NC
I’m speaking at MySQL/PHP Meetup at Charlotte,NC next week with topic being Scaling MySQL Applications. We will have a presentation [...]
January 3, 2011
Effect from innodb log block size 4096 bytes
In my post MySQL 5.5.8 and Percona Server: being adaptive I mentioned that I used innodb-log-block-size=4096 in Percona Server to [...]
January 3, 2011
MySQL 5.5.8 – in search of stability
A couple of days ago, Dimitri published a blog post, Analyzing Percona’s TPCC-like Workload on MySQL 5.5, which was a [...]
December 30, 2010
Percona Welcomes Sasha Pachev
Percona is pleased to officially (and belatedly) welcome Sasha Pachev to our team of consultants. Before joining Percona, Sasha worked [...]
December 29, 2010
Percona Server 5.1.53-12.4
Percona Server version 5.1.53-12.4 is now available for download. It is now the current stable release version. Functionality Added or [...]
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 21, 2010
MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
This is to follow up on my previous post and show the results for MySQL 5.5.8 and Percona Server on [...]