MySQL is the world’s most popular relational database but many people don’t realise that their MySQL server is not working up to its full potential. Most people use default values and do not investigate further to improvise its working. Optimisation technique is more of changes in the managing system rather than making any changes in…