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
Reply from 10.7.209.12: bytes=32 time<1ms TTL=128 Reply from 10.7.209.12: bytes=32 time<1ms TTL=128 Reply from 10.7.209.12: bytes=32 time<1ms TTL=128 Reply from 10.7.209.12: bytes=32 time<1ms TTL=128 Reply from 10.7.209.12: bytes=32 time<1ms TTL=128
We have a requirements to extract at least 5 thousand records at a time and process that. When we are extracting 5 thousand records then It takes times to give the results and sometime we get timeout or Lost connection error message. Please help on this.select * from table_name LIMIT 5000
then Its still takes times and sometimes we get Lost connection error message.