William Right's Blog
HomeArchivesCategoriesTagsAbout
  • Categories
  • develop
Posted 2026-02-14Updated 2026-02-14develop23 minutes read (About 3510 words)

MySQL 調優 | Charset & Collation 不一致導致的 JOIN 索引失效

年前接獲了一個需求, 協助海外團隊組合一些舊系統的交易資料, 結果意外的發現了一些 SQL 上的效能議題, 就順便做了個 Demo 測試一下...
Read more
William Wu

William Wu

Hope you find solution here

Taiwan

Posts

26

Categories

5

Tags

34

Follow

Categories

  • Design Pattern3
  • Development13
  • Life4
  • Troll4
  • develop1

Recents

2026-03-03

2026 平溪天燈節心得 (3/3 十分場)

2026-02-25

Orchestrator Saga | 關於 Backend for Frontend 的引入實作

Development

2026-02-14

MySQL 調優 | Charset & Collation 不一致導致的 JOIN 索引失效

develop

2026-02-09

一個代理掛號系統的流程 Redesign

Development

2026-01-17

DDD × Clean Architecture 的實戰筆記 2 | 當 Service 變成 Usecase

Design Pattern

Archives

  • March 20261
  • February 20263
  • January 20264
  • December 20251
  • November 20251
  • October 20253
  • September 20253
  • August 20251
  • June 20254
  • April 20251
  • March 20252
  • February 20252

Tags

Agile1
BFF1
Cache1
Casha5
Clean Architecture3
DB4
DDD2
Design Pattern4
DevOps1
Exception3
Garage1
Grafana1
Jmeter1
Life4
MQ2
MinIO1
Observation1
Prometheus1
RBAC1
Redis3
Rstar2
S3 Bucket1
SDLC1
SOLID2
Saga2
Spring Cloud6
Spring boot2
System Design4
chit-chat1
colorly4
develop22
flow1
github Actions1
troll2
William Right's Blog

© 2026 William Wu  Powered by Hexo & Icarus

© 2025

×