FreePgs.com Forum

FreePgs Related => Support Requests => Topic started by: giovifranco on October 30, 2006, 09:42:14 AM



Title: Server too slow
Post by: giovifranco on October 30, 2006, 09:42:14 AM
Why server in the morning is so slow? It's very very slow while in the evening it seems to be ok! In this way it's impossible for me to work, i need a faster server for navigation, my site open a pege in 1 o 2 minutes with fast internet connection. Can you resolve this problem? Thanks


Title: Re: Server too slow
Post by: brainiac744 on October 30, 2006, 08:17:39 PM
I can't think of a time that it ever goes that slowly for me, but the reason it is faster at some times and slower at others is because the traffic on the server isn't steady, at certain times of the day it peaks. And no, there's not really anything that can be done about it (other than you moving to a more expensive host).


Title: Re: Server too slow
Post by: bookish on December 14, 2006, 11:56:35 AM
The response time has been painfully slow for the past few hours. One page request timed out. I don't know if this is a problem only for users in Europe.


Title: Re: Server too slow
Post by: bonehead on December 14, 2006, 08:57:41 PM
The server has like 5,000+ accounts on it, plus it doesn't help with spammers running their crap from it also.


Title: Re: Server too slow
Post by: bookish on December 15, 2006, 01:13:24 PM
For a very long time I've been using www.StatCounter.com to track visitors to my site. About a week ago I uploaded SlimStat (http://wettone.com/code/slimstat) because it records search engine crawlers. StatCounter fetches a JavaScript file from an external server, while SlimStat uses PHP and MySQL on the FreePgs "mysql5.freepgs.com" server.

Over the one week period, StatCounter consistently recorded more Unique Visitors and Page Views. As I said in another post a while ago, if FreePgs enabled SQLite support in PHP5 it would free us from reliance on an overloaded MySQL server. The new phpBB3 (http://www.phpbb.com/) forum software can use SQLite.


Title: Re: Server too slow
Post by: brainiac744 on December 15, 2006, 04:08:43 PM
I think StatCounter relies on cookies to record unique hits...

SlimStat probably uses IP addresses? (which is more reliable by the way)


Title: Re: Server too slow
Post by: bookish on December 15, 2006, 05:24:36 PM
Yes, SlimStat uses IP addresses. I removed the include statement for SlimStat and the pages load much faster, so I think it may have been a MySQL issue.


Title: Re: Server too slow and timing out
Post by: mmn on December 15, 2006, 10:12:24 PM
The server is extremely slow right now for me.  It took over 15 refreshes to load this forum page as it was timing out every time.  My site was also consistently timing out, even simple HTML pages without mySQL or PHP usage.  Someone must be abusing the server.  I don't mind too much if it goes slow every once and a while since I am not paying much but I don't like when it times out as visitors leave my site.


Title: Re: Server too slow
Post by: brainiac744 on December 15, 2006, 10:33:25 PM
I don't seem to be having any trouble loading pages?


Title: Re: Server too slow
Post by: bonehead on December 16, 2006, 01:25:24 PM
Once all of the free accounts are gone, maybe that will help.


Title: Re: Server too slow
Post by: bookish on February 12, 2007, 05:10:26 AM
Pageloads are desperately slow at the moment. The forum loads slowly too. I'm wondering if this is a time-of-day problem. Maybe there's someone who deliberately chooses to overload the server while USA citizens are asleep in bed. I hoped this sort of problem would come to an end once free accounts were removed.


Title: Re: Server too slow
Post by: brainiac744 on February 12, 2007, 06:52:24 AM
I'm not having any problem loading pages (granted this was posted ~2 hours ago).


Title: Re: Server too slow
Post by: bookish on February 12, 2007, 07:57:17 AM
brainiac744 > I'm not having any problem loading pages

You've made unhelpful responses like that before. If it's not happening when when you try to access a page, why bother to reply? You're not helping anyone who is experiencing the problem. It's an intermittent problem, by the way.


Title: Re: Server too slow
Post by: brainiac744 on February 12, 2007, 09:34:36 AM
I am helping by defining some point as the end point of the problem. That way it's easier to look back over the logs between two certain time periods, not from one time period on.


Title: Re: Server too slow
Post by: brainiac744 on February 12, 2007, 01:58:11 PM
Well, I thought I'd try to be "helpful" and chime in to say that mysql seems to be sluggish, and barely responding right now. Other pages seem to be working fine. Both my site and this forum are affected.


Title: Re: Server too slow
Post by: Evilsprouts on February 12, 2007, 05:06:58 PM
brainiac744 > I'm not having any problem loading pages

You've made unhelpful responses like that before. If it's not happening when when you try to access a page, why bother to reply? You're not helping anyone who is experiencing the problem. It's an intermittent problem, by the way.

How RUDE!!!


Title: Re: Server too slow
Post by: Dans34 on February 12, 2007, 07:56:09 PM
brainiac744 > I'm not having any problem loading pages

he is pointing out he has no problems so prohaps it is the users connection ?


Title: Re: Server too slow
Post by: bookish on February 13, 2007, 07:03:34 AM
Dans34 > ...so prohaps it is the users connection ?

No. Because it's not happening with other sites I visit at the same time.


Title: Re: Server too slow
Post by: doctoreast on February 13, 2007, 06:13:01 PM
mysql, just to view the table structure, took
exactly 7 minutes; for my 2.5mb sql file.  Totally
horrifying performance...
pe


Title: Re: Server too slow
Post by: admin on February 28, 2007, 10:22:38 PM
If you are viewing the table structure on the mysql5 host via PMA (which is using the mysql4 driver and located on the FreePgs server) will take quite a while even with an empty database.

The best way to manage your database is to use the "MySQL GUI Tools" loaded on your local machine.  These will correctly list databases using the mysql5 (ANSI) method.  You will also not have any problems with timeouts when trying to upload large dump files using this method.

http://dev.mysql.com/downloads/gui-tools/5.0.html

Thank you,
FreePgs.com Admin


Title: Re: Server too slow
Post by: possum on March 02, 2007, 01:19:13 PM
Free mysql tool:

http://www.heidisql.com/