Displaying 4 results from an estimated 4 matches for "rows_examined".
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.
...gt; 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 | localhost | vmail | Sleep...
2019 Oct 31
2
Dovecot and MySQL aborted connections.
...* 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 | localhost |...
2013 Oct 08
4
'puppet storeconfigs export' killed
...SQL server receives the query and returns the data,
according to MySQL''s slow-queries.log:
# Time: 131008 17:06:14
# User@Host: puppet[puppet] @ [172.20.59.127]
# Thread_id: 169 Schema: puppet Last_errno: 0 Killed: 0
# Query_time: 189.509563 Lock_time: 0.000136 Rows_sent: 6168111
Rows_examined: 12712154 Rows_affected: 0 Rows_read: 18446744073709551613
# Bytes_sent: 2426331478 Tmp_tables: 0 Tmp_disk_tables: 0
Tmp_table_sizes: 0
# InnoDB_trx_id: A93
SET timestamp=1381244774;
SELECT `hosts`.`id` AS t0_r0, `hosts`.`name` AS t0_r1, `hosts`.`ip` AS
t0_r2, `hosts`.`environment` AS t0_r3,...