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.

Are not all databases compatible with how MariaDB handles it?

Discussion in 'Database Discussions' started by luigidelgado, Mar 7, 2016.

  1. luigidelgado

    luigidelgado Well-Known Member

    Joined:
    Nov 6, 2010
    Messages:
    109
    Likes Received:
    2
    Trophy Points:
    16
    Location:
    Mexico
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi all.
    I just have the "brilliant" idea of upgrading (via WHM) mySQL 5.6 to MariaDB 10.0... Somehow there was a sick Wordpress website (we manage all of them in our servers) that couldn't handle it and the whole server went down. Diagnosing it took us a couple of hours, we then had to isolate the site and move it to another server with mySQL 5.6. The website has no more than 100 visits a day but enough to bring a 16GB RAM server down just after upgrading.

    The issue was with temporary tables using BLOB and TEXT. MariaDB didn't liked them. After removing this website everything went back to normal even a little bit better than before. MariaDB is great in performance. But I think there are some things that are not handled as MySQL.

    Now I am unable to bring back the website to the server, any ideas were to look for?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you provide more details on this? Is there anything in particular that MariaDB did differently that resulted in the issue you faced?

    Thank you.
     
  3. luigidelgado

    luigidelgado Well-Known Member

    Joined:
    Nov 6, 2010
    Messages:
    109
    Likes Received:
    2
    Trophy Points:
    16
    Location:
    Mexico
    cPanel Access Level:
    Root Administrator
    Twitter:
    Michael,
    We found this even though the account was suspended. Site is a WP latest version. I read a lot of people having similar issues:
    Code:
    /www]# mysqladmin proc stat
    +-------+-------------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
    | Id | User | Host | db | Command | Time | State | Info | Progress |
    +-------+-------------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
    | 83 | qdtdep_user | localhost | qdtdep_db | Query | 3422 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 96 | qdtdep_user | localhost | qdtdep_db | Query | 3422 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 188 | qdtdep_user | localhost | qdtdep_db | Query | 3397 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 202 | qdtdep_user | localhost | qdtdep_db | Query | 3400 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 305 | qdtdep_user | localhost | qdtdep_db | Query | 3370 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 421 | qdtdep_user | localhost | qdtdep_db | Query | 3339 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 472 | qdtdep_user | localhost | qdtdep_db | Query | 3338 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 511 | qdtdep_user | localhost | qdtdep_db | Query | 3329 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 580 | qdtdep_user | localhost | qdtdep_db | Query | 3308 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 652 | qdtdep_user | localhost | qdtdep_db | Query | 3290 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 661 | qdtdep_user | localhost | qdtdep_db | Query | 3288 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 696 | qdtdep_user | localhost | qdtdep_db | Query | 3280 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 771 | qdtdep_user | localhost | qdtdep_db | Query | 3254 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 927 | qdtdep_user | localhost | qdtdep_db | Query | 3203 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 937 | qdtdep_user | localhost | qdtdep_db | Query | 3198 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 972 | qdtdep_user | localhost | qdtdep_db | Query | 3189 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1010 | qdtdep_user | localhost | qdtdep_db | Query | 3180 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1044 | qdtdep_user | localhost | qdtdep_db | Query | 3167 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1164 | qdtdep_user | localhost | qdtdep_db | Query | 3137 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1233 | qdtdep_user | localhost | qdtdep_db | Query | 3119 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1283 | qdtdep_user | localhost | qdtdep_db | Query | 3106 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1348 | qdtdep_user | localhost | qdtdep_db | Query | 3083 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1372 | qdtdep_user | localhost | qdtdep_db | Query | 3074 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1394 | qdtdep_user | localhost | qdtdep_db | Query | 3069 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1458 | qdtdep_user | localhost | qdtdep_db | Query | 3046 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1464 | qdtdep_user | localhost | qdtdep_db | Query | 3044 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1468 | qdtdep_user | localhost | qdtdep_db | Query | 3042 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1524 | qdtdep_user | localhost | qdtdep_db | Query | 3028 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1541 | qdtdep_user | localhost | qdtdep_db | Query | 3024 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1622 | qdtdep_user | localhost | qdtdep_db | Query | 2993 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1644 | qdtdep_user | localhost | qdtdep_db | Query | 2987 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1701 | qdtdep_user | localhost | qdtdep_db | Query | 2969 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1724 | qdtdep_user | localhost | qdtdep_db | Query | 2956 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1784 | qdtdep_user | localhost | qdtdep_db | Query | 2938 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1869 | qdtdep_user | localhost | qdtdep_db | Query | 2912 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 1976 | qdtdep_user | localhost | qdtdep_db | Query | 2886 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2013 | qdtdep_user | localhost | qdtdep_db | Query | 2877 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2056 | qdtdep_user | localhost | qdtdep_db | Query | 2868 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2129 | qdtdep_user | localhost | qdtdep_db | Query | 2840 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2159 | qdtdep_user | localhost | qdtdep_db | Query | 2829 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2173 | qdtdep_user | localhost | qdtdep_db | Query | 2825 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2301 | qdtdep_user | localhost | qdtdep_db | Query | 2786 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2348 | qdtdep_user | localhost | qdtdep_db | Query | 2775 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2414 | qdtdep_user | localhost | qdtdep_db | Query | 2757 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2565 | qdtdep_user | localhost | qdtdep_db | Query | 2716 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2569 | qdtdep_user | localhost | qdtdep_db | Query | 2713 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2675 | qdtdep_user | localhost | qdtdep_db | Query | 2682 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2749 | qdtdep_user | localhost | qdtdep_db | Query | 2654 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2750 | qdtdep_user | localhost | qdtdep_db | Query | 2654 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2773 | qdtdep_user | localhost | qdtdep_db | Query | 2650 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2787 | qdtdep_user | localhost | qdtdep_db | Query | 2646 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2801 | qdtdep_user | localhost | qdtdep_db | Query | 2643 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2892 | qdtdep_user | localhost | qdtdep_db | Query | 2621 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2905 | qdtdep_user | localhost | qdtdep_db | Query | 2617 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2916 | qdtdep_user | localhost | qdtdep_db | Query | 2612 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2930 | qdtdep_user | localhost | qdtdep_db | Query | 2607 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2972 | qdtdep_user | localhost | qdtdep_db | Query | 2591 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 2980 | qdtdep_user | localhost | qdtdep_db | Query | 2587 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3012 | qdtdep_user | localhost | qdtdep_db | Query | 2576 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3021 | qdtdep_user | localhost | qdtdep_db | Query | 2571 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3054 | qdtdep_user | localhost | qdtdep_db | Query | 2560 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3063 | qdtdep_user | localhost | qdtdep_db | Query | 2558 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3124 | qdtdep_user | localhost | qdtdep_db | Query | 2540 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3150 | qdtdep_user | localhost | qdtdep_db | Query | 2531 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3153 | qdtdep_user | localhost | qdtdep_db | Query | 2530 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3218 | qdtdep_user | localhost | qdtdep_db | Query | 2509 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3229 | qdtdep_user | localhost | qdtdep_db | Query | 2505 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3244 | qdtdep_user | localhost | qdtdep_db | Query | 2501 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3247 | qdtdep_user | localhost | qdtdep_db | Query | 2499 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3265 | qdtdep_user | localhost | qdtdep_db | Query | 2494 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3305 | qdtdep_user | localhost | qdtdep_db | Query | 2483 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3327 | qdtdep_user | localhost | qdtdep_db | Query | 2469 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3343 | qdtdep_user | localhost | qdtdep_db | Query | 2465 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3388 | qdtdep_user | localhost | qdtdep_db | Query | 2452 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3429 | qdtdep_user | localhost | qdtdep_db | Query | 2438 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3476 | qdtdep_user | localhost | qdtdep_db | Query | 2425 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3498 | qdtdep_user | localhost | qdtdep_db | Query | 2421 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3528 | qdtdep_user | localhost | qdtdep_db | Query | 2407 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3578 | qdtdep_user | localhost | qdtdep_db | Query | 2391 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3581 | qdtdep_user | localhost | qdtdep_db | Query | 2390 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3610 | qdtdep_user | localhost | qdtdep_db | Query | 2377 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3649 | qdtdep_user | localhost | qdtdep_db | Query | 2359 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3654 | qdtdep_user | localhost | qdtdep_db | Query | 2356 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3736 | qdtdep_user | localhost | qdtdep_db | Query | 2328 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3740 | qdtdep_user | localhost | qdtdep_db | Query | 2326 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3758 | qdtdep_user | localhost | qdtdep_db | Query | 2319 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3791 | qdtdep_user | localhost | qdtdep_db | Query | 2304 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3801 | qdtdep_user | localhost | qdtdep_db | Query | 2295 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3824 | qdtdep_user | localhost | qdtdep_db | Query | 2286 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3826 | qdtdep_user | localhost | qdtdep_db | Query | 2278 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3837 | qdtdep_user | localhost | qdtdep_db | Query | 2267 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3839 | qdtdep_user | localhost | qdtdep_db | Query | 2266 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3840 | qdtdep_user | localhost | qdtdep_db | Query | 2265 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3862 | qdtdep_user | localhost | qdtdep_db | Query | 2249 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3869 | qdtdep_user | localhost | qdtdep_db | Query | 2243 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3875 | qdtdep_user | localhost | qdtdep_db | Query | 2240 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3882 | qdtdep_user | localhost | qdtdep_db | Query | 2236 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3883 | qdtdep_user | localhost | qdtdep_db | Query | 2233 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3887 | qdtdep_user | localhost | qdtdep_db | Query | 2226 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3889 | qdtdep_user | localhost | qdtdep_db | Query | 2208 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3891 | qdtdep_user | localhost | qdtdep_db | Query | 2206 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3892 | qdtdep_user | localhost | qdtdep_db | Query | 2204 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3895 | qdtdep_user | localhost | qdtdep_db | Query | 2171 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3896 | qdtdep_user | localhost | qdtdep_db | Query | 2170 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3901 | qdtdep_user | localhost | qdtdep_db | Query | 2103 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3902 | qdtdep_user | localhost | qdtdep_db | Query | 2098 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3904 | qdtdep_user | localhost | qdtdep_db | Query | 2086 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3908 | qdtdep_user | localhost | qdtdep_db | Query | 2021 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3922 | qdtdep_user | localhost | qdtdep_db | Query | 1456 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3923 | qdtdep_user | localhost | qdtdep_db | Query | 1455 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3924 | qdtdep_user | localhost | qdtdep_db | Query | 1456 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3926 | qdtdep_user | localhost | qdtdep_db | Query | 1456 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3927 | qdtdep_user | localhost | qdtdep_db | Query | 1456 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3929 | qdtdep_user | localhost | qdtdep_db | Query | 1456 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3931 | qdtdep_user | localhost | qdtdep_db | Query | 1456 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3932 | qdtdep_user | localhost | qdtdep_db | Query | 1455 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3933 | qdtdep_user | localhost | qdtdep_db | Query | 1455 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3934 | qdtdep_user | localhost | qdtdep_db | Query | 1455 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3935 | qdtdep_user | localhost | qdtdep_db | Query | 1455 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3937 | qdtdep_user | localhost | qdtdep_db | Query | 1454 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3939 | qdtdep_user | localhost | qdtdep_db | Query | 1455 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3940 | qdtdep_user | localhost | qdtdep_db | Query | 1454 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3941 | qdtdep_user | localhost | qdtdep_db | Query | 1454 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3943 | qdtdep_user | localhost | qdtdep_db | Query | 1454 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 3946 | qdtdep_user | localhost | qdtdep_db | Query | 1452 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 4205 | qdtdep_user | localhost | qdtdep_db | Query | 1427 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 4712 | qdtdep_user | localhost | qdtdep_db | Query | 1326 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 5433 | qdtdep_user | localhost | qdtdep_db | Query | 1207 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 5687 | qdtdep_user | localhost | qdtdep_db | Query | 1153 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 5990 | qdtdep_user | localhost | qdtdep_db | Query | 1073 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 6130 | qdtdep_user | localhost | qdtdep_db | Query | 1043 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 6488 | qdtdep_user | localhost | qdtdep_db | Query | 969 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 6604 | qdtdep_user | localhost | qdtdep_db | Query | 934 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 6801 | qdtdep_user | localhost | qdtdep_db | Query | 897 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 7086 | qdtdep_user | localhost | qdtdep_db | Query | 852 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 8072 | qdtdep_user | localhost | qdtdep_db | Query | 681 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 9140 | qdtdep_user | localhost | qdtdep_db | Query | 485 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 9911 | qdtdep_user | localhost | qdtdep_db | Query | 356 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 10580 | qdtdep_user | localhost | qdtdep_db | Query | 219 | Sending data | SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL | 0.000 |
    | 11722 | root | localhost | | Query | 0 | init | show processlist | 0.000 |
    +-------+-------------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
    Uptime: 3519 Threads: 140 Questions: 405200 Slow queries: 246 Opens: 1385 Flush tables: 1 Open tables: 1448 Queries per second avg: 115.146
    
    And when checking from the inside:
    Maria was processing this hundreds of times:
    Code:
    SELECT t.term_id FROM bsbwwo6pd_terms AS t INNER JOIN bsbwwo6pd_term_taxonomy AS tt ON tt.term_id =
    
    And minutes later hundreds of this:
    Code:
    SELECT p.ID AS 'id', p.post_title AS 'title', p.post_date AS 'date', p.post_author AS 'uid' , IFNULL
    
    Server loads went as high as 120

    But if I move the worspress site to antoher cPanel server with MySQL 5.6 it will run smooth (same server soecs) at
    Below 1.0
     
    #3 luigidelgado, Mar 9, 2016
    Last edited by a moderator: Mar 9, 2016
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You may need to tune your /etc/my.cnf file to prevent this from happening. Is there a URL to where you see this discussed in more detail?

    Thank you.
     
Loading...

Share This Page