JOIN性能问题MySQL [英] JOIN Performance Issue MySQL
问题描述
我有一个 MySQL数据库视图,它在4个表上具有 JOIN ,并且所有索引都已正确使用,并且以前的响应时间还算足够,但是由于数据库是快速增长,响应时间在逐渐降低,那么我们如何调整性能?我是新来解决这种复杂性的人,我是否还需要考虑数据库镜像或分区或NoSQl ,如果可以为此提供任何文档,对学习将非常有帮助.
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.
推荐答案
根据您的检索/使用模式,我建议在所有联接条件中将Partitioning
和使用partition属性用作第一个过滤条件.
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.
这篇关于JOIN性能问题MySQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!