Previous Thread
Next Thread
Print Thread
Rate Thread
#271857 04/02/2004 1:29 AM
Joined: Jan 2004
Posts: 10
Newbie
Newbie
Offline
Joined: Jan 2004
Posts: 10
3 x mirror smart load balanced web servers
1 x MySQL db server 4G 64-bit Opterons
2000 simultaneous boards users pretty much caps it.

What can I do?

skip-locking
key_buffer = 1536M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 8M
read_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 128M
max_connections = 1500

# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 4

Sponsored Links
Joined: Oct 2001
Posts: 213
Member
Member
Offline
Joined: Oct 2001
Posts: 213
"4G 64-bit Opterons"

???? Is that 4GB RAM or 4 64-bit Opterons?

How much RAM do you have?

Do you have any stats from running mysqladmin extended-status?

Do you have other applications using MySQL?

JoshPet #271859 04/02/2004 9:47 AM
Joined: Jan 2004
Posts: 10
Newbie
Newbie
Offline
Joined: Jan 2004
Posts: 10
4G of RAM. 2 proc Opterons. We are probably going to take the db server to 12G RAM if that will help, but I haven't started hitting swap yet with the current MySQL configuration. I actually saw a load of 70 last night, but the machine recovered fine when the user number went down.

Catshadow #271860 04/02/2004 10:05 AM
Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
Remember that MySQL is only one component. You should have a look at the webserver configuration also.

I think that using a second db-server and some kind of replication and load balacing will be better than just increasing the RAM. Getting a load ~ 70 without swapping lets me suppose that the RAM isn't the current bottleneck.

-Fusion- #271861 04/02/2004 11:19 AM
Joined: Jan 2004
Posts: 10
Newbie
Newbie
Offline
Joined: Jan 2004
Posts: 10
All the servers in the web cluster perform fine. They run at less than .50 load. What should I look at in the web config?

Is Threads replication aware? I was reading through the MySQL replication documentation and it says that the app has to know to read from the slaves and write to the master.

Anyone know what some of the biggest Threads boards are (simultaneous users)? It would be cool to know what they run.

Sponsored Links
Joined: Dec 2000
Posts: 1,471
Addict
Addict
Offline
Joined: Dec 2000
Posts: 1,471
I can't give you any specific advises without knowing details about your infrastructure.


ubb.Threads doesn't support MySQL replication builtin, but it's possible. I developed that for a client some time ago. If you're interested in that, just drop me am PM or email.

2000 simultaneous users is quite much, how many posts do you have in your database? I know some boards with about 2mio posts and up to 1000 users online.

Your keybuffer is very high, you should lower it. No table in ubb.threads has such large keys. Better define join_buffer and read_round buffer instead.

-Fusion- #271863 04/02/2004 2:00 PM
Joined: Jan 2004
Posts: 10
Newbie
Newbie
Offline
Joined: Jan 2004
Posts: 10
Currently 143K posts.


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
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
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,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)