Gamipress plugin slows down site, causes high over load on cpu, slows mysql

  • Resolved karinkonig85

    (@karinkonig85)


    6 years, 2 months ago

    We installed the GAMIPRESS PLUGIN to rewards users for specific comment on our blog. But it seems this plugin is doing something more than expected causing high over load on our 16 CPU CORES and 32GB RAM. Please what is the problem and how can we contain this situation. the following queries are still in progress:

    [root@cloud ~]# mysqladmin processlist
    +——+—————-+———–+—————-+———+——+——————————+——————————————————————————————————+———-+
    | Id | User | Host | db | Command | Time | State | Info | Progress |
    +——+—————-+———–+—————-+———+——+——————————+——————————————————————————————————+———-+
    | 2 | themachine828 | localhost | themachine828 | Query | 1822 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 5 | themachine828 | localhost | themachine828 | Query | 146 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615784’, ‘_gami | 0.000 |
    | 6 | themachine828 | localhost | themachine828 | Query | 100 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615787’, ‘_gami | 0.000 |
    | 8 | themachine828 | localhost | themachine828 | Query | 177 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615781’, ‘_gami | 0.000 |
    | 11 | themachine828 | localhost | themachine828 | Query | 161 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615783’, ‘_gami | 0.000 |
    | 12 | themachine828 | localhost | themachine828 | Query | 1838 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 13 | themachine828 | localhost | themachine828 | Query | 1826 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 16 | themachine828 | localhost | themachine828 | Query | 1802 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 17 | themachine828 | localhost | themachine828 | Query | 78 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615767’, ‘_gami | 0.000 |
    | 18 | themachine828 | localhost | themachine828 | Query | 206 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615780’, ‘_gami | 0.000 |
    | 21 | themachine828 | localhost | themachine828 | Query | 1817 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 31 | themachine828 | localhost | themachine828 | Query | 602 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615791’, ‘_gami | 0.000 |
    | 36 | themachine828 | localhost | themachine828 | Query | 159 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 43 | themachine828 | localhost | themachine828 | Query | 522 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615794’, ‘_gami | 0.000 |
    | 50 | themachine828 | localhost | themachine828 | Query | 308 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615888’, ‘_gami | 0.000 |
    | 51 | themachine828 | localhost | themachine828 | Query | 482 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615795’, ‘_gami | 0.000 |
    | 55 | themachine828 | localhost | themachine828 | Query | 473 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615798’, ‘_gami | 0.000 |
    | 59 | themachine828 | localhost | themachine828 | Query | 128 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615895’, ‘_gami | 0.000 |
    | 62 | themachine828 | localhost | themachine828 | Query | 469 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615799’, ‘_gami | 0.000 |
    | 63 | themachine828 | localhost | themachine828 | Query | 182 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615825’, ‘_gami | 0.000 |
    | 65 | themachine828 | localhost | themachine828 | Query | 460 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615800’, ‘_gami | 0.000 |
    | 69 | themachine828 | localhost | themachine828 | Query | 64 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615897’, ‘_gami | 0.000 |
    | 77 | themachine828 | localhost | themachine828 | Query | 56 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615898’, ‘_gami | 0.000 |
    | 79 | themachine828 | localhost | themachine828 | Query | 183 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615826’, ‘_gami | 0.000 |
    | 86 | themachine828 | localhost | themachine828 | Query | 456 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615801’, ‘_gami | 0.000 |
    | 93 | themachine828 | localhost | themachine828 | Query | 398 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615853’, ‘_gami | 0.000 |
    | 109 | themachine828 | localhost | themachine828 | Query | 222 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615864’, ‘_gami | 0.000 |
    | 110 | themachine828 | localhost | themachine828 | Query | 217 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615903’, ‘_gami | 0.000 |
    | 111 | themachine828 | localhost | themachine828 | Query | 214 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615865’, ‘_gami | 0.000 |
    | 112 | themachine828 | localhost | themachine828 | Query | 202 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615904’, ‘_gami | 0.000 |
    | 114 | themachine828 | localhost | themachine828 | Query | 140 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615833’, ‘_gami | 0.000 |
    | 125 | themachine828 | localhost | themachine828 | Query | 100 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615905’, ‘_gami | 0.000 |
    | 132 | themachine828 | localhost | themachine828 | Query | 45 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615907’, ‘_gami | 0.000 |
    | 136 | themachine828 | localhost | themachine828 | Query | 93 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615906’, ‘_gami | 0.000 |
    | 140 | themachine828 | localhost | themachine828 | Query | 119 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615835’, ‘_gami | 0.000 |
    | 165 | themachine828 | localhost | themachine828 | Query | 596 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615792’, ‘_gami | 0.000 |
    | 170 | themachine828 | localhost | themachine828 | Query | 7 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615908’, ‘_gami | 0.000 |
    | 177 | themachine828 | localhost | themachine828 | Query | 1186 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 178 | themachine828 | localhost | themachine828 | Query | 1283 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 179 | themachine828 | localhost | themachine828 | Query | 1260 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 180 | themachine828 | localhost | themachine828 | Query | 1258 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 181 | themachine828 | localhost | themachine828 | Query | 464 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615797’, ‘_gami | 0.000 |
    | 182 | themachine828 | localhost | themachine828 | Query | 547 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615874’, ‘_gami | 0.000 |
    | 184 | themachine828 | localhost | themachine828 | Query | 609 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615871’, ‘_gami | 0.000 |
    | 185 | themachine828 | localhost | themachine828 | Query | 480 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615796’, ‘_gami | 0.000 |
    | 186 | themachine828 | localhost | themachine828 | Query | 1185 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 189 | themachine828 | localhost | themachine828 | Query | 616 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615836’, ‘_gami | 0.000 |
    | 191 | themachine828 | localhost | themachine828 | Query | 536 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615841’, ‘_gami | 0.000 |
    | 192 | themachine828 | localhost | themachine828 | Query | 438 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615802’, ‘_gami | 0.000 |
    | 193 | themachine828 | localhost | themachine828 | Query | 529 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615842’, ‘_gami | 0.000 |
    | 195 | themachine828 | localhost | themachine828 | Query | 537 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615840’, ‘_gami | 0.000 |
    | 197 | themachine828 | localhost | themachine828 | Query | 454 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615847’, ‘_gami | 0.000 |
    | 231 | themachine828 | localhost | themachine828 | Query | 348 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615810’, ‘_gami | 0.000 |
    | 232 | themachine828 | localhost | themachine828 | Query | 567 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615872’, ‘_gami | 0.000 |
    | 235 | themachine828 | localhost | themachine828 | Query | 436 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615804’, ‘_gami | 0.000 |
    | 236 | themachine828 | localhost | themachine828 | Query | 342 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615811’, ‘_gami | 0.000 |
    | 237 | themachine828 | localhost | themachine828 | Query | 406 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615851’, ‘_gami | 0.000 |
    | 256 | themachine828 | localhost | themachine828 | Query | 430 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615880’, ‘_gami | 0.000 |
    | 257 | themachine828 | localhost | themachine828 | Query | 399 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615806’, ‘_gami | 0.000 |
    | 258 | themachine828 | localhost | themachine828 | Query | 428 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615803’, ‘_gami | 0.000 |
    | 262 | themachine828 | localhost | themachine828 | Query | 394 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615807’, ‘_gami | 0.000 |
    | 292 | themachine828 | localhost | themachine828 | Query | 377 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615856’, ‘_gami | 0.000 |
    | 295 | themachine828 | localhost | themachine828 | Query | 388 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615808’, ‘_gami | 0.000 |
    | 298 | themachine828 | localhost | themachine828 | Query | 402 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615881’, ‘_gami | 0.000 |
    | 311 | themachine828 | localhost | themachine828 | Query | 286 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615863’, ‘_gami | 0.000 |
    | 327 | themachine828 | localhost | themachine828 | Query | 351 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615858’, ‘_gami | 0.000 |
    | 334 | themachine828 | localhost | themachine828 | Query | 385 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615883’, ‘_gami | 0.000 |
    | 338 | themachine828 | localhost | themachine828 | Query | 364 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615886’, ‘_gami | 0.000 |
    | 346 | themachine828 | localhost | themachine828 | Query | 337 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615812’, ‘_gami | 0.000 |
    | 347 | themachine828 | localhost | themachine828 | Query | 326 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615859’, ‘_gami | 0.000 |
    | 355 | themachine828 | localhost | themachine828 | Query | 292 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615816’, ‘_gami | 0.000 |
    | 360 | themachine828 | localhost | themachine828 | Query | 304 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615814’, ‘_gami | 0.000 |
    | 369 | themachine828 | localhost | themachine828 | Query | 334 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615813’, ‘_gami | 0.000 |
    | 383 | themachine828 | localhost | themachine828 | Query | 236 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615820’, ‘_gami | 0.000 |
    | 384 | themachine828 | localhost | themachine828 | Query | 177 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615828’, ‘_gami | 0.000 |
    | 387 | themachine828 | localhost | themachine828 | Query | 300 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615815’, ‘_gami | 0.000 |
    | 390 | themachine828 | localhost | themachine828 | Query | 236 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615819’, ‘_gami | 0.000 |
    | 391 | themachine828 | localhost | themachine828 | Query | 235 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615821’, ‘_gami | 0.000 |
    | 394 | themachine828 | localhost | themachine828 | Query | 145 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615831’, ‘_gami | 0.000 |
    | 396 | themachine828 | localhost | themachine828 | Query | 284 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615817’, ‘_gami | 0.000 |
    | 399 | themachine828 | localhost | themachine828 | Query | 555 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615900’, ‘_gami | 0.000 |
    | 403 | themachine828 | localhost | themachine828 | Query | 258 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615891’, ‘_gami | 0.000 |
    | 407 | themachine828 | localhost | themachine828 | Query | 248 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615818’, ‘_gami | 0.000 |
    | 413 | themachine828 | localhost | themachine828 | Query | 154 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615829’, ‘_gami | 0.000 |
    | 419 | themachine828 | localhost | themachine828 | Query | 186 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615824’, ‘_gami | 0.000 |
    | 426 | themachine828 | localhost | themachine828 | Query | 144 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615832’, ‘_gami | 0.000 |
    | 431 | themachine828 | localhost | themachine828 | Query | 153 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615830’, ‘_gami | 0.000 |
    | 448 | themachine828 | localhost | themachine828 | Query | 139 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615834’, ‘_gami | 0.000 |
    | 466 | themachine828 | localhost | themachine828 | Query | 2229 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 468 | themachine828 | localhost | themachine828 | Query | 2279 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 469 | themachine828 | localhost | themachine828 | Query | 544 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615839’, ‘_gami | 0.000 |
    | 470 | themachine828 | localhost | themachine828 | Query | 560 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615838’, ‘_gami | 0.000 |
    | 471 | themachine828 | localhost | themachine828 | Query | 622 | update | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615899’, ‘_gami | 0.000 |
    | 479 | themachine828 | localhost | themachine828 | Query | 107 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615896’, ‘_gami | 0.000 |
    | 488 | themachine828 | localhost | themachine828 | Query | 2170 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 498 | themachine828 | localhost | themachine828 | Query | 2146 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 499 | themachine828 | localhost | themachine828 | Query | 522 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615843’, ‘_gami | 0.000 |
    | 507 | themachine828 | localhost | themachine828 | Query | 490 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615845’, ‘_gami | 0.000 |
    | 509 | themachine828 | localhost | themachine828 | Query | 441 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615850’, ‘_gami | 0.000 |
    | 510 | themachine828 | localhost | themachine828 | Query | 508 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615844’, ‘_gami | 0.000 |
    | 520 | themachine828 | localhost | themachine828 | Query | 2086 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 542 | themachine828 | localhost | themachine828 | Query | 446 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615848’, ‘_gami | 0.000 |
    | 543 | themachine828 | localhost | themachine828 | Query | 444 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615849’, ‘_gami | 0.000 |
    | 545 | themachine828 | localhost | themachine828 | Query | 416 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615852’, ‘_gami | 0.000 |
    | 549 | themachine828 | localhost | themachine828 | Query | 2062 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 556 | themachine828 | localhost | themachine828 | Query | 136 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615869’, ‘_gami | 0.000 |
    | 562 | themachine828 | localhost | themachine828 | Query | 2039 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 563 | themachine828 | localhost | themachine828 | Query | 804 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 564 | themachine828 | localhost | themachine828 | Query | 1970 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 565 | themachine828 | localhost | themachine828 | Query | 1769 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 566 | themachine828 | localhost | themachine828 | Query | 1932 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 583 | themachine828 | localhost | themachine828 | Query | 321 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615860’, ‘_gami | 0.000 |
    | 586 | themachine828 | localhost | themachine828 | Query | 313 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615861’, ‘_gami | 0.000 |
    | 602 | themachine828 | localhost | themachine828 | Query | 1677 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 611 | themachine828 | localhost | themachine828 | Query | 189 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615867’, ‘_gami | 0.000 |
    | 615 | themachine828 | localhost | themachine828 | Query | 162 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615868’, ‘_gami | 0.000 |
    | 634 | themachine828 | localhost | themachine828 | Query | 552 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615873’, ‘_gami | 0.000 |
    | 654 | themachine828 | localhost | themachine828 | Query | 395 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615882’, ‘_gami | 0.000 |
    | 660 | themachine828 | localhost | themachine828 | Query | 318 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615887’, ‘_gami | 0.000 |
    | 667 | themachine828 | localhost | themachine828 | Query | 270 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615890’, ‘_gami | 0.000 |
    | 699 | themachine828 | localhost | themachine828 | Query | 540 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615901’, ‘_gami | 0.000 |
    | 706 | themachine828 | localhost | themachine828 | Query | 491 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615846’, ‘_gami | 0.000 |
    | 728 | themachine828 | localhost | themachine828 | Query | 385 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615854’, ‘_gami | 0.000 |
    | 741 | themachine828 | localhost | themachine828 | Query | 302 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615862’, ‘_gami | 0.000 |
    | 742 | themachine828 | localhost | themachine828 | Query | 244 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615902’, ‘_gami | 0.000 |
    | 774 | themachine828 | localhost | themachine828 | Query | 132 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615870’, ‘_gami | 0.000 |
    | 775 | themachine828 | localhost | themachine828 | Query | 34 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |
    | 786 | themachine828 | localhost | themachine828 | Query | 620 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615773’, ‘_gami | 0.000 |
    | 787 | eximstats | localhost | eximstats | Sleep | 193 | | | 0.000 |
    | 789 | themachine828 | localhost | themachine828 | Query | 591 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615774’, ‘_gami | 0.000 |
    | 796 | themachine828 | localhost | themachine828 | Query | 545 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615875’, ‘_gami | 0.000 |
    | 802 | themachine828 | localhost | themachine828 | Query | 530 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615775’, ‘_gami | 0.000 |
    | 825 | themachine828 | localhost | themachine828 | Query | 291 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615889’, ‘_gami | 0.000 |
    | 829 | themachine828 | localhost | themachine828 | Query | 62 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615789’, ‘_gami | 0.000 |
    | 844 | themachine828 | localhost | themachine828 | Query | 493 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615756’, ‘_gami | 0.000 |
    | 871 | themachine828 | localhost | themachine828 | Query | 49 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615771’, ‘_gami | 0.000 |
    | 892 | themachine828 | localhost | themachine828 | Query | 522 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615876’, ‘_gami | 0.000 |
    | 903 | themachine828 | localhost | themachine828 | Query | 425 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615777’, ‘_gami | 0.000 |
    | 981 | themachine828 | localhost | themachine828 | Query | 505 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615877’, ‘_gami | 0.000 |
    | 1009 | themachine828 | localhost | themachine828 | Query | 419 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615805’, ‘_gami | 0.000 |
    | 1014 | themachine828 | localhost | themachine828 | Query | 365 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615884’, ‘_gami | 0.000 |
    | 1088 | themachine828 | localhost | themachine828 | Query | 497 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615878’, ‘_gami | 0.000 |
    | 1089 | themachine828 | localhost | themachine828 | Query | 447 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615879’, ‘_gami | 0.000 |
    | 1092 | themachine828 | localhost | themachine828 | Query | 365 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615885’, ‘_gami | 0.000 |
    | 1094 | themachine828 | localhost | themachine828 | Query | 217 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615892’, ‘_gami | 0.000 |
    | 1095 | themachine828 | localhost | themachine828 | Query | 195 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615893’, ‘_gami | 0.000 |
    | 1098 | themachine828 | localhost | themachine828 | Query | 160 | Waiting for table level lock | INSERT INTO wp2r_gamipress_logs_meta (log_id, meta_key, meta_value) VALUES (‘615894’, ‘_gami | 0.000 |
    | 1389 | themachine828 | localhost | themachine828 | Sleep | 0 | | | 0.000 |
    | 1390 | themachine828 | localhost | themachine828 | Sleep | 0 | | | 0.000 |
    | 1391 | root | localhost | | Query | 0 | init | show processlist | 0.000 |
    +——+—————-+———–+—————-+———+——+——————————+——————————————————————————————————+———-+

Viewing 1 replies (of 1 total)
  • Plugin Author Ruben Garcia

    (@rubengc)

    Hi @karinkonig85

    Thank you so much for your deep report

    Looks like the highest process on your server is the backup of the gamipress_logs and gamipress_logs_meta table as I can see on first process:

    | 2 | themachine828 | localhost | themachine828 | Query | 1822 | Copying to tmp table | SELECT l.*
    FROM wp2r_gamipress_logs AS l
    LEFT JOIN wp2r_gamipress_logs_meta AS | 0.000 |

    This copying process get repeated many times and copy two full tables every few queries are really expensive for any server so check which process is trying to make this copy

    A setting that could improve the speed of your GamiPress install is the “Only logs activities in use” located at GamiPress -> Settings -> Logs tab

    By checking it, GamiPress will enter on a strict mode and just will log events that are in use as a points award, points deduct, achievement step or rank requirement

    Best regards

Viewing 1 replies (of 1 total)
  • The topic ‘Gamipress plugin slows down site, causes high over load on cpu, slows mysql’ is closed to new replies.