taking soo long to load

[peranha]

Why is it taking soo long for pages to load.  I am getting pages in like 60 seconds.  I am on a 8MB cable connection, so it isnt that.  All other pages work fine, just this site loads real slow.

 

Page created in 67.951 seconds with 10 queries.

 

Anyone else having this issue???

[Daniel0]

Here? The "page created in x seconds" message is how long time the server took to generate the page. It has nothing to do with your connection. mysqldump takes up quite a lot of resources on the hourly backups, so if you request a page during the 1-2 minutes it's running then you'll get slower response times.

[peranha]

yeah here "PHPfreaks.com"

[PFMaBiSmAd]

If that occurred on the full hour, it is because either a lot of automated traffic hits the site to grab the latest posts/statistics or the site is doing some automated database operations.

[Daniel0]

If that occurred on the full hour, it is because either a lot of automated traffic hits the site to grab the latest posts/statistics or the site is doing some automated database operations.

 

See:

 

mysqldump takes up quite a lot of resources on the hourly backups, so if you request a page during the 1-2 minutes it's running then you'll get slower response times.

[.josh]

I wasn't gonna say anything but since it got brought up...starting about a month ago, about 1 out of 10 requests have either been taking forever to load (60-90s) or it just times out altogether.  I'm here pretty much all day and night; it happens regardless of the time.  Only pattern I can really see is that 1 in 10 or so requests. 

[DarkWater]

I wasn't gonna say anything but since it got brought up...starting about a month ago, about 1 out of 10 requests have either been taking forever to load (60-90s) or it just times out altogether.  I'm here pretty much all day and night; it happens regardless of the time.  Only pattern I can really see is that 1 in 10 or so requests. 

 

I've never had that happen.  Only exactly on the hour.  It takes almost a minute to load right when the hour changes, but otherwise it's fast.

[.josh]

Well......could be possible that I might avg about 10 posts an hour.  That could explain it. 

[peranha]

I wasn't gonna say anything but since it got brought up...starting about a month ago, about 1 out of 10 requests have either been taking forever to load (60-90s) or it just times out altogether.  I'm here pretty much all day and night; it happens regardless of the time.  Only pattern I can really see is that 1 in 10 or so requests. 

 

It has been happening for about a month, but I dont think it is that often, maybe 1 in 20-25 requests.  I was going to see on the hour change if that makes a difference or not.

[trq]

Well......could be possible that I might avg about 10 posts an hour.  That could explain it. 

 

In fact you do average 4.610/day.

[.josh]

Not lately...I did kind of disappear for like a year, and that's an average based on my join date, so that doesn't really indicate my current rate.

[ober]

I will also concur that page loads have increased, more so in the past week or so.  But on average, they're still not long enough for me to complain and I have a low tolerance level.

[Daniel0]

It must be network problems if it isn't what I mentioned above. I check the "page created" thing on the bottom quite frequently and it's been relatively constant.

[ober]

I wasn't talking about that... the actual page creation time is always < 0.08 seconds.  I think it's the actual network.

[peranha]

It has not happened at all today.  (As of yet)

[corbin]

The backups are run on the hour, I'm quite sure, because I have issues from xx:00 to xx:02 ;p.

 

 

 

Just of curiosity, why is the DB backed up every hour?  I mean I would hate to lose some interesting posts, but every hour?  I would think like every 3 days would be good lol.

[.josh]

Because my posts really are that valuable.  In fact, in addition to that, they have a special cron job setup just to personally backup my posts on 3 different servers. 

[corbin]

Just three?!  What an insult!  You need atleast 300.  Just incase!

[.josh]

Did I mention they hired a full time midget with photographic memory to store my posts in his head?  I hear he can also juggle.

[corbin]

At the same time?

[.josh]

While hopping around in circles on a unicycle, even.  He's an Unbeatable Banzuke champion.  His name is Norm. 

[corbin]

Oh fun!  But seriously, why hourly?  Why not even like every 12 hours?

[.josh]

Because my posts really are that valuable.

[Daniel0]

The reason why we have hourly backups is to minimize any loss that might happen. I remember one time where some people complained about a few posts being lost even when we had so frequent backups. Backups every three days is way to rare for such a large database IMO. If we take the last three days then we had 2532 posts, 481 topics and 156 new members.

 

Besides, in relation to server load it doesn't matter how often we do it. There will still be a latency once in a while. We have plenty of space for the backups. We keep a backup for a week so we always have 336 (one for the main site and one for the forums) backups stored.

 

Anyways, I have a solution already, but I just can't use it. I need an additional server for database replication. Backups will then be run on the slave server which will then take all the load.

[corbin]

Eh, I guess the new users would be more of a loss than the posts.  Would be in my opinion anyway.  And now that I think about it, I guess 1 minute of laggyness isn't a big deal out of an hour ;p.