472,119 Members | 1,632 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,119 software developers and data experts.

about remote mysql

i connect mysql remotely. it is very slow
i google search, some web sites said, put
i have done that...however, it is still very slow
i read some web sites, someone said.. change the host file in mysql, however, i cannot find the host file in my mysql directory,
the version i installed is the version for windows.

Can anyone give me some ideas
Jul 26 '09 #1
6 2163
126 100+
Can you provide more information, is your mysql server stationed on a host? What software are you using to connect it?
Jul 26 '09 #2
thanks very much.

1) mysql_connect('localhost','root','123') ->both mysql and php in the same machines
2) mysql_connect('','root','123') ->both mysql and php in the same machines

the above 2 cases, it works well

3) mysql_connect('333.333.333.33','root','123') ->mysql and php in different machines

the speed become very slow

The same case also happen in my python/tkinter programs as well....

The speed is 10 times lower than normal.. always exceed the time limit

i am testing it in the windows version mysql....

Can anyone give me some clue ???
Jul 26 '09 #3
126 100+
How far are the machines, is it the same network? Or the same country...? What I can see from now, it's not mysql, but network problem.
Jul 26 '09 #4
Dear Canabee.
Thanks..very much...i am not familiar with networking, what i found is if i ping the remote server, it returns the speed of average 180ms. if i ping my localhost, it returns 0ms. Does it means that connecting remote mysql, we needs 180 times than local mysql....

i am totally confused..
Jul 26 '09 #5
126 100+
Theoretically, yes. 180 ping is usually on really really low speed connections or if you're in Europe and your mySQL server is in the States, or the opposite...
Jul 26 '09 #6
dear canabeez
thanks very much
Jul 26 '09 #7

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

12 posts views Thread by filesiteguy | last post: by
4 posts views Thread by courtney.machi | last post: by
4 posts views Thread by Jerim | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.