MyBB Community Forums

Full Version: showthread.php caused Cpanel overload
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
(2012-03-16, 06:57 PM)lexy Wrote: [ -> ]it is possible this:someone use fetch script to acces my links
instead of some of his information attest to my information by reading them through my links.
and how to change acces to my links example
http://www.example.com/shobblablablatext.php" to change it http://www.example.com/mylinkstoforums/shobblablablatext.php

AutoMedia plugin caused all this after i deactivate it resource in cpanel goes to zero


I would say use Labroccas advise, Start disabling plugins 1 by 1, and checking, Once you disable the right 1 you will notice the change of course. Then you know whats causing the problem.
(2012-03-16, 09:08 PM)Projec13 Wrote: [ -> ]
(2012-03-16, 06:57 PM)lexy Wrote: [ -> ]it is possible this:someone use fetch script to acces my links
instead of some of his information attest to my information by reading them through my links.
and how to change acces to my links example
http://www.example.com/shobblablablatext.php" to change it http://www.example.com/mylinkstoforums/shobblablablatext.php

AutoMedia plugin caused all this after i deactivate it resource in cpanel goes to zero


I would say use Labroccas advise, Start disabling plugins 1 by 1, and checking, Once you disable the right 1 you will notice the change of course. Then you know whats causing the problem.


problem causing automedia plugin and top x stats
Quote:problem causing automedia plugin and top x stats

As I stated previously "Plugins for stats in general are resource hogs".

I wish people would be more selective with the plugins they add. The assumption that a cool feature you see on another site will work well on yours is a bad one. When people are calling for MyBB to add all these nifty things into base they also don't consider the repercutions to their resources. MyBB is a fairly lean forum software. Let's keep it that way.

Quote:Templates Requiring Additional Calls (Not Cached at Startup) - 23 Total

These can each represent a new query. Well written plugins will add this to the $template global to avoid that.



mypermissions_actions is using a query but should imho use the cache instead. Poorly writtten.

Quote: #13 - Select Query
SELECT u.avatar, u.username, u.uid FROM users u LEFT JOIN sessions s ON (s.uid=u.uid) WHERE s.time > '1331920091' AND u.usergroup IN (3,4,6,8) ORDER BY u.username ASC, s.time DESC

Unsure what that is for but it's also probably poorly written. Doubt that it's needed and could be written to use globals and cache instead.

Quote:(Plugin Hook: index_start)
#14 - Select Query
SELECT * FROM users WHERE uid='66'

Again like a bad plugin.

Quote:(Plugin Hook: index_start)
#21 - Select Query
SELECT COUNT(*) AS pms_total, SUM(IF(status='0' AND folder='1','1','0')) AS pms_unread FROM privatemessages WHERE uid='1'

Some sort of PM notifcation system? Waste of a resource when MyBB already does notify you. Any ajax notification is just another waste.

Quote:(Plugin Hook: index_start)
#25 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, u.username, u.invisible, u.usergroup, u.displaygroup FROM sessions s LEFT JOIN users u ON (s.uid=u.uid) WHERE s.time>'1331920091' ORDER BY u.username ASC, s.time DESC

Stats again? Maybe users online? It's a quick query though.

Seems almost all your long queries are templates. My guess is table row locks that can all be avoided by converting from MyISAM to InnoDB and even more so if your host uses MySQL 5.5+.

But overhauling the plugins by adding the templates to the original grab would also fix the issue.
Pages: 1 2