http://www.mysqlperformanceblog.com Everything about MySQL Performance Fri, 20 Nov 2009 19:29:55 +0000 http://backend.userland.com/rss092 en Following on from our earlier announcement, Paul McCullagh has responded with the answers to your questions - as well as a few I gathered from other Percona folks, and attendees of OpenSQL Camp. Thank you Paul! What’s the "ideal" use case for the PBXT engine, and how does it compare ... http://www.mysqlperformanceblog.com/2009/11/20/paul-mccullagh-answers-your-questions-about-pbxt/ 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 ... http://www.mysqlperformanceblog.com/2009/11/20/rare-evil-mysql-bug/ 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 ... http://www.mysqlperformanceblog.com/2009/11/18/how-innodb_open_files-affects-performance/ 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 <rpm name>-<mysql version>-<percona build ... http://www.mysqlperformanceblog.com/2009/11/18/5-0-87-build20-percona-binaries/ 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 ... http://www.mysqlperformanceblog.com/2009/11/16/table_cache-negative-scalability/ A final update on training for this year - registration for InnoDB/XtraDB training in Chicago (8th December) and Atlanta (10th December) are now open. While in Atlanta I'll be giving a talk at the Atlanta PHP User Group on Optimizing MySQL Performance (details to be posted to their website shortly).  If ... http://www.mysqlperformanceblog.com/2009/11/16/chicago-atlanta-last-two-training-locations-of-the-year/ I forwarded on a list of questions about PBXT to Paul McCullagh today.  While Paul's busy answering them, I'd like to announce that Robert Dempsey (InfiniDB storage engine) and Bradley C. Kuszmaul (TokuDB storage engine) have also accepted an interview. If you have any questions about either storage engine, ... http://www.mysqlperformanceblog.com/2009/11/16/interviews-for-infinidb-and-tokudb-are-next/ I wrote a post a while back that said why you don't want to shard.  In that post that I tried to explain that hardware advances such as 128G of RAM being so cheap is changing the point at which you need to shard, and that the (often omitted) operational ... http://www.mysqlperformanceblog.com/2009/11/16/shard-early-shard-often/ When I did NDB Cluster engagements, it happened a few time that I had to cover the NDB API. Once, a customer asked an example on how to perform a simple scan. Remembering that some examples are within the NDB source tree, under ./storage/ndb/ndbapi-examples/ and I decided to ... http://www.mysqlperformanceblog.com/2009/11/15/ndb-api-examples-the-trivia-to-make-ndbapi_scan-works/ In the last 2 blog posts about High Availability for MySQL we have introduced definitions and provided a list of ( questions that you need to ask yourself before choosing a HA solution. In this new post, we will cover what is the most popular HA solution for MySQL, ... http://www.mysqlperformanceblog.com/2009/11/13/finding-your-mysql-high-availability-solution-%e2%80%93-replication/