Keep primary key / index key as tiny as possible
What will happen if we use big strings as MySQL index key
Tag: database
Is 20M of rows still a valid soft limit of MySQL table in 2023?
Innodb_buffer_pool size / table size decides whether there'll be a performance downgrade.
Yisheng's blog 