In this video, I tried to gather best practices that will definitely help backend developers and database administrators to improve their application and database performances. Most of the time problem related to slow query performance caused by not well written SQL queries. Addressing them during the development will help definitely to minimize or mitigate painful production problems.
I recommend reading those books
High Performance MySQL: Optimization, Backups, and Replication-https://amzn.to/3s23tRs
Murach’s MySQL - https://amzn.to/3lELy24
Database System Concepts - https://www.amazon.com/Database-Conce...
#MySQL
#SQL
#Query Optimization