When I connect MySQL from remote server and run below query then the results are very slow(Sometime even faced lost connection Issue). However when I run the same SQL query on the local machine then It's results are very fast.
SELECT * FROM CUSTOMERS
The customer tale contains two million records.
I have also enable skip-host-cache and skip-name-resolve in MySQL configuration.
Both machine is connected using the LAN IP and customer table is InnoDB table. I am using MySQL 5.6.
Can you please suggest me on this, why SQL query are very slow when run It from remote machine.
Thank you, Sujeet