May 20, 2013

Announcing Percona Server for MySQL version 5.1.67-14.4

March 8, 2013 By Leave a Comment

Percona is glad to announce the release of Percona Server for MySQL version 5.1.67-14.4 on March 8, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.67, including all the bug fixes in it, Percona Server 5.1.67-14.4 is now the current stable release in the 5.1 series. All of Percona‘s software is open-source and free, all the details [...]

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

Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries

March 6, 2013 By 2 Comments

This post is followup to Peter’s recent post, “Investigating MySQL Replication Latency in Percona XtraDB Cluster,” in which a question was raised as to whether we can measure latency to all nodes at the same time. It is an interesting question: If we have N nodes, can we send queries to nodes to be executed in [...]

Filed Under: MySQL, XtraDB Cluster 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 Server for MySQL version 5.5.29-30.0

February 26, 2013 By Leave a Comment

Percona is glad to announce the release of Percona Server for MySQL version 5.5.29-30.0 on February 26th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.29, including all the bug fixes in it, Percona Server 5.5.29-30.0 is now the current stable release in the 5.5 series. All of Percona‘s software is open-source and free, all the details [...]

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

MySQL 5.5 and MySQL 5.6 default variable values differences

February 21, 2013 By 8 Comments

As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default variable values. To do that I’ve loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query:

Lets go over to see what are the most important changes [...]

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

Analyzing Slow Query Table in MySQL 5.6

February 18, 2013 By 1 Comment

Next week I’m teaching an online Percona Training class, called Analyzing SQL Queries with Percona Toolkit.  This is a guided tour of best practices for pt-query-digest, the best tool for evaluating where your database response time is being spent. This month we saw the GA release of MySQL 5.6, and I wanted to check if any [...]

Filed Under: Events and Announcements, Insight for DBAs, Live Virtual Training, MySQL, Percona Toolkit, Training Tagged With: , , , , , , ,

Replication checksums in MySQL 5.6

February 15, 2013 By 3 Comments

MySQL 5.6 has an impressive list of improvements. Among them, replication checksums caught my attention as it seems that many people misunderstand the real added value of this new feature. I heard people think that with replication checksums, data integrity between the master and its replicas is now enforced. As we’ll see, it’s not that [...]

Filed Under: MySQL Tagged With: , , ,

Unexpected problem with triggers and mysqldump

February 11, 2013 By 8 Comments

Some time ago, I had to convert all tables of a database from MyISAM to InnoDB on a new server. The plan was to take a logical dump on the master, exporting separately the schema and the data, then edit the CREATE TABLE statements to ensure all tables are created with InnoDB, and reload everything [...]

Filed Under: MySQL Tagged With: ,

Implications of Metadata Locking Changes in MySQL 5.5

February 1, 2013 By 9 Comments

While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the Metadata Locking related changes that were introduced in MySQL 5.5.3. It appears that the implications of Metadata Locking have not [...]

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

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

January 13, 2013 By 4 Comments

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

Filed Under: MySQL, Percona Software Tagged With: , ,
« Older Posts
Newer Posts »