Playing with TokuDB updates I noticed in SHOW PROCESSLIST unsual for MySQL State.
CODE:
-
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.
Entry posted by Vadim | No comment
Add to: 
| 
| 
| 
| 
