Playing with TokuDB updates I noticed in SHOW PROCESSLIST unsual for MySQL State.
|
1 2 3 4 5 6 7 8 9 10 11 12 |
mysql> show processlist; +----+------+-----------+--------+---------+------+---------------------------+-----------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+--------+---------+------+---------------------------+-----------------------------+ | 3 | root | localhost | sbtest | Query | 30 | Updated about 764000 rows | update sbtest set email=zip | ... mysql> show processlist; +----+------+-----------+--------+---------+------+----------------------------+-----------------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+------+-----------+--------+---------+------+----------------------------+-----------------------------+ | 3 | root | localhost | sbtest | Query | 79 | Updated about 1900000 rows | update sbtest set email=zip | ... |
(Do not look in stupid UPDATE query, it’s just for testing 🙂 )
So looking in SHOW PROCESSLIST you can see progress of query execution.
I would want to see it in standard MySQL and InnoDB more than all these triggers and stored routines! Probably will implement this in XtraDB.
