如何使用两个表在Mysql中加快更新查询? [英] How Do I Speed Up Update Query In Mysql With Using Two Tables?
本文介绍了如何使用两个表在Mysql中加快更新查询?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我如何加快mysql中的更新查询?我有10k记录,我的参考表是11k。
Hi, how do I speed up update query in mysql? I have 10k records and my reference table is 11k.
推荐答案
Chk这个链接希望这对你有帮助。
http://dba.stackexchange.com/questions/39693/how-to-speed-up-queries-on-a-large-220-million-rows-table-9-gig-data [ ^ ]
http://stackoverflow.com/questions/17381052/using-mysql-to-run-update-on- a-large-table-is-slow-slow [ ^ ]
http://stackoverflow.com/questions/13048951/i-need-to-speed -up-specific-mysql-query-on-large-table [ ^ ]
http://www.electricmonk.nl/log/2013 / 11/06 /增加大型表的更新性能 - 在mysql / [ ^ ]
Chk this link hope this will help you.
http://dba.stackexchange.com/questions/39693/how-to-speed-up-queries-on-a-large-220-million-rows-table-9-gig-data[^]
http://stackoverflow.com/questions/17381052/using-mysql-to-run-update-on-a-large-table-is-very-slow[^]
http://stackoverflow.com/questions/13048951/i-need-to-speed-up-specific-mysql-query-on-large-table[^]
http://www.electricmonk.nl/log/2013/11/06/increasing-performance-of-bulk-updates-of-large-tables-in-mysql/[^]
这篇关于如何使用两个表在Mysql中加快更新查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文