MySQL Forums
Forum List  »  Optimizer & Parser

Running sql in server is too much slower then laptop
Posted by: Shanxiang MAO
Date: October 25, 2021 02:49AM

I use the same db data( import to server from my laptop's mysqldump), same mysql version 5.7.0,
The server's CPU is Xeon E5-2670 v3 2.3GHz, with 8G RAM, while laptop's is just i7-8565U 1.8GHz´╝îwith 8G RAM.
But running same sql in server is much slower then laptop.
For example, to run this sql "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)", server used 756 seconds, but only 2.7 seconds in my laptop. Table a has 550K rows data. Table b has 207 rows data.
It's very strange and I don't know how to optimize in server mysql. Our application can't run well in server because it's too slow.

Could you help me identify what reasons may cause this problem?

Options: ReplyQuote


Subject
Views
Written By
Posted
Running sql in server is too much slower then laptop
512
October 25, 2021 02:49AM


Sorry, you can't reply to this topic. It has been closed.

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.