Learning should never stop and particularly new technology, every year, I focus on learning new technology. Today I am sharing the MySQL Learning Path.
MySQL Performance – 5 Parameters from Config File
I got lots of emails where people wanted to know more about such parameters. Let us discuss 5 Parameters from Config File which can help MySQL Performance.Â
MySQL Performance – Slow Query and innodb_buffer_pool_size
I have helped my clients with MySQL Performance when I know the solution. Let us discuss Slow Query and innodb_buffer_pool_size.Â
MySQL MariaDB – Query Using Temp Table
SQL Server Performance Tuning but this time the question was more related to the MySQL installation they had in their system. Query Using Temp Table.
SQL SERVER – SQL_NO_CACHE and OPTION (RECOMPILE)
How to retrieve queries, not from the cache for MySQL and SQL Server, we discussed SQL_NO_CACHE and OPTION (RECOMPILE). Let us discuss this.
MySQL – Get Last Query Cost Using SHOW STATUS LIKE ‘Last_Query_Cost’
One of the most appreciated tips was about how to get Last Query Cost in MySQL using the command SHOW STATUS LIKE ‘Last_Query_Cost’.
Learn MySQL – New Technology Week
This is the last week of the year and most places it is a holiday. Today we will discuss about where we can learn MySQL online.