May 22, 2013

Webinar: MySQL 5.6 Performance Schema

May 13, 2013 By 5 Comments

This Wednesday, May 15 at 10 a.m. Pacific, I’ll be leading  a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In this Webinar I will offer an overview of Performance Schema, focusing on new features that have been added in MySQL 5.6, go over the configuration and spend most time showing [...]

Filed Under: MySQL, MySQL Webinars Tagged With: , ,

MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released

March 20, 2013 By 2 Comments

Percona is glad to announce the release of Percona XtraBackup 2.0.6 for MySQL 5.6 on March 20, 2013. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.0 series. New Features: XtraBackup 2.0.6 has implemented basic support for MySQL 5.6, Percona Server 5.6 [...]

Filed Under: MySQL Tagged With: , , ,

InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

This is part 2 in a 3 part series. In part 1, we took a quick look at some initial configuration of InnoDB full-text search and discovered a little bit of quirky behavior; here, we are going to run some queries and compare the result sets. Our hope is that the one of two things [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Announcing Percona XtraDB Cluster 5.5.29-23.7.2

February 13, 2013 By Leave a Comment

Percona is glad to announce the release of Percona XtraDB Cluster 5.5.29-23.7.2 on February 13th, 2013. Binaries are available from downloads area or from our software repositories. Bugs fixed: DML operations on temporary tables would try to append the key for provider library, which could cause a memory leak. Bug fixed for MyISAM temporary tables, [...]

Filed Under: MySQL, Percona Software, XtraDB Cluster Tagged With: ,

Announcing Percona Server 5.1.66-14.2

January 15, 2013 By Leave a Comment

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 [...]

Filed Under: Events and Announcements, MySQL, Percona Software Tagged With:

MySQL Wish for 2013 – Better Memory Accounting

December 31, 2012 By 6 Comments

With Performance Schema improvements in MySQL 5.6 I think we’re in the good shape with insight on what is causing performance bottlenecks as well as where CPU resources are spent. (Performance Schema does not accounts CPU usage directly but it is something which can be relatively easily derived from wait and stage information). Where we’re [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

Announcing Percona Server 5.6.6-60.1 Alpha

September 13, 2012 By 2 Comments

Percona is glad to announce the ALPHA release of Percona Server 5.6.6-60.1 on September 14, 2012 (Downloads are available here and from the EXPERIMENTAL Percona Software Repositories, although currently only for RHEL/CentOS as we are working on ensuring compatibility with our Debian/Ubuntu packages). Based on MySQL 5.6.6, including all the bug fixes in it, Percona Server 5.6.6-60.1 is the second ALPHA release in [...]

Filed Under: Percona Software

How to obtain the “LES” (Last Executed Statement) from an Optimized Core Dump?

September 9, 2012 By 9 Comments

Ever ran into a situation where you saw “some important variable you really needed to know about=<optimized out>” while debugging?

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Announcing Percona Server 5.1.65-14.0

September 4, 2012 By Leave a Comment

Percona is glad to announce the release of Percona Server 5.1.65-14.0 on September 4th, 2012 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.65, including all the bug fixes in it, Percona Server 5.1.65-14.0 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 [...]

Filed Under: MySQL, Percona Software

MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By 4 Comments

I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) We had lots of questions. I did not have time to answer some and others are better answered in writing anyway. Q: One developer on our team wants to replace longish (25-30) indexed varchars with [...]

Filed Under: Insight for DBAs, MySQL
« Older Posts