Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.37-galera
-
None
-
Ubuntu 12.04.4 LTS (GNU/Linux 2.6.32-28-server x86_64)
Description
select @@wsrep_slave_threads
64
MariaDB [(none)]> set global wsrep_slave_threads=1;
|
Query OK, 0 rows affected (0.00 sec)
|
 |
MariaDB [(none)]> show processlist;
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
| 4 | system user | | NULL | Sleep | 2443658 | wsrep aborter idle | NULL | 0.000 |
|
| 5 | system user | | NULL | Sleep | 164 | committed 13294138 | NULL | 0.000 |
|
| 6 | system user | | NULL | Sleep | 213 | committed 13294127 | NULL | 0.000 |
|
| 7 | system user | | NULL | Sleep | 119 | committed 13294154 | NULL | 0.000 |
|
| 8 | system user | | NULL | Sleep | 213 | committed 13294122 | NULL | 0.000 |
|
| 9 | system user | | NULL | Sleep | 65 | committed 13294165 | NULL | 0.000 |
|
| 10 | system user | | NULL | Sleep | 68 | committed 13294162 | NULL | 0.000 |
|
| 11 | system user | | NULL | Sleep | 213 | committed 13294121 | NULL | 0.000 |
|
| 12 | system user | | NULL | Sleep | 214 | committed 13294111 | NULL | 0.000 |
|
| 13 | system user | | NULL | Sleep | 213 | committed 13294117 | NULL | 0.000 |
|
| 14 | system user | | NULL | Sleep | 77 | committed 13294160 | NULL | 0.000 |
|
| 15 | system user | | NULL | Sleep | 77 | committed 13294156 | NULL | 0.000 |
|
| 16 | system user | | NULL | Sleep | 214 | committed 13294114 | NULL | 0.000 |
|
| 17 | system user | | NULL | Sleep | 213 | committed 13294120 | NULL | 0.000 |
|
| 18 | system user | | NULL | Sleep | 77 | committed 13294157 | NULL | 0.000 |
|
| 19 | system user | | NULL | Sleep | 208 | committed 13294129 | NULL | 0.000 |
|
| 20 | system user | | NULL | Sleep | 189 | committed 13294133 | NULL | 0.000 |
|
| 21 | system user | | NULL | Sleep | 137 | committed 13294142 | NULL | 0.000 |
|
| 22 | system user | | NULL | Sleep | 55 | committed 13294170 | NULL | 0.000 |
|
| 23 | system user | | NULL | Sleep | 68 | committed 13294163 | NULL | 0.000 |
|
| 24 | system user | | NULL | Sleep | 137 | committed 13294140 | NULL | 0.000 |
|
| 25 | system user | | NULL | Sleep | 213 | committed 13294118 | NULL | 0.000 |
|
| 26 | system user | | NULL | Sleep | 191 | committed 13294131 | NULL | 0.000 |
|
| 27 | system user | | NULL | Sleep | 121 | committed 13294151 | NULL | 0.000 |
|
| 28 | system user | | NULL | Sleep | 74 | committed 13294161 | NULL | 0.000 |
|
| 29 | system user | | NULL | Sleep | 137 | committed 13294143 | NULL | 0.000 |
|
| 30 | system user | | NULL | Sleep | 119 | committed 13294153 | NULL | 0.000 |
|
| 31 | system user | | NULL | Sleep | 214 | committed 13294115 | NULL | 0.000 |
|
| 32 | system user | | NULL | Sleep | 213 | committed 13294125 | NULL | 0.000 |
|
| 33 | system user | | NULL | Sleep | 201 | committed 13294130 | NULL | 0.000 |
|
| 34 | system user | | NULL | Sleep | 187 | committed 13294135 | NULL | 0.000 |
|
| 35 | system user | | NULL | Sleep | 133 | committed 13294150 | NULL | 0.000 |
|
| 36 | system user | | NULL | Sleep | 220 | committed 13294108 | NULL | 0.000 |
|
| 37 | system user | | NULL | Sleep | 213 | committed 13294128 | NULL | 0.000 |
|
| 38 | system user | | NULL | Sleep | 221 | committed 13294107 | NULL | 0.000 |
|
| 39 | system user | | NULL | Sleep | 133 | committed 13294146 | NULL | 0.000 |
|
| 40 | system user | | NULL | Sleep | 133 | committed 13294148 | NULL | 0.000 |
|
| 41 | system user | | NULL | Sleep | 137 | committed 13294141 | NULL | 0.000 |
|
| 42 | system user | | NULL | Sleep | 214 | committed 13294113 | NULL | 0.000 |
|
| 43 | system user | | NULL | Sleep | 57 | committed 13294169 | NULL | 0.000 |
|
| 44 | system user | | NULL | Sleep | 213 | committed 13294126 | NULL | 0.000 |
|
| 45 | system user | | NULL | Sleep | 213 | committed 13294123 | NULL | 0.000 |
|
| 46 | system user | | NULL | Sleep | 66 | committed 13294164 | NULL | 0.000 |
|
| 47 | system user | | NULL | Sleep | 214 | committed 13294112 | NULL | 0.000 |
|
| 48 | system user | | NULL | Sleep | 214 | committed 13294110 | NULL | 0.000 |
|
| 49 | system user | | NULL | Sleep | 185 | committed 13294137 | NULL | 0.000 |
|
| 50 | system user | | NULL | Sleep | 135 | committed 13294145 | NULL | 0.000 |
|
| 51 | system user | | NULL | Sleep | 63 | committed 13294166 | NULL | 0.000 |
|
| 52 | system user | | NULL | Sleep | 137 | committed 13294139 | NULL | 0.000 |
|
| 53 | system user | | NULL | Sleep | 58 | committed 13294168 | NULL | 0.000 |
|
| 54 | system user | | NULL | Sleep | 188 | committed 13294134 | NULL | 0.000 |
|
| 55 | system user | | NULL | Sleep | 213 | committed 13294124 | NULL | 0.000 |
|
| 56 | system user | | NULL | Sleep | 214 | committed 13294109 | NULL | 0.000 |
|
| 57 | system user | | NULL | Sleep | 213 | committed 13294116 | NULL | 0.000 |
|
| 58 | system user | | NULL | Sleep | 136 | committed 13294144 | NULL | 0.000 |
|
| 59 | system user | | NULL | Sleep | 187 | committed 13294136 | NULL | 0.000 |
|
| 60 | system user | | NULL | Sleep | 133 | committed 13294149 | NULL | 0.000 |
|
| 61 | system user | | NULL | Sleep | 63 | committed 13294167 | NULL | 0.000 |
|
| 62 | system user | | NULL | Sleep | 119 | committed 13294152 | NULL | 0.000 |
|
| 63 | system user | | NULL | Sleep | 213 | committed 13294119 | NULL | 0.000 |
|
| 64 | system user | | NULL | Sleep | 77 | committed 13294158 | NULL | 0.000 |
|
| 65 | system user | | NULL | Sleep | 190 | committed 13294132 | NULL | 0.000 |
|
| 66 | system user | | NULL | Sleep | 91 | committed 13294155 | NULL | 0.000 |
|
| 67 | system user | | NULL | Sleep | 133 | committed 13294147 | NULL | 0.000 |
|
| 68 | system user | | NULL | Sleep | 77 | committed 13294159 | NULL | 0.000 |
|
| 9660 | root | localhost | NULL | Query | 0 | sleeping | show processlist | 0.000 |
|
+------+-------------+-----------+------+---------+---------+--------------------+------------------+----------+
|
66 rows in set (0.04 sec)
|
none deleted.
oh well. lets set back to 64.
MariaDB [(none)]> set global wsrep_slave_threads=64;
|
Query OK, 0 rows affected (0.67 sec)
|
 |
MariaDB [(none)]> show processlist;
|
+------+-------------+-----------+------+---------+---------+--------------------+------------------+----------+
|
| Id | User | Host | db | Command | Time | State | Info | Progress |
|
+------+-------------+-----------+------+---------+---------+--------------------+------------------+----------+
|
| 4 | system user | | NULL | Sleep | 2443728 | wsrep aborter idle | NULL | 0.000 |
|
| 5 | system user | | NULL | Sleep | 234 | committed 13294138 | NULL | 0.000 |
|
| 6 | system user | | NULL | Sleep | 283 | committed 13294127 | NULL | 0.000 |
|
| 7 | system user | | NULL | Sleep | 189 | committed 13294154 | NULL | 0.000 |
|
| 8 | system user | | NULL | Sleep | 283 | committed 13294122 | NULL | 0.000 |
|
| 9 | system user | | NULL | Sleep | 135 | committed 13294165 | NULL | 0.000 |
|
| 10 | system user | | NULL | Sleep | 138 | committed 13294162 | NULL | 0.000 |
|
| 11 | system user | | NULL | Sleep | 283 | committed 13294121 | NULL | 0.000 |
|
| 13 | system user | | NULL | Sleep | 283 | committed 13294117 | NULL | 0.000 |
|
| 14 | system user | | NULL | Sleep | 147 | committed 13294160 | NULL | 0.000 |
|
| 15 | system user | | NULL | Sleep | 147 | committed 13294156 | NULL | 0.000 |
|
| 17 | system user | | NULL | Sleep | 283 | committed 13294120 | NULL | 0.000 |
|
| 18 | system user | | NULL | Sleep | 147 | committed 13294157 | NULL | 0.000 |
|
| 19 | system user | | NULL | Sleep | 278 | committed 13294129 | NULL | 0.000 |
|
| 20 | system user | | NULL | Sleep | 259 | committed 13294133 | NULL | 0.000 |
|
| 21 | system user | | NULL | Sleep | 207 | committed 13294142 | NULL | 0.000 |
|
| 22 | system user | | NULL | Sleep | 125 | committed 13294170 | NULL | 0.000 |
|
| 23 | system user | | NULL | Sleep | 138 | committed 13294163 | NULL | 0.000 |
|
| 24 | system user | | NULL | Sleep | 207 | committed 13294140 | NULL | 0.000 |
|
| 25 | system user | | NULL | Sleep | 283 | committed 13294118 | NULL | 0.000 |
|
| 26 | system user | | NULL | Sleep | 261 | committed 13294131 | NULL | 0.000 |
|
| 27 | system user | | NULL | Sleep | 191 | committed 13294151 | NULL | 0.000 |
|
| 28 | system user | | NULL | Sleep | 144 | committed 13294161 | NULL | 0.000 |
|
| 29 | system user | | NULL | Sleep | 207 | committed 13294143 | NULL | 0.000 |
|
| 30 | system user | | NULL | Sleep | 189 | committed 13294153 | NULL | 0.000 |
|
| 32 | system user | | NULL | Sleep | 283 | committed 13294125 | NULL | 0.000 |
|
| 33 | system user | | NULL | Sleep | 271 | committed 13294130 | NULL | 0.000 |
|
| 34 | system user | | NULL | Sleep | 257 | committed 13294135 | NULL | 0.000 |
|
| 35 | system user | | NULL | Sleep | 203 | committed 13294150 | NULL | 0.000 |
|
| 37 | system user | | NULL | Sleep | 283 | committed 13294128 | NULL | 0.000 |
|
| 39 | system user | | NULL | Sleep | 203 | committed 13294146 | NULL | 0.000 |
|
| 40 | system user | | NULL | Sleep | 203 | committed 13294148 | NULL | 0.000 |
|
| 41 | system user | | NULL | Sleep | 207 | committed 13294141 | NULL | 0.000 |
|
| 43 | system user | | NULL | Sleep | 127 | committed 13294169 | NULL | 0.000 |
|
| 44 | system user | | NULL | Sleep | 283 | committed 13294126 | NULL | 0.000 |
|
| 45 | system user | | NULL | Sleep | 283 | committed 13294123 | NULL | 0.000 |
|
| 46 | system user | | NULL | Sleep | 136 | committed 13294164 | NULL | 0.000 |
|
| 49 | system user | | NULL | Sleep | 255 | committed 13294137 | NULL | 0.000 |
|
| 50 | system user | | NULL | Sleep | 205 | committed 13294145 | NULL | 0.000 |
|
| 51 | system user | | NULL | Sleep | 133 | committed 13294166 | NULL | 0.000 |
|
| 52 | system user | | NULL | Sleep | 207 | committed 13294139 | NULL | 0.000 |
|
| 53 | system user | | NULL | Sleep | 128 | committed 13294168 | NULL | 0.000 |
|
| 54 | system user | | NULL | Sleep | 258 | committed 13294134 | NULL | 0.000 |
|
| 55 | system user | | NULL | Sleep | 283 | committed 13294124 | NULL | 0.000 |
|
| 57 | system user | | NULL | Sleep | 283 | committed 13294116 | NULL | 0.000 |
|
| 58 | system user | | NULL | Sleep | 206 | committed 13294144 | NULL | 0.000 |
|
| 59 | system user | | NULL | Sleep | 257 | committed 13294136 | NULL | 0.000 |
|
| 60 | system user | | NULL | Sleep | 203 | committed 13294149 | NULL | 0.000 |
|
| 61 | system user | | NULL | Sleep | 133 | committed 13294167 | NULL | 0.000 |
|
| 62 | system user | | NULL | Sleep | 189 | committed 13294152 | NULL | 0.000 |
|
| 63 | system user | | NULL | Sleep | 283 | committed 13294119 | NULL | 0.000 |
|
| 64 | system user | | NULL | Sleep | 147 | committed 13294158 | NULL | 0.000 |
|
| 65 | system user | | NULL | Sleep | 260 | committed 13294132 | NULL | 0.000 |
|
| 66 | system user | | NULL | Sleep | 161 | committed 13294155 | NULL | 0.000 |
|
| 67 | system user | | NULL | Sleep | 203 | committed 13294147 | NULL | 0.000 |
|
| 68 | system user | | NULL | Sleep | 147 | committed 13294159 | NULL | 0.000 |
|
| 9660 | root | localhost | NULL | Query | 0 | sleeping | show processlist | 0.000 |
|
| 9670 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9671 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9672 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9673 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9674 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9675 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9676 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9677 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9678 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9679 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9680 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9681 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9682 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9683 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9684 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9685 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9686 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9687 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9688 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9689 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9690 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9691 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9692 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9693 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9694 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9695 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9696 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9697 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9698 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9699 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9700 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9701 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9702 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9703 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9704 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9705 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9706 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9707 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9708 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9709 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9710 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9711 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9712 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9713 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9714 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9715 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9716 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9717 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9718 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9719 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9720 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9721 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9722 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9723 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9724 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9725 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9726 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9727 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9728 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9729 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9730 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9731 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
| 9732 | system user | | NULL | Sleep | 3 | NULL | NULL | 0.000 |
|
+------+-------------+-----------+------+---------+---------+--------------------+------------------+----------+
|
120 rows in set (0.03 sec)
|
another 64 threads? Is that what I said.