Halit YEŞİL
Category

MySQL / MariaDB

Query plans, index choice, schema design and version upgrades in MySQL and MariaDB, measured on real tables.

5 posts
  1. No. 20 A horseshoe magnet above a haystack pulling steel needles out of the straw, illustrating MariaDB composite index order MariaDB Composite Index: Hold the Magnet by the Right End MySQL / MariaDB
  2. No. 10 Navy cover reading SQL's Hidden Gem: Exploring WITH RECURSIVE, with a small robot holding a magnifying glass and a hierarchy diagram SQL’s Hidden Gem: Exploring WITH RECURSIVE for Hierarchical and Recursive Queries MySQL / MariaDB
  3. No. 8 A data matrix of streaming green binary digits A Big Decision in Identity Selection: INTEGER or BINARY? MySQL / MariaDB
  4. No. 6 A wooden ladder rising out of a dark pit The King Slayer of MySQL: Solving the N+1 Query Problem MySQL / MariaDB
  5. No. 4 Illustration of a person at a computer surrounded by an SQL folder, a server and chart icons MySQL with "INSERT INTO … ON DUPLICATE KEY UPDATE": Advantages and Disadvantages of a Fun Approach MySQL / MariaDB