MySQL Forums
Forum List  »  Chinese

服务器上运行SQL比笔记本还慢几百倍
Posted by: Herems Jing
Date: October 25, 2021 03:03AM

服务器配置是:windows server, Xeon E5-2670 v3 2.3GHz + 8G内存。 笔记本电脑是i7-8565U 1.8GHz + 8G内存.
mysql版本是一样的,v5.7.0,服务器的数据是从笔记本的mysqldump导进来的。
但是运行同样的语句,服务器比笔记本还慢很多。
比如跑一个语句,服务器要756秒,笔记本只要2.7秒。 语句是“update a , b set a.tid=b.tid, a.tname=b.tname where a.m=b.m and (a.tid<>b.tid or a.tname<>b.tname)” 。表a有55万条记录,表b有200多条。
请教是什么原因导致的?该如何优化呢?

Options: ReplyQuote


Subject
Views
Written By
Posted
服务器上运行SQL比笔记本还慢几百倍
377
October 25, 2021 03:03AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.