What is the average MyBB suppose to be when you refresh a thread page? Isnt 100 a lot? Some are duplicates of others up to 4-5 duplicates?
This is what the bottom of my page shows...Even though its not slow (like the page refreshes immediately), it seems wasteful.
Quote:Generated in 108 ms (21.00% PHP / 79.00% MySQL)
SQL Queries: 100 / Server Load: 0.05 / Memory Usage: 4.75 MB
[Advanced Details]
100 queries is a lot but it does also depend on the page, certain pages may require a lot of database information to perform properly. You definitely shouldn't be hitting 100 queries on an average page, that would suggest you have too many plugins IMO.
If you check the advanced details, what queries are they?
It could be Google SEO being bad at predicting that "possibly related threads" table. It links thread, author, last post, last poster profile, 10 of each... if you're unlucky each of these will be a query.
You can get rid of these queries by setting Google SEO URL to "lazy mode" but it will add cost in other places (Google SEO post-processes page content) and there's a chance of unprocessed URLs to appear in places. Google SEO also has a query limit setting, if you set it sufficiently low, it would simply stop and all remaining URLs on the page would not be SEO'ed (to be redirected when actually clicked).
Quote:If you check the advanced details, what queries are they?
Is there any safety issue in listing off exactly the whole advanced details? If so can a mod delete the code box.
---
theres usually around 60 sql querues on the index page, 80-ish on a forum listing page, and anywhere between 80-110 sql queries on an actual thread page (every thread).
and yes i have an absurd number of plugins installed and activated too
Active Plugins
Plugin Controls
PHP Files Cleaner (1)
Helps with finding and cleaning faulty PHP files that have BOM or redundant whitespace and may cause MyBB problems such as broken captcha image.
Configuration
Check files
Donate
Created by Destroy666 Deactivate
Awaiting Activation Message (1.8.0)
Shows a message to people awaiting activation by email or admin.
Created by Matt Rogowski Deactivate
Activate Users from Mod CP (1.1)
Allows Super Moderators and Administrators to activate user accounts from the Mod CP.
Created by Starpaul20 Deactivate
Admins can log into Users' accounts (1.2)
Allows admins to log into another user's account via their profile, and quickly swap back to their account via the Logout link.
Created by ZiNgA BuRgA Deactivate
Custom Code Tags (1.1)
Adds custom MyCode for python code, output, errors and inline code
Created by stranac Deactivate
Default message (1.6)
Plugin allows the administrator to determine the default message , thread message, in forum.
Created by Krzysztof "Supryk" Supryczyński Deactivate Uninstall
DVZ Random Avatars (1.1)
Assigns a Gravatar's randomly-generated abstract as an avatar on signup.
• Assign avatars to users with no avatar
• Remove Random Avatars
Created by Tomasz 'Devilshakerz' Mlynski Deactivate Uninstall
DVZ Shoutbox (2.3.1)
Lightweight AJAX chat.
Created by Tomasz 'Devilshakerz' Mlynski Deactivate Uninstall
Edit History Log (1.3)
Allows you to log all edits made to posts.
Created by Starpaul20 Deactivate Uninstall
Extended Useradmininfos (2.0.2)
This Plugin saves extended informations (Last IP-Adress, Operating system, Browser, ...) for every user and show this at the adminoptions on the profile of each user. Note privacy policy!
This plugin includes GeoLite data created by MaxMind, available from http://www.maxmind.com.
Created by Florian Berger Deactivate Uninstall
Fast Quote (1.2.0)
PayPal - The safer, easier way to pay online!This plugin provide very fast quote option - select text and click button! Quote has never been so easy!
Created by Lukasz "LukasAMD" Tkacz Deactivate Uninstall
Favorite Threads (1.1)
Allows your members to favorite threads to view in their User CP.
Created by Starpaul20 Deactivate Uninstall
Forum Age (1.0)
shows how old your forum is.
Created by Nasyr Deactivate
Google SEO (1.8.0)
Google Search Engine Optimization as described in the official Google's SEO starter guide. Please see the documentation for details.
404, Meta, Redirect, Sitemap and URL are enabled. (Configure)
Click to Revert changes to core files.
Created by Andreas Klauer Deactivate Uninstall
Usergroup Legend (1.2)
This mod will display the membergroups color legend under the list of online members.
Created by MyBB Romania Deactivate Uninstall
Memberships in Profile (1.0)
Displays what usergroups a user is in on their profile page.
Created by ZiNgA BuRgA Deactivate
Guest Warn (4.0)
Show an elegant warn for all guest of your forum.
Created by Clear Deactivate
Haz Spoiler (1.0)
Add [spoiler] tag
Created by Hazmole Deactivate
Hide Sigs and Website of New Users (1.2)
Hides the signatures and website links of users with low post counts, in an attempt to lessen impact of sig-link spammers.
Created by ZiNgA BuRgA Deactivate
Inline Success Messages (2.0)
Adds support for inline success messages globally instead of an (un)friendly redirection page.
Created by Shade Deactivate Uninstall
Mark Edited as Unread (1.0.1)
PayPal - The safer, easier way to pay online!This plugin marks edited posts as unread by change date, if the post is last in topic.
Created by Lukasz Tkacz Deactivate Uninstall
MinifyHTML (1.4)
(~ MinifyHTML settings ~)PayPal - The safer, easier way to pay online!
Removes unnecessary line breaks from website source code
Created by SvePu Deactivate
Moderation Actions Preview (1.1)
Displays moderation actions sorted by date in posts/announcements/profiles.
Configuration
Donate
Created by Destroy666 Deactivate Uninstall
Last User's Threads in Profile (1.00)
Created by AliReza_Tofighi Deactivate
MyFlood (1.3)
A plugin which allows you to prevent flooding through new posts and new threads per usergroup.
Created by Polarbear541 Deactivate Uninstall
My Insert Buttons (3.0.0)
Created by martec Deactivate Uninstall
My Insert Command (1.0.1)
Created by martec Deactivate Uninstall
MyProfile (1.2)
Enhances MyBB's default users profiles with comments, friend system and last visitors.
Created by TheGarfield Deactivate Uninstall
No Links Allowed (0.1)
This plugin used to deny posting links before reaching min. amount of posts.
Created by Yaldaram Deactivate
Note moderator (2.0)
Allow moderator to add simple note to each post.
Created by Krzysztof "Supryk" Supryczyński Deactivate Uninstall
Show the users that has been online today (2.0)
Shows the users that has been online within 24 hours.
Created by CraKteR Deactivate
OUGC Admin Post Edit (1.0)
Allows administrators to edit additional post data.
Created by Omar G. Deactivate Uninstall
Page Manager (1.5.2)
Allows you to manage additional pages.
Created by Sebastian Wunderlich Deactivate Uninstall
Template Conditionals (1.8)
Allows you to use PHP conditionals in templates. This is the "safe" variant of the PHP and Conditionals in Templates plugin.
Created by ZiNgA BuRgA Deactivate
Private Message Log (1.2)
Allows Administrators to view Private Messages sent on their board.
Created by Starpaul20 Deactivate
Portal Announcement Cut Off. (1.0)
It sets a minimum of characters for portal announcements.
Created by bubulang Deactivate
ProStats /proʊˈstæts/ (1.9.7)
Professional stats for MyBB. (Settings)
Created by SaeedGh and AliReza Tofighi Deactivate Uninstall
Redirect after registration (1.0)
Redirect to your new members to a custom url after registration.
Created by Dark Neo Deactivate
Related Threads (1.0.1)
PayPal - The safer, easier way to pay online!This plugin checks to see if there are already similar threads when we write new topic (using AJAX).
Created by Lukasz "LukasAMD" Tkacz Deactivate Uninstall
Rin Editor (0.8.9)
Rin Editor (Powerd by CKEditor) PayPal - The safer, easier way to pay online!
Created by martec Deactivate Uninstall
Settings Cleaner (2.0)
Keeps your settings organized
Created by Nickman Deactivate
Referral in Profile (1.1)
This plugin displays the user's referrals in their profiles.
Created by Jeff Chan Deactivate Uninstall
Like System (2.0.0)
A simple post like system.
Created by euantor Deactivate Uninstall
Smashable Christmas Lights (1.0)
Displays christmas lights on the top of your forum. You can even smash them with or without sound effects!
This plugin based on the christmaslights script by Scott Schiller.
Created by SvePu Deactivate Uninstall
Disable Special Characters in Usernames (1.4)
Only allows users to sign up with usernames container letters, numbers and the underscore (_) character.
Created by ZiNgA BuRgA Deactivate
Tagging Plugin! (1.3.4)
Allows you to tag other users in your posts
Created by flash.tato Deactivate Uninstall
Thread Tooltip Preview (1.33)
Allows users to preview the content of a thread via a tooltip, similar to vBulletin.
Created by ZiNgA BuRgA Deactivate Uninstall
Thread Link (1.2)
Allows you to set a url that a thread will redirect to.
Created by Jammerx2 Deactivate
Trash Bin (1.1.2)
Moves all permanently deleted threads to a trashbin for 60 days
Created by S. Lenders Deactivate Uninstall
View Unanswered Posts (1.5)
PayPal - The safer, easier way to pay online!This plugin adds a function to search topic without any replies (unanswered posts).
Created by Lukasz Tkacz Deactivate Uninstall
Undo Delete (1.2.1)
Allows you to restore deleted threads, posts, polls and attachments.
Created by Sebastian Wunderlich Deactivate Uninstall
View Unread Posts (1.5)
This plugin add a "view unread posts" function for all registered users.
Created by Lukasz Tkacz Deactivate Uninstall
Users Browsed Topic (1.3.0)
This plugin show users who browsed thread.
Created by Lukasz Tkacz Deactivate Uninstall
Word Block (2.0)
Block specific words from being posted on your forum. Click here to run the update script.
Created by Mark Janssen Deactivate Uninstall
YourCode (2.1)
Forget MyCode. Take control of YourCode's more powerful way to manage custom BB codes and even the internally cached MyCodes.
Manage YourCode
PayPal - The safer, easier way to pay online!
PayPal - The safer, easier way to pay online!
Created by Wildcard
Templates Requiring Additional Calls showed the names of 16 templates that were not cached by their plugins, contributing to the number of queries.
There was a large amount of queries fetching user data, likely caused by
Tagging Plugin! (you can verify that by viewing a post with a large number of mentioned users) - see if alternatives like
DVZ Mentions,
MentionMe fit your needs.
(2017-08-09, 02:08 PM)Devilshakerz Wrote: [ -> ]Templates Requiring Additional Calls showed the names of 16 templates that were not cached by their plugins, contributing to the number of queries.
There was a large amount of queries fetching user data, likely caused by Tagging Plugin! (you can verify that by viewing a post with a large number of mentioned users) - see if alternatives like DVZ Mentions, MentionMe fit your needs.
I dont think i have seen someone in a long time use tagging. Does the tag have to be in the thread loaded to activate that template? All the threads i have checked no one has tags users. I disabled hte tagging plugin and tried again, but this time i got 116 queries. Seemed like the same number of mybb_users calls as before.
does the additional calls mean there is nothing to do due to the plugin not caching them then?
There is about 35 google SEO calls.
(2017-08-09, 02:18 PM)metulburr Wrote: [ -> ] (2017-08-09, 02:08 PM)Devilshakerz Wrote: [ -> ]Templates Requiring Additional Calls showed the names of 16 templates that were not cached by their plugins, contributing to the number of queries.
There was a large amount of queries fetching user data, likely caused by Tagging Plugin! (you can verify that by viewing a post with a large number of mentioned users) - see if alternatives like DVZ Mentions, MentionMe fit your needs.
I dont think i have seen someone in a long time use tagging. Does the tag have to be in the thread loaded to activate that template? All the threads i have checked no one has tags users. I disabled hte tagging plugin and tried again, but this time i got 116 queries. Seemed like the same number of mybb_users calls as before.
You can try deactivating other plugins in the same way.
Quote:does the additional calls mean there is nothing to do due to the plugin not caching them then?
These plugins would have to be modified for optimal performance (hook into
global_start and add the template names that will be used to the global
$templatelist variable - the core will preload them in a single query).