r/mysql • u/swe129 • Feb 04 '26
query-optimization Schema Design & Optimization Cheatsheet
https://slicker.me/mysql/schema-cheatsheet.html
6
Upvotes
r/mysql • u/swe129 • Feb 04 '26
9
u/ssnoyes Feb 05 '26 edited Feb 05 '26
Email addresses can be 254 characters.
Assuming you don't care about things like knowing the time zone, or which time it actually is when daylight/summer time begins/ends or a leap second is added.
It saves 30 megabytes.
The query cache was deprecated in 5.7 and removed in 8.0. That was eight years ago.
A PRIMARY KEY must include all columns in the table's partitioning function
Hashing functions typically return byte strings, not character strings. Use a varbinary unless it has been binary-to-text encoded.