Go Back   Australian Ford Forums > General Topics > Ford Forums Central > Site Support

Site Support If something isn't working or you have a suggestion ( a nice one !! ) let us know here.

Reply
 
Thread Tools Display Modes
Old 01-02-2013, 11:15 PM   #1
supershifty
Missing a sock...
Donating Member3
 
supershifty's Avatar
 
Join Date: Mar 2012
Location: Brisbane 4017
Posts: 8,250
Valued Contributor: For members whose non technical contributions are worthy of recognition. - Issue reason: Dave has been a long time active member on the forums and in particular has been a busy volunteer whenever there are cruises and toys runs etc held in South East Qld. He actively gives up his time and ensures that the events are provided for, be it commun 
Default AFF pages slow to load

I've found that the forum pages are slow to load in the last few days, I mean really slow. When I open the main/login page to AFF it's all good, but when I right click on a link/thread to open up in a new window it turns to pus. Not saying it's an AFF problem at all, could be at well my end.

The AFF pages aren't graphically heavy, so should be almost instantaneous. I've clicked on you tube links within the forum and they stream without a hitch.

Anyone else had the same lately? or should I just man up?

Cheers!

__________________

Real friends + great times = sheer bliss!

Considering becoming an organ donor? Click here

QLD Events, Cruises and Get Togethers: Click here

Gain success instantly - lower your standards.

It's not government funded - it's taxpayer funded.

Last edited by supershifty; 01-02-2013 at 11:22 PM.
supershifty is offline   Reply With Quote Multi-Quote with this Post
Old 02-02-2013, 01:33 AM   #2
Joshmcmillan
FF.Com.Au Hardcore
 
Joshmcmillan's Avatar
 
Join Date: Aug 2009
Location: Mid North Coast, NSW
Posts: 1,205
Default Re: AFF pages slow to load

Yeah I got it starting tonight.

Probably too much traffic on such a great forum ;) I'm sure it will be fixed up soon.
__________________
MY CARS:
-

FG XR6 Turbo, 6 Speed Manual, Silhouette .

12/78 XC Ford Fairmont Project Car. (351, 5spd)
Build Thread: http://www.fordforums.com.au/showthread.php?t=11444473

1968 Ford F350 LWB Dually. 300 Six, 4 speed. Beavertail project.

Joshmcmillan is offline   Reply With Quote Multi-Quote with this Post
Old 02-02-2013, 02:23 AM   #3
Mechan1k
Moderator
Donating Member1
 
Mechan1k's Avatar
 
Join Date: Feb 2005
Location: Kenthurst
Posts: 40,403
Valued Contributor: For members whose non technical contributions are worthy of recognition. - Issue reason: Brings a wealth of knowledge to the forums and is frequently giving helpful advice. Technical Contributor: For members who share their technical expertise. - Issue reason: Always willing to help out with technical information. 
Default Re: AFF pages slow to load

I have noticed the lag as well here.
Mechan1k is offline   Reply With Quote Multi-Quote with this Post
Old 02-02-2013, 09:07 AM   #4
russellw
Chairman & Administrator
Donating Member3
 
russellw's Avatar
 
Join Date: Dec 2004
Location: 1975
Posts: 107,244
Community Builder: In recognition of those who have helped build the AFF community. - Issue reason: Raptor: For Continued, and prolonged service to the wider Ford Community 
Default Re: AFF pages slow to load

Although the pages aren't graphically heavy they are heavy on database load which is usually where any performance issues on AFF come from.

Having said that, the server loads currently look ok (6.75% CPU) - albeit higher than I'd normally expect to see for early on a Saturday but there are 1,500 users on as well - I will turn on monitoring to gather some information before making a definitive call.

Cheers
Russ
__________________

__________________________________________________

Observatio Facta Rotae


russellw is offline   Reply With Quote Multi-Quote with this Post
2 users like this post:
Old 02-02-2013, 09:21 AM   #5
Bam
XB,XF,ZL,EA,EL,BA,SY,SZII
 
Bam's Avatar
 
Join Date: Sep 2005
Location: Canberra
Posts: 3,479
Tech Writer: Recognition for the technical writers of AFF - Issue reason: Excellent write up on Air bag installation. 
Default Re: AFF pages slow to load

Thanks Russ. I've also experienced this problem for about three days...same as Shifty insofar as other sites were OK. There were about 2500 users online when I checked a couple of days ago. It seems to be occurring during peak periods, ie. in the evenings.
Bam is offline   Reply With Quote Multi-Quote with this Post
Old 02-02-2013, 09:40 AM   #6
Jason[98.EL]
FF.Com.Au Hardcore
 
Jason[98.EL]'s Avatar
 
Join Date: Jan 2005
Location: GEELONG
Posts: 7,946
Default Re: AFF pages slow to load

I have had the same issue

Thought it was my comp playing funny buggers again but it seams not to be the case if others are having the same problem

Jason
__________________
no longer have a ford but a ford man at heart
R.I.P 98 EL MAY YOU HAVE A GOOD LIFE IN FALCON HEAVEN

[SIGPIC][/SIGPIC]
Jason[98.EL] is offline   Reply With Quote Multi-Quote with this Post
Old 02-02-2013, 09:54 AM   #7
russellw
Chairman & Administrator
Donating Member3
 
russellw's Avatar
 
Join Date: Dec 2004
Location: 1975
Posts: 107,244
Community Builder: In recognition of those who have helped build the AFF community. - Issue reason: Raptor: For Continued, and prolonged service to the wider Ford Community 
Default Re: AFF pages slow to load

No it is a server issue - a bit more analysis shows that while Apache CPU utilisation is low, mySQL (which runs the database) CPU utilisation is very high with average server loads in the 30's and utilisations up toward 100%.

I'll be doing some mySQL tuning throughout the morning so expect several restarts for mySQL and Apache.

Cheers
Russ
__________________

__________________________________________________

Observatio Facta Rotae


russellw is offline   Reply With Quote Multi-Quote with this Post
4 users like this post:
Old 02-02-2013, 11:29 AM   #8
Geez Louise
Awesome
 
Geez Louise's Avatar
 
Join Date: Oct 2007
Location: In my own little world..Everyone here knows me :)
Posts: 9,401
Valued Contributor: For members whose non technical contributions are worthy of recognition. - Issue reason: All the behind the scenes things that help the community. 
Default Re: AFF pages slow to load

I had been having serious issues for the past week and thought it was my end. Turns out some of it was.

The Optus and Telstra networks are having issues at the moment because of the bushfires/Flooding etc. Although I know Russ has said there is a server issue as well. please bare in mind your internet may be a little slower over the coming week while the infrastructure gets fixed by your provider.

Cheers
Col
__________________
Geez Louise is offline   Reply With Quote Multi-Quote with this Post
2 users like this post:
Old 02-02-2013, 04:18 PM   #9
supershifty
Missing a sock...
Donating Member3
 
supershifty's Avatar
 
Join Date: Mar 2012
Location: Brisbane 4017
Posts: 8,250
Valued Contributor: For members whose non technical contributions are worthy of recognition. - Issue reason: Dave has been a long time active member on the forums and in particular has been a busy volunteer whenever there are cruises and toys runs etc held in South East Qld. He actively gives up his time and ensures that the events are provided for, be it commun 
Default Re: AFF pages slow to load

The pages are flying for me at the moment - it's all good!

Thanks Russell!
__________________

Real friends + great times = sheer bliss!

Considering becoming an organ donor? Click here

QLD Events, Cruises and Get Togethers: Click here

Gain success instantly - lower your standards.

It's not government funded - it's taxpayer funded.
supershifty is offline   Reply With Quote Multi-Quote with this Post
Old 02-02-2013, 05:45 PM   #10
russellw
Chairman & Administrator
Donating Member3
 
russellw's Avatar
 
Join Date: Dec 2004
Location: 1975
Posts: 107,244
Community Builder: In recognition of those who have helped build the AFF community. - Issue reason: Raptor: For Continued, and prolonged service to the wider Ford Community 
Default Re: AFF pages slow to load

The server loads were fluctuating between the 30's and 40's - ideally they should be below 5 and they are currently running between 4 and 5 after some tuning work. As there are currently 1,760 user on-line that's more than acceptable with Apache load also down to about 4.45%.

MySQL CPU utilisation is now down in the 40% bracket and anything under 80% average is fine.

There's a couple more things I will do tomorrow after the SQL server has been running for 12 hours but that's a good start.

Cheers
Russ
__________________

__________________________________________________

Observatio Facta Rotae


russellw is offline   Reply With Quote Multi-Quote with this Post
3 users like this post:
Old 02-02-2013, 05:49 PM   #11
Jason[98.EL]
FF.Com.Au Hardcore
 
Jason[98.EL]'s Avatar
 
Join Date: Jan 2005
Location: GEELONG
Posts: 7,946
Default Re: AFF pages slow to load

thanks Russ

The pages are flying at the moment so job well done

Jason
__________________
no longer have a ford but a ford man at heart
R.I.P 98 EL MAY YOU HAVE A GOOD LIFE IN FALCON HEAVEN

[SIGPIC][/SIGPIC]
Jason[98.EL] is offline   Reply With Quote Multi-Quote with this Post
Old 02-02-2013, 07:14 PM   #12
russellw
Chairman & Administrator
Donating Member3
 
russellw's Avatar
 
Join Date: Dec 2004
Location: 1975
Posts: 107,244
Community Builder: In recognition of those who have helped build the AFF community. - Issue reason: Raptor: For Continued, and prolonged service to the wider Ford Community 
Default Re: AFF pages slow to load

Sorry about the extra couple of restarts but I needed to change something else.

Cheers
Russ
__________________

__________________________________________________

Observatio Facta Rotae


russellw is offline   Reply With Quote Multi-Quote with this Post
Old 02-02-2013, 08:15 PM   #13
foxtrot3
FF.Com.Au Hardcore
 
foxtrot3's Avatar
 
Join Date: Apr 2008
Posts: 5,466
Tech Writer: Recognition for the technical writers of AFF - Issue reason: Technical articles. 
Default Re: AFF pages slow to load

Hi. Definitely rapid load again now. Have you changed the "new posts" search back to the old way? Its hard to tell as I cleared my history to see if that speeded things up. Cheers MD
__________________


HI

I'M MICHAEL

2003 ACID RUSH BA FUTURA WAGON

light up window switches | auto on cruise control | doubleclick window lift from remote
foxtrot3 is offline   Reply With Quote Multi-Quote with this Post
Old 02-02-2013, 08:23 PM   #14
Mechan1k
Moderator
Donating Member1
 
Mechan1k's Avatar
 
Join Date: Feb 2005
Location: Kenthurst
Posts: 40,403
Valued Contributor: For members whose non technical contributions are worthy of recognition. - Issue reason: Brings a wealth of knowledge to the forums and is frequently giving helpful advice. Technical Contributor: For members who share their technical expertise. - Issue reason: Always willing to help out with technical information. 
Default Re: AFF pages slow to load

Quote:
Originally Posted by Geez Louise View Post
I had been having serious issues for the past week and thought it was my end. Turns out some of it was.

The Optus and Telstra networks are having issues at the moment because of the bushfires/Flooding etc. Although I know Russ has said there is a server issue as well. please bare in mind your internet may be a little slower over the coming week while the infrastructure gets fixed by your provider.

Cheers
Col
To add to this .... there are still issues with in the QLD region ... even though Telstra has temporarily fixed a couple of IOFs heading to Northern QLD for the timebeing. Also there are a number of DC's in the Brissy Metro area still running on diesel due to lack of MAINS Power as well.

Some regions though still have no comms.
Mechan1k is offline   Reply With Quote Multi-Quote with this Post
Old 02-02-2013, 09:50 PM   #15
russellw
Chairman & Administrator
Donating Member3
 
russellw's Avatar
 
Join Date: Dec 2004
Location: 1975
Posts: 107,244
Community Builder: In recognition of those who have helped build the AFF community. - Issue reason: Raptor: For Continued, and prolonged service to the wider Ford Community 
Default Re: AFF pages slow to load

Quote:
Originally Posted by foxtrot3 View Post
Hi. Definitely rapid load again now. Have you changed the "new posts" search back to the old way? Its hard to tell as I cleared my history to see if that speeded things up. Cheers MD
I have - one of the things that adds load to the database is the number of reads and writes required to maintain that data compared to the cookie based method previously used.

Despite having almost 2,000 users on currently, server loads are still under 5, have only peaked at 7.5 and Apache load is only:

CPU Usage: u1664.36 s19.42 cu4.28 cs0 - 2.56% CPU load31 requests/sec - 0.5 MB/second - 18.1 kB/request75 requests currently being processed, 0 idle workersCheers
Russ
__________________

__________________________________________________

Observatio Facta Rotae


russellw is offline   Reply With Quote Multi-Quote with this Post
This user likes this post:
Old 02-02-2013, 10:23 PM   #16
99AUXR
Brad
 
99AUXR's Avatar
 
Join Date: Jul 2010
Location: New Zealand
Posts: 5,827
Tech Writer: Recognition for the technical writers of AFF - Issue reason: Installing starter motor advice on ba / bf 6cyc Falcon. 
Default Re: AFF pages slow to load

Yea last week has been pretty slow thought it was just my agricultural internet. . . . .Much better now though.
99AUXR is offline   Reply With Quote Multi-Quote with this Post
Old 03-02-2013, 09:54 AM   #17
russellw
Chairman & Administrator
Donating Member3
 
russellw's Avatar
 
Join Date: Dec 2004
Location: 1975
Posts: 107,244
Community Builder: In recognition of those who have helped build the AFF community. - Issue reason: Raptor: For Continued, and prolonged service to the wider Ford Community 
Default Re: AFF pages slow to load

I'll be doing a SQL table optimise this morning as well as some re-indexing so things may be slow and the server may be unavailable for short periods (~20 seconds).

Cheers
Russ
__________________

__________________________________________________

Observatio Facta Rotae


russellw is offline   Reply With Quote Multi-Quote with this Post
Old 03-02-2013, 09:55 AM   #18
russellw
Chairman & Administrator
Donating Member3
 
russellw's Avatar
 
Join Date: Dec 2004
Location: 1975
Posts: 107,244
Community Builder: In recognition of those who have helped build the AFF community. - Issue reason: Raptor: For Continued, and prolonged service to the wider Ford Community 
Default Re: AFF pages slow to load

I'll be doing a SQL table optimise this morning as well as some re-indexing so things may be slow and the server may be unavailable for short periods (~20 seconds).

Cheers
Russ
__________________

__________________________________________________

Observatio Facta Rotae


russellw is offline   Reply With Quote Multi-Quote with this Post
Old 03-02-2013, 10:37 AM   #19
jmac
Regular Member
 
jmac's Avatar
 
Join Date: Mar 2012
Location: Melbourne, Victoria
Posts: 267
Default

Quote:
Originally Posted by russellw View Post
I'll be doing a SQL table optimise this morning as well as some re-indexing so things may be slow and the server may be unavailable for short periods (~20 seconds).

Cheers
Russ
Hey Russ I have some scripts that help with the mysql and Apache tuning process if you are interested pm me ;-)

Sent from my GT-I9100 using Tapatalk 2
__________________
12' FPV Mkii F6 Vixen
-= ID1000 - Venom Cat - BPR SRI - PW Stage2 Cooler - Tune=- (348Kw)


Mazda 3 MPS Aurora Blue Gone :(
-=PG SRI - PG Inlet - ETS TMIC - GFB Hybrid BOV - Best Mufflers DP - Eibach Pro - AccessPort STG2 - Autotech HPFP - ITV22 - Michelin PSS=- (198Kw/466NM ATW)
jmac is offline   Reply With Quote Multi-Quote with this Post
Old 03-02-2013, 01:41 PM   #20
XR6T0Y
Half brain dead already
 
XR6T0Y's Avatar
 
Join Date: Oct 2011
Location: South Aus
Posts: 3,080
Default Re: AFF pages slow to load

Has anyone been getting the page coming up (after trying to load into a thread) saying Database error?
__________________
"My Shockwave Baby"

Running tuned at 191.3rwkw with 475nm Torque
Pacemaker PH4490 + Hiflo Pacemaker cat/catpipe + Xforce 2.5' catback into dual pipes after Diff.
FG Manifold + Herrod airbox + 20% underdrive +Hi flow thermostat + 26mm radiator and Weapon X coils!
Now rolling on staggered Matte black Lesnso D1R's
NOW MANUAL!
Shockwave Blue!
More to come

Now the proud owner of a '97 NL Fairlane

XR6T0Y is offline   Reply With Quote Multi-Quote with this Post
Old 03-02-2013, 02:34 PM   #21
Jason[98.EL]
FF.Com.Au Hardcore
 
Jason[98.EL]'s Avatar
 
Join Date: Jan 2005
Location: GEELONG
Posts: 7,946
Default Re: AFF pages slow to load

Quote:
Originally Posted by XR6T0Y View Post
Has anyone been getting the page coming up (after trying to load into a thread) saying Database error?
I would guess that it is part of the work russ is doing behind the scenes

Jason
__________________
no longer have a ford but a ford man at heart
R.I.P 98 EL MAY YOU HAVE A GOOD LIFE IN FALCON HEAVEN

[SIGPIC][/SIGPIC]
Jason[98.EL] is offline   Reply With Quote Multi-Quote with this Post
This user likes this post:
Old 03-02-2013, 04:10 PM   #22
russellw
Chairman & Administrator
Donating Member3
 
russellw's Avatar
 
Join Date: Dec 2004
Location: 1975
Posts: 107,244
Community Builder: In recognition of those who have helped build the AFF community. - Issue reason: Raptor: For Continued, and prolonged service to the wider Ford Community 
Default Re: AFF pages slow to load

Quite correct - whenever I restart mySQL you'll get a db error as it's obviously not available for the time it takes to restart.

Cheers
Russ
__________________

__________________________________________________

Observatio Facta Rotae


russellw is offline   Reply With Quote Multi-Quote with this Post
This user likes this post:
Old 03-02-2013, 09:51 PM   #23
Bam
XB,XF,ZL,EA,EL,BA,SY,SZII
 
Bam's Avatar
 
Join Date: Sep 2005
Location: Canberra
Posts: 3,479
Tech Writer: Recognition for the technical writers of AFF - Issue reason: Excellent write up on Air bag installation. 
Default Re: AFF pages slow to load

Even the home page was slow to load tonight. 2300 users online at 2150 hours.
Bam is offline   Reply With Quote Multi-Quote with this Post
Old 03-02-2013, 10:14 PM   #24
99AUXR
Brad
 
99AUXR's Avatar
 
Join Date: Jul 2010
Location: New Zealand
Posts: 5,827
Tech Writer: Recognition for the technical writers of AFF - Issue reason: Installing starter motor advice on ba / bf 6cyc Falcon. 
Default Re: AFF pages slow to load

Quote:
2321 (746 members and 1575 guests)
Its the Guests. Ban them, Ban them all

Last edited by 99AUXR; 03-02-2013 at 10:26 PM.
99AUXR is offline   Reply With Quote Multi-Quote with this Post
Old 04-02-2013, 02:11 PM   #25
Silver Ghia
Moderator
Donating Member3
 
Silver Ghia's Avatar
 
Join Date: Jun 2006
Location: Foothills of the Macedon Ranges
Posts: 18,575
Technical Contributor: For members who share their technical expertise. - Issue reason: As Silver Ghia his contributions to the AU and BA technical areas have been of high quality and valuable to the member base. 
Default Re: AFF pages slow to load

Perhaps the high number of guests is because there are a number of forums that were previously private, are now available for guests to open? Unsure when these became open for guests to read but perhaps this could be a reason for the problem?
Silver Ghia is online now   Reply With Quote Multi-Quote with this Post
Old 04-02-2013, 03:13 PM   #26
BionicXR6
Banned
 
BionicXR6's Avatar
 
Join Date: Apr 2011
Location: Sydney
Posts: 934
Default Re: AFF pages slow to load

There is also an issue with the forum where one is not able to un subscribe from threads via the drop down menu under thread tools. This is also causing an issue with still listing read subscribed threads in the user's control panel.
BionicXR6 is offline   Reply With Quote Multi-Quote with this Post
Old 08-02-2013, 10:26 PM   #27
stevz
Banned
 
Join Date: Mar 2006
Posts: 1,223
Default Re: AFF pages slow to load

The forum has been painfully slow for me tonight..
stevz is offline   Reply With Quote Multi-Quote with this Post
Old 03-03-2013, 05:46 PM   #28
Bam
XB,XF,ZL,EA,EL,BA,SY,SZII
 
Bam's Avatar
 
Join Date: Sep 2005
Location: Canberra
Posts: 3,479
Tech Writer: Recognition for the technical writers of AFF - Issue reason: Excellent write up on Air bag installation. 
Default Re: AFF pages slow to load

Hate to say it but it's doing it again. As at the time of this post, the home page took about 30 secs to load and the User CP hadn't finished loading after 2 mins. Approx 2300 users online. Cross-checked other sites and they were OK, hence it's not my ISP.

I had a similar problem during peak hours yesterday. Off-peak hours (eg. 0600) were OK.
Bam is offline   Reply With Quote Multi-Quote with this Post
Old 03-03-2013, 07:26 PM   #29
russellw
Chairman & Administrator
Donating Member3
 
russellw's Avatar
 
Join Date: Dec 2004
Location: 1975
Posts: 107,244
Community Builder: In recognition of those who have helped build the AFF community. - Issue reason: Raptor: For Continued, and prolonged service to the wider Ford Community 
Default Re: AFF pages slow to load

It's not load related as I've resolved those issues however we are clearing the SQL cache every couple of hours and that will result in long queries for a few minutes while the cache rebuilds.

However, that is the lesser of evils as what was happening was that the system would run low on memory when getting a lot of queries and then it starts doing what are known as low memory prunes of the cache.

In simple terms, these are a bad thing as they cause all the memory addresses used by the query cache to be rebuilt and performance suffers - flushing the cache every couple of hours allows the cache to rebuild gracefully and has less of a performance impact.

We will also be doubling the primary memory in the server so that some of those thresholds can be raised in order to avoid this issue - or at least flush the cache less often.

When I first started the tuning exercise the low memory prunes were going up every hour so that by the early evening they were in the half million bracket whereas now they are in the low thousands and not increasing until late at night.

Cheers
Russ
__________________

__________________________________________________

Observatio Facta Rotae


russellw is offline   Reply With Quote Multi-Quote with this Post
Old 09-03-2013, 02:32 PM   #30
MercurySilver
Isn't it obvious?
Donating Member1
 
MercurySilver's Avatar
 
Join Date: Nov 2009
Location: in a world of idiots
Posts: 5,383
Default Re: AFF pages slow to load

very slow for me today
__________________
08 Strike G6E T.
10 Ergo G6E
Sept 75 XB Falcon in mushroom beige, 3 on the tree 200cid for sale, offers in the teens
MercurySilver is offline   Reply With Quote Multi-Quote with this Post
Reply


Forum Jump


All times are GMT +11. The time now is 09:45 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Other than what is legally copyrighted by the respective owners, this site is copyright www.fordforums.com.au
Positive SSL