Quote:SELECT t.*, (t.totalratings/t.numratings) AS averagerating, r.uid AS rated, t.username AS threadusername, u.username\n\tFROM mybb_threads t\n\tLEFT JOIN mybb_users u ON (u.uid = t.uid)\nLEFT JOIN mybb_threadratings r ON(r.tid=t.tid AND r.uid='2672')\n\tWHERE t.fid='1' AND t.visible='1' \n\tORDER BY t.sticky DESC, t.lastpost desc \n\tLIMIT 0, 50
This is the primary query that's causing the issue...How can i fix this ? this makes server too slow...
We can't really work with that. Where does it show?? When does it show?? Does it show an SQL error?? I cannot read your mind.
(2008-12-28, 10:23 AM)MattR Wrote: [ -> ]We can't really work with that. Where does it show?? When does it show?? Does it show an SQL error?? I cannot read your mind.
hey matt i asked the hostgator that i have problem with server which is currently too slow and they sent me this message:
Quote:Hello,What appears to be happening is that one or 2 queries are being very slow, and they lock the threads database causing everything else to sit waiting for access (hence why the pages are extremely slow). This is the primary query that's causing the issue, I recommend looking into this, you may want to post on the vbulletin forums asking about it if you don't know yourself what's causing it. SELECT t.*, (t.totalratings/t.numratings) AS averagerating, r.uid AS rated, t.username AS threadusername, u.username\n\tFROM mybb_threads t\n\tLEFT JOIN mybb_users u ON (u.uid = t.uid)\nLEFT JOIN mybb_threadratings r ON(r.tid=t.tid AND r.uid='2672')\n\tWHERE t.fid='1' AND t.visible='1' \n\tORDER BY t.sticky DESC, t.lastpost desc \n\tLIMIT 0, 50 Thank you,
(2008-12-28, 10:32 AM)ExCLuSiVe Wrote: [ -> ]you may want to post on the vbulletin forums asking about it
Again,
where does this query show?? On all pages?? Just some?? Is it a red SQL error?? Does it say a particular table has crashed and needs repairing??
showtread.php not working at all...
it doesn't show .. its the query that cause the problem...
hostgator system administrator found this for me...
Ok can you please answer my question?? Does it say that a table is crashed and needs to be repaired?? Can you just printscreen the error...?? I mean where did you get this query from, it must show somewhere... can you printscreen where it shows??
I got that information by typing this in the command line:mysql -e "show full processlist"You can also get it in phpMyAdmin under the process list section. There were a lot of locked queries on one of those tables because they were waiting for that query to complete. That is why I showed you it as a problematic query.
186 adincel_user localhost adincel_ingilizcepratiknetmybb Query 157 Locked UPDATE mybb_threads SET views=views+1 WHERE tid='1...
187 adincel_user localhost adincel_ingilizcepratiknetmybb Query 156 Locked UPDATE mybb_threads SET views=views+1 WHERE tid='1...
188 adincel_user localhost adincel_ingilizcepratiknetmybb Query 156 Locked SELECT * FROM mybb_threads WHERE tid='16963'
190 adincel_user localhost adincel_ingilizcepratiknetmybb Query 156 Locked SELECT * FROM mybb_threads WHERE tid='97028'
194 adincel_user localhost adincel_ingilizcepratiknetmybb Query 147 Locked SELECT * FROM mybb_threads WHERE tid='8331'
195 adincel_user localhost adincel_ingilizcepratiknetmybb Query 146 Locked SELECT * FROM mybb_threads WHERE tid='11004'
196 adincel_user localhost adincel_ingilizcepratiknetmybb Query 145 Locked SELECT * FROM mybb_threads WHERE tid='98118'
198 adincel_user localhost adincel_ingilizcepratiknetmybb Query 139 Locked SELECT * FROM mybb_threads WHERE tid='97908'
202 adincel_user localhost adincel_ingilizcepratiknetmybb Query 129 Locked SELECT * FROM mybb_threads WHERE tid='97312'
203 adincel_user localhost adincel_ingilizcepratiknetmybb Query 123 Locked SELECT * FROM mybb_threads WHERE tid='97665'
204 adincel_user localhost adincel_ingilizcepratiknetmybb Query 121 Locked SELECT * FROM mybb_threads WHERE tid='8331'
205 adincel_user localhost adincel_ingilizcepratiknetmybb Query 119 Locked SELECT * FROM mybb_threads WHERE tid='98046'
211 adincel_user localhost adincel_ingilizcepratiknetmybb Query 109 Locked SELECT * FROM mybb_threads WHERE tid='97004'
212 adincel_user localhost adincel_ingilizcepratiknetmybb Query 108 Locked SELECT * FROM mybb_threads WHERE tid='98118'
214 adincel_user localhost adincel_ingilizcepratiknetmybb Query 104 Locked SELECT * FROM mybb_threads WHERE tid='97054'
215 adincel_user localhost adincel_ingilizcepratiknetmybb Query 104 Locked SELECT t.tid, t.dateline, p.edittime, t.subject, f...
216 adincel_user localhost adincel_ingilizcepratiknetmybb Query 104 Locked SELECT * FROM mybb_threads WHERE tid='8331'
217 adincel_user localhost adincel_ingilizcepratiknetmybb Query 102 Locked SELECT * FROM mybb_threads WHERE tid='97735'
220 adincel_user localhost adincel_ingilizcepratiknetmybb Query 97 Locked SELECT * FROM mybb_threads WHERE tid='13218'
221 adincel_user localhost adincel_ingilizcepratiknetmybb Query 96 Locked SELECT * FROM mybb_threads WHERE tid='13218'
222 adincel_user localhost adincel_ingilizcepratiknetmybb Query 90 Locked SELECT * FROM mybb_threads WHERE tid='17048'
223 adincel_user localhost adincel_ingilizcepratiknetmybb Query 89 Locked SELECT * FROM mybb_threads WHERE tid='8331'
224 adincel_user localhost adincel_ingilizcepratiknetmybb Query 89 Locked SELECT f.style, f.overridestyle, t.*
FROM mybb...
225 adincel_user localhost adincel_ingilizcepratiknetmybb Query 88 Locked SELECT * FROM mybb_threads WHERE tid='97873'
229 adincel_user localhost adincel_ingilizcepratiknetmybb Query 84 Locked SELECT * FROM mybb_threads WHERE tid='97058'
230 adincel_user localhost adincel_ingilizcepratiknetmybb Query 83 Locked SELECT * FROM mybb_threads WHERE tid='97877'
231 adincel_user localhost adincel_ingilizcepratiknetmybb Query 82 Locked SELECT * FROM mybb_threads WHERE tid='97119'
232 adincel_user localhost adincel_ingilizcepratiknetmybb Query 80 Locked SELECT * FROM mybb_threads WHERE tid='97108'
233 adincel_user localhost adincel_ingilizcepratiknetmybb Query 79 Locked SELECT subject,username,uid,tid,replies FROM mybb_...
234 adincel_user localhost adincel_ingilizcepratiknetmybb Query 78 Locked SELECT * FROM mybb_threads WHERE tid='36687'
236 adincel_user localhost adincel_ingilizcepratiknetmybb Query 73 Locked SELECT t.*, (t.totalratings/t.numratings) AS avera...
237 adincel_user localhost adincel_ingilizcepratiknetmybb Query 70 Locked SELECT * FROM mybb_threads WHERE tid='8331'
238 adincel_user localhost adincel_ingilizcepratiknetmybb Query 68 Locked SELECT * FROM mybb_threads WHERE tid='97974'
242 adincel_user localhost adincel_ingilizcepratiknetmybb Query 61 Locked SELECT * FROM mybb_threads WHERE tid='97312'
243 adincel_user localhost adincel_ingilizcepratiknetmybb Query 58 Locked SELECT * FROM mybb_threads WHERE tid='8331'
244 adincel_user localhost adincel_ingilizcepratiknetmybb Query 58 Locked SELECT * FROM mybb_threads WHERE tid='8331'
245 adincel_user localhost adincel_ingilizcepratiknetmybb Query 56 Locked SELECT * FROM mybb_threads WHERE tid='8331'
247 adincel_user localhost adincel_ingilizcepratiknetmybb Query 53 Locked SELECT * FROM mybb_threads WHERE tid='8331'
248 adincel_user localhost adincel_ingilizcepratiknetmybb Query 53 Locked SELECT * FROM mybb_threads WHERE tid='97752'
250 adincel_user localhost adincel_ingilizcepratiknetmybb Query 51 Locked UPDATE mybb_users
SET unreadpms='0' WHERE ui...
251 adincel_user localhost adincel_ingilizcepratiknetmybb Query 50 Locked SELECT u.*, f.*
FROM mybb_users u
LEFT JOIN...
252 adincel_user localhost adincel_ingilizcepratiknetmybb Query 45 Locked SELECT * FROM mybb_threads WHERE tid='17048'
254 adincel_user localhost adincel_ingilizcepratiknetmybb Query 44 Locked SELECT * FROM mybb_threads WHERE tid='97711'
255 adincel_user localhost adincel_ingilizcepratiknetmybb Query 42 Locked SELECT * FROM mybb_threads WHERE tid='97032'
256 adincel_user localhost adincel_ingilizcepratiknetmybb Query 42 Locked SELECT * FROM mybb_threads WHERE tid='97790'
257 adincel_user localhost adincel_ingilizcepratiknetmybb Query 42 Locked SELECT * FROM mybb_threads WHERE tid='97293'
258 adincel_user localhost adincel_ingilizcepratiknetmybb Query 39 Locked SELECT * FROM mybb_threads WHERE tid='19601'
259 adincel_user localhost adincel_ingilizcepratiknetmybb Query 39 Locked SELECT * FROM mybb_threads WHERE tid='2096'
263 adincel_user localhost adincel_ingilizcepratiknetmybb Query 37 Locked SELECT * FROM mybb_threads WHERE tid='16963'
266 adincel_user localhost adincel_ingilizcepratiknetmybb Query 32 Locked SELECT * FROM mybb_threads WHERE tid='97293'
267 adincel_user localhost adincel_ingilizcepratiknetmybb Query 31 Locked SELECT * FROM mybb_threads WHERE tid='97293'
268 adincel_user localhost adincel_ingilizcepratiknetmybb Query 29 Locked SELECT * FROM mybb_threads WHERE tid='97943'
269 adincel_user localhost adincel_ingilizcepratiknetmybb Query 26 Locked SELECT * FROM mybb_threads WHERE tid='97943'
271 root localhost adincel_ingilizcepratiknetmybb Query 22 Locked REPAIR TABLE mybb_forums
272 adincel_user localhost adincel_ingilizcepratiknetmybb Query 22 Locked SELECT * FROM mybb_threads WHERE tid='97473'
273 adincel_user localhost adincel_ingilizcepratiknetmybb Query 22 Locked SELECT * FROM mybb_threads WHERE tid='97752'
275 adincel_user localhost adincel_ingilizcepratiknetmybb Query 17 Locked SELECT * FROM mybb_threads WHERE tid='17048'
276 adincel_user localhost adincel_ingilizcepratiknetmybb Query 15 Locked SELECT * FROM mybb_threads WHERE tid='97943'
277 adincel_user localhost adincel_ingilizcepratiknetmybb Query 13 Locked SELECT * FROM mybb_users WHERE uid='3'
278 adincel_user localhost adincel_ingilizcepratiknetmybb Query 12 Locked SELECT * FROM mybb_threads WHERE tid='13218'
279 adincel_user localhost adincel_ingilizcepratiknetmybb Query 11 Locked SELECT * FROM mybb_threads WHERE tid='98043'
280 adincel_user localhost adincel_ingilizcepratiknetmybb Query 8 Locked SELECT * FROM mybb_threads WHERE tid='3844'
281 adincel_user localhost adincel_ingilizcepratiknetmybb Query 6 Locked SELECT * FROM mybb_threads WHERE tid='17048'
283 adincel_user localhost adincel_ingilizcepratiknetmybb Query 6 Locked SELECT * FROM mybb_threads WHERE tid='97913'
284 adincel_user localhost adincel_ingilizcepratiknetmybb Query 1 Locked SELECT * FROM mybb_threads WHERE tid='97088'
285 root localhost NULL Query 0 NULL SHOW PROCESSLIST
why this is happening?
I'll stretch to say this isn't really normal MyBB behaviour - do you have any plugins installed that effect the showthread page?
If you want, you can edit inc/init.php, and find the following:
define("TIME_NOW", time());
...and change it to...
define("TIME_NOW", time());
define("NO_PLUGINS", 1);
This will disable any plugins without deactivating/uninstalling them, and help debug your forum a little better.
Disable thread ratings for all your forums.
UPDATE mybb_forums SET allowtratings=0
it worked. thank you so much for help and cooperation!
I editted manually all the categories , is there any way we can disable thread rating for all forums??
and if its available where the codes go, please let me know.
thanks