Favourites
Most popular topics | Computers Hardware&Softwareopen/close
- argh, bloody cookies!!!... (51)
- Web Browser poll... (48)
- Who uses firefox?... (43)
- bit torrents?... (42)
- Programming Languages? Do... (36)
- noisy fan... (31)
- test your connection spee... (30)
- Webdesigner wanted!... (27)
- Hellllppppppppppppppppppp... (27)
- Computer Games...... (26)
- PC wont boot up... (25)
- Screen Resolution Poll... (25)
- What security do you have... (24)
- Which Antivirus ???... (24)
- Windows Vista... (21)
- limewire n windows media ... (21)
- Next Upgrade... (20)
- what sad idiot invents vi... (19)
- What games do you play?... (19)
- Router woes... (18)
- It is not illeagal to cop... (15)
- Speed of the website... (15)
- Need advice on upgrading ... (14)
- belkin wireless router pr... (13)
- Just bought a new mouse... (12)
Latest topics | Computers Hardware&Softwareopen/close
- Pokemon Team of Choice...
- What is your best RPG gam...
- Girl Gamers unite!...
- A problem that needs a so...
- See which websites are bl...
- The database server is bo...
- Bye Vista, Hello XP...
- MSN without the windows u...
- VIEW SIZE...
- Cant watch vids properly ...
- Woolworths...
- Exploring Second Life at ...
- Murder in the virtual wor...
- AVG free is not updating ...
- Google Chrome...
- Msn keeps crashing..help!...
- Free antivirus...
- my first Post Fron the iP...
- Epson Printers... 8504
- Don't get a wireless keyb...
- _SwapShop_...
- Bookmarks...
- Help!!...
- A joke for geeks...
- I HATE BT... 8514
Home >> Computers Hardware&Software >> Speed of the website
30.12.2007, 19:09 quote
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
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
haha. classy database problems. one of the many reasons i stay far, far away from them.
31.12.2007, 02:04 quote
i'm thinking, either problem with apache cache, the actual physical server, or servers connection to the tinternets
31.12.2007, 09:42 quote
Cazzabee wrote: |
DOnt think the snow has helped matters either |
I found the snowflake script to be quite processor intensive and just disabled javascript in my browser, which helped a bit.
31.12.2007, 14:53 quote
kizz wrote: |
Thanks Stu 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
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
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
02.01.2008, 21:53 quote
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
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
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
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
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
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 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
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.
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