Do you have any suggestion on mysql optimization?

06 Aug 2018 5 108  1
fuzail faisal

I want to know if there are any good ways to optimize mysql to the best performance possible on the existing hardware it’s installed on.

Tags
Add a Answer

One Reply to “Do you have any suggestion on mysql optimization?”

  1. Hi Fuzail

    I very much recommend this professional tool you can download here:

    https://github.com/major/MySQLTuner-perl

    This will calculate the best optimized configuration for your my.cnf file and will be very helpfull with performance

    also it's very important to host your SQL on an SSD VPS for fastest performance possible , and of curse always use indexing on the right columns.

    Thanks.

Leave a Reply