(Ulf Wendel) Would you like to see the EXPLAIN output for all MySQL queries of any PHP application without changing the application much? Easy-peasy: compile PHP to use the mysqlnd library, install PECL/mysqlnd_uh and paste 22 lines of evil code into your auto_prepend_file .
Tag: Open Source
MySQL Thread Pool: Problem Definition
(Mikael Ronstrom) A new thread pool plugin is now a part of the MySQL Enterprise Edition. In this blog we will cover the problem that the thread pool is solving and some high-level description of how it solves this problem.
MYSQL GET DIAGNOSTICS
(Marc Alff) A new feature just got merged into mysql-trunk, the GET DIAGNOSTICS statement.
Important Caveats When Using pt-online-schema-change
(Ben Black) Using pt-online-schema-change is a great way to change a table without downtime or switching over to a secondary database first. While using it on production systems, we found some interesting issues to consider.
The Empty Error Log
(Andrew Moore) The MySQL errorlog is an important point of reference when administering a MySQL Server. We can grasp much about the state of our MySQL instance by the informational and error messages written out to it by our MySQL daemon.
Nasty Regression Bug: SELECT COUNT(DISTINCT) crashes InnoDB when WHERE operand is in Primary Key or Unique Index
(Chris Calender) In 5.5, a crashing, regression bug exists if you use SELECT COUNT(DISTINCT) *and* one of the WHERE operands is in the Primary Key (or just a unique index).
Uh, uh… faking or caching MySQL PHP results
(Ulf Wendel) Unfortunately MySQL Proxy was no good source of inspiration today. MySQL Proxy can do many wonderful things which you can do with C based mysqlnd plugins as well.
MySQL 101 – More Transactions
(Adam Donnison) In our last episode we looked at transactions and how to create them. In this episode I’ll look at some of the implications of transactions, especially in a web application.
Uh, uh… PHP MySQL client fail over
(Ulf Wendel) It is the third day I try to find mysqlnd plugin use cases for the Succeed with Plugins webinar on October, 26th. Not being innovative or creative today, I looked into a classic: client fail over.
Multi-master, NoSQL and MySQL
(Mark Callaghan) The MySQL family has been innovating rapidly. New features need names and sometimes those names are confusing. Describing something as multi-master or a NoSQL solution has confused me.
