MariaDB [(none)]> show processlist;
|
+----+-------------+-----------------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+----+-------------+-----------------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
| 1 | system user | | NULL | Sleep | 376 | wsrep aborter idle | NULL | 0.000 |
|
| 2 | system user | | NULL | Sleep | 376 | Closing tables | NULL | 0.000 |
|
| 5 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 6 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 3 | system user | | NULL | Daemon | NULL | InnoDB purge coordinator | NULL | 0.000 |
|
| 4 | system user | | NULL | Daemon | NULL | InnoDB purge worker | NULL | 0.000 |
|
| 7 | system user | | NULL | Daemon | NULL | InnoDB shutdown handler | NULL | 0.000 |
|
| 11 | system user | | NULL | Sleep | 375 | wsrep applier idle | NULL | 0.000 |
|
| 12 | system user | | NULL | Sleep | 375 | Closing tables | NULL | 0.000 |
|
| 14 | system user | | NULL | Sleep | 375 | wsrep applier idle | NULL | 0.000 |
|
| 22 | ramesh | localhost:50776 | test | Query | 295 | acquiring total order isolation | OPTIMIZE TABLE `oltp8` /* QNO 982 CON_ID 22 */ | 0.000 |
|
| 23 | ramesh | localhost:50788 | test | Query | 325 | Commit | INSERT INTO `oltp10` ( `id` ) VALUES ( NULL ),( NULL ),( NULL ),( NULL ) /* QNO 940 CON_ID 23 */ | 0.000 |
|
| 24 | ramesh | localhost:50802 | test | Query | 325 | Waiting for table metadata lock | ALTER ONLINE TABLE `oltp8` ROW_FORMAT=DYNAMIC /* QNO 942 CON_ID 24 */ | 0.000 |
|
| 27 | ramesh | localhost:50836 | test | Query | 325 | Commit | INSERT INTO `oltp7` ( `id` ) VALUES ( NULL ),( NULL ),( NULL ),( NULL ) /* QNO 934 CON_ID 27 */ | 0.000 |
|
| 28 | ramesh | localhost:50852 | test | Query | 295 | acquiring total order isolation | KILL CONNECTION @conid /* QNO 931 CON_ID 28 */ | 0.000 |
|
| 31 | ramesh | localhost:50878 | test | Query | 115 | acquiring total order isolation | KILL CONNECTION @conid /* QNO 929 CON_ID 31 */ | 0.000 |
|
| 35 | ramesh | localhost:50900 | test | Query | 85 | acquiring total order isolation | KILL CONNECTION @conid /* QNO 941 CON_ID 35 */ | 0.000 |
|
| 36 | ramesh | localhost:50916 | test | Query | 325 | acquiring total order isolation | KILL QUERY @conid /* QNO 927 CON_ID 36 */ | 0.000 |
|
| 37 | ramesh | localhost:54008 | test | Query | 25 | Init | INSERT INTO `oltp5` ( `id` ) VALUES ( NULL ),( NULL ),( NULL ),( NULL ) /* QNO 953 CON_ID 29 */ | 0.000 |
|
| 39 | ramesh | localhost:54032 | test | Query | 25 | Init | INSERT INTO `oltp8` ( `id`, `id`) VALUES ( NULL, -699531264 ) /* QNO 959 CON_ID 33 */ | 0.000 |
|
| 40 | ramesh | localhost:54034 | test | Query | 325 | acquiring total order isolation | OPTIMIZE TABLE `oltp8` /* QNO 943 CON_ID 26 */ | 0.000 |
|
| 42 | ramesh | localhost:52848 | test | Query | 25 | Init | SELECT CONCAT('SELECT * FROM INFORMATION_SCHEMA.',table_name,' ORDER BY RAND() LIMIT 10') FROM INFOR | 0.000 |
|
| 43 | ramesh | localhost:52850 | test | Killed | 325 | acquiring total order isolation | KILL QUERY @conid /* QNO 956 CON_ID 34 */ | 0.000 |
|
| 44 | ramesh | localhost:52856 | test | Query | 325 | Commit | INSERT INTO `oltp1` ( `id` ) VALUES ( NULL ),( NULL ),( NULL ),( NULL ) /* QNO 983 CON_ID 21 */ | 0.000 |
|
| 45 | ramesh | localhost:52864 | test | Killed | 325 | Commit | INSERT INTO `oltp7` ( `id`, `pad` ) VALUES ( NULL, 'v' ) /* QNO 952 CON_ID 25 */ | 0.000 |
|
| 46 | ramesh | localhost:52876 | test | Query | 25 | Init | INSERT INTO `oltp4` ( `c` ) VALUES ( 's' ) /* QNO 939 CON_ID 32 */ | 0.000 |
|
| 47 | ramesh | localhost:52890 | test | Query | 145 | acquiring total order isolation | ALTER ONLINE TABLE `oltp9` FORCE, LOCK=SHARED, ALGORITHM=INPLACE /* QNO 961 CON_ID 25 */ | 0.000 |
|
| 48 | root | localhost | NULL | Query | 177 | acquiring total order isolation | create database test_one | 0.000 |
|
| 49 | root | localhost | NULL | Query | 0 | Init | show processlist | 0.000 |
|
+----+-------------+-----------------+------+---------+------+---------------------------------+------------------------------------------------------------------------------------------------------+----------+
|
29 rows in set (0.001 sec)
|
|
MariaDB [(none)]>
|