Tag Archives: easy

MySQL metrics for read workloads

Posted on 2011/05/19 by

There are multiple metrics that are really useful for read workload analysis, that should all be tracked and looked at in performance-critical environments. The most commonly used is of course Questions (or ‘Queries’, ‘COM_Select’) – this is probably primary finger-pointing … Continue reading →

Posted in facebook, mysql | Tagged , , , ,

MySQL processlist phrase book

Posted on 2009/09/27 by

For your convenience, a short phrase book, starting with explanation of process states where MySQL is mostly working to look up data from tables: “Sending data” – reading data from tables (or looking it up) “Copying to tmp table” – … Continue reading →

Posted in mysql | Tagged , , | 13 Comments

query cache tuning

Posted on 2009/07/08 by

For anyone, who has questions about MySQL query cache tuning, try this tuning assistant: http://dom.as/tech/query-cache-tuner/

Posted in mysql | Tagged , , , | 13 Comments