(Ike Walker) A while back one of my foreign keys started causing trouble. The problem was that some parent rows had tens of thousand of child rows, and the foreign key was defined with CASCADE DELETE enabled. When we deleted one of those parent rows on a master database, it took several seconds to e

(Arjen Lentz) You might find a warning like the below in your error log:

(Stewart Smith) I had reason to look into the extended secondary index code in MariaDB and MySQL recently, and there was one bit that I really didn’t like.

(Denish Patel) One of the clients of OmniTI requested help to provide sample application to insert JSON data into Postgres using Java JDBC driver . I’m not Java expert so it took a while for me to write a simple java code to insert data.

(Ike Walker) A while back one of my foreign keys started causing trouble. The problem was that some parent rows had tens of thousand of child rows, and the foreign key was defined with CASCADE DELETE enabled.

(Stephane Combaudon) Global Transactions Identifiers are one of the new features regarding replication in MySQL 5.6. They open up a lot of opportunities to make the life of DBAs much easier when having to maintain servers under a specific replication topology.

(Steve Meyers) Most serious users of MySQL have moved their tables to InnoDB years ago. For those who haven’t, let’s discuss why InnoDB is a more scalable solution than MyISAM.

(morgan tocker) I was playing around with MySQL 5.7 this weekend and before having read the changelog, I managed to spot these two little gems.

(depesz) In this, hopefully 2nd to last, post in the series, I will cover the rest of usually happening operations that you can see in your explain outputs.

(Phil Hildebrand) Now that I’m back doing just database stuff, I’ve come to realize I’ve gotten a little sloppy about doing my homework. Homework’s never been my favorite thing in the world, but it often reduces stress when your under the gun during an outage or upgrade…