emergency after core update mysql uses 100% cpu
Installation and Configuration
i keep getting a 304 gateway timeout in phpomyadmin
i read that might be caused by my isp bloicking requestsd that take too long/
its absolutely something in the gallery the processlist fills up with 1st waiting to lock then these
| 158 | greentec_jam | localhost | greentec_jam | Query | 938 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 160 | greentec_jam | localhost | greentec_jam | Query | 935 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 1013 | greentec_jam | localhost | greentec_jam | Query | 865 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 2961 | greentec_jam | localhost | greentec_jam | Query | 703 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 3071 | greentec_jam | localhost | greentec_jam | Query | 684 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 3162 | greentec_jam | localhost | greentec_jam | Query | 672 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 3173 | greentec_jam | localhost | greentec_jam | Query | 669 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 3227 | greentec_jam | localhost | greentec_jam | Query | 664 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 3743 | greentec_jam | localhost | greentec_jam | Query | 590 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 4012 | greentec_jam | localhost | greentec_jam | Query | 554 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 4140 | greentec_jam | localhost | greentec_jam | Query | 544 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 4653 | greentec_jam | localhost | greentec_jam | Query | 508 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 5359 | greentec_jam | localhost | greentec_jam | Query | 453 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 5448 | greentec_jam | localhost | greentec_jam | Query | 443 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 5879 | greentec_jam | localhost | greentec_jam | Query | 370 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 6252 | greentec_jam | localhost | greentec_jam | Query | 294 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 6293 | greentec_jam | localhost | greentec_jam | Query | 283 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 6616 | greentec_jam | localhost | greentec_jam | Query | 225 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 6724 | greentec_jam | localhost | greentec_jam | Query | 200 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 6747 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
| 7312 | greentec_jam | localhost | greentec_jam | Query | 46 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
| 7459 | greentec_jam | localhost | greentec_jam | Query | 16 | Copying to tmp table | SELECT a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
WHERE a.`key` = 'gallery_image_size' AN | 0.000 |
+------+--------------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+
even if i do nothing after restarting MySQL they stasart filling up till i get too many connections
had 160 some rows at times