June 19, 2013

Post: MySQL Webinar: Percona XtraDB Cluster Operations, June 26

… tremendous interest and adoption.  There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach…

Post: Call for papers: Percona Live London

… the code level? Share your perspective about the internals or explain how specific features work in depth. These stories are gold…

Post: MySQL Query Patterns, Optimized - Webinar questions followup

… (k1, k2, k3) is an index lookup.  Look at the EXPLAIN output — it accesses these first, by looking up the keywords…’); Q: On the Dynamic Pivot, the straight join, can you explain more about why you thought about doing that and why… in index order.  This made the first table in the EXPLAIN seem like it was scanning more rows.  But by avoiding…

Comment: Converting Character Sets

… does this to make sure there’s *no* truncation, as explained in the manual – http://dev.mysql.com/doc/refman/5…

Post: Percona MySQL University @Portland next Monday!

… in the Cloud Matt Yonkovit, our VP of Consulting, will explain how to work with BigData effectively Justin Swanhart, our Senior…

Post: The small improvements of MySQL 5.6: Duplicate Index Detection

… accepted as a bug as early as 2005!). The report explains more in detail what the “will be disallowed in a…

Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4

….4 may break your cluster. In this post I will explain you how to fix your cluster in case it breaks…

Post: ZFS on Linux and MySQL

… I got were when using compression.  I still have to explain this, maybe it is related to better raid controller write…

Post: Experiences with the McAfee MySQL Audit Plugin

… you also need to do this, the details are clearly explained here. The plugin writes its output in json format, and…

Comment: Benchmarking Percona Server TokuDB vs InnoDB

Mark thanks for the tip, this give me the motivation to put more efforts to explain what i saw. The same data load inside uncrompressed was good so PMP result need to follow, the only difference is the compression and range partitions. I’ll keep posting