(Satya Bodapati) In my previous blog post, I explained the internals of the sorted index build process. The blog ended with saying “there is one disadvantage.”

(Frederic Descamps) MySQL supports different types of Indexes. They depend on the storage engine and on the type of data. This is the list of supported indexes:

(Tibor Korocz) In this blog post, I am going to show why we have to be careful with stored functions in select list, as a single query can cause thousands of queries in the background if we aren’t cautious.

(Shinguz) The MySQL sys Schema is a cool thing and was mostly developed by Mark Leith and Jesper Wisborg Krogh from Oracle/MySQL.

(Tibor Korocz) Recently I had a case where queries against Aurora Reader were 2-3 times slower than on the Writer node. In this blog post, we are going to discuss why.

(Jean-François Gagné) I am currently running tests with sysbench and dbdeployer on a Google Cloud Platform Debian 9 instance. I ran into an interesting limit and lifting it was not straightforward.

(Carlos Salguero) I receive many questions about errors being reported about pt-kill… and often those errors are not real.

(Eric M. Stone) In this blog post we will define what a split-brain scenario means in a MySQL database cluster, and then explore how a Tungsten MySQL database cluster reacts to a split-brain situation.

(Shinguz) It is Saturday night at 23:19. Time to go to bed after a hard migration day. Just a last clean-up query before finishing: Tap tap tap. Enter! – Oops!

(Federico Razzoli) One of the trickiest problems in SQL is to query rows in tranches. This is typically needed in a website search, or in a dynamic catalogue where products appear as you scroll down.