Tag: Optimization

All the articles with the tag "Optimization".

• USING HASH Silently Becomes a B-Tree on InnoDB

  8 Sep, 2026

  I checked a write-up on MySQL/MariaDB index creation and EXPLAIN against the manuals. The hash index recipe doesn't work on InnoDB, and four of the EXPLAIN column descriptions are wrong.

• GPU Instancing Shaders: The Korean Manual Is Missing an A

  5 Sep, 2026

  Revisiting Unity's 2021.3 manual page on adding GPU instancing to custom shaders. The Korean localisation has three macro typos, and the render pipeline compatibility table has changed since.