MySQL Performance Blog

Over last couple of years I have ran into random MySQL crashes in production when multiple key caches were used. Unfortunately this never was frequent or critical enough issue so I could spend time creating repeatable test case and search of the bug in the MySQL database did not find anything. Recently we had this problem again and now discussed it with Monty’s team – this time we found the bug for this issue.

It is no surprise why I could not find the bug easily – the bug is not really related to multiple key caches but to online key cache resize. It is just this code most actively used in case you’re using multiple key caches. It is very rare one would resize single key cache in production and it only triggers crash sometimes, while if you’re using multiple key caches there are often some scripts in place which adjust their size or change mappings of the tables.
[read more...]

Talks are great. I however very much like discussion and opinion share atmosphere of the Birds of a Feather sessions so we host/co-host number of BOFs at the comming OSCON conference.

Future of MySQL Forks, Branches and Patches I guess is the topic a lot of us are interested in. Monty was going to Show Up and we also should see if we can get someone from Drizzle.

Is Enterprise Flash Ready for Prime Time Flash is cool and hot these days. This is the discussion session and I would really like to hear how well flash works for you whenever you’re using it for storage as a cache or as a part of your hybrid storage hierarchy.

Open Source Data Management Is the BOF about open source tools you’re using to deal with your data – storage, caching analytics. I am especially interested hearing on unorthodox use of the software and successes of new technologies.

I also expect there will be number of other BOFs we’ll attend as the time permits. Monty was going to organize BOF on Open Database Alliance though I have not seen it listed yet.