May 22, 2013

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: , , , , , ,

Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster

January 31, 2013 By 2 Comments

With our newest release of Percona XtraDB Cluster, I would like to highlight a very nice ability to recovery a node and bring it back to the cluster with an incremental transfer after a crash. This feature was available even in previous release, but now I want to give some details. So, MySQL crashes from [...]

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

Feature preview: Compact backups in Percona XtraBackup

January 29, 2013 By 11 Comments

We continue to improve Percona XtraBackup, and today I would like to give a preview for one feature which comes in next Percona XtraBackup 2.1 release. This feature is “Compact backups”, and let me explain what it does. As you may know InnoDB PK (Primary Key) contains all data, and all secondary indexes are only [...]

Filed Under: MySQL, Percona Software Tagged With: ,

Read/Write Splitting with PHP Webinar Questions Followup

January 23, 2013 By 4 Comments

Today I gave a presentation on “Read/Write Splitting with PHP” for Percona Webinars.  If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions.  I answered as many as I could during the session, but here are [...]

Filed Under: Events and Announcements, Insight for Developers, MySQL Tagged With: , ,

Common MySQL traps webinar questions followup

January 17, 2013 By 1 Comment

Thanks to all attendees of the webinar yesterday! If you missed it, you can watch the video recording. Here are some questions that remained unanswered due to time constraints. Q: Are there any technical considerations or best practice tips to have a replicated slave in the cloud, for example on Amazon AWS? Hardware resources are [...]

Filed Under: MySQL

Sphinx search performance optimization: attribute-based filters

January 15, 2013 By 9 Comments

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

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

How does MySQL Replication really work?

January 9, 2013 By 9 Comments

While we do have many blog posts on replication on our blog, such as on replication being single-threaded, on semi-synchronous replication or on estimating replication capacity, I don’t think we have one that covers the very basics of how MySQL replication really works on the high level. Or it’s been so long ago I can’t [...]

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

Percona Toolkit by example – pt-stalk

January 3, 2013 By 3 Comments

pt-stalk recipes: Gather forensic data about MySQL when a server problem occurs It happens to us all from time to time: a server issue arises that leaves you scratching your head. That’s when Percona Toolkit’s pt-stalk comes into play, helping you diagnose the problem by capturing diagnostic data that helps you pinpoint what’s causing the [...]

Filed Under: Insight for DBAs, MySQL, Percona Software, Percona Toolkit 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

Quickly finding unused indexes (and estimating their size)

December 5, 2012 By 2 Comments

I had a customer recently who needed to reduce their database size on disk quickly without a lot of messy schema redesign and application recoding.  They didn’t want to drop any actual data, and their index usage was fairly high, so we decided to look for unused indexes that could be removed. Collecting data It’s [...]

Filed Under: Insight for DBAs, MySQL, Percona Software
« Older Posts
Newer Posts »