Database Query Optimization & Plan Performance Tuning

Database administrators can never afford to ignore SQL database issues because the smallest ones can bring the biggest losses to the organization. At the same time, even a minor scope for change can prove to be a great opportunity for database query optimization. Although one may need a considerable amount of experience to discover such

Improve MySQL Database Performance: Debugging Idle Connections

Do you wonder why a SHOW PROCESS LIST connection in your database has been in a sleep state for a considerably long time? If you have, you may be relieved to know that while it is still a sign of trouble, it is not an uncommon process. Why You are Getting Sleeping MySQL Connections So,