Full Version: Forum slow?
From: Mick [#49]
8 Feb 2007
To: ALL
From: Stunt Engraver (DGL) [#50]
8 Feb 2007
To: Mick [#49] 9 Feb 2007
Too slow, too soon after the last episode.
As much as Go Daddy says it's nothing on their end, we may have to test that theory, in the only way we can, which is by changing our hosting company.
Stay tuned.
From: RALLYGUY (RALLYGUY1) [#51]
8 Feb 2007
To: Stunt Engraver (DGL) [#50] 8 Feb 2007
Verification of very slow speeds here in the Midwest again...........
For all the conspiracy theorists............No reports of any global internet attacks yet this morning..... but it's early........ :)
From: Dee (DEENA-ONLY) [#52]
9 Feb 2007
To: RALLYGUY (RALLYGUY1) [#51] 9 Feb 2007
Crawling in the east.
Dee
From: Dee (DEENA-ONLY) [#53]
9 Feb 2007
To: Dee (DEENA-ONLY) [#52] 9 Feb 2007
When I went to post the above I got this message before the post appeared.
Error Message for server admins and developers:
Unknown error [2013]
Lost connection to MySQL server during query
SELECT USER_THREAD.UID, USER.NICKNAME, USER.EMAIL FROM EE_USER_THREAD USER_THREAD LEFT JOIN USER USER ON (USER.UID = USER_THREAD.UID) WHERE USER_THREAD.TID = 5803 AND USER_THREAD.INTEREST = 2 AND USER_THREAD.UID NOT IN (23, 910)
Unknown error in line 132 of file db_mysql.inc.php
Beehive Forum 0.7.1 on PHP/4.3.11 Linux CGI-FCGI, MySQL/40027
From: BobT [#54]
9 Feb 2007
To: ALL
From: RALLYGUY (RALLYGUY1) [#55]
9 Feb 2007
To: Stunt Engraver (DGL) [#34] 9 Feb 2007
From: Stunt Engraver (DGL) [#56]
9 Feb 2007
To: RALLYGUY (RALLYGUY1) [#55] 9 Feb 2007
Good idea.
Here's the server IP address:
208.109.78.126
Thanks,
From: Dee (DEENA-ONLY) [#57]
9 Feb 2007
To: Stunt Engraver (DGL) [#56] 9 Feb 2007
There are certainly others in forum land who have no idea what a ping is let alone what we should do with that number. Do you want us to do something with those numbers & if so please post step by step directions.
Dee
From: John (ICTJOHN) [#58]
9 Feb 2007
To: Stunt Engraver (DGL) [#56] 9 Feb 2007
It is slooooooooow here in KS as well.
I just did a ping and it ranges from a low of 58ms to a high of 79ms
:S
From: RALLYGUY (RALLYGUY1) [#59]
9 Feb 2007
To: Dee (DEENA-ONLY) [#57] 9 Feb 2007
Here are instructions.
http://www.mymommybiz.com/seo/howtoping.html
You can ping by a web address, or a server IP address.
It shows the latency, or time in milliseconds and any packet (data) loss along the way.
I am attaching my test results for the IP, and the url in a screen shot.
If there are server hops they are usually shown in the list (I didn't see any in my test). I'm hoping the Go Daddy people will find something like this useful in problem solving the trouble.
Not sure if 50-60 ms is good or bad. I also tested Google, and it was 11 ms, our own websites were 13 ms average.
Hope this helps,
From: sprinter [#60]
9 Feb 2007
To: RALLYGUY (RALLYGUY1) [#59] 9 Feb 2007
Those pings really aren't that bad, just not great. It would be bad if you were real time gaming, but it wouldn't cause this slowdown.
Dee found the real problem, Beehive is sql database driven. Hosting companies run the sql databases on seperate servers than the hosting servers. It's an internal routing problem. I had the same problem on WOE several months ago, the only fix was to change hosting servers, which the providers don't like doing for you.
From: RALLYGUY (RALLYGUY1) [#61]
9 Feb 2007
To: Stunt Engraver (DGL) [#50] 9 Feb 2007
You can go to .....
http://www.hostpulse.com/hosting/networktools/pingresult.asp
Scroll down, type the url in the speed test box, and it will show ping information, as well as where you compare to other web sites currently.
Ours and most that I have tested for comparison have been in the top 3 every time I tested them.......The EE site is showing up about halfway down the list.
From: RALLYGUY (RALLYGUY1) [#62]
9 Feb 2007
To: sprinter [#60] 9 Feb 2007
Makes sense, a latency of 60 ms is good in the gaming community........
That's why its wierd...I think you're on to something with the internal issues........
From: Harvey only (HARVEY-ONLY) [#63]
9 Feb 2007
To: ALL
I am running pings of about 116 ms.
You can ping from the DOS prompt
ping 208.109.78.126
It will give 5 pings then the average.
Sprinter's answer makes a ton of sense. Certainly an explanation. It could explain why they say our server is running fine when the results are awful. It is a Go Daddy internal problem with retrieving data.
From: Stunt Engraver (DGL) [#64]
9 Feb 2007
To: sprinter [#60] 9 Feb 2007
The voice of experience, with a similar situation, carries some weight.
Thank you.
Go Daddy, as in the past, is saying there are no server problems on their end.
When you said the cure is to change hosting servers, would that mean using a different hosting company, or do I need to convince Go Daddy to get going and make a change from within?
From: sprinter [#65]
9 Feb 2007
To: Stunt Engraver (DGL) [#64] 9 Feb 2007
David,
Try to have them change your shared server, that has the beehive software on it. They will resist I'm sure. I had to threaten to cancel serveral accounts to get my provider to make the change.
They really don't like to host sql based forums, In all rights they are correct in saying the server doesn't have any any problems. They will probably also tell you that the sql databases are an added bonus feature and are not meant to be used with a forum.
The other solution is to go to a dedicated maintained server that has the sql database on the same server as the software, but as you remember that can also have problems. The other solution is to have multiple servers with different providers and load share them, which is how I have WOE, the downside to this is the software required to manage and sync them. In theory with the multiple servers you should never be down and have resonable speeds.
In any event, good luck.
From: sprinter [#66]
9 Feb 2007
To: Stunt Engraver (DGL) [#64] 9 Feb 2007
It is timing out contacting the sql server! When I posted to you I received this error and had to post it 3 times to make it work.
Error Message for server admins and developers:
Unknown error [2013]
Lost connection to MySQL server during query
SELECT USER_THREAD.UID, USER.NICKNAME, USER.EMAIL FROM EE_USER_THREAD USER_THREAD LEFT JOIN USER USER ON (USER.UID = USER_THREAD.UID) WHERE USER_THREAD.TID = 5803 AND USER_THREAD.INTEREST = 2 AND USER_THREAD.UID NOT IN (200, 4)
Unknown error in line 132 of file db_mysql.inc.php
Beehive Forum 0.7.1 on PHP/4.3.11 Linux CGI-FCGI, MySQL/40027
From: Stunt Engraver (DGL) [#67]
9 Feb 2007
To: sprinter [#65] 9 Feb 2007
Thanks again Ken.
You're correct in saying that Go Daddy regards the Beehive (sql database) software as some sort of Martian invention and points to it as the likely problem.
Looks like a server/hosting change will be comiing in the near future.
I appreciate the info.
EDITED: 9 Feb 2007 by DGL
From: Harvey only (HARVEY-ONLY) [#68]
9 Feb 2007
To: Stunt Engraver (DGL) [#67] 9 Feb 2007
54 files totaling faintly over 1 Meg, 20 minutes!
The server went from molasses of 170 bytes per second then slowly got faster. A few files came in at 70-100 KBytes per second then down to 180-400 bytes per second again. It seemed for a while that the transfer speed was about 1/10 the file size, till it went to 1/20 the file size. Even a PASV command was taking 10 seconds for a server response at times. This does not use MySql at all.
Line 132 on that file is a blank line.
127 function db_query($sql, $connection_id)
128
129 {
130
131 if ($result = @mysql_query($sql, $connection_id)) {
132
133 return $result;
134
135 }Something smells rotten here with Go Daddy's assurances that all is right.
Show messages: 1-8 9-28 29-48 49-68 69-88 89-91