Forum Activity for @soaringeagle

soaringeagle
@soaringeagle
08/30/17 12:21:02PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

btw it absolutely is running despite saying its not
i'll see what the colocation gyuy can do then if i have to reboot and do integhrity check.. etc at least the ram will be cleared out for sa good 30 minutes or so
soaringeagle
@soaringeagle
08/30/17 12:17:06PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

i get this when i try
 service mysql stop
cat: /var/lib/mysql//server.dreadlockssite.com.pid: Permission denied
 ERROR! MySQL server process # is not running!
rm: remove write-protected regular file `/var/lib/mysql//server.dreadlockssite.com.pid'?

my instints to not rem,ove it?
soaringeagle
@soaringeagle
08/30/17 12:10:20PM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

since that was stuck in the processlist.. without queues or repairs (and site in maintenance mode) ran badblocks found 10 on 1st drive scanned
that and the issue having restarting MySQL etc the place i collocate at is going to login and try to straighten it out... good thing a neighbour runs something like nearby geek or something and suggested might be a drive issue... which now totally makes sense...cpu prying to access data it cant
i dunno though since ram keeps climbing too
was getting too manmy connections like a dod attack
soaringeagle
@soaringeagle
08/30/17 11:44:12AM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

i paused all queues and still get 72 rows of this and think this is using up asll the cpus
| 33087 | greentec_jam | localhost | NULL         | Query   |    0 | init                 | SHOW PROCESSLIST                                                                                     |    0.000 |
| 34408 | greentec_jam | localhost | greentec_jam | Query   | 5405 | 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 |
| 34489 | greentec_jam | localhost | greentec_jam | Query   | 5398 | 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 |
| 35284 | greentec_jam | localhost | greentec_jam | Query   | 5308 | 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 |
| 35749 | greentec_jam | localhost | greentec_jam | Query   | 5262 | 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 |
| 36338 | greentec_jam | localhost | greentec_jam | Query   | 5203 | 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 |
| 37627 | greentec_jam | localhost | greentec_jam | Query   | 5079 | 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 |
| 38081 | greentec_jam | localhost | greentec_jam | Query   | 5045 | 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 |
| 38273 | greentec_jam | localhost | greentec_jam | Query   | 5024 | 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 |
| 38297 | greentec_jam | localhost | greentec_jam | Query   | 5007 | 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 |
| 38328 | greentec_jam | localhost | greentec_jam | Query   | 5006 | 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 |
| 38731 | greentec_jam | localhost | greentec_jam | Query   | 4949 | 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 |
| 39149 | greentec_jam | localhost | greentec_jam | Query   | 4895 | 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 |
| 39201 | greentec_jam | localhost | greentec_jam | Query   | 4889 | 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 |
| 39262 | greentec_jam | localhost | greentec_jam | Query   | 4886 | 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 |
| 39616 | greentec_jam | localhost | greentec_jam | Query   | 4838 | 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 |
| 39819 | greentec_jam | localhost | greentec_jam | Query   | 4811 | 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 |
| 39999 | greentec_jam | localhost | greentec_jam | Query   | 4784 | 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 |
| 40090 | greentec_jam | localhost | greentec_jam | Query   | 4773 | 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 |
| 40178 | greentec_jam | localhost | greentec_jam | Query   | 4761 | 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 |
| 40634 | greentec_jam | localhost | greentec_jam | Query   | 4697 | 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 |
| 40694 | greentec_jam | localhost | greentec_jam | Query   | 4692 | 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 |
| 41000 | greentec_jam | localhost | greentec_jam | Query   | 4659 | 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 |
| 41615 | greentec_jam | localhost | greentec_jam | Query   | 4577 | 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 |
| 42142 | greentec_jam | localhost | greentec_jam | Query   | 4514 | 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 |
| 42822 | greentec_jam | localhost | greentec_jam | Query   | 4438 | 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 |
| 43038 | greentec_jam | localhost | greentec_jam | Query   | 4391 | 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 |
| 43209 | greentec_jam | localhost | greentec_jam | Query   | 4336 | 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 |
| 43623 | greentec_jam | localhost | greentec_jam | Query   | 4288 | 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 |
| 43666 | greentec_jam | localhost | greentec_jam | Query   | 4283 | 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 |
| 43871 | greentec_jam | localhost | greentec_jam | Query   | 4261 | 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 |
| 44195 | greentec_jam | localhost | greentec_jam | Query   | 4225 | 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 |
| 44202 | greentec_jam | localhost | greentec_jam | Query   | 4224 | 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 |
| 44345 | greentec_jam | localhost | greentec_jam | Query   | 4186 | 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 |
| 44706 | greentec_jam | localhost | greentec_jam | Query   | 4114 | 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 |
| 44937 | greentec_jam | localhost | greentec_jam | Query   | 4087 | 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 |
| 45010 | greentec_jam | localhost | greentec_jam | Query   | 4076 | 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 |
| 45437 | greentec_jam | localhost | greentec_jam | Query   | 4016 | 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 |
| 45514 | greentec_jam | localhost | greentec_jam | Query   | 4003 | 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 |
| 45663 | greentec_jam | localhost | greentec_jam | Query   | 3973 | 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 |
| 45754 | greentec_jam | localhost | greentec_jam | Query   | 3960 | 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 |
| 46422 | greentec_jam | localhost | greentec_jam | Query   | 3864 | 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 |
| 46490 | greentec_jam | localhost | greentec_jam | Query   | 3854 | 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 |
| 46527 | greentec_jam | localhost | greentec_jam | Query   | 3847 | 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 |
| 47197 | greentec_jam | localhost | greentec_jam | Query   | 3708 | 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 |
| 47895 | greentec_jam | localhost | greentec_jam | Query   | 3595 | 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 |
| 47958 | greentec_jam | localhost | greentec_jam | Query   | 3564 | 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 |
| 48008 | greentec_jam | localhost | greentec_jam | Query   | 3558 | 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 |
| 48135 | greentec_jam | localhost | greentec_jam | Query   | 3540 | 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 |
| 48664 | greentec_jam | localhost | greentec_jam | Query   | 3476 | 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 |
| 49041 | greentec_jam | localhost | greentec_jam | Query   | 3421 | 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 |
+-------+--------------+-----------+--------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+----------+
thought it wasd from the integrity check stopping at the repair jr gallery item key (i think or item)
soaringeagle
@soaringeagle
08/30/17 10:39:54AM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

update.. sites responding theres 24 queue entries im doing a full integrity check all options if i gotta go through the queue and reset all till the core 1 is 1st i will but cpu and ram are still dangerously high..
soaringeagle
@soaringeagle
08/30/17 10:01:30AM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

BACKED OUT OF THAT AND NOW ONLY
| 14888 | greentec_jam | localhost | greentec_jam | Query   |  725 | 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 |
| 14904 | greentec_jam | localhost | greentec_jam | Query   |  723 | 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 |
| 17197 | greentec_jam | localhost | greentec_jam | Query   |  572 | 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 |
| 17961 | greentec_jam | localhost | greentec_jam | Query   |  541 | 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 |
| 21316 | greentec_jam | localhost | greentec_jam | Query   |  405 | 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 |
| 22171 | greentec_jam | localhost | greentec_jam | Query   |  357 | 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 |
| 22410 | greentec_jam | localhost | greentec_jam | Query   |  344 | 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 |
| 23141 | 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 |
| 23318 | 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 |
| 24811 | greentec_jam | localhost | greentec_jam | Query   |  192 | 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 |
| 25377 | greentec_jam | localhost | greentec_jam | Query   |   74 | 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 |
| 25745 | 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 |
| 25838 | greentec_jam | localhost | greentec_jam | Query   |    6 | 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 |
| 25917 | greentec_jam | localhost | greentec_jam | Sleep   |    0 |                      | NULL 

rams creeping towards 100%
im going to try opening several putty sessions login to mysqwl as several users (any i suspect might be the issue) check all processes but i am having issues repairing the dreadlockssite 1 that's wjhy i think that's the 1
soaringeagle
@soaringeagle
08/30/17 09:55:54AM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

i am try ing to repair from phpmyadmin but in small chunks (1 oir 2 modules at a time) so thry complete 1 threw a serious error comments
oh wait yes in edge i was trying to run the repair.php
soaringeagle
@soaringeagle
08/30/17 09:31:48AM
3,304 posts

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 |
soaringeagle
@soaringeagle
08/30/17 09:23:53AM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

cant even get into MySQL
for some weird reason it wont let me login i even changed root password to be certain i could but its still not letting me in
soaringeagle
@soaringeagle
08/30/17 08:51:04AM
3,304 posts

emergency after core update mysql uses 100% cpu


Installation and Configuration

i cant be absolutely certain its the cause but repairing tables in phpmyadmin get a gateway timeout
running repair.php gets connection timeout
(renaming the filer in plesk failed with mv command failure had to edit in nano save with new filename)

ran
myisamchk -r /var/lib/mysql/greentec_jam/*
it said it fixed a bunch of errors
still can't run repair.php (if integrity checks a must after core updates like it was upgrading to 6.0 can't it be enforced to run before any other updates?)
i'm scared to update my other sites core now
updated by @soaringeagle: 12/01/17 10:07:30PM
  61