[BlueOnyx:22586] Re: Help please with mysqld

[Colin Jack]

Update:

Increased max-children to 20 and flushed Bayes database and it has settled down! 

Sorted (I hope).

Colin

> -----Original Message-----
> From: Blueonyx <blueonyx-bounces at mail.blueonyx.it> On Behalf Of Colin Jack
> Sent: 10 January 2019 12:10
> To: BlueOnyx General Mailing List <blueonyx at mail.blueonyx.it>
> Subject: [BlueOnyx:22585] Help please with mysqld
> 
> [root at pegasus log]# mysqladmin -u root -p processlist Enter password:
> +-------+--------+-----------+---------+---------+------+--------------+----------------------------------
> --------------------------------------------------------------------+
> | Id    | User   | Host      | db      | Command | Time | State        | Info
> |
> +-------+--------+-----------+---------+---------+------+--------------+----------------------------------
> --------------------------------------------------------------------+
> | 21776 | avspam | localhost | avspam6 | Killed  | 1250 |              |
> |
> | 22154 | avspam | localhost | avspam6 | Query   | 1292 | Sending data |
> SELECT count(*)
>                FROM bayes_token
>               WHERE id = '8'
>                 AND ati |
> | 22172 | avspam | localhost | avspam6 | Query   | 1180 | Sending data |
> SELECT count(*)
>                FROM bayes_token
>               WHERE id = '8'
>                 AND ati |
> | 22181 | avspam | localhost | avspam6 | Query   | 1152 | Sending data |
> SELECT count(*)
>                FROM bayes_token
>               WHERE id = '8'
>                 AND ati |
> | 22201 | avspam | localhost | avspam6 | Query   | 1140 | Sending data |
> SELECT count(*)
>                FROM bayes_token
>               WHERE id = '8'
>                 AND ati |
> | 22239 | avspam | localhost | avspam6 | Query   | 837  | Sending data |
> SELECT count(*)
>                FROM bayes_token
>               WHERE id = '8'
>                 AND ati |
> | 22319 | avspam | localhost | avspam6 | Query   | 548  | Sending data |
> SELECT count(*)
>                FROM bayes_token
>               WHERE id = '8'
>                 AND ati |
> | 22373 | avspam | localhost | avspam6 | Query   | 425  | Sending data |
> SELECT count(*)
>                FROM bayes_token
>               WHERE id = '8'
>                 AND ati |
> | 22395 | avspam | localhost | avspam6 | Query   | 314  | Sending data |
> SELECT count(*)
>                FROM bayes_token
>               WHERE id = '8'
>                 AND ati |
> | 22443 | avspam | localhost | avspam6 | Query   | 33   | Updating     | UPDATE
> bayes_token SET atime = '1547126154' WHERE id = '8' AND token IN
> (';?','!&?','7q??/','?   |
> | 22449 | avspam | localhost | avspam6 | Sleep   | 14   |              |
> |
> | 22450 | root   | localhost |         | Query   | 2    |              | show processlist
> |
> +-------+--------+-----------+---------+---------+------+--------------+----------------------------------
> --------------------------------------------------------------------+
> One of our VPS has suddenly started running slowly.
> Initial concern was that we may have a spam flood but no.
> 
> top - 12:06:49 up 1 day, 22:57,  1 user,  load average: 5.27, 5.12, 5.27
> Tasks: 153 total,   2 running, 150 sleeping,   0 stopped,   1 zombie
> Cpu(s): 15.4%us,  1.7%sy,  0.0%ni, 67.5%id, 15.5%wa,  0.0%hi,  0.0%si,  0.0%st
> Mem:  12582912k total, 10093908k used,  2489004k free,        0k buffers
> Swap:  4194304k total,   292380k used,  3901924k free,  7218020k cached
> 
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
>  8410 mysql     20   0 1589m  34m 4480 S 170.2  0.3   3649:55 mysqld
>  4275 michrow   20   0  296m  88m 3136 R 99.9  0.7   0:07.10 spamd
>  3830 admserv   20   0  435m  20m 5352 D  1.0  0.2   0:00.22 httpd.admsrv
>  3406 root      20   0 36348 2628 1872 S  0.7  0.0   0:00.29 auth
>  3326 root      20   0  113m 1400  984 D  0.3  0.0   0:00.16 tar
>  3327 root      20   0 1212m 9.8m  572 S  0.3  0.1   0:02.24 pigz
>  3686 root      20   0 15032 1292  944 R  0.3  0.0   0:00.71 top
>  8614 tomcat    20   0 5577m  50m 2972 S  0.3  0.4   4:26.72 java
>  9664 root      20   0  139m 3232 1024 S  0.3  0.0   4:14.46 sec
> 
> MySQL seems to have gone crazy!
> 
> I would appreciate some help in tracking down what is causing this.
> 
> 5208R - fully up to date.
> Tried rebooting which clears it briefly.
> 
> Thanks
> 
> Colin
> 
> 
> 
> _______________________________________________
> Blueonyx mailing list
> Blueonyx at mail.blueonyx.it
> http://mail.blueonyx.it/mailman/listinfo/blueonyx