Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Are not all databases compatible with how MariaDB handles it?

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

  1. luigidelgado

    luigidelgado Well-Known Member

    Joined:
    Nov 6, 2010
    Messages:
    119
    Likes Received:
    5
    Trophy Points:
    68
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,423
    Likes Received:
    1,956
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. luigidelgado

    luigidelgado Well-Known Member

    Joined:
    Nov 6, 2010
    Messages:
    119
    Likes Received:
    5
    Trophy Points:
    68
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 luigidelgado, Mar 9, 2016
    Last edited by a moderator: Mar 9, 2016
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,423
    Likes Received:
    1,956
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice