Previous Thread
Next Thread
Print Thread
Rate Thread
Boards going slow. Might be a MySQL issue. #285148
05/05/2005 12:53 PM
05/05/2005 12:53 PM
Joined: May 2005
Posts: 4
M
Musicarl Offline OP
Lurker
Musicarl  Offline OP
Lurker
M
Joined: May 2005
Posts: 4
Hi all.

We're running UBB 6.2.2 with a lot of customization that has kept us from upgrading. We're on a good dedicated server with 2 Gigs of RAM. We have over 40,000 users, but only about 1000 have used the message boards (our users for our main site are automatically registered on the boards). There are usually 10-25 people online.

Many times, our boards are very slow. The processess back up and things grind to a halt. We get a lot of overhead in our w3t_users table, and it helps when we Optimize, but they slow down again quickly.

About a week ago, I rebooted the whole server and the boards were great for almost 3 days. They were fast and happy. Then, they started slowing down again. I'd rather not reboot the whole server every few days, so if anyone has ideas on what we can do to narrow it down and solve the problem, please let me know. Our hosting company tells me MySQL has been sluggish on a lot of forums lately.

Thanks,
Carl
www.songfacts.com

Sponsored Links
Re: Boards going slow. Might be a MySQL issue. [Re: bigjoeyc] #285149
05/05/2005 1:33 PM
05/05/2005 1:33 PM
Joined: Oct 2003
Posts: 2,409
Richmond, VA
scroungr Offline
Old Hand
scroungr  Offline
Old Hand
Joined: Oct 2003
Posts: 2,409
Richmond, VA
[]Our hosting company tells me MySQL has been sluggish on a lot of forums lately.[/] Did they say why? Since it is not YOUR server and is the hosting companies, not much we can say will help you... Especially since THEY acknowledged a problem. Have they tweaked their MYSQL any? because since it is their server thats something only they can do? I would suggest to them that they move you to another server if they have one, to see if that helps you any.[/]

Re: Boards going slow. Might be a MySQL issue. [Re: 234234] #285150
05/05/2005 4:03 PM
05/05/2005 4:03 PM
Joined: Mar 2000
Posts: 25,587
Texas
AllenAyres Offline
I type Like navaho
AllenAyres  Offline
I type Like navaho
Joined: Mar 2000
Posts: 25,587
Texas
hmm.. you could point them to the 'tune mysql' topic here.


- Allen wavey
- What Drives You?
Re: Boards going slow. Might be a MySQL issue. [Re: SurfMinister] #285151
05/06/2005 1:55 AM
05/06/2005 1:55 AM
Joined: May 2005
Posts: 4
M
Musicarl Offline OP
Lurker
Musicarl  Offline OP
Lurker
M
Joined: May 2005
Posts: 4
Sorry about the confusion - we are on our own server. It's colocated hosting, so the box lives at the hosting company and they made the observation about boards on other servers as well.

I did read the thread on tuning MySQL, and it looks like our settings are in pretty good shape. I'm wondering if there's some kind of cache that clears out when the server is restarted that I can clear every so often.

Re: Boards going slow. Might be a MySQL issue. [Re: bigjoeyc] #285152
05/06/2005 4:16 AM
05/06/2005 4:16 AM
Joined: Sep 2000
Posts: 229
Asia
S
santana Offline
Member
santana  Offline
Member
S
Joined: Sep 2000
Posts: 229
Asia
I was using mySql 3.23 and it was upgraded it to 4.0. So far so good and very stable. A great improvement though.


...... x ......
Using UBBt 6.4.2 + Digg Ajax Mod, Trust Ajax Mod, Captcha Regristation & Login mod, Checkusername Ajax mode.
Sponsored Links

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
· Blue Host
· Interserver.net
Visit Us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,170
Joined: July 2001
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,448
Posts293,484
Members13,793
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 25,587
JoshPet 11,330
Rick 8,373
LK 7,396
Lord Dexter 6,503
Gizmo 5,938
Greg Hard 5,533
Top Posters(30 Days)
isaac 4
Today's Statistics
Currently Online 730
Topics Created 0
Posts Made 0
Users Online 2
Birthdays 21
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2018 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.6.2
(Preview build 20180611.dev)
Page Time: 0.061s Queries: 15 (0.022s) Memory: 3.2509 MB (Peak: 3.3971 MB) Zlib enabled. Server Time: 2018-06-22 07:16:07 UTC