MySQL server intensively uses dynamic memory allocation so a good choice of memory allocator is quite important for the proper utilization of CPU/RAM resources. Efficient memory allocator should help to improve scalability, increase throughput and keep memory footprint under the control. In this post I’m going to check impact of several memory allocators on the [...]
Tutorial Insights for Percona Live, London
August 24, 2011 By Leave a Comment
We have a great line up of Tutorials on Percona Live, London. I hand picked number of them after seeing outstanding speaker Performance in other Places. Let me tell in little bit more details about people we have invited and their talks. Yoshinori Matsunobu Talk on Linux Hardware and Optimizations for MySQL at Oreilly MySQL [...]
Gathering queries from a server with Maatkit and tcpdump
July 1, 2009 By 23 Comments
For the last couple of months, we’ve been quietly developing a MySQL protocol parser for Maatkit. It isn’t an implementation of the protocol: it’s an observer of the protocol. This lets us gather queries from servers that don’t have a slow query log enabled, at very high time resolution. With this new functionality, it becomes [...]
Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set correctly. I’ve seen a lot [...]
MySQL Community Needs
August 15, 2007 By 3 Comments
Sheeri just posted a great post putting a different view on recent MySQL Community Announcements. This however raises very interesting point what MySQL Community really needs ? I think the problem is there are no single set of needs for Community which can be maintained within single version. I see at least two set of [...]
Planet MySQL AdSense Advertisement
May 17, 2007 By 14 Comments
As you probably know MySQL is Running AdSense Ads on PlanetMySQL.org for last few months. When the project was just started it was Ad free. I’m curious If MySQL Really ask syndicated Blog owners if they would allow that or if they just hope if someone does not like it he would speak up ? [...]
