Where the open source database community meets: Use code PERCONA75 and secure your spot for Percona Live. Register

Downloads

Blog

The feature I love in TokuDB

June 12, 2009

Author

Vadim Tkachenko

Insight for DBAs

Share this Post:

Playing with TokuDB updates I noticed in SHOW PROCESSLIST unsual for MySQL State.

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 |
...

mysql> show processlist;

+----+------+-----------+--------+---------+------+---------------------------+-----------------------------+

+----+------+-----------+--------+---------+------+---------------------------+-----------------------------+

...

mysql> show processlist;

+----+------+-----------+--------+---------+------+----------------------------+-----------------------------+

+----+------+-----------+--------+---------+------+----------------------------+-----------------------------+

...

(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.

0 0 votes

Article Rating

4 Comments

Oldest

Newest Most Voted

Inline Feedbacks

View all comments

Adomas

16 years ago

I’ve always missed this kind of stuff from MySQL. Hope to see more of it coming to MySQL and other forks.

Gil

16 years ago

That is so awesome. Does it work for ALTER TABLE too?

Can’t help but wonder how many times I’ve impatiently killed a MySQL server, assuming a long-running query was never going to finish, never to discover that it was only 30 seconds away from completing.

Zardosht Kasheff

16 years ago

Gil, TokuDB shows progress for alter tables that add or drop indexes. It does not show progress for other alter tables (such as those that add a column).

In summary, TokuDB shows progress in the following situations:
1) updates, as shown above
2) deletes, similar to above
3) insert statements (for example, doing loads with “insert into foo select * from bar” will show progress)
4) index creation