You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 329 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - nuke speed [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
trini
Sergeant
Sergeant


Joined: Jan 26, 2004
Posts: 81


PostPosted: Thu Feb 26, 2004 12:07 pm Reply with quoteBack to top

i was just wondering how fast can nuke be...meaning if there are alot of users logged on or viewing pages what are types of drawbacks will there be..say if i have nuke on a dedicated server how will it differ from one running on a shared server. Does anyone know much cpu usuage nuke uses for say 1000 users online at the same time..will it be dependant on what each user is using..and one more thing..what module or script really slows down nuke..
thank you
ps.the reason im asking is that i need a nuke site to run fast with say 1000 or more users online at the same time ..please if any one can help or if there are any resources outlying this let me know
Find all posts by triniView user's profileSend private message
luchtzak
Support Mod
Support Mod


Joined: Mar 19, 2003
Posts: 308


PostPosted: Fri Feb 27, 2004 3:04 am Reply with quoteBack to top

Hi trini,

my first webhosting was on a shared server (400 other websites) with SQL-database on another place, after about 6.000-10.000 pageviews per day the server started screaming Smile

my second webhosting was also on a shared server but with SQL-database on the same location, all went well untill we got about 20.000 pageviews per day...

Now I am running the website on a semi-dedicated server P4 2.8 gigahertz 1 giga ram without any problem.

I should say: take a fast dedicated server and you will be quite all right Wink

greetz,

Bart

_________________
Luchtzak Aviation - Snookerforum Belgium
Find all posts by luchtzakView user's profileSend private messageVisit poster's website
trini
Sergeant
Sergeant


Joined: Jan 26, 2004
Posts: 81


PostPosted: Fri Feb 27, 2004 11:48 am Reply with quoteBack to top

thanks i will do that ..i do have my own dedicated server with about 15 other websites running right now ..so i guess i can start up on me server until the site gets big..would u say thats the best way to go about it .
Find all posts by triniView user's profileSend private message
Zhen-Xjell
Nuke Cops Founder
Nuke Cops Founder


Joined: Nov 14, 2002
Posts: 5939


PostPosted: Fri Feb 27, 2004 11:52 am Reply with quoteBack to top

Single dedicated server here, dual Xeons, 4MB mem, dual SCSI HDs... nukecops.com 80,000 hits per day, computercops.boz 170,000 hits per day. Notice any lag? Wink

_________________
Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki]
Find all posts by Zhen-XjellView user's profileSend private messageSend e-mailVisit poster's website
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283


PostPosted: Fri Mar 26, 2004 11:57 pm Reply with quoteBack to top

Trini,

With a large user base/large forums, you can take nuke in two directions. You can add a big iron, like Zhen-Xjell's, cheap these days.

In addition, you can start adding special optimization for large forums. See posts by lanzer (who has a very large forum) on phpbb.com.
http://www.phpbb.com/phpBB/viewtopic.php?t=135383&highlight=lanzer

steve

_________________
ezClassifieds|Forums:Auto,Mac,Job,Win,HW
Find all posts by steven111View user's profileSend private messageVisit poster's website
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283


PostPosted: Fri Jun 11, 2004 3:07 pm Reply with quoteBack to top

If the main part of your nuke site is forums, then take a good look at all the sql queries. I have found quite a few joins where the indecis where not set up properly. I was scratching my heads for DAYS, and finally figured it. Don't go for a bigger box, before doing it. I have a dedicated server, and still had huge problems (now solved).

_________________
ezClassifieds|Forums:Auto,Mac,Job,Win,HW
Find all posts by steven111View user's profileSend private messageVisit poster's website
Zhen-Xjell
Nuke Cops Founder
Nuke Cops Founder


Joined: Nov 14, 2002
Posts: 5939


PostPosted: Sun Jun 13, 2004 10:34 am Reply with quoteBack to top

Steven111, which ones?

_________________
Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki]
Find all posts by Zhen-XjellView user's profileSend private messageSend e-mailVisit poster's website
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283


PostPosted: Sun Jun 13, 2004 11:01 am Reply with quoteBack to top

The following affect your performance if your topics table is too large:

In table: nuke_bbtopics (the following fields are not indexed, and show up in joins):
topic_poster
topic_first_post_id
topic_last_post_id

The following key is double indexed, for no reason (only affect write performance).

table: nuke_users
PRIMARY KEY (user_id),
KEY uid (user_id)

If you are in unix, run "VMSTAT 1". Anytime there is writing to swap, then you have a problem, most likely a join problem (in case of larger forums, and if you think you have plenty of ram).

There may be some other stuff, but I don't recall, and my notes leave something to be desired Crying or Very sad

_________________
ezClassifieds|Forums:Auto,Mac,Job,Win,HW
Find all posts by steven111View user's profileSend private messageVisit poster's website
Zhen-Xjell
Nuke Cops Founder
Nuke Cops Founder


Joined: Nov 14, 2002
Posts: 5939


PostPosted: Sun Jun 13, 2004 11:07 am Reply with quoteBack to top

So you're recommending an index on those fields in bbtopics?

_________________
Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki]
Find all posts by Zhen-XjellView user's profileSend private messageSend e-mailVisit poster's website
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283


PostPosted: Sun Jun 13, 2004 11:12 am Reply with quoteBack to top

Any fields that show up in table joins, and is time-sensitive, "should" be indexed. This is specially so if the topics table is larger... but I think in general the answer is always YES. A db is read many more times than it is written to, so the extra time to write the extra indecis is a small price to pay for much higher join performance.

I was seriously struggling with my home page performance - when users were logged on. The topics indexing saved the day, reducing the lag time from 50 seconds or more to less than 2 seconds.

_________________
ezClassifieds|Forums:Auto,Mac,Job,Win,HW
Find all posts by steven111View user's profileSend private messageVisit poster's website
Zhen-Xjell
Nuke Cops Founder
Nuke Cops Founder


Joined: Nov 14, 2002
Posts: 5939


PostPosted: Sun Jun 13, 2004 11:16 am Reply with quoteBack to top

I have added indices to that table already, but have not indexed topic_first_post_id or topic_last_post_id. Indexing these two made a difference?

_________________
Paul Laudanski, Microsoft MVP Windows-Security
CastleCops: [de] [en] [wiki]
Find all posts by Zhen-XjellView user's profileSend private messageSend e-mailVisit poster's website
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283


PostPosted: Sun Jun 13, 2004 11:23 am Reply with quoteBack to top

topic_last_post_id and topic_first_post_id affect viewing of forum in viewforum.php. I believe in a multi-table query like this one, you never want to have table scans (vs. properly indexed joins). If topic_table too small, it may not be as noticable, but why not do it properly?

$sql = "select t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
WHERE t.forum_id = $forum_id
AND t.topic_poster = u.user_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
AND t.topic_type <> " . POST_ANNOUNCE . "
$limit_topics_time
ORDER BY t.topic_type DESC, t.topic_last_post_id DESC
LIMIT $start, ".$board_config['topics_per_page'];

_________________
ezClassifieds|Forums:Auto,Mac,Job,Win,HW
Find all posts by steven111View user's profileSend private messageVisit poster's website
luchtzak
Support Mod
Support Mod


Joined: Mar 19, 2003
Posts: 308


PostPosted: Sun Jun 13, 2004 3:01 pm Reply with quoteBack to top

Are there other tables that need to be indexed to run the system faster?

greetings,

Bart

_________________
Luchtzak Aviation - Snookerforum Belgium
Find all posts by luchtzakView user's profileSend private messageVisit poster's website
steven111
Lieutenant
Lieutenant


Joined: Dec 30, 2003
Posts: 283


PostPosted: Sun Jun 13, 2004 3:11 pm Reply with quoteBack to top

The ones I know for now are here. I will add more if I find them (anyone else?).

Make sure your query cache is properly tuned, and that you have proper mysql startup settings for it. Some info here.

_________________
ezClassifieds|Forums:Auto,Mac,Job,Win,HW
Find all posts by steven111View user's profileSend private messageVisit poster's website
djmaze
Captain
Captain


Joined: Nov 29, 2003
Posts: 566

Location: Netherlands

PostPosted: Thu Jun 24, 2004 9:27 am Reply with quoteBack to top

Code:
ALTER TABLE `cms_bbtopics` ADD INDEX topic_last_post_id (topic_last_post_id);
ALTER TABLE `cms_bbtopics` ADD INDEX topic_first_post_id (topic_first_post_id)


Actualy there are lots more, but i can't remember which Crying or Very sad
I will try to find them Wink

_________________
Famous people never give their signature Rolling Eyes
http://www.cpgnuke.com <- back online thanks to dedicatednow.com
Don't ask me to be admin on your site please Exclamation
Find all posts by djmazeView user's profileSend private messageVisit poster's website
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
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



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.056 Seconds - 216 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::