Monthly Archives: July 2012
Like others we were not satisfied with the fix for a bug in MySQL which caused the query cache and partitioning to not work reliably together. The bug, in simple terms, was that if the query cache was enabled and you used partitioned tables and if a partitioned table was using a transactional engine like InnoDB or XtraDB, the query cache could, under certain circumstances, return incorrect results.
Returning incorrect results is a definite, high-priority bug. However, the upstream fix was to disable all caching of queries from partitioned tables. We wanted a better solution because the query cache can be very useful and beneficial for partitioned tables, just like it is useful and beneficial for non-partitioned tables. …
Things are definitely a little quieter here in MariaDB land as many people embark on summer vacations to rest and recharge. However we will be at OSCON 2012. We have a booth in the non-profit/projects pavilion, amazing amounts of schwag, and the famous black vodka that Monty always brings with him. We plan to have a BoF on Thursday evening (come to D135 at 8pm), and we will be at the MySQL BoF on Wednesday evening as well, just for good measure.
Come say hi. Come tell us how you’re using MariaDB.
…