Displaying 3 results from an estimated 3 matches for "time_ms".
2019 Oct 30
2
Dovecot and MySQL aborted connections.
We also spotted these sql connections getting aborted, upon upgrading
MySQL from 5.6 to 5.7. (Going back to 5.6 we don't see them!)
Turning on mysql general query logging we can see it is Dovecot's mysql
connections that inquire about or update quota usage in particular:
*** /logs//mysql.log ***
2019-10-30T10:52:22.624690-07:00 2 Connect dovecot at localhost on
npomail using
2019 Oct 30
0
Dovecot and MySQL aborted connections.
...2 is dovecot):
mysql> select * from INFORMATION_SCHEMA.PROCESSLIST where USER like 'vmail%';
+-----+--------+-----------------+-------+---------+------+-------+------+---------+-----------+---------------+------+
| ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | TID |
+-----+--------+-----------------+-------+---------+------+-------+------+---------+-----------+---------------+------+
| 147 | vmail | localhost | vmail | Sleep | 1 | | NULL | 566 | 0 | 0 | 6664 |
| 148 | vmail | local...
2019 Oct 31
2
Dovecot and MySQL aborted connections.
...> mysql> select * from INFORMATION_SCHEMA.PROCESSLIST where USER like 'vmail%';
> +-----+--------+-----------------+-------+---------+------+-------+------+---------+-----------+---------------+------+
> | ID | USER | HOST | DB | COMMAND | TIME | STATE | INFO | TIME_MS | ROWS_SENT | ROWS_EXAMINED | TID |
> +-----+--------+-----------------+-------+---------+------+-------+------+---------+-----------+---------------+------+
> | 147 | vmail | localhost | vmail | Sleep | 1 | | NULL | 566 | 0 | 0 | 6664 |
> | 148 |...