Skip to main content

Are not all databases compatible with how MariaDB handles it?

luigidelgado
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?

Comments

3 comments

Date Votes
  • cPanelMichael
    The issue was with temporary tables using BLOB and TEXT. MariaDB didn't liked them.

    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.
    0
  • luigidelgado
    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:
    /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:
    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:
    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
    0
  • cPanelMichael
    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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post