gistfile1.txt

MariaDB [lobsters]> show full processlist;
+-------+----------+-----------+----------+---------+------+-------------------+---------------------------------------------------------------------+----------+
| Id    | User     | Host      | db       | Command | Time | State             | Info                                                                | Progress |
+-------+----------+-----------+----------+---------+------+-------------------+---------------------------------------------------------------------+----------+
| 64327 | lobsters | localhost | lobsters | Query   | 5988 | Copy to tmp table | ALTER TABLE `stories` CHANGE `score` `score` int DEFAULT 1 NOT NULL |   51.579 |
| 64463 | lobsters | localhost | lobsters | Query   |    0 | Init              | show full processlist                                               |    0.000 |
+-------+----------+-----------+----------+---------+------+-------------------+---------------------------------------------------------------------+----------+
2 rows in set (0.003 sec)

MariaDB [lobsters]> select * from information_schema.processlist;
+-------+----------+-----------+----------+---------+------+----------------------+---------------------------------------------------------------------+-------------+-------+-----------+----------+-------------+-----------------+---------------+----------+---------------------------------------------------------------------+---------+
| ID    | USER     | HOST      | DB       | COMMAND | TIME | STATE                | INFO                                                                | TIME_MS     | STAGE | MAX_STAGE | PROGRESS | MEMORY_USED | MAX_MEMORY_USED | EXAMINED_ROWS | QUERY_ID | INFO_BINARY                                                         | TID     |
+-------+----------+-----------+----------+---------+------+----------------------+---------------------------------------------------------------------+-------------+-------+-----------+----------+-------------+-----------------+---------------+----------+---------------------------------------------------------------------+---------+
| 64463 | lobsters | localhost | lobsters | Query   |    0 | Filling schema table | select * from information_schema.processlist                        |       0.773 |     0 |         0 |    0.000 |       95184 |          254872 |             0 | 37492892 | select * from information_schema.processlist                        | 4137939 |
| 64327 | lobsters | localhost | lobsters | Query   | 6058 | Copy to tmp table    | ALTER TABLE `stories` CHANGE `score` `score` int DEFAULT 1 NOT NULL | 6058062.701 |     1 |         2 |  104.094 |      117480 |          272608 |             0 | 37492569 | ALTER TABLE `stories` CHANGE `score` `score` int DEFAULT 1 NOT NULL | 4133884 |
+-------+----------+-----------+----------+---------+------+----------------------+---------------------------------------------------------------------+-------------+-------+-----------+----------+-------------+-----------------+---------------+----------+---------------------------------------------------------------------+---------+
2 rows in set (0.001 sec)