MySQL Performance Blog

We’ve been busy expanding our training curriculum to include training for developers building applications with MySQL.  We have reached the point where we’re ready for a pilot teach – and it brings me great pleasure to announce that we’re opening it up for blog readers to attend, free of charge.

The details:
San Francisco
4th December
9:30AM – 5PM

Spaces are limited, so to give everyone a fair chance we’re delaying registration to open at noon tomorrow (Friday) Pacific Time. It’s strictly first in first served, so be quick!  The registration link is here.

The Percona team has kept on expanding. We are very pleased to announce the addition of Morgan Tocker and Matt Yonkovit!

[read more...]

At Percona we provide services both Onsite – visiting the customers and Remote – logging in to their systems or communicating via email,phone,instant messaging.

We believe both approaches have their benefits and drawbacks and mixing them right way allows you to get your problems solved most efficient way.
[read more...]

Today we glad to announce release 1.0.3-4 of our XtraDB storage engine.

Here is a list of enhancements in this release:

• Move to MySQL 5.1.33
• Move to InnoDB plugin 1.0.3
• more reliable replication, innodb_overwrite_relay_log_info patch now included in the release
• fix assertions for UNIV_DEBUG
• new fix for rw_lock patch

Percona XtraDB 1.0.3-4 (Sakura) available in source and several binary packages.

XtraDB is compatible with existing InnoDB tables (unless you used innodb_extra_undoslots) and we are going to keep compatibility in further releases. We are open for features requests for new engine and ready to accept community patches. You can monitor Percona’s current tasks and further plans on the Percona XtraDB Launchpad project. You can also request features and report bugs there. Also we have setup two maillists for General discussions and for Development related questions.

Percona presented two talks at PHP Quebec last week – one on A Tour of MySQL High Availability, and another on Performance Tuning MySQL. There was a great reaction to showcasing some of the quick-wins that can be found by using the Percona patches. Unfortunately, the one thing that I forgot to mention in the slides is that the patches are Open Source and free to use.

We had too many requests for deb builds of Percona releases so I could not ignore that and added scripts to build binaries on our Ubuntu 8.10 box. It's going to be only 64bit releases (32bit is dead, isn't it?), and I tested binaries on Debian Lenny system and it seems working fine.

So I prepared binaries for our Build13 (which I actually did not announce to not spam PlanetMySQL a lot, I will figure out another channel for announcements), and you can get it there http://www.percona.com/mysql/5.0.77-b13/deb/, and your feedback is welcome!

As for changes for Build13 it contains InnoDB Data Dictionary restriction patch, which I mentioned before (http://www.mysqlperformanceblog.com/2009/02/11/limiting-innodb-data-dictionary/).

Speaking of deb binaries I tried to keep it compatible with native deb binaries, but I had to make some changes:

1. There was strange configure parameters

which I was not sure how to interpret, so I removed any mentioning of embedded server as 5.0 actually is not supposed to work in embedded mode and our patches can't be compiled in this case.

2. I removed NDB cluster engine from builds, we have not tested combination of our patches with NDB so I really do not know how it works together.

Enjoy!

Today we announce release 1.0.2-3 of our XtraDB storage engine.

Here is a list of enhancements:

• Move to MySQL 5.1.31
• Scalability fix — ability to use several rollback segments

Increasing the number of rseg may be helpful for CPU scale of write-intentional workloads. See benchmark results.

• Scalability fix — replaced page_hash mutex to page_hash read-write lock. See benchmark results.
• Fix broken group commit in InnoDB

As you know, the group commit of InnoDB doesn't work after MySQL 5.0 with binlog.
We pretend to fix this and added "innodb_enable_unsafe_group_commit=[0|1]" parameter. Note if you set this parameter to "1" record order of binlog and InnoDB transaction log could be not same. But because InnoDB manages transactions in correct order most users may not have problem with this.

• New parameters in the XtraDB io patches:
  • innodb_ibuf_max_size — Restrict innodb-insert-buffer size
  • innodb_ibuf_active_contract — Enabling it makes the each user threads positive to contract the insert buffer as possible in asynchronous
  • innodb_ibuf_accel_rate — This parameter is additional tuning the amount of insert buffer processing by background thread.
  • innodb_flush_neighbor_pages — When you use the storage which don't have "head seek latency" (e.g. SSD or enough Write-Buffered), 0 may show better performance.
• Changed parameter for control read ahead activity. Now it accepts string values:
  • innodb_read_ahead = [none|random|linear|both]
• Deb builds for Ubuntu

Percona XtraDB 1.0.2-3 (Sapporo) available in source and several binary packages.

XtraDB is compatible with existing InnoDB tables (unless you used innodb_extra_undoslots) and we are going to keep compatibility in further releases. We are open for features requests for new engine and ready to accept community patches. You can monitor Percona’s current tasks and further plans on the Percona XtraDB Launchpad project. You can also request features and report bugs there. Also we have setup two maillists for General discussions and for Development related questions.

Percona is hiring. We've added several experts recently and we're growing at a fast but sustainable pace. The demand for our services is strong, and we have openings for more experts in the next couple of months.

Let me explain a little about what we're looking for at the moment. While we do have a career path for less experienced people, right now we are looking for people who are top-level, senior experts in LAMP/Open-Source performance and scalability. Most of our work involves MySQL (at least peripherally, usually centrally) but not all of it; and we are looking for a PostgreSQL expert as well as systems administration and operations skills. If you're also an expert in a related technology (e.g. Hadoop, popular cloud platforms, or some other component that you might expect to see at the Percona Performance Conference) we'd like to talk with you.

[read more...]

All of us here at Percona warmly invite you to Percona Performance Conference 2009 on April 22 and 23, 2009 in the Hyatt Regency in Santa Clara, California. The theme for the conference is Performance Is Everything. This conference is about application performance overall, not just databases. Attendance is free of charge for everyone. Experts in many types of technologies -- databases, search, cloud computing, massively parallel computing, client-side optimization -- will present their real-life experience.

[read more...]

As we've said before, the Percona team just keeps growing. This time around, I'm pleased to welcome Ryan and Vladimir.

Ryan Lowe initially joined us from Florida (USA) in June. In his previous lives he scaled an Alexa top 1000 site with a sharded MySQL backend, worked in aerospace, worked in telecom, and lots of other things. His background as a consultant, DBA (with Oracle, too!), DBA manager, and programmer makes him a great match for Percona's clients. He also contributed some improvements to Wordpress, and he blogs here and on Pablowe.

Vladimir Fedorkov joins us from Lipetsk in the Russian Federation. (Brrr!) Vladimir and Peter have known each other and worked together for years in past endeavors. Vladimir can make Sphinx do just about anything, and is an expert systems administrator too. (Did you know that we provide systems administration services to our clients? It's not all about query optimization.) Vladimir is also the leader of one of our groups of consultants (codename: Mercury) and is helping us solidify core parts of our services offerings.

Vladimir and Ryan, a big welcome -- we are fortunate indeed you're working with us. And... go team!

PS: I can't help but triple-dip, and point out that our own Ewen Fortune has been a MySQL Cluster Certified DBA for quite a long time now. OK, shameless plug over. And, congratulations Nicklas!