EmergencyEMERGENCY? Get 24/7 Help Now!

Great work Innodb Team

 | November 30, 2009 |  Posted In: Events and Announcements

I thought I should praise Innodb team for all the work they have been doing recently. We see a lot of cool stuff happening, especially in the area of our interest which is Performance And Scalability. Innodb Plugin 1.0.4 had a lot of great performance improvements and 1.0.5/1.0.6 gets even further with long standing caching […]

Read More

More on table_cache

 | November 26, 2009 |  Posted In: Benchmarks, Insight for DBAs, MySQL

In my previous post I looked into how large table_cache actually can decrease performance. The “miss” path is getting more expensive very quickly as table cache growths so if you’re going to have high miss ratio anyway you’re better off with small table cache. What I have not checked though is how does table_cache (or […]

Read More

Rare evil MySQL Bug

 | November 20, 2009 |  Posted In: Insight for DBAs, MySQL

There is the rare bug which I ran into every so often. Last time I’ve seen it about 3 years ago on MySQL 4.1 and I hoped it is long fixed since… but it looks like it is not. I now get to see MySQL 5.4.2 in the funny state. When you see bug happening […]

Read More

How innodb_open_files affects performance

 | November 18, 2009 |  Posted In: Insight for DBAs, MySQL

Recently I looked at table_cache sizing which showed larger table cache does not always provides the best performance. So I decided to look at yet another similar variable – innodb_open_files which defines how many files Innodb will keep open while working in innodb_file_per_table mode. Unlike MyISAM Innodb does not have to keep open file descriptor […]

Read More

5.0.87-build20 Percona binaries

 | November 18, 2009 |  Posted In: MySQL, Percona Software

Dear Community, We are pleased to present the 20th build of MySQL server with Percona patches. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.87 innodb_rw_lock.patch is ported from InnoDB Plugin 1.0.3 To be compatible with RedHat RPM repository, the naming scheme has changed to

Example:

[…]

Read More

New TokuDB 2.2.0 feature: more query progress information

 | November 17, 2009 |  Posted In: Tokutek, TokuView

Last spring, we added a feature that allows the user to see the progress of writes in a statement. Vadim liked it. In 2.2.0, in “show processlist”, we add progress information on reads. Here is an example of what “show processlist” displays on an update:

Here is an example of what “show processlist” displays […]

Read More

table_cache negative scalability

 | November 16, 2009 |  Posted In: Benchmarks

Couple of months ago there was a post by FreshBooks on getting great performance improvements by lowering table_cache variable. So I decided to investigate what is really happening here. The “common sense” approach to tuning caches is to get them as large as you can if you have enough resources (such as memory). With MySQL […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.