Running sql in server is too much slower then laptop
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?
Subject
Views
Written By
Posted
Running sql in server is too much slower then laptop
864
October 25, 2021 02:49AM
382
October 25, 2021 09:50AM
348
November 13, 2021 07:59PM
366
November 13, 2021 09:21PM
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.