September 30, 2014

Userstats patches with information schema support

Recently, we added information schema support to Google’s userstats patch. There are three information schema tables added: user_statistics, table_statistics, index_statistics. One can now use select * from information_schema.user_statistics along with show user_statistics. Links: Patch for 5.0.62 Patch for 5.1.26

Percona builds with patches

As there were many requests for Debian binary packages in our announcement of Percona builds with custom patchsets, we decided to play with it and built .deb, which you can find there: http://www.percona.com/blog/mysql/debian/ You can also add the following repositories into your sources.list: deb http://percona.com/blog/mysql/debian/5.0/ binary-amd64/ deb http://percona.com/blog/mysql/debian/5.0/ source/ deb http://percona.com/blog/mysql/debian/5.1/ binary-amd64/ deb http://percona.com/blog/mysql/debian/5.1/ source/ […]

Percona builds with Percona patchsets

Percona has a strong team of MySQL developers and consultants on board, so we decided to prepare builds with our patches and third-party patches which we think are very useful. We actually use these internally and for our customers. Current releases include: microslow patch (enables microsecond resolution in slow logs) execution plan (show info about […]

Updated msl (microslow) patch, installation walk-through!

For a couple of months there have been no updates to our msl patch, however recently I managed some time to change this. The functionality was extended a little bit and what’s even more important the patch is available for all the recent MySQL releases. To remind anyone who has not yet come across this […]

The new cool MySQL patch has landed! Check your queries performance!

Microslow patch is used by many DBAs and developers to accurately time their queries and to catch those which run less than a second as they can also be a performance killer for a busy application. Recently I have started the development of an updated version of the patch. The basic idea is the same […]

Microslow patch for 5.1.20

Microslow patch has been there for some time, but only for earlier MySQL editions such as 4.1 and 5.0. Now it’s also available for the latest 5.1. Because MySQL went through a lot of internal changes, the patch had to be written from scratch. It introduces some minor change in existing functionality and also adds […]

Microslow patch for 5.0.37

Just short message that patch enables microsecond resolution in slow-log (see more http://www.percona.com/blog/2006/09/06/slow-query-log-analyzes-tools/) for 5.0.37 is available here: www.percona.com/blog/files/patches/patch.slow-micro.5.0.37.diff The patch for 5.0.41 : www.percona.com/blog/files/patches/patch.slow-micro.5.0.41.diff

Backport of micro-time patch to mysql 4.1

Taking into account 4.1 tree is still popular and is used on many production servers we decided to make backport of patch to slow-log queries. The patch allows to specify time of slow queries in microseconds and is very helpful in a fight with problematic queries. 4.1 Patch is available here (The original patch was […]

Galera data on Percona Cloud Tools (and other MySQL monitoring tools)

I was talking with a Percona Support customer earlier this week who was looking for Galera data on Percona Cloud Tools. (Percona Cloud Tools, now in free beta, is a hosted service providing access to query performance insights for all MySQL uses.) The customer mentioned they were already keeping track of some Galera stats on Cacti, and […]

Percona Server 5.6.20-68.0 is now available

Percona is glad to announce the release of Percona Server 5.6.20-68.0 on August 29, 2014. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.20, including all the bug fixes in it, Percona Server 5.6.20-68.0 is the current GA release in the Percona Server 5.6 series. All of Percona’s […]