MySQL – MySQL Query Optimization and Performance Tuning – Online Video Courses
In year 2013, I had focused on MySQL along with SQL Server in database products. As I learn more and more MySQL, I quickly realized that there is no proper course or structured information for MySQL Performance Tuning. I had decided to build a course around common MySQL Performance Problems. I have decided to build the performance tuning course in two parts. 1) MySQL Indexing for Performance and 2) MySQL Query Optimization and Performance Tuning. I had released MySQL Indexing for Performance course earlier this year and right before the end of the year 2013 the second course MySQL Query Optimization and Performance Tuning has released as well.
SQL SERVER – Monitor Database via a Heatmap, Alarms List and Realtime Diagnostics for FREE
SQL SERVER – Detecting Potential Bottlenecks with the help of Profiler
SQLAuthority News – Learn MySQL Indexing in 99 Minutes – MySQL Indexing for Performance – Video Course
SQL SERVER – Tips for SQL Query Optimization by Analyzing Query Plan
SQL SERVER – Example of Performance Tuning for Advanced Users with DB Optimizer
Performance tuning is such a subject that everyone wants to master it. In beginning everybody is at a novice level and spend lots of time learning how to master the art of performance tuning. However, as we progress further the tuning of the system keeps on getting very difficult. I have understood in my early career there should be no need of ego in the technology field. There are always better solutions and better ideas out there and we should not resist them. Instead of resisting the change and new wave I personally adopt it. Let us learn about DB Optimizer.