The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Query Slow

Discussion in 'Workarounds and Optimization' started by mahdy_sharifi, Nov 5, 2014.

  1. mahdy_sharifi

    mahdy_sharifi Well-Known Member

    Joined:
    Feb 26, 2012
    Messages:
    175
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    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 :


    Code:
    | 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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page