(Peter Gulutzan) The MySQL manual says:

(Rob Gravelle) Even with a lot of experience under your belt as a Database Administrator (DBA), using Insert and Update statements can be a nerve racking affair. I know that every time I run one of these commands on a production database I have to hold my breath as I click the phpMyAdmin GO button.

(Rob Gravelle) Even with a lot of experience under your belt as a Database Administrator (DBA), using Insert and Update statements can be a nerve racking affair. I know that every time I run one of these commands on a production database I have to hold my breath as I click the phpMyAdmin GO button.

(Mark Leith) Many of us have been there in the past, you get an alert telling you that replication has stopped because of an error, you dig in to it to find that you’re getting an error for an update event that is trying to update a non-existent row, or a duplicate key error because the row ID for s

(Mark Leith) Many of us have been there in the past, you get an alert telling you that replication has stopped because of an error, you dig in to it to find that you’re getting an error for an update event that is trying to update a non-existent row, or a duplicate key error because the row ID for s

(Keith Hollman) Here’s a way to detect the sql query causing a lock or a session to fail, and also to identify the o.s.pid if need be (btw, no rocket science). “a” way.. I’m sure there are many others, so feel free to suggest, please.

(Keith Hollman) Here’s a way to detect the sql query causing a lock or a session to fail, and also to identify the o.s.pid if need be (btw, no rocket science). “a” way.. I’m sure there are many others, so feel free to suggest, please.

(Shlomi Noach) Some notes after working with SHOW BINLOG EVENTS and SHOW RELAYLOG EVENTS statements; there are a few gotchas and some interesting facts. My reflections also follow.

(Shlomi Noach) Some notes after working with SHOW BINLOG EVENTS and SHOW RELAYLOG EVENTS statements; there are a few gotchas and some interesting facts. My reflections also follow.

(Giuseppe Maxia) When a new version of MySQL appears, the first source of information for the brave experimenter is a page in the manual named What is new in MySQL X.X, also known as MySQL in a nutshell. For MySQL 5.7, the in-a-nutshell page lists quite a lot of changes.