Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Feb 2002
Posts: 8
Joined: Feb 2002
Posts: 8
We're having a bit of a nightmare. We have three ubb.threads installations on a server. Two are fine, but the big and most trafficed board has a lot of issues.

We get very long query times, sometimes like 10 minutes to generate a page. But mostly the hold ups are about 60 seconds. Very sporadic too. I disabled search and had a period of tranquility, no issues at all. Then bham it did it again.

Sometimes, probably related, we get a ton of sleeping proceses, like it goes up to 600. IO wait shoots up, server load goes up and then apache often wigs out.

I would appreciate it very much if anyone could advise on mySQL settings. I'd like to perfect them as much as possible.

It's a 4 CPU machine. 2GB of RAM. The main board is highly trafficed, generally about 400 - 800 users using it any one time. We do run other sites on the server, so SQL can't be too greedy. But as you can see, it is important in terms of where the server load is lying.

I realize I don't really post here, despite being a member for a long time. I'm concious of being one of those people that comes in, gets what they want then goes. But I'm hoping you guys can help me out none the less. (If I was more compentent, I'd contribute!)

These are the current numbers:

set-variable = key_buffer=640M
set-variable = max_allowed_packet=16M
set-variable = table_cache=1024
set-variable = sort_buffer=16M
set-variable = read_buffer_size=2M
set-variable = record_buffer=6M
set-variable = myisam_sort_buffer_size=128M
set-variable = thread_cache=16
# Try number of CPU's*2 for thread_concurrency
set-variable = thread_concurrency=8
set-variable = max_connections=512
#log-slow-queries = /var/log/slow_queries.log

Sponsored Links

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
Visit us on Facebook
Member Spotlight
Posts: 190
Joined: June 2000
Forum Statistics
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,832
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 81
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-2023 VNC Web Services

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