JOIN Performance Issue MySQL

问题:

I have a MySQL DB View which is having a JOIN on 4 Tables and all indexes have been used properly and previously response time was fair enough but as the database is growing rapidly, the response time is gradually degrading, so how can we tune the performance? I am new to solve this kind of complexity, Do I need to think about database mirroring or partitioning or NoSQl as well, if any doc can be supported on this, it would be very helpful in learning.

回答1:

Depending on your retrieval/usage pattern, I advice to use Partitioning and use the partition attribute in all join conditions and as first filter condition.