ii upgraded from mysql to mariadb 10 last night
now the cpu use was all over the place but always many times higher then usual
router.php seemed to spawn way ore instances using more ram and cpu
everything seemed to use way more cpu it was often off the charts causing instability even ram and swap at 1 point for no explainable reason maxed out
mysql activity shows it doing the same repeating join sequence over and over
| 210888 | greentec_jam | localhost | greentec_jam | Query | 2 | Sending data | SELECT STRAIGHT_JOIN a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
JOIN jr_jrgallery_item_ke | 0.000 |
| 210956 | greentec_jam | localhost | greentec_jam | Sleep | 0 | | NULL | 0.000 |
| 210961 | greentec_jam | localhost | greentec_jam | Query | 2 | Sending data | SELECT STRAIGHT_JOIN a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
JOIN jr_jrgallery_item_ke | 0.000 |
| 210974 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
| 210988 | greentec_jam | localhost | greentec_jam | Query | 0 | Sending data | SELECT STRAIGHT_JOIN a.`_item_id` AS _item_id FROM jr_jrrating_item_key a
JOIN jr_jrrating_item_key | 0.000 |
--
soaringeagle
head dreadhead at dreadlocks site
glider pilot student and member/volunteer coordinator with freedoms wings international soaring for people with disabilities
updated by @soaringeagle: 01/23/16 04:40:02PM
