Previous Thread
Next Thread
Print Thread
Rate Thread
btripp #211158 10/10/2001 3:05 AM
Joined: Aug 2001
Posts: 8
User
User
Offline
Joined: Aug 2001
Posts: 8
I'm going to second this and add to it a little. I'd like to see a very strong focus on improving performance for the software and more of a focus on helping people optimize their servers. I've been lurking around on vbulletin's site and it seems there are more than a few sites over there that hit 500-800 users online (some at peak others pretty continuous) and it does appear they are doing this on one box, many running other sites on the servers as well. I realize they don't have the threaded option, but frankly with w3t it seems like if you have more than 100 users online the suggestion is to buy a second server. Honestly, I don't think that's an acceptable answer (please excuse my frankness here).

We have a pretty beefy box and it's the forums that kill us, no question. We recently installed a second mysql binary specifically for the forums and when we get any sort of load on the forums and watch the CPU usage jump up to 80%+ in a heartbeat for that mysql daemon. It doesn't take much to get it there. And the number of queries per second is just crazy.

I'd really like to see you spend monster time (or hire a mysql guru) to really look at the structure of the database and tables, the relationships between everything and all the queries the system produces to really trick out this bad boy. Right now it's generating way way way too many queries, especially in the threaded areas. And what I see regulary in the slow query log are really just three or four of the queries that come in over and over again. And have options in the config and setup for things like multiple tables for forum posts using categories to group them in tables where they will improve performance by splitting up things like that. I think a goal of achieving something like 500 (recurring) to 750 (peak) users online on a single server, of course with certain parameters set (ie intel based hardware platform, o/s, mysql binary version, table types, specific my.cnf options, etc..) that can be recreated by your customers is not an unrealistic one.

Just my $0.02

Sponsored Links
Entire Thread
Subject Posted By Posted
What's next? Rick 07/31/2001 4:30 AM
Re: What's next? santana 07/31/2001 5:11 AM
Re: What's next? The Team 07/31/2001 5:15 AM
Re: What's next? The Team 07/31/2001 5:17 AM
Re: What's next? bmh 07/31/2001 6:21 AM
Re: What's next? algorithms 07/31/2001 7:08 AM
Re: What's next? Lecter 07/31/2001 7:44 AM
Re: What's next? WolfUK 07/31/2001 8:10 AM
Re: What's next? Babul 07/31/2001 8:20 AM
Re: What's next? flint 07/31/2001 8:23 AM
Cross reference roger20 07/31/2001 8:59 AM
Re: What's next? Babul 07/31/2001 9:35 AM
Re: What's next? mcasassus 07/31/2001 9:39 AM
Re: What's next? dannylin 07/31/2001 9:43 AM
Re: What's next? The Team 07/31/2001 10:27 AM
Something wrong with previous post! Eileen 07/31/2001 10:29 AM
Re: What's next? Eileen 07/31/2001 10:32 AM
Re: What's next? The Team 07/31/2001 11:17 AM
Re: What's next? patagon 07/31/2001 11:34 AM
Re: What's next? Maze 07/31/2001 11:56 AM
store the markup codes.... rgranger 07/31/2001 12:18 PM
Re: Something wrong with previous post! razvan 07/31/2001 12:37 PM
Re: What's next? WolfUK 07/31/2001 12:44 PM
Re: What's next? avolia 07/31/2001 12:48 PM
Re: What's next? The Team 07/31/2001 1:20 PM
Re: What's next? hatter 07/31/2001 1:58 PM
Moderation The Team 07/31/2001 2:11 PM
Re: What's next? ehill 07/31/2001 2:25 PM
Re: What's next? bgroman 07/31/2001 2:58 PM
Re: What's next? Pilgrim 07/31/2001 3:24 PM
Re: HUMOR: suggestion The Team 07/31/2001 3:25 PM
Re: Archive / History The Team 07/31/2001 3:30 PM
Re: What's next? lpa 07/31/2001 3:58 PM
Re: What's next? MTO 07/31/2001 4:31 PM
Re: What's next? Rick 07/31/2001 4:43 PM
Re: What's next? The Team 07/31/2001 4:43 PM
Re: What's next? The Team 07/31/2001 4:48 PM
Re: What's next? Gerrit 07/31/2001 5:10 PM
Re: What's next? The Team 07/31/2001 5:11 PM
Re: What's next? Muhammad 07/31/2001 5:17 PM
Re: What's next? Rick 07/31/2001 5:26 PM
Re: What's next? Muhammad 07/31/2001 5:30 PM
Re: What's next? Gerrit 07/31/2001 5:42 PM
Re: What's next? The Team 07/31/2001 6:38 PM
Re: What's next? The Team 07/31/2001 6:49 PM
Re: What's next? The Team 07/31/2001 7:10 PM
Easy New Icon Addition XanthViper 07/31/2001 7:13 PM
Re: store the markup codes.... Eileen 07/31/2001 7:18 PM
Re: What's next? Eileen 07/31/2001 7:26 PM
Re: What's next? Eileen 07/31/2001 7:57 PM
Re: What's next? jerry_st 07/31/2001 8:43 PM
Re: What's next? jerry_st 07/31/2001 8:57 PM
Re: What's next? Eileen 07/31/2001 9:13 PM
Modularity and plugins Sharif 07/31/2001 10:05 PM
Re: What's next? The Team 08/01/2001 1:45 AM
Re: What's next? dgermann 08/01/2001 1:51 AM
Re: Modularity and plugins Eileen 08/01/2001 2:22 AM
Re: What's next? Brewskie 08/01/2001 4:54 AM
Re: What's next? The Team 08/01/2001 6:03 AM
Re: What's next? Muhammad 08/01/2001 2:06 PM
Re: What's next? poil 08/01/2001 5:57 PM
Re: What's next? coloradok5 08/02/2001 8:38 PM
Using the IP to assign to group at registration kdp 08/03/2001 8:09 AM
Re: What's next? dannylin 08/04/2001 4:45 AM
Re: What's next? ScottCargill 08/05/2001 1:46 AM
Re: What's next? ktorbeck 08/05/2001 5:27 AM
Re: What's next? The Team 08/05/2001 6:54 AM
sorry for the delay, you have mail. rgranger 08/07/2001 3:03 AM
Re: sorry for the delay, you have mail. Eileen 08/07/2001 3:54 AM
Re: What's next? dannylin 08/07/2001 6:19 PM
Re: Required profile field & notice users. dannylin 08/09/2001 5:17 PM
Re: What's next? ktorbeck 08/17/2001 3:30 AM
Re: What's next? Eileen 08/17/2001 4:59 AM
Re: What's next? Gerrit 08/17/2001 8:43 AM
Re: What's next? Rick 08/17/2001 3:46 PM
Re: What's next? Gerrit 08/17/2001 4:17 PM
Re: What's next? Eileen 08/17/2001 5:06 PM
Re: What's next? Gerrit 08/17/2001 6:08 PM
Re: What's next? Eileen 08/17/2001 7:21 PM
Re: What's next? ktorbeck 08/18/2001 4:08 AM
Re: What's next? ktorbeck 08/18/2001 4:09 AM
Re: What's next? Eileen 08/18/2001 5:02 AM
Re: What's next? moondoggy 08/18/2001 6:06 AM
Re: What's next? martinB 08/20/2001 8:50 AM
Re: What's next? kcweb 09/15/2001 7:45 PM
Re: What's next? Rick 09/15/2001 10:46 PM
Re: What's next? Jim Osby 09/26/2001 2:07 AM
Re: What's next? Jhariden 10/02/2001 3:48 PM
Re: What's next? Eileen 10/02/2001 7:39 PM
Re: What's next? Datal 10/02/2001 7:45 PM
Re: What's next? Rick 10/03/2001 5:17 AM
Re: What's next? me_o_my 10/10/2001 10:05 AM

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,575
Posts293,931
Members13,823
Most Online6,139
Sep 21st, 2024
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,834
Greg Hard 4,625
Top Posters(30 Days)
Gizmo 1
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2025 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)