我用自己的机子测试了下,有时候很快有时候又很慢。CMD平均花费比百度的还少。Microsoft Windows XP [版本 5.1.2600] (C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\Administrator>ping www.baidu.comPinging www.a.shifen.com [119.75.218.45] with 32 bytes of data:Reply from 119.75.218.45: bytes=32 time=412ms TTL=55 Reply from 119.75.218.45: bytes=32 time=327ms TTL=55 Reply from 119.75.218.45: bytes=32 time=299ms TTL=55 Reply from 119.75.218.45: bytes=32 time=131ms TTL=55Ping statistics for 119.75.218.45: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 131ms, Maximum = 412ms, Average = 292msC:\Documents and Settings\Administrator>ping 221.213.10.55Pinging 221.213.10.55 with 32 bytes of data:Reply from 221.213.10.55: bytes=32 time=76ms TTL=118 Reply from 221.213.10.55: bytes=32 time=38ms TTL=118 Reply from 221.213.10.55: bytes=32 time=67ms TTL=118 Reply from 221.213.10.55: bytes=32 time=38ms TTL=118Ping statistics for 221.213.10.55: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 38ms, Maximum = 76ms, Average = 54msC:\Documents and Settings\Administrator>ping www.baidu.comPinging www.a.shifen.com [119.75.218.45] with 32 bytes of data:Reply from 119.75.218.45: bytes=32 time=42ms TTL=55 Reply from 119.75.218.45: bytes=32 time=39ms TTL=55 Reply from 119.75.218.45: bytes=32 time=40ms TTL=55 Reply from 119.75.218.45: bytes=32 time=38ms TTL=55Ping statistics for 119.75.218.45: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 38ms, Maximum = 42ms, Average = 39msC:\Documents and Settings\Administrator>ping 221.213.10.55Pinging 221.213.10.55 with 32 bytes of data:Reply from 221.213.10.55: bytes=32 time=41ms TTL=118 Reply from 221.213.10.55: bytes=32 time=50ms TTL=118 Reply from 221.213.10.55: bytes=32 time=135ms TTL=118 Reply from 221.213.10.55: bytes=32 time=94ms TTL=118Ping statistics for 221.213.10.55: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 41ms, Maximum = 135ms, Average = 80msC:\Documents and Settings\Administrator>
我用自己的机子测试了下,有时候很快有时候又很慢。CMD平均花费比百度的还少。Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\Administrator>ping www.baidu.comPinging www.a.shifen.com [119.75.218.45] with 32 bytes of data:Reply from 119.75.218.45: bytes=32 time=412ms TTL=55
Reply from 119.75.218.45: bytes=32 time=327ms TTL=55
Reply from 119.75.218.45: bytes=32 time=299ms TTL=55
Reply from 119.75.218.45: bytes=32 time=131ms TTL=55Ping statistics for 119.75.218.45:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 131ms, Maximum = 412ms, Average = 292msC:\Documents and Settings\Administrator>ping 221.213.10.55Pinging 221.213.10.55 with 32 bytes of data:Reply from 221.213.10.55: bytes=32 time=76ms TTL=118
Reply from 221.213.10.55: bytes=32 time=38ms TTL=118
Reply from 221.213.10.55: bytes=32 time=67ms TTL=118
Reply from 221.213.10.55: bytes=32 time=38ms TTL=118Ping statistics for 221.213.10.55:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 38ms, Maximum = 76ms, Average = 54msC:\Documents and Settings\Administrator>ping www.baidu.comPinging www.a.shifen.com [119.75.218.45] with 32 bytes of data:Reply from 119.75.218.45: bytes=32 time=42ms TTL=55
Reply from 119.75.218.45: bytes=32 time=39ms TTL=55
Reply from 119.75.218.45: bytes=32 time=40ms TTL=55
Reply from 119.75.218.45: bytes=32 time=38ms TTL=55Ping statistics for 119.75.218.45:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 38ms, Maximum = 42ms, Average = 39msC:\Documents and Settings\Administrator>ping 221.213.10.55Pinging 221.213.10.55 with 32 bytes of data:Reply from 221.213.10.55: bytes=32 time=41ms TTL=118
Reply from 221.213.10.55: bytes=32 time=50ms TTL=118
Reply from 221.213.10.55: bytes=32 time=135ms TTL=118
Reply from 221.213.10.55: bytes=32 time=94ms TTL=118Ping statistics for 221.213.10.55:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 41ms, Maximum = 135ms, Average = 80msC:\Documents and Settings\Administrator>
如果有,上去检查一下网络配置,看你ping时间的长短,不像是通过局域网连接的。
哦,这个ping是我在自己电脑里面ping的
不是在S-PHP服务器或者S-MYSQL服务器上面ping的
现在下班了,明天ping看看。
不过昨天我在S-PHP服务器里面的 CMD里面使用ipconfig/all来看,却并没有发现任何以 192. 开头的文字。
我们网站也是两个机器分开运用的,并没有这个现象呀。如确认你的程序及配置无错的话:1、检查这两个IP有没有在一个IP段,再查看所属的接入商。如应用机器与数据机器分别不同供应商肯定是不行的,如电信与网通。2、检查数据机器上有没有带宽限制或其它硬件限制,如防火墙之类的拒绝规则。
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127
Reply from 221.213.10.55: bytes=32 time<1ms TTL=127C:\Documents and Settings\Administrator>ping www.baidu.com -tPinging www.a.shifen.com [119.75.218.45] with 32 bytes of data:Reply from 119.75.218.45: bytes=32 time=40ms TTL=52
Reply from 119.75.218.45: bytes=32 time=33ms TTL=52
Reply from 119.75.218.45: bytes=32 time=33ms TTL=52
Reply from 119.75.218.45: bytes=32 time=40ms TTL=52
Reply from 119.75.218.45: bytes=32 time=33ms TTL=52
Reply from 119.75.218.45: bytes=32 time=40ms TTL=52
Reply from 119.75.218.45: bytes=32 time=40ms TTL=52
Reply from 119.75.218.45: bytes=32 time=33ms TTL=52
Reply from 119.75.218.45: bytes=32 time=40ms TTL=52
Reply from 119.75.218.45: bytes=32 time=33ms TTL=52
Reply from 119.75.218.45: bytes=32 time=33ms TTL=52
Reply from 119.75.218.45: bytes=32 time=40ms TTL=52
我感觉还是应该从mysql的配置下手
IP地址是另外一个,是公司的,我用这个221.213.10.55 来代替的。
应该是局域网里面的,但是在S-PHP 或者S-MYSQL的网上邻居(这两台机子都是WIN系统的机子)里面并没有其他任何机子的,而且服务器提供者也并没有提供他们的局域网地址的。
其实是因为连接数太多了,很多都是Sleep进程。show processlist看到的。