Buy Percona ServicesBuy Now!

Recall of Percona Server 5.1.47-11.0

 | June 29, 2010 |  Posted In: Percona Software

Percona Server release 11.0 which we announced few days ago unfortunately was released with a bug introduced while implementing stripping comments in query cache which could cause server crash with certain types of queries if query cache is enabled. We have released Percona Server release 11.1 which includes a fix for this issue. If you […]

Read More

Making Updates Fast, by Avoiding Disk Seeks

 | June 22, 2010 |  Posted In: Tokutek, TokuView

The analysis that shows how to make deletions really fast by using clustering keys and TokuDB’s fractal tree based engine also applies to make updates really fast. (I left it out of the last post to keep the story simple). As a quick example, let’s look at the following statement:

Executing this statement has […]

Read More

Percona Server 5.1.47-rel11.0

 | June 21, 2010 |  Posted In: MySQL, Percona Software

Dear Community, Percona Server version 5.1.47-rel11.0 is available for download now. The changes in this release include: New features Percona Server is now based on MySQL 5.1.47, and XtraDB is now based on InnoDB plugin 1.0.8. XtraDB now uses the fast recovery code released in InnoDB Plugin version 1.0.8, instead of Percona’s earlier fast-recovery code. […]

Read More

Disk seeks are evil, so let’s avoid them, pt. 4

 | June 18, 2010 |  Posted In: Tokutek, TokuView

Continuing in the theme from previous posts, I’d like to examine another case where we can eliminate all disk seeks from a MySQL operation and therefore get two orders-of-magnitude speedup. The general outline of these posts is: B-trees do insertion disk seeks. While they’re at it, they piggyback some other work on the disk seeks. […]

Read More

What does Handler_read_rnd mean?

 | June 15, 2010 |  Posted In: Insight for Developers, MySQL

MySQL’s SHOW STATUS command has two counters that are often confusing and result in “what does that mean?” questions: Handler_read_rnd Handler_read_rnd_next As I understand it, there is some historical context to the choice of names here, hearkening back to before I was involved with MySQL, way back when it was a wrapper around ISAM tables […]

Read More