SELECT Query is slow when run remotely in MySQL
Posted by: sujeet singh
Date: July 24, 2016 07:35AM

Hi,

When I connect MySQL from remote server and run below SQL 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 (Machine where MySQL is Installed) then 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

Options: ReplyQuote


Subject
Written By
Posted
SELECT Query is slow when run remotely in MySQL
July 24, 2016 07:35AM


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.