Monthly Archives - July 2013

InnoDB Full-text Search in MySQL 5.6: Part 3, Performance

This is part 3 of a 3 part series covering the new InnoDB full-text search features in MySQL 5.6. To catch up on the previous parts, see part 1 or part 2
Some of you may recall a few months ago that I promised a third part in my InnoDB full-text search (FTS) series, in […]

Read more

Let’s talk about Percona Server 5.6: Enterprise Grade MySQL (webinar)

The new Percona Server 5.6 is the most manageable, highest performance, and most scalable version of MySQL available. Percona Server 5.6 is the best open source MySQL choice for enterprise-grade applications because it combines new features with the best features of Percona Server 5.5 and MySQL 5.6 to provide unparalleled performance.
Join me tomorrow as […]

Read more

Why it’s beneficial to attend MySQL conferences

Peter Zaitsev speaks at the Percona Live MySQL Conference and Expo in Santa Clara, Calif. in April 2013.
In the MySQL ecosystem, there is some sort of conference or another all year long. But why are they important?
To answer this, we can split the audience into 3 groups:
– MySQL Professionnals
– MySQL Community Members
– MySQL (Future?) […]

Read more

Your troubles are over, pt-heartbeat 2.1

Poor pt-heartbeat 2.1: it was perfectly fine through Percona Toolkit 2.1.7, but it’s had a rough life since. Its troubles are finally over as of Percona Toolkit 2.1.10. At a conference recently, a user joked to me that “Percona Toolkit is awesome, but you really broke pt-heartbeat.” It’s true, and if you haven’t heard […]

Read more

Checking B+tree leaf nodes list consistency in InnoDB

If we have InnoDB pages there are two ways to learn how many records they contain:

PAGE_N_RECS field in the page header
Count records while walking over the list of records from infimum to supremum

In some previous revision of the recovery tool a short summary was added to a dump which is produced by the constraints_parser.
But […]

Read more