|All requests||>||What is the best PHP mysql tuner class?||>||Request new recommendation||>||Featured requests||>||No recommendations|
by muabshir - 2 years ago (2017-03-24)
I have a large database and I want to tune it because I feel day by day the application is getting slower.
1. by Manuel Lemos - 2 years ago (2017-03-27) Reply
There are many things you can do but first you need to diagnose the problem. Why it is getting slower?
It can be that you are performing the same queries many times. In that case you can use some caching classes.
You may want to watch this this tutorial video so you decide what problem you need to solve.
This package can show you MySQL query execution plans so you can figure for instance if any slow queries are using indexes to be faster or not.