EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Toolkit 2.1.10 is now available

 | July 18, 2013 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit

Percona is glad to announce the release of Percona Toolkit 2.1.10 on July 18th, 2013 (Downloads are available here). Bugs Fixed: Unfortunately, the relatively new –utc option for pt-heart was still broken because “MySQL interprets date as a value in the current time zone and converts it to an internal value in UTC.” Now the tool works […]

Read More

MySQL Webinar: Advanced Query Tuning

 | July 17, 2013 |  Posted In: MySQL, MySQL Webinars

On July 24 at 10 a.m. PDT, I will be delivering a Webinar on Advanced MySQL Query Tuning. I will focus on optimizing the common slow queries with group by and order by. Those queries usually create temporary tables and perform a “filesort” operation. I will show how to optimize those queries so that they […]

Read More

Percona Toolkit 2.2.4 is now available

 | July 17, 2013 |  Posted In: Events and Announcements, MySQL, Percona Software, Percona Toolkit

Percona is glad to announce the release of Percona Toolkit 2.2.4 on July 17th, 2013 (Downloads are available here and from the Percona Software Repositories). New Features: pt-query-digest –output json includes query examples as of v2.2.3. Some people might not want this because it exposes real data. New option, –output json-anon, has been implemented. This option will provide the […]

Read More

Recovering temporal types in MySQL 5.6: TIME, TIMESTAMP and DATETIME

 | July 16, 2013 |  Posted In: Insight for DBAs, MySQL

MySQL 5.6 introduces a new feature – microseconds resolution in some temporal types. As of 5.6.4 TIME, TIMESTAMP and DATETIME can have a fractional part. To create a field with subseconds you can specify precision in brackets: TIME(3), DATETIME(6) etc. Obviously, the new feature requires the format change. All three types may now have a […]

Read More

An Ubuntu PPA of daily builds of Percona XtraBackup

 | July 16, 2013 |  Posted In: MySQL, Percona Software, Percona XtraBackup

Run Ubuntu and want to try new features of Percona XtraBackup? Well, now you can. We have a Personal Package Archive (PPA) percona-daily/percona-xtrabackup. Every time code is pushed to our main source code repository, the PPA is updated. We are currently building for Ubuntu lucid (10.04LTS), Precise (12.04), Quantal (12.10) and Raring (13.04). To add […]

Read More

Why Unique Indexes are Bad

 | July 15, 2013 |  Posted In: Tokutek, TokuView

Before creating a unique index in TokuMX or TokuDB, ask yourself, “does my application really depend on the database enforcing uniqueness of this key?” If the answer is ANYTHING other than yes, do not declare the index to be unique. Why? Because unique indexes may kill your write performance. In this post, I’ll explain why. […]

Read More

Crash-resistant replication: How to avoid MySQL replication errors

 | July 15, 2013 |  Posted In: MySQL, Percona Server, Percona Software

Percona Server’s “crash-resistant replication” feature is useful in versions 5.1 through 5.5. However, in Percona Server 5.6 it’s replaced with Oracle MySQL 5.6’s “crash safe replication” feature, which has it’s own implementation (you can read more about it here). A MySQL slave normally stores its position in files master.info and relay-log.info which are updated by […]

Read More

innotop 1.9.1 released

 | July 12, 2013 |  Posted In: MySQL

Lefred and I spent a bit of time making innotop 1.9.1. We’ve released a new version mainly to include MySQL 5.6 support as well as including some bugs fixed by Baron Schwartz and Frédéric Descamps. You can download the .tar.gz and rpm’s (new!) at http://code.google.com/p/innotop/downloads/list Bugs fixed: Issue 71: DBI prints to STDERR instead of just throwing an […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.