Previous Thread
Next Thread
Print Thread
Hop To
#203271 12/14/2007 7:29 AM
Joined: Dec 2007
Posts: 4
R
stranger
stranger
R Offline
Joined: Dec 2007
Posts: 4
My forum is running very slow. Sometimes it takes so much time and after that it shows the page and sometime not. I think mysql query is running slow because html pages are displaying without delay but php are not? So please tell how to fix this problem?

raukb5 #203272 12/14/2007 7:51 AM
Joined: Aug 2006
Posts: 1,358
Y
Veteran
Veteran
Y Offline
Joined: Aug 2006
Posts: 1,358
Did you turn on the debugging information? It will show MySQL performance data on the bottom of the forum, like Generated in 0.032 seconds in which 0.003 seconds were spent on a total of 13 queries. Zlib compression enabled..

What times are displayed there?


[Linked Image from siemons.org]
Yarp #203275 12/14/2007 1:00 PM
Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
raukb5 - if you let us know the url of your site (it is not in you profile), we can have a look to see if it is slow for us smile

Ian #203292 12/15/2007 1:06 AM
Joined: Dec 2007
Posts: 4
R
stranger
stranger
R Offline
Joined: Dec 2007
Posts: 4
my site url is http://www.fishingminnesota.com/forum/ubbthreads.php.

Generated in 280.863 seconds in which 278.367 seconds were spent on a total of 9 queries.

Last edited by raukb5; 12/15/2007 1:50 AM.
raukb5 #203295 12/15/2007 5:29 AM
Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
Hi,

Your site responded fine to me - I had no issues viewing the forums.

I did notice you are on 6.4.4 - I would recommend upgrading to a later version smile

Ian #203296 12/15/2007 6:00 AM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I too am not having any speed issues accessing your site; in fact, it seems quite fast


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #203547 12/19/2007 12:00 PM
Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
It is quite fast in the off hours. However, during the day it has frequent slow downs. We suspect it has something to do with the search function and our high number of users during peak times.

Any suggestions?

On a side note we are prepared to upgrade which has been a painful process in the past. Hopefully this time it goes better.

Any tips for a better upgrade process?

Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
are you on a shared or dedicated server - if shared then it might be due to activity on other sites.

Ian #203552 12/19/2007 12:54 PM
Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
It's a dedicated server and most likley the search function is causing the slowdown according to MySQL log here: mysql/fishing-slow.log

Can we limit the search function?

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
in 7.3, it will be much faster and much less CPU drain.

SD #203567 12/19/2007 5:00 PM
Joined: Jan 2006
Posts: 53
H
journeyman
journeyman
H Offline
Joined: Jan 2006
Posts: 53
I take it we can't limit the search function?

Joined: Jul 2006
Posts: 2,143
Pooh-Bah
Pooh-Bah
Joined: Jul 2006
Posts: 2,143
Have you taken the time to tune MySQL yet?

The search uses a fulltext index, in the version just going into beta this is changed. At the moment there isn't a lot you can do with it except edit the templates to remove some options.


This thread for sale. Click here! [Linked Image from navaho.infopop.cc]
David Dreezer #203584 12/19/2007 8:50 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
A lot of people neglect tuning apache as well... Most use the default settings and completely neglect it...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #203590 12/19/2007 9:09 PM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
why don't you post an apache tuning dealio in the tutorials forum.. you are the nix guru.. go for it..

SD #203591 12/19/2007 9:13 PM
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Well, what I know is not really comprehensive so what I know would be miniscule in means of an actual useful article... Mainly, most people neglect to set their max servers from the default...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Gizmo #205103 01/18/2008 9:15 AM
Joined: Jul 2006
Posts: 62
C
journeyman
journeyman
C Offline
Joined: Jul 2006
Posts: 62
C'mon, who's doing the apache tuning article!


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
2 members (Havenofsobriety, rootman), 624 guests, and 106 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)