June 18, 2013

Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit

…does not need much introduction, especially to the MySQL server developers. The Valgrind Memcheck tool, …must be serialized in memory after the reset. A speculative processor might perform the read…are unprotected. These are buffer pool statistics counters: number of read, written, evicted, etc. pages…

Post: MySQL: Followup on UNION for query optimization, Query profiling

… what exactly happens during query execution – very helpful for MySQL Performance optimization: mysql> flush status; Query OK, 0 rows affected (0.00… STATUS to reset counters run the query (assiming your system does not do anything) and run SHOW STATUS to see how counters have… as in MySQL 5.0 you do not have to any more. SHOW STATUS now will show per session counter increments and…

Post: Ultimate MySQL variable and status reference list

I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just …