Buy Percona ServicesBuy Now!

Is MySQL’s innodb_file_per_table slowing you down?

 | February 24, 2015 |  Posted In: Benchmarks, InnoDB, MySQL, Percona MySQL Consulting, Percona Server for MySQL

MySQL’s innodb_file_per_table is a wonderful thing – most of the time. Having every table use its own .ibd file allows you to easily reclaim space when dropping or truncating tables. But in some use cases, it may cause significant performance issues. Many of you in the audience are responsible for running automated tests on your […]

Read More

How well does your table fit in the InnoDB buffer pool in MySQL 5.6+?

 | December 29, 2014 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona Server for MySQL

Some time ago, Peter Zaitsev posted a blog titled “How well does your table fits in innodb buffer pool?” He used some special INFORMATION_SCHEMA tables developed for Percona Server 5.1 to report how much of each InnoDB table and index resides in your buffer pool. As Peter pointed out, you can use this view into […]

Read More

InnoDB’s multi-versioning handling can be Achilles’ heel

 | December 17, 2014 |  Posted In: InnoDB, Insight for DBAs, MySQL

I believe InnoDB storage engine architecture is great for a lot of online workloads, however, there are no silver bullets in technology and all design choices have their trade offs. In this blog post I’m going to talk about one important InnoDB limitation that you should consider. InnoDB is a multiversion concurrency control (MVCC) storage […]

Read More

MySQL’s INNODB_METRICS table: How much is the overhead?

 | November 18, 2014 |  Posted In: Benchmarks, InnoDB, MySQL

Starting with MySQL 5.6 there is an INNODB_METRICS table available in INFORMATION_SCHEMA which contains some additional information than provided in the SHOW GLOBAL STATUS output – yet might be more lightweight than PERFORMANCE_SCHEMA. Too bad INNODB_METRICS was designed during the Oracle-Sun split under MySQL leadership and so it covers only InnoDB counters. I think this […]

Read More

Optimizing MySQL for Zabbix

 | November 14, 2014 |  Posted In: High-availability, InnoDB, MySQL

This blog post was inspired by my visit at the annual Zabbix Conference in Riga, Latvia this year, where I gave a couple of talks on MySQL and beyond. It was a two day single-track event with some 200 participants, a number of interesting talks on Zabbix (and related technologies) and really well-organized evening activities. […]

Read More

How to deal with MySQL deadlocks

 | October 28, 2014 |  Posted In: InnoDB, Insight for DBAs, MySQL, Percona Server for MySQL

A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable. InnoDB automatically detects transaction deadlocks, rollbacks a transaction immediately and returns an error. It uses a metric to pick the […]

Read More