(Robert Barabas) The other day a colleague and friend of mine, Peter Boros, had a case where one of our clients had to track down the process shutting down MySQL. This blog is based on the discussion we had about that internally.

(Shlomi Noach) Following up on New features I’d like to see in MySQL 5.8, here are statements I would like to see in MySQL 5.8:

(Shlomi Noach) Following up on New features I’d like to see in MySQL 5.8, here are statements I would like to see in MySQL 5.8:

(Giuseppe Maxia) During the PerconaLive conference in Amsterdam, I attended a session where I heard a good piece of advice about using GTID. It amounts to: look at SHOW SLAVE STATUS output, and if you see more than one line in the Executed_Gtid_Set field, this tells you immediately if someone has wr

(Giuseppe Maxia) During the PerconaLive conference in Amsterdam, I attended a session where I heard a good piece of advice about using GTID. It amounts to: look at SHOW SLAVE STATUS output, and if you see more than one line in the Executed_Gtid_Set field, this tells you immediately if someone has wr

(Todd Farmer) Complimenting the expanded CREATE USER syntax introduced in MySQL Server 5.7.6 is more useful ALTER USER syntax. Before MySQL Server 5.7.6, ALTER USER could only be used to expire a user’s password.

(Todd Farmer) Complimenting the expanded CREATE USER syntax introduced in MySQL Server 5.7.6 is more useful ALTER USER syntax. Before MySQL Server 5.7.6, ALTER USER could only be used to expire a user’s password.

(Ben Krug) As a MySQL support engineer, I see this so often, that I felt it could help to write a post about it.

(Ben Krug) As a MySQL support engineer, I see this so often, that I felt it could help to write a post about it.

The sort buffer, which is controlled by the sort_buffer_size setting, is probably one of the most-discussed MySQL settings. Interestingly, in many cases it has a lot less potential to help performance than to hurt it, so configuring it is often about avoiding trouble rather than gaining a lot of per