Previous Thread
Next Thread
Print Thread
Hop To
Anonymous
Unregistered
Anonymous
Unregistered
Apologies in advance if this post duplicates anything previous it's just I'm running a 6.2.1 Forum and I notice that the two previous queries relate to 6.4 so I'm not sure whether the same is applicable?

Basically my Forum has slowed up big time since Friday and my Host says there's nothing awol his end?

My Forum

How do I tell what's a Forum/Script/MySQL issue and what's Host-related (Not just this time but in the future as well)?

Can someone please re-post the list of tips to ensure a fast forum?

Also all this "add a &debug=1 to the end of any of the url's in your address bar and it will give you a full output of all the queries and where the slowdown is coming from, from the mysql portion or from the server itself.

Went way over my head. If someone could explain to me what the results mean I'd be grateful please?

Similarly (if relevant?) running sql command. What's that all about and how do I do it? <img border="0" title="" alt="[Confused]" src="images/icons/confused.gif" />

Thanks in desperation

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
When adding debug=1, your looking for the portion where it says how long each query took. Basically you're looking for any high number. Any query that takes over a second would be one that we'd want to look at closer.

Anonymous
Unregistered
Anonymous
Unregistered
Hi Rick
Thanks for that.

Did the following query and got a 1 on screen. Does this categorically mean the problem is with my Host?

Can you please remind me of the list of tips to ensure a fast forum?

Thanks

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Ahh, I should note that you will need to be logged in as an Administrator to see the full debugging text. If not, then it will only show you the 1 as you stated.

Anonymous
Unregistered
Anonymous
Unregistered
Okay I'm now getting a series of results ranging from
0.009 seconds
2.774 seconds
2.633 seconds
0.021 seconds
0.002 seconds
0.047 seconds
0.035 seconds
0.002 seconds
0.002 seconds
0.014 seconds
<img border="0" title="" alt="[Confused]" src="images/icons/confused.gif" />

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
What 2 queries are being ran when the execution time is over 2 seconds?

Anonymous
Unregistered
Anonymous
Unregistered
Query: SELECT COUNT(*) FROM w3t_Users WHERE U_Approved='yes' - 2.774 seconds

Query: SELECT U_Username , U_Number FROM w3t_Users WHERE U_Approved='yes' ORDER BY U_Number DESC LIMIT 0 , - 2.633 seconds.

Anonymous
Unregistered
Anonymous
Unregistered
<img border="0" title="" alt="[Confused]" src="images/icons/confused.gif" />

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Those 2 queries are one of the reasons that we put those into the cache for 6.4. There's really nothing that can be done for that version beyond turning off the newuser and total users queries and display.

Anonymous
Unregistered
Anonymous
Unregistered
For arguments sake, have you optimized the db lately?

Anonymous
Unregistered
Anonymous
Unregistered
Rick- If my Host is to blame for the lack of speed in your valued opinion will an upgrade to 6.4 make "that" much difference?

Also can you please elaborate or point me in the direction on more info. on "turning off the newuser and total users queries and display". <img border="0" title="" alt="[Confused]" src="images/icons/confused.gif" />

J.C.
optimized the db lately?
Can you advise how I do that please?

Thanks in anticipation

Anonymous
Unregistered
Anonymous
Unregistered
Well hopefully your host has done it here and there, otherwise.. Yikes..

Look in the admin panel for DB Management. In this section you should see "Optimize Tables".
Click it and follow the text you see after the new page loads. <img border="0" title="" alt="[Smile]" src="images/icons/smile.gif" />

Joined: Dec 2003
Posts: 19
M
stranger
stranger
M Offline
Joined: Dec 2003
Posts: 19
I've optimised the Database as suggested.
Any other tips please for maximising my Forum Speed? <img src="https://www.ubbcentral.com/boards/images/graemlins/confused.gif" alt="" /> <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />

Joined: Jun 2006
Posts: 742
enthusiast
enthusiast
Joined: Jun 2006
Posts: 742
Tips that can reduce the load on your MySQL Server:
  • Use partial new post tracking instead of full new post tracking in your config file.
  • Set the theme file to show a smaller number of topics per page on the postlist screen and smaller number of posts to be shown in flat mode (recommend 10 each). This will reduce the load that anonymous users have on the forum.
  • If your theme file was set to a large number of posts per page - you can update all existing members to a lower amount with this query:
    (Backup your database first)
    UPDATE w3t_Users
    SET U_PostsPer = 10,
    U_FlatPosts = 10

    Users can still select a higher amount in their display prefs, but for the masses this can reduce the overall load.
  • adjust the settings of each forum to show a reduced range of topics. Example if they are all set to show "all topics" - set each forum to show only topics from the last 30 days etc...


Joshua Pettit
Web Developer
www.ThreadsDev.net | www.JoshuaPettit.com
Joined: Dec 2003
Posts: 19
M
stranger
stranger
M Offline
Joined: Dec 2003
Posts: 19
Thanks Josh


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 (Gizmo, Nightcrawler), 553 guests, and 186 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)