Previous Thread
Next Thread
Print Thread
Rate Thread
#259756 10/02/2003 3:33 PM
Joined: Oct 2002
Posts: 71
Power User
Power User
Offline
Joined: Oct 2002
Posts: 71
First some background.

I've been running UBBThreads now for 8 months (upgraded from UBB that I ran for 4 years) and have the following:

site: TDIClub Forums ( By IP as we just moved the server )
Processor: Dual PIII 1.13GHZ system
Disks: Raid5 7200rpm IDE Drives
Ram: 2GB ECC
replies: 519400
topics: 61997
Users online (30min, not 10min): 100 logged in, 120-150 not
Load average: 0.79, 0.49, 0.58
Referer check disabled
persistent connections (same with them disabled)

from tweaked my.conf:
Code
 <br />set-variable    = key_buffer=64M <br />set-variable    = table_cache=1024 <br />set-variable    = sort_buffer=4M <br />set_variable    = read_buffer_size=2M <br />set-variable    = max_allowed_packet=1M <br />set-variable    = thread_stack=128K <br />


The problem is I still get varying results in performance.
Many queries will queries will give results in under a second, but more an more are taking longer. Like this one: I've recorded it taking 11.233 seconds, but most of the time its less than .2

Not sure what to do...I've had the main page take 20 seconds ones.

Thanks for any suggestions

Fred

PS, this doesn't always happen, I can track any sort of relationship with the slow downs, but they keep coming and going....

Sponsored Links
Entire Thread
Subject Posted By Posted
Mysql causing slowdowns? VWDerf 10/02/2003 10:33 PM
Re: Mysql causing slowdowns? msula 10/03/2003 12:07 AM
Re: Mysql causing slowdowns? VWDerf 10/03/2003 5:38 AM
Re: Mysql causing slowdowns? Astaran 10/03/2003 2:55 PM
Re: Mysql causing slowdowns? VWDerf 10/03/2003 4:21 PM
Re: Mysql causing slowdowns? Astaran 10/03/2003 4:42 PM
Re: Mysql causing slowdowns? VWDerf 10/03/2003 4:47 PM
Re: Mysql causing slowdowns? Astaran 10/03/2003 5:00 PM
Re: Mysql causing slowdowns? VWDerf 10/08/2003 3:20 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
Nettomo
Nettomo
Germany, Bremen
Posts: 417
Joined: November 2001
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
WebGuy 2
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 20240430)