MyBB Community Forums

MyBB Community Forums > 1.8 Support > General Support > slow loading speeds
Full Version: slow loading speeds
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2 3 4 5 6

metulburr

2018-02-14, 02:23 PM
My forum up to a couple weeks ago was quite fast. It would load pages almost instantaneous. A page would never take over 1 second.

Now i (and other users) have all of a sudden been getting slow loading speeds. Sometimes it takes 60 seconds to load. But most times it takes like 4 seconds. Which is dreadfully slow compared to normal. And whenever it takes 60 seconds is unbearable.

Im wondering if there is a common issue involved with MyBB? Ive tweaked the possible apache settings that is related to this problem and nothing has changed. Im wondering if there is some default setting or something going on the MyBB side of it.

My initial guess was the apache setting MaxKeepAliveRequests might of been set too low, but after inscreasing it, nothing changed. Is there a similar thing in MyBB setting?

When loading a page for 60 seconds, i checked on the server with HTOP, and only about 1/4 of the RAM is being used.


Quote:Generated in 14.373 seconds (64.58% PHP / 35.42% MySQL)

SQL Queries: 109 / Server Load: 18.23 / Memory Usage: 5.25 MB

Ive always had a lot of SQL queries, and its never taken that long. Before i could easily do 200 queries in under a second. Now it
Here is a debug info for a single thread load

MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 	28.262 seconds 	No. DB Queries: 	134
PHP Processing Time: 	18.138 seconds (64.18%) 	DB Processing Time: 	10.124 seconds (35.82%)
Extensions Used: 	mysqli, xml 	Global.php Processing Time: 	5.961 seconds
PHP Version: 	5.5.9-1ubuntu4.23 	Server Load: 	34.48
GZip Encoding Status: 	Disabled 	No. Templates Used: 	228 (213 Cached / 16 Manually Loaded)
Memory Usage: 	5.5 MB (5767168 bytes) 	Memory Limit: 	128M
Database Connections (1 Total)
[READ] mybbuser@localhost (Connected in 289 ms)

Database Queries (134 Total)
#1 - Select Query
SELECT title,cache FROM mybb_datacache
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_datacache 	ALL 					46 	
Query Time: 17 ms

#2 - Select Query
SELECT id FROM mybb_google_seo WHERE idtype=4 AND url='Is-This-Code-Ok-How-Can-I-Avoid-Using-Global-Variables'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype 	idtype 	363 	const,const 	1 	
Query Time: 24 ms

#3 - Select Query
SELECT subject,tid,prefix FROM mybb_threads WHERE tid IN (8309)
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_threads 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 3 ms

#4 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id<=8309 AND url IN ('Is-This-Code-Ok-How-Can-I-Avoid-Using-Global-Variables','Is-This-Code-Ok-How-Can-I-Avoid-Using-Global-Variables--8309') AND EXISTS(SELECT tid FROM mybb_threads WHERE tid=id) ORDER BY id ASC
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	range 	idtype,active 	idtype 	363 		2 	Using where; Using filesort
mybb_threads 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.mybb_google_seo.id 	1 	Using index
Query Time: 4 ms

#5 - Select Query
SELECT * FROM mybb_sessions WHERE sid='dbe8e80408aefc2a1f1fa6dc305af23c' AND ip=X'43f26b96'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_sessions 	const 	PRIMARY,ip 	PRIMARY 	98 	const 	1 	
Query Time: 8 ms

#6 - Select Query
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='1' LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
u 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
f 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 245 ms

#7 - Select Query
SELECT * FROM mybb_threads WHERE tid = '8309'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_threads 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 49 ms

#8 - Write Query
UPDATE mybb_sessions SET `uid`='1', `time`=1518618037, `location`='/showthread.php?tid=8309&amp;pid=39633&amp;debug=1', `useragent`='Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0', `location1`=8, `location2`=8309, `nopermission`=0 WHERE sid='dbe8e80408aefc2a1f1fa6dc305af23c'
Query Time: 76 ms

(Plugin Hook: global_start)
#9 - Select Query
SELECT * FROM mybb_announcement WHERE Global='1' AND Enabled='1' ORDER BY Sort
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_announcement 	ALL 					3 	Using where; Using filesort
Query Time: 9 ms

#10 - Select Query
SELECT fid FROM mybb_posts WHERE pid = '39633' LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_posts 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 22 ms

#11 - Select Query
SELECT name, tid, properties, stylesheets, allowedgroups FROM mybb_themes WHERE tid = '2' LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_themes 	const 	PRIMARY 	PRIMARY 	2 	const 	1 	
Query Time: 12 ms

#12 - Select Query
SELECT name FROM mybb_themestylesheets WHERE sid=21
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_themestylesheets 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 56 ms

#13 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'showthread' ,'postbit' ,'postbit_author_user' ,'postbit_author_guest' ,'showthread_newthread' ,'showthread_newreply' ,'showthread_newreply_closed' ,'postbit_avatar' ,'postbit_find' ,'postbit_pm' ,'postbit_www' ,'postbit_email' ,'postbit_edit' ,'postbit_quote' ,'postbit_report' ,'postbit_signature' ,'postbit_online' ,'postbit_offline' ,'postbit_away' ,'showthread_ratethread' ,'multipage' ,'multipage_breadcrumb' ,'multipage_end' ,'multipage_jump_page' ,'multipage_nextpage' ,'multipage_page' ,'multipage_page_current' ,'multipage_page_link_current' ,'multipage_prevpage' ,'multipage_start' ,'showthread_inlinemoderation_softdelete' ,'showthread_inlinemoderation_restore' ,'showthread_inlinemoderation_delete' ,'postbit_posturl' ,'postbit_icon' ,'postbit_editedby' ,'showthread_similarthreads' ,'showthread_similarthreads_bit' ,'postbit_iplogged_show' ,'postbit_iplogged_hiden' ,'postbit_profilefield' ,'showthread_quickreply' ,'showthread_add_poll' ,'showthread_send_thread' ,'showthread_poll_editpoll' ,'showthread_poll_undovote' ,'showthread_moderationoptions_standard' ,'postbit_editedby_editreason' ,'forumjump_advanced' ,'forumjump_special' ,'forumjump_bit' ,'postbit_reputation' ,'postbit_quickdelete' ,'postbit_attachments' ,'postbit_attachments_attachment' ,'postbit_attachments_thumbnails' ,'postbit_attachments_images_image' ,'postbit_attachments_images' ,'showthread_quickreply_options_stick' ,'showthread_quickreply_options_close' ,'attachment_icon' ,'postbit_inlinecheck' ,'showthread_inlinemoderation' ,'postbit_attachments_thumbnails_thumbnail' ,'postbit_ignored' ,'postbit_groupimage' ,'postbit_multiquote' ,'showthread_search' ,'showthread_moderationoptions_custom_tool' ,'showthread_moderationoptions_custom' ,'showthread_inlinemoderation_custom_tool' ,'showthread_inlinemoderation_custom' ,'showthread_usersbrowsing' ,'showthread_usersbrowsing_user' ,'showthread_poll_option_multiple' ,'showthread_poll_option' ,'showthread_poll' ,'showthread_quickreply_options_signature' ,'showthread_threaded_bitactive' ,'showthread_threaded_bit' ,'postbit_attachments_attachment_unapproved' ,'showthread_threadnotes' ,'showthread_threadnotes_viewnotes' ,'showthread_moderationoptions_openclose' ,'showthread_moderationoptions_stickunstick' ,'showthread_moderationoptions_delete' ,'showthread_moderationoptions_threadnotes' ,'showthread_moderationoptions_manage' ,'showthread_moderationoptions_deletepoll' ,'showthread_threadnoteslink' ,'showthread_poll_results' ,'showthread_classic_header' ,'postbit_warn' ,'postbit_userstar' ,'postbit_reputation_formatted_link' ,'postbit_warninglevel_formatted' ,'postbit_quickrestore' ,'forumdisplay_password' ,'forumdisplay_password_wrongpass' ,'postbit_classic' ,'postbit_purgespammer' ,'showthread_inlinemoderation_approve' ,'forumdisplay_thread_icon' ,'showthread_poll_resultbit' ,'postbit_warninglevel' ,'postbit_gotopost' ,'showthread_moderationoptions_softdelete' ,'showthread_moderationoptions_restore' ,'post_captcha' ,'post_captcha_recaptcha' ,'post_captcha_nocaptcha' ,'showthread_moderationoptions' ,'showthread_inlinemoderation_standard' ,'showthread_threadedbox' ,'postbit_rep_button' ,'showthread_inlinemoderation_manage' ,'global_moderation_notice' ,'postbit_edithistory' ,'showthread_favorite' ,'unreadPosts_link' ,'unreadPosts_counter' ,'unreadPosts_linkCounter' ,'unreadPosts_postbit' ,'' ,'simplelikes_likebutton' ,'simplelikes_likebar' ,'moderationactionspreview_ip' ,'moderationactionspreview_avatar' ,'moderationactionspreview_post' ,'moderationactionspreview_postbit_row' ,'prostats' ,'prostats_readstate_icon' ,'prostats_newmembers' ,'prostats_newmembers_row' ,'prostats_topposters' ,'prostats_topposters_row' ,'prostats_topthreadposters' ,'prostats_topthreadposters_row' ,'prostats_topreferrers' ,'prostats_topreferrers_row' ,'prostats_mostthanks' ,'prostats_mostthanks_row' ,'prostats_newestposts' ,'prostats_newestposts_row' ,'prostats_newestposts_specialchar' ,'prostats_mostreplies' ,'prostats_mostreplies_row' ,'prostats_mostviews' ,'prostats_mostviews_row' ,'prostats_topdownloads' ,'prostats_topdownloads_row' ,'prostats_mostreputation' ,'prostats_mostreputation_row' ,'prostats_message' ,'prostats_onerowextra' ,'prostats_tworowextra' ,'notemoderator_post' ,'notemoderator_normal' ,'notemoderator_information' ,'notemoderator_warn' ,'notemoderator_buttons' ,'notemoderator_postbit_button' ,'rinbutquick' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'error' ,'footer_languageselect_option' ,'footer_contactus' ,'global_pending_joinrequests' ,'global_awaiting_activation' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'footer_themeselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'header_menu_calendar' ,'nav_dropdown' ,'footer_themeselector' ,'task_image' ,'global_boardclosed_warning' ,'global_bannedwarning' ,'error_inline' ,'error_nopermission_loggedin' ,'error_nopermission' ,'debug_summary' ,'header_quicksearch' ,'header_menu_search' ,'header_menu_portal' ,'header_menu_memberlist' ,'usercp_themeselector_option' ,'smilie' ,'global_board_offline_modal' ,'video_dailymotion_embed' ,'video_facebook_embed' ,'video_liveleak_embed' ,'video_metacafe_embed' ,'video_myspacetv_embed' ,'video_veoh_embed' ,'video_vimeo_embed' ,'video_yahoo_embed' ,'video_youtube_embed') AND sid IN ('-2','-1','1') ORDER BY sid ASC
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	ALL 	sid 				1338 	Using where; Using filesort
Query Time: 178 ms

#14 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (1)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 34 ms

#15 - Select Query
SELECT tid, name, pid, allowedgroups FROM mybb_themes WHERE pid!='0'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_themes 	ALL 					5 	Using where
Query Time: 110 ms

(Plugin Hook: global_end)
#16 - Write Query
UPDATE mybb_users SET last_useragent='Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0' WHERE uid=1
Query Time: 190 ms

#17 - Select Query
SELECT threads, unapprovedthreads FROM mybb_forums WHERE fid = '8' LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_forums 	const 	PRIMARY 	PRIMARY 	2 	const 	1 	
Query Time: 50 ms

#18 - Select Query
SELECT COUNT(tid) as threads FROM mybb_threads WHERE fid = '8' AND (lastpost >= '1518617040' OR sticky=1) AND visible IN (-1,0,1) ORDER BY lastpost DESC
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_threads 	ref 	fid,lastpost 	fid 	2 	const 	4264 	Using where
Query Time: 142 ms

#19 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=3 AND id IN (7)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 169 ms

#20 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=3 AND id IN (8)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 36 ms

(Plugin Hook: showthread_start)
#21 - Select Query
SELECT tid FROM mybb_favorites WHERE tid='8309' AND uid='1' LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_favorites 	ref 	uid 	uid 	4 	const 	5 	Using where
Query Time: 137 ms

(Plugin Hook: showthread_start)
#22 - Write Query
REPLACE INTO mybb_threadsread_users SET tid = '8309', uid = '1', dateline = '1518618037'
Query Time: 64 ms

(Plugin Hook: showthread_start)
#23 - Select Query
SELECT * FROM mybb_announcement WHERE Global='' AND Enabled='1' ORDER BY Sort
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_announcement 	ALL 					3 	Using where; Using filesort
Query Time: 10 ms

(Plugin Hook: showthread_start)
#24 - Select Query
SELECT dateline FROM mybb_threadsread WHERE uid='1' AND tid='8309'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_threadsread 	const 	tid 	tid 	8 	const,const 	1 	
Query Time: 236 ms

(Plugin Hook: showthread_start)
#25 - Select Query
SELECT dateline FROM mybb_forumsread WHERE fid='8' AND uid='1'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_forumsread 	const 	fid 	fid 	8 	const,const 	1 	
Query Time: 48 ms

#26 - Select Query
SELECT * FROM mybb_posts WHERE pid = '39633'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_posts 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 230 ms

#27 - Select Query
SELECT COUNT(p.dateline) AS count FROM mybb_posts p WHERE p.tid = '8309' AND p.dateline <= '1518598992' AND p.visible IN (-1,0,1)
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
p 	range 	tid,visible,dateline,tiddate 	tiddate 	8 		1 	Using where
Query Time: 27 ms

#28 - Select Query
SELECT COUNT(*) AS replies FROM mybb_posts p WHERE p.tid='8309' AND p.visible IN (-1,0,1)
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
p 	ref 	tid,visible,tiddate 	tid 	4 	const 	5 	Using where
Query Time: 186 ms

#29 - Select Query
SELECT p.pid FROM mybb_posts p WHERE p.tid='8309' AND p.visible IN (-1,0,1) ORDER BY p.dateline LIMIT 0, 10
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
p 	ref 	tid,visible,tiddate 	tiddate 	4 	const 	5 	Using where
Query Time: 44 ms

#30 - Select Query
SELECT * FROM mybb_attachments WHERE pid IN('39633','39638','39639','39641','39654','39666','39667')
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_attachments 	range 	pid 	pid 	4 		7 	Using where
Query Time: 111 ms

#31 - Select Query
SELECT u.*, u.username AS userusername, p.*, f.*, eu.username AS editusername FROM mybb_posts p LEFT JOIN mybb_users u ON (u.uid=p.uid) LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) LEFT JOIN mybb_users eu ON (eu.uid=p.edituid) WHERE pid IN('39633','39638','39639','39641','39654','39666','39667') ORDER BY p.dateline
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
p 	range 	PRIMARY 	PRIMARY 	4 		7 	Using where; Using filesort
u 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.p.uid 	1 	
f 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.u.uid 	1 	
eu 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.p.edituid 	1 	
Query Time: 31 ms

#32 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (4190)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 31 ms

(Plugin Hook: postbit)
#33 - Select Query
SELECT template FROM mybb_templates WHERE title='fastQuote_button' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		3 	Using where
Query Time: 102 ms

(Plugin Hook: postbit)
#34 - Select Query
SELECT l.*, u.username, u.avatar, u.usergroup, u.displaygroup FROM mybb_post_likes l LEFT JOIN mybb_users u ON (l.user_id = u.uid) WHERE l.post_id IN('39633','39638','39639','39641','39654','39666','39667')
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
l 	range 	unique_post_user_id,post_id_index 	unique_post_user_id 	4 		7 	Using where
u 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.l.user_id 	1 	
Query Time: 7 ms

(Plugin Hook: postbit)
#35 - Select Query
SELECT p.uid, (SELECT COUNT(*) FROM mybb_post_likes l LEFT JOIN mybb_posts mp ON (l.post_id = mp.pid) WHERE mp.uid = p.uid) AS count FROM mybb_posts p WHERE pid IN('39633','39638','39639','39641','39654','39666','39667') GROUP BY p.uid
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
p 	range 	PRIMARY 	PRIMARY 	4 		7 	Using where; Using temporary; Using filesort
mp 	ref 	PRIMARY,uid 	uid 	4 	func 	11 	Using where
l 	ref 	unique_post_user_id,post_id_index 	unique_post_user_id 	4 	mybb2.mp.pid 	1 	Using where; Using index
Query Time: 39 ms

(Plugin Hook: postbit)
#36 - Select Query
SELECT dateline, pid FROM mybb_posts WHERE tid = 8309 AND visible IN(-1,0,1) ORDER BY dateline LIMIT 0, 10
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_posts 	ref 	tid,visible,tiddate 	tiddate 	4 	const 	5 	Using where
Query Time: 72 ms

(Plugin Hook: postbit)
#37 - Select Query
SELECT u.username, u.usergroup, u.displaygroup, u.avatar, u.avatardimensions, m.dateline, m.uid, m.action, m.pid FROM mybb_moderatorlog m LEFT JOIN mybb_users u ON(u.uid = m.uid) WHERE m.tid = 8309
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
m 	ref 	tid 	tid 	4 	const 	1 	
u 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.m.uid 	1 	
Query Time: 19 ms

(Plugin Hook: postbit)
#38 - Select Query
SELECT nm.*, u.uid, u.username, u.usergroup, u.displaygroup FROM mybb_notemoderator nm LEFT JOIN mybb_users u ON (nm.uid=u.uid) WHERE pid IN('39633','39638','39639','39641','39654','39666','39667') ORDER BY nm.dateline DESC
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
nm 	range 	pid 	pid 	4 		7 	Using where; Using filesort
u 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.nm.uid 	1 	
Query Time: 67 ms

#39 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (2662)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 97 ms

#40 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (9)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 189 ms

#41 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (6602)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 130 ms

#42 - Select Query
SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('Is This Code Ok? How Can I Avoid Using Global Variables?') AS relevance FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='8' AND t.tid!='8309' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('Is This Code Ok? How Can I Avoid Using Global Variables?') >= '5' ORDER BY t.lastpost DESC LIMIT 0, 10
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
t 	fulltext 	PRIMARY,fid,subject 	subject 	0 		1 	Using where; Using filesort
u 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.t.uid 	1 	
Query Time: 163 ms

#43 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8283)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 10 ms

#44 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (6668)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 100 ms

#45 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (7487)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 23 ms

#46 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (6256)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 7 ms

#47 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (7290)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 97 ms

#48 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (6260)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 79 ms

#49 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (7132)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 9 ms

#50 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (5402)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 15 ms

#51 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (6566)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 114 ms

#52 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (3323)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 62 ms

#53 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (6207)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 165 ms

#54 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (3)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 88 ms

#55 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (3313)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 113 ms

#56 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (5976)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 24 ms

#57 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (3761)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 70 ms

#58 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (4524)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 217 ms

#59 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (21)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 34 ms

#60 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (2019)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 173 ms

#61 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (4041)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 42 ms

#62 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (50)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 9 ms

#63 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (666)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 162 ms

#64 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (3357)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 17 ms

#65 - Select Query
SELECT pid FROM mybb_posts WHERE tid='8309' ORDER BY pid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_posts 	ref 	tid,tiddate 	tid 	4 	const 	5 	Using where; Using filesort
Query Time: 122 ms

#66 - Select Query
SELECT tid, name, type FROM mybb_modtools WHERE (CONCAT(',',forums,',') LIKE '%,8,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND (groups='' OR CONCAT(',',groups,',') LIKE '%,-1,%' OR CONCAT(',',groups,',') LIKE '%,4,%')
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_modtools 	ALL 					11 	Using where
Query Time: 95 ms

#67 - Select Query
SELECT tid FROM mybb_threadsubscriptions WHERE tid='8309' AND uid='1' LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_threadsubscriptions 	ref 	uid,tid 	tid 	4 	const 	1 	Using where
Query Time: 232 ms

#68 - Select Query
SELECT s.ip, s.uid, s.time, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time > '1518617737' AND location2='8309' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
s 	range 	time 	time 	4 		33 	Using where; Using temporary; Using filesort
u 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.s.uid 	1 	
Query Time: 610 μs

(Plugin Hook: pre_output_page)
#69 - Select Query
SELECT tu.uid, tu.username, tu.usergroup, tu.displaygroup, tubt.dateline FROM mybb_threadsread_users AS tubt INNER JOIN mybb_users AS tu ON tubt.uid = tu.uid WHERE tubt.tid = '8309' ORDER BY username ASC
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
tubt 	ref 	tid 	tid 	4 	const 	7 	Using temporary; Using filesort
tu 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.tubt.uid 	1 	
Query Time: 56 ms

(Plugin Hook: pre_output_page)
#70 - Select Query
SELECT template FROM mybb_templates WHERE title='usersBrowsedUser' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		3 	Using where
Query Time: 12 ms

(Plugin Hook: pre_output_page)
#71 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (7)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 74 ms

(Plugin Hook: pre_output_page)
#72 - Select Query
SELECT template FROM mybb_templates WHERE title='usersBrowsed' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		3 	Using where
Query Time: 27 ms

(Plugin Hook: pre_output_page)
#73 - Select Query
SELECT 1 FROM mybb_threads WHERE replies = 0 AND visible = 1 AND closed NOT LIKE 'moved|%' LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_threads 	ALL 					6947 	Using where
Query Time: 16 ms

(Plugin Hook: pre_output_page)
#74 - Select Query
SELECT template FROM mybb_templates WHERE title='unansweredPosts_link' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		3 	Using where
Query Time: 35 ms

(Plugin Hook: pre_output_page)
#75 - Select Query
SELECT * FROM mybb_moderators WHERE ((id IN (4) AND isgroup='1') OR (id='1' AND isgroup='0'))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
							Impossible WHERE noticed after reading const tables
Query Time: 25 ms

(Plugin Hook: pre_output_page)
#76 - Select Query
SELECT t.subject,t.username,t.uid,t.tid,t.fid,t.lastpost,t.lastposter,t.lastposteruid,t.replies,t.visible,tr.uid AS truid,tr.dateline,tp.displaystyle AS styledprefix,f.name FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_threadprefixes tp ON (tp.pid = t.prefix) LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE (t.visible = '1' OR '1'='1' ) AND t.fid NOT IN ('30','28','29') AND t.closed NOT LIKE 'moved|%' AND t.visible != '-2' AND f.active = '1' ORDER BY t.lastpost DESC LIMIT 0,11
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
t 	index 	fid 	lastpost 	6 		11 	Using where
tr 	eq_ref 	tid 	tid 	8 	mybb2.t.tid,const 	1 	
tp 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.t.prefix 	1 	
f 	eq_ref 	PRIMARY 	PRIMARY 	2 	mybb2.t.fid 	1 	Using where
Query Time: 7 ms

(Plugin Hook: pre_output_page)
#77 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_latest_posts' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		3 	Using where
Query Time: 8 ms

(Plugin Hook: pre_output_page)
#78 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_date' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		3 	Using where
Query Time: 75 ms

(Plugin Hook: pre_output_page)
#79 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_starter' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		4 	Using where
Query Time: 31 ms

(Plugin Hook: pre_output_page)
#80 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_last_sender' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		4 	Using where
Query Time: 23 ms

(Plugin Hook: pre_output_page)
#81 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_forum' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		4 	Using where
Query Time: 40 ms

(Plugin Hook: pre_output_page)
#82 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8306)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 28 ms

(Plugin Hook: pre_output_page)
#83 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '2019'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 22 ms

(Plugin Hook: pre_output_page)
#84 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '9'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 1 ms

(Plugin Hook: pre_output_page)
#85 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=3 AND id IN (10)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 24 ms

(Plugin Hook: pre_output_page)
#86 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_latest_posts' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		3 	Using where
Query Time: 10 ms

(Plugin Hook: pre_output_page)
#87 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_date' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		3 	Using where
Query Time: 64 ms

(Plugin Hook: pre_output_page)
#88 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_starter' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		4 	Using where
Query Time: 24 ms

(Plugin Hook: pre_output_page)
#89 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_last_sender' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		4 	Using where
Query Time: 35 ms

(Plugin Hook: pre_output_page)
#90 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_forum' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		4 	Using where
Query Time: 83 ms

(Plugin Hook: pre_output_page)
#91 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '4190'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 48 ms

(Plugin Hook: pre_output_page)
#92 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '9'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 35 ms

(Plugin Hook: pre_output_page)
#93 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8274)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 50 ms

(Plugin Hook: pre_output_page)
#94 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '7291'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 4 ms

(Plugin Hook: pre_output_page)
#95 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (7291)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 38 ms

(Plugin Hook: pre_output_page)
#96 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '7291'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 19 ms

(Plugin Hook: pre_output_page)
#97 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8314)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 94 ms

(Plugin Hook: pre_output_page)
#98 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 21 ms

(Plugin Hook: pre_output_page)
#99 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '7'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 2 ms

(Plugin Hook: pre_output_page)
#100 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=3 AND id IN (26)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 16 ms

(Plugin Hook: pre_output_page)
#101 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8285)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 195 ms

(Plugin Hook: pre_output_page)
#102 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '7465'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 29 ms

(Plugin Hook: pre_output_page)
#103 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (7465)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 12 ms

(Plugin Hook: pre_output_page)
#104 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '7465'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 8 ms

(Plugin Hook: pre_output_page)
#105 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8304)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 33 ms

(Plugin Hook: pre_output_page)
#106 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '7153'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 24 ms

(Plugin Hook: pre_output_page)
#107 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (7153)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 210 ms

(Plugin Hook: pre_output_page)
#108 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '50'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 5 ms

(Plugin Hook: pre_output_page)
#109 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=3 AND id IN (13)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 8 ms

(Plugin Hook: pre_output_page)
#110 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8305)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 36 ms

(Plugin Hook: pre_output_page)
#111 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '3470'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 46 ms

(Plugin Hook: pre_output_page)
#112 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (3470)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 219 ms

(Plugin Hook: pre_output_page)
#113 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '50'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 35 ms

(Plugin Hook: pre_output_page)
#114 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8307)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 320 ms

(Plugin Hook: pre_output_page)
#115 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '7488'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 446 ms

(Plugin Hook: pre_output_page)
#116 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (7488)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 3 ms

(Plugin Hook: pre_output_page)
#117 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '50'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 3 ms

(Plugin Hook: pre_output_page)
#118 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=3 AND id IN (31)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 20 ms

(Plugin Hook: pre_output_page)
#119 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8313)))
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_google_seo 	const 	idtype,active 	active 	7 	const,const,const 	1 	
Query Time: 26 ms

(Plugin Hook: pre_output_page)
#120 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '6335'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 37 ms

(Plugin Hook: pre_output_page)
#121 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '6335'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 8 ms

(Plugin Hook: pre_output_page)
#122 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '6431'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 24 ms

(Plugin Hook: pre_output_page)
#123 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '50'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 360 μs

(Plugin Hook: pre_output_page)
#124 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '7489'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 69 ms

(Plugin Hook: pre_output_page)
#125 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '5'
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	const 	PRIMARY 	PRIMARY 	4 	const 	1 	
Query Time: 11 ms

(Plugin Hook: pre_output_page)
#126 - Select Query
SELECT username,threadnum,uid,usergroup,displaygroup FROM mybb_users ORDER BY threadnum DESC LIMIT 0,5
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	ALL 					3748 	Using filesort
Query Time: 76 ms

(Plugin Hook: pre_output_page)
#127 - Select Query
SELECT u.uid,u.username,u.usergroup,u.displaygroup,count(*) as refcount FROM mybb_users u LEFT JOIN mybb_users r ON (r.referrer = u.uid) WHERE r.referrer = u.uid GROUP BY r.referrer DESC ORDER BY refcount DESC LIMIT 0 ,5
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
r 	ALL 					3748 	Using temporary; Using filesort
u 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.r.referrer 	1 	
Query Time: 114 ms

(Plugin Hook: pre_output_page)
#128 - Select Query
SELECT uid,regdate,username,usergroup,displaygroup FROM mybb_users ORDER BY uid DESC LIMIT 0,5
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	index 		PRIMARY 	4 		5 	
Query Time: 94 ms

(Plugin Hook: pre_output_page)
#129 - Select Query
SELECT username,postnum,uid,usergroup,displaygroup FROM mybb_users ORDER BY postnum DESC LIMIT 0,5
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_users 	ALL 					3748 	Using filesort
Query Time: 161 ms

(Plugin Hook: pre_output_page)
#130 - Select Query
SELECT t.subject,t.tid,t.fid,t.replies,t.lastpost,t.visible,tr.uid AS truid,tr.dateline FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE (t.visible = '1' OR '1'='1' ) AND t.fid NOT IN ('30','28','29') AND t.closed NOT LIKE 'moved|%' AND t.visible != '-2' AND f.active = '1' ORDER BY t.replies DESC LIMIT 0,5
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
t 	range 	fid 	fid 	2 		6740 	Using where; Using filesort
f 	eq_ref 	PRIMARY 	PRIMARY 	2 	mybb2.t.fid 	1 	Using where
tr 	eq_ref 	tid 	tid 	8 	mybb2.t.tid,const 	1 	
Query Time: 560 ms

(Plugin Hook: pre_output_page)
#131 - Select Query
SELECT u.uid,u.reputation,u.username,u.usergroup,u.displaygroup FROM mybb_users u LEFT JOIN mybb_usergroups ug ON (u.usergroup = ug.gid) WHERE ug.usereputationsystem='1' ORDER BY u.reputation DESC LIMIT 0,5
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
u 	ALL 	usergroup 				3748 	Using filesort
ug 	eq_ref 	PRIMARY 	PRIMARY 	2 	mybb2.u.usergroup 	1 	Using where
Query Time: 124 ms

(Plugin Hook: pre_output_page)
#132 - Select Query
SELECT template FROM mybb_templates WHERE title='unreadPosts_threadCSSCode' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		4 	Using where
Query Time: 136 ms

(Plugin Hook: pre_output_page)
#133 - Select Query
SELECT 1 FROM mybb_posts p INNER JOIN mybb_threads t ON (p.tid = t.tid) LEFT JOIN mybb_threadsread tr ON (tr.uid = 1 AND t.tid = tr.tid) LEFT JOIN mybb_forumsread fr ON (fr.uid = 1 AND t.fid = fr.fid) WHERE p.visible = 1 AND t.visible = 1 AND p.dateline > IFNULL(tr.dateline,1518581453) AND p.dateline > IFNULL(fr.dateline,1518581453) AND p.dateline > 1518581453 LIMIT 501
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
p 	range 	tid,visible,dateline,tiddate 	dateline 	4 		73 	Using where
t 	eq_ref 	PRIMARY 	PRIMARY 	4 	mybb2.p.tid 	1 	Using where
tr 	eq_ref 	tid 	tid 	8 	mybb2.t.tid,const 	1 	Using where
fr 	eq_ref 	fid 	fid 	8 	mybb2.t.fid,const 	1 	Using where
Query Time: 102 ms

(Plugin Hook: pre_output_page)
#134 - Select Query
SELECT template FROM mybb_templates WHERE title='codebuttons' AND sid IN ('-2','-1','1') ORDER BY sid DESC LIMIT 1
Table 	Type 	Possible Keys 	Key 	Key Length 	Ref 	Rows 	Extra
mybb_templates 	range 	sid 	sid 	364 		3 	Using where
Query Time: 37 ms

Template Statistics
Templates Used (Loaded for this Page) - 228 Total
error, error_inline, error_nopermission, error_nopermission_loggedin, footer, footer_contactus, footer_languageselect, footer_languageselect_option, footer_themeselect, footer_themeselector, forumdisplay_password, forumdisplay_password_wrongpass, forumdisplay_thread_icon, forumjump_advanced, forumjump_bit, forumjump_special, global_bannedwarning, global_boardclosed_warning, global_pending_joinrequests, global_pm_alert, global_unreadreports, global_moderation_notice, global_awaiting_activation, header, header_menu_calendar, header_menu_memberlist, header_menu_portal, header_menu_search, header_quicksearch, header_welcomeblock_guest, header_welcomeblock_member, header_welcomeblock_member_admin, header_welcomeblock_member_moderator, multipage, multipage_breadcrumb, multipage_end, multipage_jump_page, multipage_nextpage, multipage_page, multipage_page_current, multipage_page_link_current, multipage_prevpage, multipage_start, nav, nav_bit, nav_bit_active, nav_dropdown, nav_sep, nav_sep_active, post_captcha, post_captcha_recaptcha, post_captcha_nocaptcha, postbit, postbit_attachments, postbit_attachments_attachment, postbit_attachments_attachment_unapproved, postbit_attachments_images, postbit_attachments_images_image, postbit_attachments_thumbnails, postbit_attachments_thumbnails_thumbnail, postbit_author_guest, postbit_author_user, postbit_avatar, postbit_away, postbit_classic, postbit_edit, postbit_editedby, postbit_editedby_editreason, postbit_email, postbit_find, postbit_purgespammer, postbit_gotopost, postbit_groupimage, postbit_icon, postbit_ignored, postbit_inlinecheck, postbit_iplogged_hiden, postbit_iplogged_show, postbit_multiquote, postbit_offline, postbit_online, postbit_pm, postbit_posturl, postbit_profilefield, postbit_quickdelete, postbit_quickrestore, postbit_quote, postbit_rep_button, postbit_report, postbit_reputation, postbit_reputation_formatted_link, postbit_signature, postbit_userstar, postbit_warn, postbit_warninglevel, postbit_warninglevel_formatted, postbit_www, showthread, showthread_add_poll, showthread_classic_header, showthread_inlinemoderation, showthread_inlinemoderation_approve, showthread_inlinemoderation_custom, showthread_inlinemoderation_custom_tool, showthread_inlinemoderation_delete, showthread_inlinemoderation_manage, showthread_inlinemoderation_restore, showthread_inlinemoderation_standard, showthread_inlinemoderation_softdelete, showthread_moderationoptions, showthread_moderationoptions_custom, showthread_moderationoptions_custom_tool, showthread_moderationoptions_delete, showthread_moderationoptions_deletepoll, showthread_moderationoptions_manage, showthread_moderationoptions_openclose, showthread_moderationoptions_restore, showthread_moderationoptions_softdelete, showthread_moderationoptions_standard, showthread_moderationoptions_stickunstick, showthread_moderationoptions_threadnotes, showthread_newreply, showthread_newreply_closed, showthread_newthread, showthread_poll, showthread_poll_editpoll, showthread_poll_option, showthread_poll_option_multiple, showthread_poll_resultbit, showthread_poll_results, showthread_poll_undovote, showthread_quickreply, showthread_quickreply_options_close, showthread_quickreply_options_signature, showthread_quickreply_options_stick, showthread_ratethread, showthread_search, showthread_send_thread, showthread_similarthreads, showthread_similarthreads_bit, showthread_threaded_bit, showthread_threaded_bitactive, showthread_threadedbox, showthread_threadnotes, showthread_threadnotes_viewnotes, showthread_threadnoteslink, showthread_usersbrowsing, showthread_usersbrowsing_user, usercp_themeselector_option, video_metacafe_embed, video_dailymotion_embed, video_facebook_embed, video_liveleak_embed, video_myspacetv_embed, video_youtube_embed, video_veoh_embed, video_vimeo_embed, video_yahoo_embed, attachment_icon, debug_summary, gobutton, headerinclude, htmldoctype, redirect, task_image, smilie, global_board_offline_modal, simplelikes_likebar, simplelikes_likebutton, moderationactionspreview_ip, moderationactionspreview_avatar, moderationactionspreview_post, moderationactionspreview_postbit_row, notemoderator_post, notemoderator_normal, notemoderator_information, notemoderator_warn, notemoderator_buttons, notemoderator_postbit_button, prostats_topdownloads_row, prostats_topdownloads, prostats_newmembers_row, prostats_newmembers, prostats_mostviews_row, prostats_mostviews, prostats_mostthanks, prostats_mostthanks_row, unreadPosts_link, unreadPosts_linkCounter, unreadPosts_counter, unreadPosts_postbit, postbit_edithistory, showthread_favorite, prostats_mostreputation_row, prostats_mostreputation, prostats_mostreplies_row, prostats_mostreplies, prostats_newestposts_specialchar, prostats_topposters, prostats_topposters_row, prostats_topthreadposters, prostats_topthreadposters_row, prostats_topreferrers, prostats_topreferrers_row, prostats_message, prostats_onerowextra, prostats_tworowextra, prostats_newestposts_row, prostats_newestposts, prostats_readstate_icon, prostats, rinbutquick, fastQuote_button, usersBrowsedUser, usersBrowsed, unansweredPosts_link, prostats_newestposts_head_latest_posts, prostats_newestposts_head_date, prostats_newestposts_head_starter, prostats_newestposts_head_last_sender, prostats_newestposts_head_forum, prostats_newestposts_latest_posts, prostats_newestposts_date, prostats_newestposts_starter, prostats_newestposts_last_sender, prostats_newestposts_forum, unreadPosts_threadCSSCode, codebuttons

Templates Requiring Additional Calls (Not Cached at Startup) - 16 Total
fastQuote_button, usersBrowsedUser, usersBrowsed, unansweredPosts_link, prostats_newestposts_head_latest_posts, prostats_newestposts_head_date, prostats_newestposts_head_starter, prostats_newestposts_head_last_sender, prostats_newestposts_head_forum, prostats_newestposts_latest_posts, prostats_newestposts_date, prostats_newestposts_starter, prostats_newestposts_last_sender, prostats_newestposts_forum, unreadPosts_threadCSSCode, codebuttons

User 4384

2018-02-14, 03:23 PM
Hi,

seems or a DB problem:

Quote:After a lot of inserts, deletes, updates, etc., you table can get fragmented and your indexes may not be optimized. I would suggest that you re-index and optimize tables


or a hardware problem (if it's this you'll have to ask to check it to your server's admin).

If I could bet, I'll say that it seems more a hardware problem.

Hope someone have better answers.

metulburr

2018-02-14, 05:28 PM
i am the server admin. Why do you think its a hardware issue?

The server is hosted on a VPS.

User 4384

2018-02-14, 06:20 PM
Hi again,

because in all these years, it happens to me 2 times, and I got crazy checking the DB, requests, server logs, and so on, and nothing, it was from a hard drive problem (once) and a RAM problem (the other time), but I spent so many days wondering what the hell was going on...

Unless it's caused by a DB problem, you don't loose anything asking the VPS tech guys to check if the hardware it's OK

A simple SELECT query 160 ms...., it's too much
By the way, I've checked your forum, and you don't have a Leverage browser caching for image / css and js files.

Quote:Page load times can be significantly improved by asking visitors to save and reuse the files included in your website.
  • Reduces page load times for repeat visitors

  • Particularly effective on websites where users regularly re-visit the same areas of the website

  • Benefit-cost ratio: high


More info:
https://gtmetrix.com/leverage-browser-caching.html

metulburr

2018-02-14, 06:52 PM
ill ask the provider for a hardware check

Also i enabled mod_expires and set appropriate settings for apache, but it didnt change anything. But thanks for that though.

User 4384

2018-02-14, 07:04 PM
Hi,

as the link I add in my last post said, you only have to add the lines in the .htaccess file

The lines are:
## EXPIRES CACHING ##
<IfModule mod_expires.c>
ExpiresActive On
ExpiresByType image/jpg "access plus 1 year"
ExpiresByType image/jpeg "access plus 1 year"
ExpiresByType image/gif "access plus 1 year"
ExpiresByType image/png "access plus 1 year"
ExpiresByType text/css "access plus 1 month"
ExpiresByType application/pdf "access plus 1 month"
ExpiresByType text/x-javascript "access plus 1 month"
ExpiresByType application/x-shockwave-flash "access plus 1 month"
ExpiresByType image/x-icon "access plus 1 year"
ExpiresDefault "access plus 2 days"
</IfModule>
## EXPIRES CACHING ##

But I've a better expire caching (the one I use):

## EXPIRES CACHING ##
<IfModule mod_expires.c>
ExpiresActive On
ExpiresByType image/jpg "access plus 7 days"
ExpiresByType image/jpeg "access plus 7 days"
ExpiresByType image/gif "access plus 7 days"
ExpiresByType image/png "access plus 7 days"
ExpiresByType text/css "access plus 1 week"
ExpiresByType application/pdf "access plus 6 month"
ExpiresByType text/x-javascript "access plus 7 days"
ExpiresByType application/x-shockwave-flash "access plus 3 month"
AddType image/x-icon .ico
ExpiresByType image/x-icon "access plus 30 days"
ExpiresByType image/ico "access plus 30 days"
# Do not cache HTML
ExpiresByType text/html "access plus 0 seconds"
# Dinamyc data do not cache
ExpiresByType text/xml "access plus 0 seconds"
ExpiresByType application/xml "access plus 0 seconds"
ExpiresByType application/json "access plus 0 seconds"
# RSS feeds
ExpiresByType application/atom+xml "access plus 6 hours"
ExpiresByType application/rss+xml "access plus 6 hours"
# Web fonts: 1 month
ExpiresByType application/x-font-ttf "access plus 1 month"
ExpiresByType font/opentype "access plus 1 month"
ExpiresByType application/x-font-woff "access plus 1 month"
ExpiresByType image/svg+xml "access plus 1 month"
ExpiresByType application/vnd.ms-fontobject "access plus 1 month"
# By default
ExpiresDefault "access plus 7 days"
</IfModule>
## EXPIRES CACHING ##

metulburr

2018-02-14, 07:05 PM
i enabled mod_expires and set appropriate settings for apache, but it didnt change anything.
I got a B for both Pagespeed and Yslow now, but it still remains to be dreadfully slow.

User 4384

2018-02-14, 07:13 PM
Leverage browser caching is working now (it works for second visits and so on, not for firsts Wink

As you could see in the image I attach, the problem is when anybody tries to connect to the web, not the web itself.

[attachment=39949]

metulburr

2018-02-14, 07:19 PM
well thats nice to have setup finally. But that is not causing the slow loading of the website as i am still taking long periods to load a page here and there. The time seems to change on how long exactly it takes. Last night it took 60 seconds, today about 4-6 seconds. A month ago...... less than 1 second.

User 4384

2018-02-14, 07:21 PM
As I said, contact the VPS staff, and let them check it  Wink

Now you could shw them the waterfall of your forum
Pages: 1 2 3 4 5 6
MyBB Community Forums > 1.8 Support > General Support > slow loading speeds