Buy Percona ServicesBuy Now!

How to pretty-print my.cnf with a one-liner

 | June 15, 2009 |  Posted In: Insight for DBAs

When I’m looking at a server, I often want to see the /etc/my.cnf file nicely formatted, and with comments stripped. This Perl one-liner will pretty-print the file:

Read More

The feature I love in TokuDB

 | June 11, 2009 |  Posted In: Insight for DBAs

Playing with TokuDB updates I noticed in SHOW PROCESSLIST unsual for MySQL State.

(Do not look in stupid UPDATE query, it’s just for testing 🙂 ) So looking in SHOW PROCESSLIST you can see progress of query execution. I would want to see it in standard MySQL and InnoDB more than all these triggers […]

Read More

MySQL 5.1 Grammar Changes to Support Clustering Indexes

 | June 11, 2009 |  Posted In: Tokutek, TokuView

This post is for storage engine developers that may be interested in implementing multiple clustering keys. After blogging about TokuDB’s multiple clustering indexes feature, Baron Schwartz suggested we contribute the patch to allow other storage engine to implement the feature. We filed a feature request to MySQL to support this, along with a proposed patch. […]

Read More

5.0.77 / 5.0.82 -build16 Percona binaries

 | June 11, 2009 |  Posted In: Percona Software

Dear community, We are pleased to announce the build16 of MySQL server® with Percona patches. Since the build13 there was a couple of customer specific releases, which explains cutover in numbering and a pause between the builds. Also we prepared build for both 5.0.77 and 5.0.82 versions. Since that time new patches were added: profiling_slow.patch […]

Read More

mysql-proxy, urgh performance and scalability ?

 | June 9, 2009 |  Posted In: Benchmarks

For one our project I needed proxy solution, and mysql-proxy is one of well-known, so it was logical first choice. The obvious question which come in mind is what performance penalty we have using mysql-proxy, version 0.7.1. So it is easy to test. (By the way sysbench recently was pushed to Launchpad, see lp:sysbench, and […]

Read More

Long Index Keys

 | June 1, 2009 |  Posted In: Tokutek, TokuView

In this post we’ll describe a query that accrued significant performance advantages from using a relatively long index key. (This posting is by Zardosht and Bradley.) We ran across this query recently when interacting with a customer (who gave us permission to post this sanitized version of the story):

With a table defined as […]

Read More