Query Slow
Hello :
We moved our user website to new server, but in new server when we wants open thread (forums website) that not open and error occurred .
after checked database query we see following slow query :
Is this problem related above slow query ? do you have idea to resolve issue ? Regards
| 7009958 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 30 | Copying to tmp table | SELECT `mybb_threads`.tag
root@server6 [~]# mysqladmin processlist | grep kal
| 7009958 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 118 | Copying to tmp table | SELECT `mybb_threads`.tag
| 7011767 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 82 | Waiting for table level lock | UPDATE mybb_threads SET views=views+1 WH
ERE tid='5783' |
| 7012768 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 68 | Waiting for table level lock | SELECT t.uid, t.fid, t.tid, t.subject, t
.visible, p.displaystyle AS threadprefix
| 7013243 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 60 | Waiting for table level lock | SELECT * FROM mybb_threads WHERE tid='67
53' |
| 7013393 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 56 | Waiting for table level lock | SELECT `mybb_threads`.tag
| 7013564 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 54 | Waiting for table level lock | SELECT * FROM mybb_threads WHERE tid='10
0' |
| 7014716 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 30 | Waiting for table level lock | SELECT * FROM mybb_threads WHERE tid='11
217' AND closed NOT LIKE 'moved|%' |
| 7015347 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 18 | Waiting for table level lock | SELECT * FROM mybb_threads WHERE tid='9'
AND closed NOT LIKE 'moved|%' |
| 7015419 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 17 | Waiting for table level lock | SELECT subject, tid, dateline, firstpost
FROM mybb_threads WHERE visible='1' AND closed NOT LIKE 'mo |
| 7015773 | kalkalfo_kalanjo | localhost | kalkalfo_formka | Query | 9 | Waiting for table level lock | SELECT fid FROM mybb_threads WHERE tid =
'5915' LIMIT 1
Is this problem related above slow query ? do you have idea to resolve issue ? Regards
-
Hello :) I have moved this thread to our "Optimization" forum as you will likely get more feedback here. Have you ran the MySQL tuner script yet to see what can be improved upon? Thank you. 0
Please sign in to leave a comment.
Comments
1 comment