Query Slow

mahdy_sharifi

• November 05, 2014 07:22

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 :
| 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

• 

  cPanelMichael

  • November 05, 2014 15:05

  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.