Upgraded to Siena from Genoa, using much more resources than before
singh336 |
|
---|---|
Okay, when should we do this, or is this something I should do and show you the results ? Added 11 hours later: Here is what I got running the debug mode on with maintenance mode on: Dev-mode : SQL query Duration Timeline Execution stack (file[line]: function) Query BEGIN 0.000 ms #3 0.608 ms 9.640 ms index.php [37]: require_once(); → common.php [325]: CotDB->query(); SELECT * FROM sed_users WHERE user_id = 243 #4 0.678 ms 10.590 ms index.php [37]: require_once(); → common.php [382]: CotDB->update(); UPDATE `sed_users` SET `user_lastlog`=1390974578 WHERE user_id=243 #5 0.201 ms 12.176 ms index.php [37]: require_once(); → common.php [452]: include(); → i18n.input.php [24]: MySQL_cache->get(); → cache.php [727]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'i18n' AND c_name = 'locales' #6 0.497 ms 14.077 ms index.php [37]: require_once(); → common.php [452]: include(); → whosonline.input.php [24]: CotDB->query(); SELECT * FROM sed_online WHERE online_userid=243 #7 0.285 ms 14.661 ms index.php [37]: require_once(); → common.php [452]: include(); → whosonline.input.php [69]: CotDB->delete(); DELETE FROM `sed_online` WHERE online_lastseen < 1390972778 #8 0.475 ms 15.035 ms index.php [37]: require_once(); → common.php [452]: include(); → whosonline.input.php [71]: CotDB->query(); SELECT COUNT(*) FROM sed_online WHERE online_name='v' #9 0.232 ms 15.590 ms index.php [37]: require_once(); → common.php [452]: include(); → whosonline.input.php [72]: CotDB->query(); SELECT DISTINCT o.online_name, o.online_userid FROM sed_online o WHERE o.online_name != 'v' ORDER BY online_name ASC #10 0.361 ms 16.631 ms index.php [37]: require_once(); → common.php [461]: CotDB->query(); SELECT grp_maintenance FROM sed_groups WHERE grp_id='5' #11 3.878 ms 19.862 ms index.php [37]: require_once(); → common.php [626]: include(); → hits.global.php [36]: cot_stat_inc(); → hits.functions.php [56]: CotDB->query(); UPDATE sed_stats SET stat_value=stat_value+1 WHERE stat_name='totalpages' #12 0.384 ms 23.855 ms index.php [37]: require_once(); → common.php [626]: include(); → hits.global.php [37]: cot_stat_update(); → hits.functions.php [71]: CotDB->query(); INSERT INTO sed_stats (stat_name, stat_value) VALUES ('2014-01-29', 1) ON DUPLICATE KEY UPDATE stat_value=stat_value+1 #13 0.509 ms 24.672 ms index.php [37]: require_once(); → common.php [626]: include(); → banlist.global.php [25]: CotDB->query(); SELECT banlist_id, banlist_ip, banlist_reason, banlist_expire FROM sed_banlist WHERE banlist_ip IN ('67.248.100.12','67.248.100.*','67.248.*.*','67.*.*.*') #14 0.316 ms 32.574 ms index.php [37]: require_once(); → common.php [626]: include(); → i18n.global.php [21]: MySQL_cache->get(); → cache.php [727]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'i18n' AND c_name = 'structure' #15 0.827 ms 33.000 ms index.php [37]: require_once(); → common.php [626]: include(); → i18n.global.php [25]: cot_i18n_load_structure(); → i18n.functions.php [170]: CotDB->query(); SELECT * FROM sed_i18n_structure #16 0.435 ms 39.933 ms index.php [126]: require_once(); → index.php [46]: require_once(); → header.php [86]: include(); → hits.header.php [30]: CotDB->query(); SELECT stat_value FROM sed_stats where stat_name='maxusers' LIMIT 1 #17 0.286 ms 40.939 ms index.php [126]: require_once(); → index.php [46]: require_once(); → header.php [86]: include(); → page.header.php [23]: CotDB->query(); SELECT COUNT(*) FROM sed_pages WHERE page_state=1 #18 0.167 ms 41.521 ms index.php [126]: require_once(); → index.php [46]: require_once(); → header.php [86]: include(); → page.header.php [46]: CotDB->query(); SELECT COUNT(*) FROM sed_pages WHERE page_state=2 AND page_ownerid = 243 #19 0.329 ms 42.593 ms index.php [126]: require_once(); → index.php [46]: require_once(); → header.php [86]: include(); → contact.header.php [24]: CotDB->query(); SELECT COUNT(*) FROM sed_contact WHERE contact_val=0 #20 7.739 ms 55.307 ms index.php [126]: require_once(); → index.php [53]: include(); → tags.index.php [25]: cot_tag_cloud(); → tags.functions.php [95]: CotDB->query(); SELECT `tag`, COUNT(*) AS `cnt` FROM sed_tag_references WHERE tag_area = 'pages' GROUP BY `tag` ORDER BY RAND() #21 1.023 ms 70.180 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [108]: CotDB->query(); SELECT COUNT(*) FROM sed_com WHERE com_code='chat' #22 2.158 ms 71.300 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [110]: CotDB->query(); SELECT c.*, u.* FROM sed_com AS c LEFT JOIN sed_users AS u ON u.user_id = c.com_authorid WHERE com_area='chat' AND com_code='chat' ORDER BY com_id DESC LIMIT 0, 10 #23 2.009 ms 74.258 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [119]: cot_parse(); → functions.php [4133]: include(); → bbcode.parser.php [19]: require_once(); → bbcode.functions.php [16]: cot_bbcode_load(); → bbcode.functions.php [155]: CotDB->query(); SELECT * FROM sed_bbcode WHERE bbc_enabled = 1 ORDER BY bbc_priority #24 1.408 ms 83.836 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #25 1.585 ms 85.390 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #26 0.219 ms 92.557 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #27 0.327 ms 92.906 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #28 0.413 ms 100.227 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #29 0.320 ms 100.754 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #30 0.197 ms 106.429 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #31 0.292 ms 106.784 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #32 0.286 ms 112.988 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #33 0.241 ms 113.423 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #34 0.490 ms 121.011 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #35 0.541 ms 121.617 ms index.php [126]: require_once(); → index.php [53]: include(); → minichat.php [168]: minichat_build(); → minichat.php [126]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #36 0.364 ms 136.078 ms index.php [126]: require_once(); → index.php [53]: include(); → polls.index.php [30]: CotDB->query(); SELECT * FROM sed_polls WHERE poll_type='index' AND poll_state='0' ORDER by poll_creationdate DESC LIMIT 2 #37 0.172 ms 136.608 ms index.php [126]: require_once(); → index.php [53]: include(); → polls.index.php [38]: cot_poll_form(); → polls.functions.php [323]: CotDB->query(); SELECT pv_id FROM sed_polls_voters WHERE pv_pollid = 131 AND pv_userid = '243' LIMIT 1 #38 0.247 ms 137.511 ms index.php [126]: require_once(); → index.php [53]: include(); → polls.index.php [38]: cot_poll_form(); → polls.functions.php [338]: CotDB->query(); SELECT SUM(po_count) FROM sed_polls_options WHERE po_pollid = 131 #39 0.302 ms 137.844 ms index.php [126]: require_once(); → index.php [53]: include(); → polls.index.php [38]: cot_poll_form(); → polls.functions.php [341]: CotDB->query(); SELECT po_id, po_text, po_count FROM sed_polls_options WHERE po_pollid = 131 ORDER by po_id ASC #40 0.288 ms 144.651 ms index.php [126]: require_once(); → index.php [53]: include(); → polls.index.php [49]: include(); → comments.polls.index.tags.php [24]: cot_comments_link(); → comments.functions.php [386]: cot_comments_count(); → comments.functions.php [63]: CotDB->query(); SELECT COUNT(*) FROM sed_com WHERE com_area = ? AND com_code = ? #41 0.253 ms 146.212 ms index.php [126]: require_once(); → index.php [53]: include(); → polls.index.php [38]: cot_poll_form(); → polls.functions.php [323]: CotDB->query(); SELECT pv_id FROM sed_polls_voters WHERE pv_pollid = 129 AND pv_userid = '243' LIMIT 1 #42 0.225 ms 147.166 ms index.php [126]: require_once(); → index.php [53]: include(); → polls.index.php [38]: cot_poll_form(); → polls.functions.php [338]: CotDB->query(); SELECT SUM(po_count) FROM sed_polls_options WHERE po_pollid = 129 #43 0.311 ms 147.477 ms index.php [126]: require_once(); → index.php [53]: include(); → polls.index.php [38]: cot_poll_form(); → polls.functions.php [341]: CotDB->query(); SELECT po_id, po_text, po_count FROM sed_polls_options WHERE po_pollid = 129 ORDER by po_id ASC #44 0.236 ms 154.413 ms index.php [126]: require_once(); → index.php [53]: include(); → polls.index.php [49]: include(); → comments.polls.index.tags.php [24]: cot_comments_link(); → comments.functions.php [386]: cot_comments_count(); → comments.functions.php [63]: CotDB->query(); SELECT COUNT(*) FROM sed_com WHERE com_area = ? AND com_code = ? #45 0.171 ms 158.588 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [32]: CotDB->query(); SELECT COUNT(DISTINCT com_code) FROM sed_com #46 0.266 ms 159.571 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [45]: CotDB->query(); SELECT MAX(com_id) AS _id, MAX(com_date) AS _date FROM sed_com GROUP BY com_code ORDER BY _date DESC LIMIT 0, 10 #47 0.310 ms 159.915 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [53]: CotDB->query(); SELECT * FROM sed_com WHERE com_id IN('122516','122515','122514','122509','122507','122504','122503','122494','122493','122484') ORDER BY com_date DESC #48 0.525 ms 160.309 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [67]: CotDB->query(); SELECT * FROM sed_pages WHERE page_id = 3498 LIMIT 1 #49 0.745 ms 162.577 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [67]: CotDB->query(); SELECT * FROM sed_pages WHERE page_id = 1613 LIMIT 1 #50 0.500 ms 169.023 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [67]: CotDB->query(); SELECT * FROM sed_pages WHERE page_id = 3497 LIMIT 1 #51 1.847 ms 174.096 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [67]: CotDB->query(); SELECT * FROM sed_pages WHERE page_id = 3219 LIMIT 1 #52 1.542 ms 177.983 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [67]: CotDB->query(); SELECT * FROM sed_pages WHERE page_id = 1582 LIMIT 1 #53 0.514 ms 181.512 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [67]: CotDB->query(); SELECT * FROM sed_pages WHERE page_id = 3232 LIMIT 1 #54 1.176 ms 185.780 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [67]: CotDB->query(); SELECT * FROM sed_pages WHERE page_id = 1032 LIMIT 1 #55 1.231 ms 188.865 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [67]: CotDB->query(); SELECT * FROM sed_pages WHERE page_id = 3422 LIMIT 1 #56 1.943 ms 191.652 ms index.php [126]: require_once(); → index.php [53]: include(); → recentcomments.index.php [67]: CotDB->query(); SELECT * FROM sed_pages WHERE page_id = 3260 LIMIT 1 #57 216.203 ms 199.715 ms index.php [126]: require_once(); → index.php [53]: include(); → news.php [96]: CotDB->query(); SELECT p.*, u.* , (SELECT COUNT(*) FROM `sed_com` WHERE com_area = 'page' AND com_code = p.page_id) AS com_count FROM sed_pages AS p LEFT JOIN sed_users AS u ON u.user_id=p.page_ownerid WHERE page_state = 0 AND page_cat <> 'system' AND page_begin <= 1390974578 AND (page_expire = 0 OR page_expire > 1390974578) AND page_cat IN ('news','events','videos','competitions','gom-news','street-legal-download-news','real-world-news','game-news') ORDER BY page_date DESC LIMIT 0, 3 #58 9.406 ms 416.061 ms index.php [126]: require_once(); → index.php [53]: include(); → news.php [98]: CotDB->query(); SELECT COUNT(*) FROM sed_pages AS p WHERE page_state = 0 AND page_cat <> 'system' AND page_begin <= 1390974578 AND (page_expire = 0 OR page_expire > 1390974578) AND page_cat IN ('news','events','videos','competitions','gom-news','street-legal-download-news','real-world-news','game-news') #59 0.341 ms 431.157 ms index.php [126]: require_once(); → index.php [53]: include(); → news.php [142]: include(); → tags.news.php [45]: cot_tag_list(); → tags.functions.php [220]: CotDB->query(); SELECT `tag`, `tag_item` FROM sed_tag_references WHERE tag_item IN(3498,3496,3494) AND tag_area = 'pages' #60 979.040 ms 467.845 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [256]: CotDB->query(); SELECT p.*, u.* , (SELECT COUNT(*) FROM `sed_com` WHERE com_area = 'page' AND com_code = p.page_id) AS com_count FROM sed_pages AS p LEFT JOIN sed_users AS u ON u.user_id=p.page_ownerid WHERE page_state=0 AND page_begin <= 1390974578 AND (page_expire = 0 OR page_expire > 1390974578) AND page_cat <> 'system' AND page_cat IN ('tutorials','3d-tutorials','street-legal-modding','photoshop-tutorials','articles','legal','downloads','street-legal-racing-redline','body-mods','car-mods','decal-mods','engine-mods','exhaust-mods','interior-mods','miscellanious-part-mods','rims-tires-wheel-mods','sound-mods','suspension-mods','texture-mods','the-games','tracks','tools','patches','paint-jobs','street-legal-1','sl1-body-parts','sl1-car-mods','sl1-decal-mods','sl1-engine-mods','sl1-exhaust-mods','sl1-interior-mods','sl1-misc-mods','sl1-rims-tires-mods','sl1-sound-mods','sl1-suspension','sl1-textures','sl1-game','dlsl1tools','sl1-patches','sl1-paint-jobs','cross-racing-championship','crc-car-mods','dlcrcskins','dlcrctracks','dlcrcgmodes','dlcrcmisc','dlgom','dlgomwallpaper','dlgomvideos','dlgommisc','dlgommusic','lfs','lfsskins','lfssetups','lfstools','dl_misc','dl_iv','dl_ivcars','dl_ivpatch','dl_ivsave','dl_ivskins','dl_ivother','dl_ivtools','dl_ivcheats','dl_ivvideo','dl_ivweapon','ferrari','ferraricar','ferraritrack','ferrarimisc','dlmax','dlmaxmodeld','dlmaxscripts','dlmaxplug-in','dlmaxtextures','dlmaxmaterials','dlmaxprograms','dl_wr2','dl_othergames','temp','links','closedlinks','system','weblogs') ORDER by page_date desc LIMIT 0, 12 #61 1.067 ms 1459.126 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #62 0.247 ms 1460.363 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #63 0.496 ms 1468.478 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #64 1.631 ms 1469.130 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #65 2.358 ms 1482.809 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #66 0.737 ms 1485.674 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #67 2.286 ms 1495.295 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #68 0.520 ms 1497.819 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #69 0.221 ms 1512.515 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #70 0.337 ms 1512.907 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #71 1.116 ms 1527.252 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #72 0.336 ms 1528.531 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #73 0.340 ms 1537.984 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #74 0.295 ms 1538.482 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #75 0.201 ms 1547.460 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #76 0.634 ms 1547.806 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #77 0.583 ms 1558.965 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #78 0.274 ms 1559.773 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #79 0.817 ms 1570.005 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [17]: MySQL_cache->exists(); → cache.php [702]: CotDB->query(); SELECT c_value FROM sed_cache WHERE c_realm = 'users' AND c_name = 'cot_userimages_config' #80 0.369 ms 1571.024 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [277]: cot_generate_usertags(); → functions.php [2156]: include(); → userimages.usertags.main.php [22]: cot_userimages_config_get(); → userimages.functions.php [24]: cot_config_load(); → configuration.php [217]: CotDB->query(); SELECT config_name, config_type, config_value, config_default, config_variants, config_order FROM sed_config WHERE config_owner = ? AND config_cat = ? AND config_subcat = ? AND config_donor = ? #81 33.530 ms 1580.743 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [65]: cot_build_recentforums(); → recentitems.functions.php [38]: CotDB->query(); SELECT * FROM sed_forum_topics WHERE (ft_movedto IS NULL OR ft_movedto = '') AND ft_mode=0 AND ft_cat IN ('c1','6','4','5','7','48','52','c2','46','47','21','23','50','51','c3','31','41','35','36','37','39','c4','43','44','45','c5','25','26','27','c7','42','12','22','13','11','24','30','c8','16','17','18','19','20','c9','32','3','15','14','29','10','53','c10','49','33','34') ORDER by ft_updated DESC LIMIT 10 END 1.643 ms Total:1.2963s - Queries:81 - Average:0.016s/q
Added 8 minutes later: I don't know what I'm really looking for in the above debug report but it looks to me that the NEWS and the RECENT ITEMS are taking the most time to load, is this correct? I see the biggest jump in time with these two.
→ tags.news.php [45]: cot_tag_list(); → tags.functions.php [220]: CotDB->query(); SELECT `tag`, `tag_item` FROM sed_tag_references WHERE tag_item IN(3498,3496,3494) AND tag_area = 'pages' #60 979.040 ms 467.845 ms index.php [126]: require_once(); → index.php [53]: include(); → recentitems.index.php [41]: cot_build_recentpages(); → recentitems.functions.php [256]: CotDB->query(); SELECT p.*, u.* , (SELECT COUNT(*) FROM `sed_com` WHERE com_area = 'page' AND com_code = p.page_id) AS com_count FROM sed_pages AS p LEFT JOIN sed_users AS u ON u.user_id=p.page_ownerid WHERE page_state=0 AND page_begin <= 1390974578 AND (page_expire = 0 OR page_expire > 1390974578) AND page_cat <> 'system' AND page_cat IN ('tutorials','3d-tutorials','street-legal-modding','photoshop-tutorials','articles','legal','downloads','street-legal-racing-redline','body-mods','car-mods','decal-mods','engine-mods','exhaust-mods','interior-mods','miscellanious-part-mods','rims-tires-wheel-mods','sound-mods','suspension-mods','texture-mods','the-games','tracks','tools','patches','paint-jobs','street-legal-1','sl1-body-parts','sl1-car-mods','sl1-decal-mods','sl1-engine-mods','sl1-exhaust-mods','sl1-interior-mods','sl1-misc-mods','sl1-rims-tires-mods','sl1-sound-mods','sl1-suspension','sl1-textures','sl1-game','dlsl1tools','sl1-patches','sl1-paint-jobs','cross-racing-championship','crc-car-mods','dlcrcskins','dlcrctracks','dlcrcgmodes','dlcrcmisc','dlgom','dlgomwallpaper','dlgomvideos','dlgommisc','dlgommusic','lfs','lfsskins','lfssetups','lfstools','dl_misc','dl_iv','dl_ivcars','dl_ivpatch','dl_ivsave','dl_ivskins','dl_ivother','dl_ivtools','dl_ivcheats','dl_ivvideo','dl_ivweapon','ferrari','ferraricar','ferraritrack','ferrarimisc','dlmax','dlmaxmodeld','dlmaxscripts','dlmaxplug-in','dlmaxtextures','dlmaxmaterials','dlmaxprograms','dl_wr2','dl_othergames','temp','links','closedlinks','system','weblogs') ORDER by page_date desc LIMIT 0, 12 #61 1.067 ms 1459.126 ms index.php [126]: require_once(); → index.php [53]: include();
Added 3 days later: Okay so good news is that the last few days CPU stats have dropped quite a bit about %30 average from the usual average.
You can see the cpu stats dropped regardless of the increased traffic / activity on the website during the same days, which is good news to me. also looking at the stats its very clear we get little unique hits versus the amount of "hits" total which means i should heavily benefit from proper caching ... I added this code to the HTACESS file in the root of the website, im not sure if this was a good idea or not.. what do you think.. Header unset ETag Header unset Last-Modified FileETag None Header unset Cache-control Header set Expires "access plus 1 month" The difference I noticed was that the background image on my website seems to quickly load when im clicking around pages, and that doesn't seem like a good thing, i was expecting an instant load for most if not all the graphics on the sites theme design... Any advice on how to do these expire header / browser leverage caching the right way with siena ? Added 3 days later: no idea what to do :/ Added 20 hours later: Is there a way to load sections of the home page after / delayed ?
The recent items and news are holding up the rest of the page from loading it seems like, is there a way to load them using ajax or some other way so the rest of the page will load on time? <a href="http://www.streetlegalmods.com/">http://www.streetlegalmods.com/</a>
|
|
Відредаговано: singh336 (04.02.2014 18:48, 10 років тому) |
Twiebie |
|
---|---|
#39106 singh336: Do you have caching turned on for the recent items plugin? Should be at: admin.php?m=config&n=edit&o=plug&p=recentitems |
|
Відредаговано: Twiebie (04.02.2014 23:38, 10 років тому) |
singh336 |
|
---|---|
Yeah I did that as soon as trustmaster suggested Added 3 days later: craziness : / Added 6 days later: how / what is the best way to use those cahce options, because like i said i have access to a few of them i just know how to setup them up with cotonti
<a href="http://www.streetlegalmods.com/">http://www.streetlegalmods.com/</a>
|
|
Відредаговано: singh336 (18.02.2014 22:57, 10 років тому) |
tensh |
|
---|---|
I have a performance-related question for experienced developers: What approach would be better performance-wise? - Table A with serialized array of items in a Text field? The items will be used in many various searches and statistics. |
Alex300 |
|
---|---|
Second will be much better Есть миры, не здесь, там, где небеса горят, и моря засыпают, и реки дремлют; люди сделаны из дыма, а города – из песен. Где-то опасность, где-то несправедливость, даже где-то остыл чай. Идем Эйс, у нас много работы!...
...Sorry for my english... Бесплатные расширения для Cotonti: https://lily-software.com/free-scripts/ |
tensh |
|
---|---|
Thank you very much for an answer :) |