nuke speed

Sergeant Joined: Jan 26, 2004 Posts: 81

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

Support Mod Joined: Mar 19, 2003 Posts: 308

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

Sergeant Joined: Jan 26, 2004 Posts: 81

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 .

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

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

Lieutenant Joined: Dec 30, 2003 Posts: 283

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

Lieutenant Joined: Dec 30, 2003 Posts: 283

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).

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

Steven111, which ones?

Lieutenant Joined: Dec 30, 2003 Posts: 283

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

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

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

Lieutenant Joined: Dec 30, 2003 Posts: 283

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.

Nuke Cops Founder Joined: Nov 14, 2002 Posts: 5939

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?

Lieutenant Joined: Dec 30, 2003 Posts: 283

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'];

Support Mod Joined: Mar 19, 2003 Posts: 308

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

greetings,

Bart

Lieutenant Joined: Dec 30, 2003 Posts: 283

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.

Posted: Thu Jun 24, 2004 9:27 am

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