emergency after core update mysql uses 100% cpu
Installation and Configuration
OK was able to login as that database user
not root only as the user
heres what the procvesslist looks like
| 13822 | greentec_jam | localhost | greentec_jam | Query | 65 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'jen-hookah' | 0.000 |
| 13823 | greentec_jam | localhost | greentec_jam | Query | 62 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'dreadlocks-f | 0.000 |
| 13826 | greentec_jam | localhost | greentec_jam | Query | 42 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 85 | 0.000 |
| 13827 | greentec_jam | localhost | greentec_jam | Query | 60 | Waiting for table level lock | SELECT `_item_id` AS i, `value` AS v FROM jr_jrprofile_item_key WHERE `key` = 'profile_private' AND | 0.000 |
| 13828 | greentec_jam | localhost | greentec_jam | Query | 60 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 85 | 0.000 |
| 13829 | greentec_jam | localhost | greentec_jam | Query | 58 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'heather-b' L | 0.000 |
| 13830 | greentec_jam | localhost | greentec_jam | Query | 42 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 6228 | 0.000 |
| 13833 | greentec_jam | localhost | greentec_jam | Query | 42 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 7800 | 0.000 |
| 13836 | greentec_jam | localhost | greentec_jam | Query | 43 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'heather' LIM | 0.000 |
| 13837 | greentec_jam | localhost | greentec_jam | Query | 43 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'dreadlocks-f | 0.000 |
| 13839 | greentec_jam | localhost | greentec_jam | Query | 42 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'britt' LIMIT | 0.000 |
| 13843 | greentec_jam | localhost | greentec_jam | Query | 42 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'soaring-eagl | 0.000 |
| 13845 | greentec_jam | localhost | greentec_jam | Query | 42 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'jen-hookah' | 0.000 |
| 13852 | greentec_jam | localhost | greentec_jam | Query | 42 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 5942 | 0.000 |
| 13855 | greentec_jam | localhost | greentec_jam | Query | 42 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 85 | 0.000 |
| 13891 | greentec_jam | localhost | greentec_jam | Query | 41 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'heather-b' L | 0.000 |
| 13892 | greentec_jam | localhost | greentec_jam | Query | 41 | Waiting for table level lock | SELECT `_item_id` AS i, `value` AS v FROM jr_jrprofile_item_key WHERE `key` = 'profile_private' AND | 0.000 |
| 13898 | greentec_jam | localhost | greentec_jam | Query | 32 | Waiting for table level lock | SELECT `key` FROM jr_jrprofile_item_key GROUP BY `key` ORDER BY `key` ASC | 0.000 |
| 13904 | greentec_jam | localhost | greentec_jam | Query | 30 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 14141 | 0.000 |
| 13906 | greentec_jam | localhost | greentec_jam | Query | 29 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'heather' LIM | 0.000 |
| 13909 | greentec_jam | localhost | greentec_jam | Query | 27 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'photo' LIMIT | 0.000 |
| 13910 | greentec_jam | localhost | greentec_jam | Query | 27 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'britt' LIMIT | 0.000 |
| 13911 | greentec_jam | localhost | greentec_jam | Query | 27 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'taye' LIMIT | 0.000 |
| 13912 | greentec_jam | localhost | greentec_jam | Query | 26 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'ben' LIMIT 1 | 0.000 |
| 13913 | greentec_jam | localhost | greentec_jam | Query | 25 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'soaring-eagl | 0.000 |
| 13919 | greentec_jam | localhost | greentec_jam | Query | 23 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 85 | 0.000 |
| 13920 | greentec_jam | localhost | NULL | Query | 0 | init | SHOW PROCESSLIST | 0.000 |
| 13925 | greentec_jam | localhost | greentec_jam | Query | 13 | Waiting for table level lock | SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_url' AND `value` = 'andrea2' LIM | 0.000 |
| 13929 | greentec_jam | localhost | greentec_jam | Query | 10 | Waiting for table level lock | SELECT `key` AS k,`index` AS x,`value` AS v FROM jr_jrprofile_item_key WHERE `_item_id` = 14141 | 0.000 |