MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Running sql in server is too much slower then laptop
Posted by: Peter Brawley
Date: November 13, 2021 09:21PM

> same mysql version 5.7.0

Probably not. What is the actual MySQL version with each machine?

Let's see my.cnf/ini for each machine.

How much free memory is there on each machine? Run free or its equivalent.

Run Explain on the query on each server and post both results here.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Running sql in server is too much slower then laptop
729
Shanxiang MAO
October 25, 2021 02:49AM
Re: Running sql in server is too much slower then laptop
330
Peter Brawley
October 25, 2021 09:50AM
Re: Running sql in server is too much slower then laptop
295
Herems Jing
November 13, 2021 07:59PM
Re: Running sql in server is too much slower then laptop
305
Peter Brawley
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.