如何使用两个表在Mysql中加快更新查询？ [英] How Do I Speed Up Update Query In Mysql With Using Two Tables?

问题描述

我如何加快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屋！