PrecisionSQLHow to Stop Bulk INSERT From Locking the Table Forever
Big inserts can block every other query.
YouTube
How to Use IGNORE INDEX When Optimizer Picks Wrong Plan
MySQL sometimes chooses the slow path.
How to Use IGNORE INDEX When Optimizer Picks Wrong Plan #performance
How to Stop Decimal Precision From Losing Money
Floating point can silently drop cents.
How to Stop Decimal Precision From Losing Money #money
Timo TijhofWikiApiary is back online after having been down and overloaded for a long time.
Bawolff brought it back and did a ton of full stack performance work to optimise the whole system. Adding HTTP caching, tuning InnoDB, and more!
https://blog.bawolff.net/2026/03/giving-wikiapiary-kick.html
#MediaWiki #WikiApiary #Wikibase #Wikidata #VinylCache #VarnishCache #MariaDB #MySQL #webperf #SRE
gihyo.jp第128回 「内向き思考打破が日本を救う！」セミナー報告、MySQL 9.7アーリー・アクセス版リリース、次期PostgreSQL 19の期待したい新機能候補
https://gihyo.jp/article/2026/04/ossdb-various-news0128?utm_source=feed
How to Stop MySQL From Scanning With FIND_IN_SET
FIND_IN_SET bypasses indexes and burns CPU.
How to Stop MySQL From Scanning With FIND_IN_SET #howto
Magical Cat@hostinger
Codee barely able to get through, and all it can do is to cry about 45% CPU usage of MySQL. Due to "non-standard" configuration from Docker installaitons "shop" of Docker Manager.
Looks like using of docker is not best choice ever, as I can't use nor terminal properly neither Codee can't operate over it directly.
I can't investigate why CPU usage skyroketed.
There is no any "table below" (see image).
How to Prevent Slow Query Log From Filling Your Disk
One bad query. Millions of log lines.
How to Prevent Slow Query Log From Filling Your Disk #slowquery
How to Stop AUTO_INCREMENT From Reusing After Restart
Recycled IDs can break your caching.
Shyim