May 20, 2013

Is Synchronous Replication right for your app?

May 14, 2013 By 17 Comments

I talk with lot of people who are really interested in Percona XtraDB Cluster (PXC) and mostly they are interested in PXC as a high-availability solution.  But, what they tend not to think too much about is if moving from async to synchronous replication is right for their application or not. Facts about Galera replication [...]

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

Is your MySQL buffer pool warm? Make it sweat!

April 16, 2013 By 6 Comments

Today’s blog post diving into the waters of the MySQL buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1 of 2. Thank you to Kyle Oppenheim at Groupon for contributing to this project and post. We’ll be posting Part 2 on Thursday. I’ll be at the Percona Live MySQL Conference and [...]

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

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

InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

I’ve never been a very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by the potential disadvantages and the strengths of InnoDB. However, up until MySQL 5.6, MyISAM was the only storage engine with support for full-text search (FTS). And I’ve encountered many [...]

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

Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80

February 25, 2013 By 10 Comments

There are many reasons for wanting a small MySQL database server: You’re a uni student who wants to learn the SQL language better and needs a mini-testbox You’re a Windows user who wants to play around with Percona Server on Linux You’re a corporate application developer who wants a small SQL development & test box [...]

Filed Under: Hardware and Storage, Insight for DBAs, Insight for Developers, 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: , , , , , ,

Concatenating MyISAM files

November 19, 2012 By 5 Comments

Recently, I found myself involved in the migration of a large read-only InnoDB database to MyISAM (eventually packed). The only issue was that for one of the table, we were talking of 5 TB of data, 23B rows. Not small… I calculated that with something like insert into MyISAM_table… select * from Innodb_table… would take [...]

Filed Under: MySQL

Measuring the amount of writes in InnoDB redo logs

October 8, 2012 By 4 Comments

Choosing a good InnoDB log file size is key to InnoDB write performance. This can be done by measuring the amount of writes in the redo logs. You can find a detailed explanation in this post. To sum up, here are the main points: The redo logs should be large enough to store at most [...]

Filed Under: Insight for DBAs, MySQL

Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6

August 30, 2012 By 2 Comments

I got the message in the morning today about the bug being fixed in MySQL 5.6.6…. which I reported in Early 2006 (while still being with MySQL) and running MySQL 4.1 I honestly thought this issue was fixed long ago as it was indeed pretty annoying. I must say I’m very impressed with Oracle team [...]

Filed Under: Insight for DBAs, MySQL
« Older Posts