Gamipress plugin slows down site, causes high over load on cpu, slows mysql
-
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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_gamipress_logs_meta
(log_id
,meta_key
,meta_value
) VALUES (‘615838’, ‘_gami | 0.000 |
| 471 | themachine828 | localhost | themachine828 | Query | 622 | update | INSERT INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 INTOwp2r_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 |
+——+—————-+———–+—————-+———+——+——————————+——————————————————————————————————+———-+
- The topic ‘Gamipress plugin slows down site, causes high over load on cpu, slows mysql’ is closed to new replies.