469,125 Members | 1,753 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,125 developers. It's quick & easy.

about remote mysql

10
i connect mysql remotely. it is very slow
i google search, some web sites said, put
skip-name-resolve
skip-host-cache
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 2114
Canabeez
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
weskam
10
thanks very much.

1) mysql_connect('localhost','root','123') ->both mysql and php in the same machines
2) mysql_connect('222.222.222.22','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
Canabeez
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
weskam
10
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
Canabeez
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
weskam
10
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
1 post views Thread by CARIGAR | last post: by
reply views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.