Posts: 130787 Topics: 9284 LOGIN

Home >> Computers Hardware&Software >> Speed of the website

30.12.2007, 19:09 quote

geekyscotty

Just out of curiosity is anyone else having problems with the speed Flirtbox.co.uk & .net are loading??? I know its been mentioned that Yahoo Slurp! seems to be having a bit of a crap affect on the site load times, but wasn't sure if that issue had been sorted.

 

30.12.2007, 23:18 quote

Anonymous

It was:

- another bot crawling the website
- then a database table was broken
- after that the ip_conntrack_max was too low and had to be increased
- then another datebase table was broken again
- the database cache size had then to be decreased as there was not enough memory in the temp dir to repair tables
- ...while apache had problems as I had to start the server again and StartServers was set too low so it stalled.

so lot's of fun....I need to outsource the webhosting some day - too much trouble.

 

30.12.2007, 23:27 quote

geekyscotty

haha. classy database problems. one of the many reasons i stay far, far away from them. Smile

 

31.12.2007, 02:04 quote

geekyscotty

i'm thinking, either problem with apache cache, the actual physical server, or servers connection to the tinternets

 

31.12.2007, 09:42 quote

Anonymous

Cazzabee wrote:
DOnt think the snow has helped matters either Very Happy


I found the snowflake script to be quite processor intensive and just disabled javascript in my browser, which helped a bit.

 

31.12.2007, 13:52 quote

kizz

Thanks Stu Smile I disabled javascript and its loading much better now.

 

31.12.2007, 14:53 quote

Anonymous

kizz wrote:
Thanks Stu Smile I disabled javascript and its loading much better now.


(I just noticed this post from Kizz and my heart rate has speeded up )

Disabling javascript *might* also mean that other aspects of the site might not work, although I think most of the javascript features are Google-related (probably not the forum though, as I can't see any other scripts that rely on javascript). Toby could probably shed more light on on how disabling javascript in the browser would affect using the site.

Edit: The back and forwards buttons for the photos on the profile pages rely on javascript too, I think the jump menus do as well (e.g. location menu in the Last Seen bit)

 

01.01.2008, 18:29 quote

Anonymous

Javascript is just on the client side - the problem is on the server side.

Mainly, it is the database at the moment as some queries damage tables once in a while (a mysql bug)...and I have not identified the queries yet.

 

01.01.2008, 19:28 quote

Anonymous

I realise that the javascript is client side and has nothing to do with the current problems, but I did find that disabling javascript helped a little with the general loading speed of the forum (not so much the web site). To be honest, sometimes I even disable images when I visit the forum, just to get the forum to load a bit faster when it is slow......everything helps Very Happy

 

02.01.2008, 21:53 quote

Anonymous

bizarrely i have been able to login from home without resorting to proxies, havent been able to do that for about 6 weeks.

 

04.01.2008, 08:37 quote

Anonymous

beddo wrote:
I don't come on so much because I have to start a page loading and then I go do something and forget about it for a while Smile

Sometimes it just doesn't load at all! I'd offer my help as a php/mysql developer but I don't know what I'd be able to do that you couldn't do already..


The main problem is currently that some MySQL queries crash the database tables....then MySQL repairs them in the background the the website gets really slow as MySQL uses a Ramdisk as the tmp directory. Without a ramdisk MySQL would be too slow....but with one, the memory is a problem if tables crash. I have not found an easy way to identify those queries yet.

Another problem is that exim4 sometimes blocks port 80....maybe because PHP sends a mail and then the Apache process dies...and strangely the only process still occupying port 80 after a "killall -9 apache2" is exim4 which is only supposed to block port 25.

 

04.01.2008, 09:48 quote

Anonymous

Ok, I found a nasty killer query:

Art:

flush table forum_forms;
flush table forum_topics;
flush table forum_posts;
SELECT SQL_NO_CACHE t.topic_id, t.topic_title, t.topic_title_url, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id,
f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce,
 f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.forum_url, f.forum_domain
        FROM forum_topics t, forum_forums f, forum_posts p
        WHERE p.post_id > 136463
                AND f.forum_id = t.forum_id
                 order by t.topic_id asc limit 1;

#1030 - Got error 28 from storage engine


I hope replacing that query with something else will speed up the website a bit!

That's the problem with PhpBB based forums...sometimes they don't use joins or "fatal" where statements that make no sense.

 

04.01.2008, 09:56 quote

Anonymous

god wrote:


That's the problem with PhpBB based forums...sometimes they don't use joins or "fatal" where statements that make no sense.


As a matter of interest, which version of phpBB are you using for the forums?

 

04.01.2008, 10:13 quote

Anonymous

Can't remember. Does it show anywhere ?

However, I have replaced half of the queries by now and added some additional code.

I am going to replace all queries that take longe then 0.001 seconds though.

Maybe I'll check out JavaBB some day.

p.s.: the last query was not phpbb's fault Embarassed however, they do not make use of inner joins and often you find "joins" using where statements.
Also the topic view counter should be in a separate table to avoid locking during updates that occur almost every second...therefore I made a cron job to update them only once an hour for the time being.

 

04.01.2008, 10:32 quote

Anonymous

god wrote:
Can't remember. Does it show anywhere ?


The version release usually shows in the Admin index page (right frame), and tells you which version you're running and what the latest release is that you can upgrade to. I'm guessing this forum is quite heavily modified, so upgrading would be quite a big job?

I've done a few upgrades to phpBB3 recently, but I try to convince clients to go for a script that is a bit more reliable, like the SMF script (Simple Machines Forum) - it has an excellent conversion tool and converts from phpBB to SMF (although not sure how a conversion would with such a big database as the one that runs this forum!

But since it probably isn't the script that is casing most of the problems I guess it would be a waste of time converting to another script if the problems lie mainly with the MySQL queries.

 
 
Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum