May 25, 2012

Post: Heikki Tuuri Innodb answers - Part I

… the answers I have so far. Plus we may get some interesting follow up questions out of this. I had added my comments to some of the questions. HT will stand for Heikki Tuuri in the answers… version does not match the WHERE condition in a search. Please use this with care: you MUST use row-based binlogging…

Post: The two even more fundamental performance metrics

…So that’s it. Ladies and gentlemen (drum roll please), the two basic performance metrics: Arrival time Completion … are paired up. This is item #2 in my numbered list above. Let’s suppose that arrivals …the SQL in hand, we might be able to answer questions about what’s happening in that little spike. …

Post: Online MySQL Configuration Wizard from Percona

… tuning wizard is our answer to the commonly asked question, “what is a good default configuration file for my server with 16 GB… add more online tools to help you be more productive. Please give it a spin and let us know what you…

Post: Innodb Fuzzy checkpointing woes

…when peak load returns. This is actually the question I do not have good answer for. How can we detect how good…I would like to get the control about this in my hands and being able to say this device can …  If you run into what you think is one please help us by commenting on this bug. Real word use…