FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  Who is OnlineWho is Online   Join! (free) Join! (free)  
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
  • Welcome
  • Guest

Speeding up large forums

 
Post new topic   Reply to topic    myfreeforum.org Forum Index -> Forum Blogs
View previous topic :: View next topic  
Author Message
Please Register and Login to this forum to stop seeing this advertising.






Add Karma

rated by members
Add Comment
Show Comments


online/offline
Posted:     Post subject:

Back to top
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92900

Joined: 22 May 2005
Posts: 32204



Add Karma

rated by 281 members
Add Comment
Show Comments


online/offline
PostPosted: Fri Jul 31, 2009 7:22 pm    Post subject: Speeding up large forums  Reply with quote

I am planning some database experiments with busy forums, starting of course with the busiest of them all downsizer.net.

I have been logging database queries and seeing some long query times These are not really explainable by lack of server power, but are fairly explainable by the fact that with the MyISAM table types used on all the forums, a write to a table locks the entire table, so if as you might imagine on a busy forum topic views are accumulating at a ferocious rate, then the topics table may be pretty much under constant lock, queuing up loads of requests both to read and write it. Almost no amount of hardware may compensate for this.
There is another table type that can be used  InnoDB tables that only do row level blocking on a write. Of course these types of tables are not without their downsides as well, so it will be interesting to see the results.
_________________

Family Friendly Shareware | | Web Design/Services | Free Forums
Back to top
View user's profile Send private message Visit poster's website
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92900

Joined: 22 May 2005
Posts: 32204



Add Karma

rated by 281 members
Add Comment
Show Comments


online/offline
PostPosted: Sat Aug 01, 2009 8:41 am    Post subject: Reply with quote

No immediate ill effects at least with one table changed.

The downsizer forum is about 3x busier than any myff site   and so the issues that are becoming urgent there have no need to be rushed elsewhere. We can take it slowly and measure effects.
_________________

Family Friendly Shareware | | Web Design/Services | Free Forums
Back to top
View user's profile Send private message Visit poster's website
myff admin
Site Admin
Site Admin
FLAG

Virtual Cash: 92900

Joined: 22 May 2005
Posts: 32204



Add Karma

rated by 281 members
Add Comment
Show Comments


online/offline
PostPosted: Tue Aug 04, 2009 9:24 pm    Post subject: Reply with quote

It cannot be denied that there is a distinct speed improvement.

It also makes in plainer that this is all about table locking, unless you are running a very big and very busy forum there would be minimal improvements and overall things would probably slow down as the existing tables are also very to read and use a lot less system resources.

For example I really doubt the size and activity on the support forum would make it a candidate.


_________________

Family Friendly Shareware | | Web Design/Services | Free Forums
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    myfreeforum.org Forum Index -> Forum Blogs All times are GMT
Page 1 of 1
 
 
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

Card File  Gallery  Forum Archive
Powered by phpBB © 2001, 2005 phpBB Group
Create your own free forum | Buy a domain to use with your forum