This doc contains my accumulated knowledge about console, terminal and shell. I, together with many of you, do not spend dedicated time to learning these concepts, but instead keep accumulating the...

Celery has a AMQP broker and an consumer backend. kombu Kombu is a messaging library that supports AMQP, redis, etc. It is basically an AMQP broker. I feel reading its user guide is super helpful...

There are only two difficult problems in the traditional RDBMS domain: query optimization and concurrency control. This blog discuss various aspects of the latter in Mysql. Isolation levels The b...

Template Argument Deduction For Function Calls The ultimate source of truth is temp.deduct.call. Let’s take a few examples. Example 1: cv-qualifier and reference type template <typename T>...

QEP: query execution plan Join straight join It is kind of option that forbid reordering tables when joining. According to official doc, This can be used for those (few) cases for which the ...

Some random thoughts or learnings. 2025-03-09 Today I learned a new nvim plugin called ltex-ls which is grammar checker for Latex and markdown. It provides a cmd line tool ltex-cli. I was very ex...

Questions What is Mysql iterator executor

I am reading a good book “Database internals” by Alex Petrov. Below are some useful papers I read Ubiquitous b-tree Some useful resources: Alibaba’s database engine blogs http://mysql.ta...

Stored Procedures (sp). One trick of loading a stored procedure in a mysql shell is to use sourece command. You can check if a sp exists by show create procedure MY_PROC. This is a good post abo...

Mini transaction