mysql itself has bottlenecks: once the data volume reaches the tens-of-millions level or above, no matter how you optimize mysql, its performance drops noticeably (unless you have a dedicated team developing and improving mysql). So here are a few ways to solve it.
- Increase the buffer and cache values in the mysql configuration, and add more server CPUs and memory.
- Use a third-party engine or a derivative version. For example: Percona, MariaDB, TokuDB 3. Migrate to another database. For example: PostgreSQL, Oracle
