October 21, 2014

FOSDEM 2013: MySQL And Friends Community Dinner

Just like previous years, the ‘MySQL And Friends’ community is gathering to have a dinner on the Saturdaynight of FOSDEM. This time it is on February 2nd, 2013. This year, it will not be an Italian restaurant, but more a Belgian style restaurant, about 10 minutes walk from the FOSDEM event. Mirabelle: http://www.mirabelle.be/index.php?lang=en Chaussée de Boondael, […]

Sphinx search performance optimization: multi-threaded search

Queries in MySQL, Sphinx and many other database or search engines are typically single-threaded. That is when you issue a single query on your brand new r910 with 32 CPU cores and 16 disks, the maximum that is going to be used to process this query at any given point is 1 CPU core and […]

Announcing Percona Server 5.1.66-14.2

Percona is glad to announce the release of Percona Server 5.1.66-14.2 on January 15th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug fixes in it, Percona Server 5.1.66-14.2 is now the current stable release in the 5.1 series. All of Percona‘s software is open-source and free, all the details of the release can […]

Sphinx search performance optimization: attribute-based filters

One of the most common causes of a poor Sphinx search performance I find our customers face is misuse of search filters. In this article I will cover how Sphinx attributes (which are normally used for filtering) work, when they are a good idea to use and what to do when they are not, but […]

DotOrg Pavilion and MySQL Community Awards at Percona Live MySQL Conference and Expo 2013

Percona Live MySQL Conference and Expo 2013 – the largest MySQL Conference event of the year is getting close and we’re now announcing two community activities which are going to happen at this event. Call of DotOrg Pavilion exhibitors is open – DotOrg pavilion is a free expo hall space for non commercial projects relevant […]

Reminder: Speaking at MySQL Meetups in Charlotte and Atlanta today and tomorrow.

In a few hours I’m leaving for my “SouthEast Meetup Tour” first going to Charlotte where I’m speaking Today, Jan 14, about MySQL Indexing: Best practices on local MySQL Meetup and then going to Atlanta to give the same talk on Atlanta MySQL Meetup Jan 15th. If you’re in the area please come by, I’ll […]

CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we’re doing in Percona Server 5.5.29)

In preparing Percona Server 5.5.29 (not yet released, but soon), I filed MySQL bug 68045 (is marked private as it’s a security bug). This bug is in relation to the Oracle fix for CVE-2012-4414 and a problem I found with it. The MariaDB fix (which we incorporated into Percona Server 5.5.28-29.3) is not affected. When the […]

Join us for our first Percona MySQL University event in Raleigh, N.C. Jan 29

At Percona we focus on education a lot, which we believe is critical for us to be successful with our mission of making businesses successful with their use of MySQL. The MySQL Performance Blog, our first effort in this space, by now contains over 1,000 technical articles. We have spoken on countless conferences and Meetups […]

Profiling MySQL Memory Usage With Valgrind Massif

There are times where you need to know exactly how much memory the mysqld server (or any other program) is using, where (i.e. for what function) it was allocated, how it got there (a backtrace, please!), and at what point in time the allocation happened. For example; you may have noticed a sharp memory increase […]

Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6

Percona Toolkit 2.1.8 was released today and the new version comes with some pretty cool news: Beta support for MySQL 5.6 (which as you might know is also in beta). In addition to various bug fixes, Percona Toolkit 2.1.8 also offers beta support for Percona XtraDB Cluster (PXC). Version 2.1.8 continues the trend of solid […]