Three most important things make impact to MySQL performance


03 Sep 2021 / by KhanhIceTea

There are 3 important things affected to MySQL performance

BUFFERS

Buffers is temporary where data lives in memory. Because memory speed > disk speed ⇒ keep data fit in memory is best way to keep good performance.

So, before thinking about scale horizontaly by clustering or sharding, just throw your money to upgrade your server specs. Keep it simple and live in only server with large memory.

INDEXES

Index could make your query faster, and ... slower. Really, no silver bullets in tech, monitoring your slow query and find out why it was slowww.

Even turn off query optimizer in specific query which full scan table is faster than range index scan.

JOINs

JOIN makes SQL databases good, popular, easier for users (developer, data analysis, BI, ...). But, things alway have downside, "easier" makes users free from making it right and making it fast (they just focus to make it work).

Btw, if your query join tables less than 100,000 rows, then don't worry, be happy 😎

Good luck!

Ref :


Sound good ?