Untitled

 avatar
unknown
plain_text
4 months ago
37 kB
8
No Index
MariaDB [(none)]> show processlist;
+-----+-------------+---------------------------------+-----------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id  | User        | Host                            | db        | Command | Time | State                    | Info                                                                                                 | Progress |
+-----+-------------+---------------------------------+-----------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
|   1 | system user |                                 | NULL      | Daemon  | NULL | InnoDB purge coordinator | NULL                                                                                                 |    0.000 |
|   2 | system user |                                 | NULL      | Daemon  | NULL | InnoDB purge worker      | NULL                                                                                                 |    0.000 |
|   3 | system user |                                 | NULL      | Daemon  | NULL | InnoDB purge worker      | NULL                                                                                                 |    0.000 |
|   4 | system user |                                 | NULL      | Daemon  | NULL | InnoDB purge worker      | NULL                                                                                                 |    0.000 |
|   5 | system user |                                 | NULL      | Daemon  | NULL | InnoDB shutdown handler  | NULL                                                                                                 |    0.000 |
|   8 | root        | -----TOEM1.domain.example:50176 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|   9 | root        | localhost:58047                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  10 | root        | localhost:58044                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  11 | root        | -----TOEM3.domain.example:57795 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  12 | root        | -----TOEM4.domain.example:62820 | theopenem | Query   |    0 | Sending data             | SELECT
`Extent1`.`software_inventory_id`,
`Extent1`.`name`,
`Extent1`.`version`,
`Extent1`.`m |    0.000 |
|  13 | root        | -----TOEM3.domain.example:57797 | theopenem | Query   |    0 | Sending data             | SELECT
`Extent1`.`software_inventory_id`,
`Extent1`.`name`,
`Extent1`.`version`,
`Extent1`.`m |    0.000 |
|  14 | root        | -----TOEM1.domain.example:50177 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  15 | root        | localhost:58048                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  16 | root        | localhost:58049                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  17 | root        | localhost:58043                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  18 | root        | -----TOEM1.domain.example:50178 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  19 | root        | -----TOEM4.domain.example:62822 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  20 | root        | localhost:58050                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  21 | root        | -----TOEM3.domain.example:57798 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  22 | root        | localhost:58051                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  23 | root        | -----TOEM4.domain.example:62823 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  24 | root        | localhost:58046                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  25 | root        | localhost:58052                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  26 | root        | -----TOEM1.domain.example:50179 | theopenem | Sleep   |    4 |                          | NULL                                                                                                 |    0.000 |
|  27 | root        | localhost:58053                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  28 | root        | localhost:58045                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  29 | root        | localhost:58054                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  30 | root        | localhost:58055                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  31 | root        | localhost:58056                 | theopenem | Query   |    0 | Sending data             | SELECT
`Extent1`.`software_inventory_id`,
`Extent1`.`name`,
`Extent1`.`version`,
`Extent1`.`m |    0.000 |
|  32 | root        | -----TOEM4.domain.example:62824 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  33 | root        | localhost:58057                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  34 | root        | localhost:58058                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  35 | root        | -----TOEM1.domain.example:50180 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  36 | root        | localhost:58059                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  37 | root        | localhost:58060                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  38 | root        | -----TOEM4.domain.example:62825 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  39 | root        | -----TOEM1.domain.example:50181 | theopenem | Sleep   |   18 |                          | NULL                                                                                                 |    0.000 |
|  40 | root        | localhost:58061                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  41 | root        | localhost:58062                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  42 | root        | localhost:58063                 | theopenem | Query   |    0 | Writing to net           | SELECT
`Extent1`.`wu_inventory_id`,
`Extent1`.`title`,
`Extent1`.`category`,
`Extent1`.`updat |    0.000 |
|  43 | root        | -----TOEM4.domain.example:62826 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  44 | root        | -----TOEM1.domain.example:50182 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  45 | root        | localhost:58064                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  46 | root        | localhost:58065                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  47 | root        | -----TOEM4.domain.example:62821 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  48 | root        | localhost:58066                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  49 | root        | localhost:58067                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  50 | root        | -----TOEM4.domain.example:62827 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  51 | root        | -----TOEM4.domain.example:62828 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  52 | root        | -----TOEM4.domain.example:62829 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  53 | root        | localhost:58068                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  54 | root        | localhost:58069                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  55 | root        | -----TOEM1.domain.example:50183 | theopenem | Sleep   |    8 |                          | NULL                                                                                                 |    0.000 |
|  56 | root        | -----TOEM4.domain.example:62830 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  57 | root        | -----TOEM4.domain.example:62831 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  58 | root        | localhost:58070                 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  59 | root        | -----TOEM4.domain.example:62832 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  60 | root        | -----TOEM1.domain.example:50184 | theopenem | Sleep   |    8 |                          | NULL                                                                                                 |    0.000 |
|  61 | root        | -----TOEM4.domain.example:62833 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  62 | root        | -----TOEM4.domain.example:62834 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  63 | root        | -----TOEM1.domain.example:50185 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  64 | root        | -----TOEM4.domain.example:62835 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  65 | root        | -----TOEM1.domain.example:50186 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  66 | root        | -----TOEM4.domain.example:62836 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  67 | root        | -----TOEM1.domain.example:50187 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  68 | root        | -----TOEM3.domain.example:57796 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  69 | root        | -----TOEM4.domain.example:62837 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  70 | root        | -----TOEM1.domain.example:50188 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  71 | root        | -----TOEM3.domain.example:57799 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  72 | root        | -----TOEM4.domain.example:62838 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  73 | root        | -----TOEM3.domain.example:57800 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  74 | root        | -----TOEM1.domain.example:50189 | theopenem | Sleep   |    4 |                          | NULL                                                                                                 |    0.000 |
|  75 | root        | -----TOEM3.domain.example:57801 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  76 | root        | -----TOEM1.domain.example:50190 | theopenem | Sleep   |    8 |                          | NULL                                                                                                 |    0.000 |
|  77 | root        | -----TOEM3.domain.example:57802 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  78 | root        | -----TOEM4.domain.example:62839 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  79 | root        | -----TOEM3.domain.example:57803 | theopenem | Query   |    0 | Sending data             | SELECT
`Extent1`.`software_inventory_id`,
`Extent1`.`name`,
`Extent1`.`version`,
`Extent1`.`m |    0.000 |
|  80 | root        | -----TOEM4.domain.example:62840 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  81 | root        | -----TOEM1.domain.example:50191 | theopenem | Sleep   |    8 |                          | NULL                                                                                                 |    0.000 |
|  82 | root        | -----TOEM3.domain.example:57804 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  83 | root        | -----TOEM3.domain.example:57805 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  84 | root        | -----TOEM3.domain.example:57806 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  85 | root        | -----TOEM4.domain.example:62841 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  86 | root        | -----TOEM1.domain.example:50192 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  87 | root        | -----TOEM4.domain.example:62842 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  88 | root        | -----TOEM1.domain.example:50193 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  89 | root        | -----TOEM3.domain.example:57807 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  90 | root        | -----TOEM3.domain.example:57808 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  91 | root        | -----TOEM1.domain.example:50194 | theopenem | Sleep   |    4 |                          | NULL                                                                                                 |    0.000 |
|  92 | root        | -----TOEM3.domain.example:57809 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  93 | root        | -----TOEM1.domain.example:50195 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  94 | root        | -----TOEM3.domain.example:57810 | theopenem | Query   |    0 | Sending data             | SELECT
`Extent1`.`software_inventory_id`,
`Extent1`.`name`,
`Extent1`.`version`,
`Extent1`.`m |    0.000 |
|  95 | root        | -----TOEM3.domain.example:57811 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  96 | root        | -----TOEM3.domain.example:57812 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
|  97 | root        | -----TOEM1.domain.example:50196 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
|  98 | root        | -----TOEM1.domain.example:50197 | theopenem | Sleep   |    4 |                          | NULL                                                                                                 |    0.000 |
|  99 | root        | -----TOEM3.domain.example:57813 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 100 | root        | -----TOEM3.domain.example:57814 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 101 | root        | -----TOEM4.domain.example:62816 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 102 | root        | -----TOEM4.domain.example:62817 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 103 | root        | -----TOEM2.domain.example:51040 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 104 | root        | -----TOEM2.domain.example:51039 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 105 | root        | -----TOEM1.domain.example:50173 | theopenem | Sleep   |   15 |                          | NULL                                                                                                 |    0.000 |
| 106 | root        | -----TOEM3.domain.example:57791 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 107 | root        | -----TOEM2.domain.example:51043 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 108 | root        | -----TOEM1.domain.example:50198 | theopenem | Sleep   |    8 |                          | NULL                                                                                                 |    0.000 |
| 109 | root        | -----TOEM4.domain.example:62818 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 110 | root        | -----TOEM2.domain.example:51044 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 111 | root        | -----TOEM1.domain.example:50199 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
| 112 | root        | -----TOEM2.domain.example:51045 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 113 | root        | -----TOEM1.domain.example:50200 | theopenem | Sleep   |    8 |                          | NULL                                                                                                 |    0.000 |
| 114 | root        | -----TOEM2.domain.example:51046 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 115 | root        | -----TOEM2.domain.example:51047 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 116 | root        | -----TOEM1.domain.example:50201 | theopenem | Sleep   |    8 |                          | NULL                                                                                                 |    0.000 |
| 117 | root        | -----TOEM4.domain.example:62819 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 118 | root        | -----TOEM2.domain.example:51048 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 119 | root        | -----TOEM2.domain.example:51041 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 120 | root        | -----TOEM2.domain.example:51049 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 121 | root        | -----TOEM1.domain.example:50202 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
| 122 | root        | -----TOEM2.domain.example:51050 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 123 | root        | -----TOEM1.domain.example:50203 | theopenem | Sleep   |   15 |                          | NULL                                                                                                 |    0.000 |
| 124 | root        | -----TOEM2.domain.example:51051 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 125 | root        | -----TOEM1.domain.example:50204 | theopenem | Sleep   |   18 |                          | NULL                                                                                                 |    0.000 |
| 126 | root        | -----TOEM2.domain.example:51052 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 127 | root        | -----TOEM1.domain.example:50205 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
| 128 | root        | -----TOEM2.domain.example:51053 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 129 | root        | -----TOEM1.domain.example:50206 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
| 130 | root        | -----TOEM2.domain.example:51054 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 131 | root        | -----TOEM3.domain.example:57792 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 132 | root        | -----TOEM1.domain.example:50207 | theopenem | Sleep   |   15 |                          | NULL                                                                                                 |    0.000 |
| 133 | root        | -----TOEM2.domain.example:51055 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 134 | root        | -----TOEM1.domain.example:50208 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
| 135 | root        | -----TOEM1.domain.example:50209 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
| 136 | root        | -----TOEM2.domain.example:51056 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 137 | root        | -----TOEM2.domain.example:51057 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 138 | root        | -----TOEM2.domain.example:51058 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 139 | root        | -----TOEM2.domain.example:51059 | theopenem | Query   |    0 | Sending data             | SELECT
`Extent1`.`software_inventory_id`,
`Extent1`.`name`,
`Extent1`.`version`,
`Extent1`.`m |    0.000 |
| 140 | root        | -----TOEM1.domain.example:50174 | theopenem | Sleep   |    4 |                          | NULL                                                                                                 |    0.000 |
| 141 | root        | -----TOEM2.domain.example:51060 | theopenem | Query   |    0 | Sending data             | SELECT
`Extent1`.`wu_inventory_id`,
`Extent1`.`title`,
`Extent1`.`category`,
`Extent1`.`updat |    0.000 |
| 142 | root        | -----TOEM1.domain.example:50175 | theopenem | Sleep   |    9 |                          | NULL                                                                                                 |    0.000 |
| 143 | root        | -----TOEM2.domain.example:51061 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 144 | root        | -----TOEM2.domain.example:51062 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 145 | root        | -----TOEM2.domain.example:51063 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 146 | root        | -----TOEM2.domain.example:51064 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 147 | root        | -----TOEM2.domain.example:51065 | theopenem | Query   |    0 | Sending data             | SELECT
`Extent1`.`software_inventory_id`,
`Extent1`.`name`,
`Extent1`.`version`,
`Extent1`.`m |    0.000 |
| 148 | root        | -----TOEM2.domain.example:51066 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 149 | root        | -----TOEM2.domain.example:51067 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 150 | root        | -----TOEM2.domain.example:51042 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 151 | root        | -----TOEM2.domain.example:51068 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 152 | root        | -----TOEM2.domain.example:51069 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 153 | root        | -----TOEM2.domain.example:51070 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 154 | root        | -----TOEM2.domain.example:51071 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 155 | root        | -----TOEM2.domain.example:51072 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 156 | root        | -----TOEM3.domain.example:57793 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 157 | root        | -----TOEM3.domain.example:57794 | theopenem | Sleep   |    0 |                          | NULL                                                                                                 |    0.000 |
| 162 | root        | localhost:58080                 | mysql     | Sleep   |   16 |                          | NULL                                                                                                 |    0.000 |
| 168 | root        | localhost:63155                 | NULL      | Query   |    0 | Init                     | show processlist                                                                                     |    0.000 |
+-----+-------------+---------------------------------+-----------+---------+------+--------------------------+------------------------------------------------------------------------------------------------------+----------+
157 rows in set (0.005 sec)
Editor is loading...