-
Notifications
You must be signed in to change notification settings - Fork 0
/
mysql_snapshot.txt
253 lines (253 loc) · 52.9 KB
/
mysql_snapshot.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
MySQL [hammerdb]> show full processlist;
+------+-----------------+-------------------+----------+---------+------+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+-----------------+-------------------+----------+---------+------+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 5 | event_scheduler | localhost | NULL | Daemon | 1976 | Waiting on empty queue | NULL |
| 16 | root | 127.0.0.1:47034 | NULL | Sleep | 15 | | NULL |
| 198 | root | x.x.x.x:55478 | hammerdb | Query | 0 | init | show full processlist |
| 1023 | hammerdb | x.x.x.x:57044 | hammerdb | Sleep | 114 | | NULL |
| 1024 | hammerdb | x.x.x.x:57048 | hammerdb | Query | 1 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1025 | hammerdb | x.x.x.x:57062 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1026 | hammerdb | x.x.x.x:57066 | hammerdb | Query | 0 | executing | CALL PAYMENT(3,1,3,1,@p_c_id,1,2812,@p_c_last,@p_w_street_1,@p_w_street_2,@p_w_city,@p_w_state,@p_w_zip,@p_d_street_1,@p_d_street_2,@p_d_city,@p_d_state,@p_d_zip,@p_c_first,@p_c_middle,@p_c_street_1,@p_c_street_2,@p_c_city,@p_c_state,@p_c_zip,@p_c_phone,@p_c_since,@p_c_credit,@p_c_credit_lim,@p_c_discount,@p_c_balance,@p_c_data,str_to_date(20230421185136,'%Y%m%d%H%i%s')) |
| 1027 | hammerdb | x.x.x.x:57078 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1028 | hammerdb | x.x.x.x:57084 | hammerdb | Query | 0 | executing | CALL PAYMENT(5,6,5,6,@p_c_id,1,3545,@p_c_last,@p_w_street_1,@p_w_street_2,@p_w_city,@p_w_state,@p_w_zip,@p_d_street_1,@p_d_street_2,@p_d_city,@p_d_state,@p_d_zip,@p_c_first,@p_c_middle,@p_c_street_1,@p_c_street_2,@p_c_city,@p_c_state,@p_c_zip,@p_c_phone,@p_c_since,@p_c_credit,@p_c_credit_lim,@p_c_discount,@p_c_balance,@p_c_data,str_to_date(20230421185136,'%Y%m%d%H%i%s')) |
| 1029 | hammerdb | x.x.x.x:57092 | hammerdb | Query | 0 | updating | UPDATE warehouse SET w_ytd = w_ytd + p_h_amount
WHERE w_id = p_w_id |
| 1031 | hammerdb | x.x.x.x:57104 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1032 | hammerdb | x.x.x.x:57108 | hammerdb | Query | 2 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1033 | hammerdb | x.x.x.x:57112 | hammerdb | Query | 0 | statistics | SELECT no_o_id INTO d_no_o_id FROM new_order WHERE no_w_id = d_w_id AND no_d_id = d_d_id LIMIT 1 |
| 1034 | hammerdb | x.x.x.x:57126 | hammerdb | Sleep | 0 | | NULL |
| 1035 | hammerdb | x.x.x.x:57132 | hammerdb | Query | 0 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_dist_info)
VALUES (o_id, no_d_id, no_w_id, loop_counter, no_ol_i_id, no_ol_supply_w_id, no_ol_quantity, no_ol_amount, no_ol_dist_info) |
| 1036 | hammerdb | x.x.x.x:57148 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1038 | hammerdb | x.x.x.x:57162 | hammerdb | Sleep | 0 | | NULL |
| 1039 | hammerdb | x.x.x.x:34136 | hammerdb | Query | 1 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1040 | hammerdb | x.x.x.x:34142 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1041 | hammerdb | x.x.x.x:34146 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1042 | hammerdb | x.x.x.x:34148 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1043 | hammerdb | x.x.x.x:34160 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1045 | hammerdb | x.x.x.x:34172 | hammerdb | Query | 0 | System lock | UPDATE customer SET c_balance = c_balance + d_ol_total
WHERE c_id = d_c_id AND c_d_id = d_d_id AND
c_w_id = d_w_id |
| 1046 | hammerdb | x.x.x.x:34176 | hammerdb | Query | 0 | System lock | UPDATE customer SET c_balance = p_c_balance
WHERE c_w_id = p_c_w_id AND c_d_id = p_c_d_id AND
c_id = p_c_id |
| 1047 | hammerdb | x.x.x.x:34192 | hammerdb | Query | 0 | updating | UPDATE warehouse SET w_ytd = w_ytd + p_h_amount
WHERE w_id = p_w_id |
| 1048 | hammerdb | x.x.x.x:34204 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1049 | hammerdb | x.x.x.x:34212 | hammerdb | Query | 0 | updating | UPDATE customer SET c_balance = c_balance + d_ol_total
WHERE c_id = d_c_id AND c_d_id = d_d_id AND
c_w_id = d_w_id |
| 1052 | hammerdb | x.x.x.x:34218 | hammerdb | Query | 0 | update | INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES (o_id, no_d_id, no_w_id, no_c_id, timestamp, no_o_ol_cnt, no_o_all_local) |
| 1053 | hammerdb | x.x.x.x:34224 | hammerdb | Query | 0 | statistics | SELECT count(c_id) INTO namecnt
FROM customer
WHERE c_last = p_c_last AND c_d_id = p_c_d_id AND c_w_id = p_c_w_id |
| 1059 | hammerdb | x.x.x.x:34244 | hammerdb | Query | 0 | statistics | SELECT c_discount, c_last, c_credit, w_tax
INTO no_c_discount, no_c_last, no_c_credit, no_w_tax
FROM customer, warehouse
WHERE warehouse.w_id = no_w_id AND customer.c_w_id = no_w_id AND
customer.c_d_id = no_d_id AND customer.c_id = no_c_id |
| 1060 | hammerdb | x.x.x.x:34246 | hammerdb | Query | 0 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_dist_info)
VALUES (o_id, no_d_id, no_w_id, loop_counter, no_ol_i_id, no_ol_supply_w_id, no_ol_quantity, no_ol_amount, no_ol_dist_info) |
| 1061 | hammerdb | x.x.x.x:34250 | hammerdb | Query | 0 | statistics | CALL PAYMENT(28,6,28,6,@p_c_id,1,1878,@p_c_last,@p_w_street_1,@p_w_street_2,@p_w_city,@p_w_state,@p_w_zip,@p_d_street_1,@p_d_street_2,@p_d_city,@p_d_state,@p_d_zip,@p_c_first,@p_c_middle,@p_c_street_1,@p_c_street_2,@p_c_city,@p_c_state,@p_c_zip,@p_c_phone,@p_c_since,@p_c_credit,@p_c_credit_lim,@p_c_discount,@p_c_balance,@p_c_data,str_to_date(20230421185136,'%Y%m%d%H%i%s')) |
| 1062 | hammerdb | x.x.x.x:34264 | hammerdb | Query | 0 | update | INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES (o_id, no_d_id, no_w_id, no_c_id, timestamp, no_o_ol_cnt, no_o_all_local) |
| 1063 | hammerdb | x.x.x.x:34278 | hammerdb | Query | 0 | executing | CALL PAYMENT(30,1,30,1,@p_c_id,1,3761,@p_c_last,@p_w_street_1,@p_w_street_2,@p_w_city,@p_w_state,@p_w_zip,@p_d_street_1,@p_d_street_2,@p_d_city,@p_d_state,@p_d_zip,@p_c_first,@p_c_middle,@p_c_street_1,@p_c_street_2,@p_c_city,@p_c_state,@p_c_zip,@p_c_phone,@p_c_since,@p_c_credit,@p_c_credit_lim,@p_c_discount,@p_c_balance,@p_c_data,str_to_date(20230421185136,'%Y%m%d%H%i%s')) |
| 1064 | hammerdb | x.x.x.x:34294 | hammerdb | Query | 0 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1066 | hammerdb | x.x.x.x:34312 | hammerdb | Query | 0 | executing | CALL PAYMENT(132,5,132,5,@p_c_id,1,4486,@p_c_last,@p_w_street_1,@p_w_street_2,@p_w_city,@p_w_state,@p_w_zip,@p_d_street_1,@p_d_street_2,@p_d_city,@p_d_state,@p_d_zip,@p_c_first,@p_c_middle,@p_c_street_1,@p_c_street_2,@p_c_city,@p_c_state,@p_c_zip,@p_c_phone,@p_c_since,@p_c_credit,@p_c_credit_lim,@p_c_discount,@p_c_balance,@p_c_data,str_to_date(20230421185136,'%Y%m%d%H%i%s')) |
| 1067 | hammerdb | x.x.x.x:34314 | hammerdb | Query | 0 | update | INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES (o_id, no_d_id, no_w_id, no_c_id, timestamp, no_o_ol_cnt, no_o_all_local) |
| 1069 | hammerdb | x.x.x.x:44758 | hammerdb | Sleep | 0 | | NULL |
| 1070 | hammerdb | x.x.x.x:44764 | hammerdb | Query | 0 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1071 | hammerdb | x.x.x.x:44774 | hammerdb | Query | 0 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1072 | hammerdb | x.x.x.x:44780 | hammerdb | Query | 0 | System lock | UPDATE customer
SET c_balance = p_c_balance, c_data = p_c_new_data
WHERE c_w_id = p_c_w_id AND c_d_id = p_c_d_id AND
c_id = p_c_id |
| 1074 | hammerdb | x.x.x.x:44788 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1075 | hammerdb | x.x.x.x:44792 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1076 | hammerdb | x.x.x.x:44808 | hammerdb | Query | 0 | update | INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES (o_id, no_d_id, no_w_id, no_c_id, timestamp, no_o_ol_cnt, no_o_all_local) |
| 1077 | hammerdb | x.x.x.x:44810 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1078 | hammerdb | x.x.x.x:44820 | hammerdb | Query | 0 | System lock | UPDATE order_line SET ol_delivery_d = timestamp
WHERE ol_o_id = d_no_o_id AND ol_d_id = d_d_id AND
ol_w_id = d_w_id |
| 1079 | hammerdb | x.x.x.x:44834 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1080 | hammerdb | x.x.x.x:44836 | hammerdb | Query | 1 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1082 | hammerdb | x.x.x.x:44862 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1084 | hammerdb | x.x.x.x:44874 | hammerdb | Query | 0 | update | INSERT INTO new_order (no_o_id, no_d_id, no_w_id) VALUES (o_id, no_d_id, no_w_id) |
| 1085 | hammerdb | x.x.x.x:44888 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1086 | hammerdb | x.x.x.x:44892 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1087 | hammerdb | x.x.x.x:44902 | hammerdb | Query | 0 | update | INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES (o_id, no_d_id, no_w_id, no_c_id, timestamp, no_o_ol_cnt, no_o_all_local) |
| 1088 | hammerdb | x.x.x.x:44908 | hammerdb | Query | 0 | executing | CALL PAYMENT(350,5,350,5,@p_c_id,1,1591,@p_c_last,@p_w_street_1,@p_w_street_2,@p_w_city,@p_w_state,@p_w_zip,@p_d_street_1,@p_d_street_2,@p_d_city,@p_d_state,@p_d_zip,@p_c_first,@p_c_middle,@p_c_street_1,@p_c_street_2,@p_c_city,@p_c_state,@p_c_zip,@p_c_phone,@p_c_since,@p_c_credit,@p_c_credit_lim,@p_c_discount,@p_c_balance,@p_c_data,str_to_date(20230421185136,'%Y%m%d%H%i%s')) |
| 1090 | hammerdb | x.x.x.x:44916 | hammerdb | Query | 0 | System lock | UPDATE orders SET o_carrier_id = d_o_carrier_id
WHERE o_id = d_no_o_id AND o_d_id = d_d_id AND
o_w_id = d_w_id |
| 1091 | hammerdb | x.x.x.x:44920 | hammerdb | Query | 0 | update | INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES (o_id, no_d_id, no_w_id, no_c_id, timestamp, no_o_ol_cnt, no_o_all_local) |
| 1092 | hammerdb | x.x.x.x:44932 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1093 | hammerdb | x.x.x.x:56862 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1095 | hammerdb | x.x.x.x:56878 | hammerdb | Query | 0 | System lock | UPDATE customer SET c_balance = c_balance + d_ol_total
WHERE c_id = d_c_id AND c_d_id = d_d_id AND
c_w_id = d_w_id |
| 1096 | hammerdb | x.x.x.x:56894 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1097 | hammerdb | x.x.x.x:56902 | hammerdb | Query | 0 | updating | UPDATE warehouse SET w_ytd = w_ytd + p_h_amount
WHERE w_id = p_w_id |
| 1099 | hammerdb | x.x.x.x:56932 | hammerdb | Query | 0 | executing | CALL PAYMENT(158,3,158,3,@p_c_id,1,4825,@p_c_last,@p_w_street_1,@p_w_street_2,@p_w_city,@p_w_state,@p_w_zip,@p_d_street_1,@p_d_street_2,@p_d_city,@p_d_state,@p_d_zip,@p_c_first,@p_c_middle,@p_c_street_1,@p_c_street_2,@p_c_city,@p_c_state,@p_c_zip,@p_c_phone,@p_c_since,@p_c_credit,@p_c_credit_lim,@p_c_discount,@p_c_balance,@p_c_data,str_to_date(20230421185136,'%Y%m%d%H%i%s')) |
| 1100 | hammerdb | x.x.x.x:56934 | hammerdb | Sleep | 0 | | NULL |
| 1101 | hammerdb | x.x.x.x:56950 | hammerdb | Query | 0 | update | INSERT INTO new_order (no_o_id, no_d_id, no_w_id) VALUES (o_id, no_d_id, no_w_id) |
| 1102 | hammerdb | x.x.x.x:56956 | hammerdb | Query | 0 | executing | CALL PAYMENT(361,1,361,1,@p_c_id,1,3181,@p_c_last,@p_w_street_1,@p_w_street_2,@p_w_city,@p_w_state,@p_w_zip,@p_d_street_1,@p_d_street_2,@p_d_city,@p_d_state,@p_d_zip,@p_c_first,@p_c_middle,@p_c_street_1,@p_c_street_2,@p_c_city,@p_c_state,@p_c_zip,@p_c_phone,@p_c_since,@p_c_credit,@p_c_credit_lim,@p_c_discount,@p_c_balance,@p_c_data,str_to_date(20230421185136,'%Y%m%d%H%i%s')) |
| 1103 | hammerdb | x.x.x.x:56968 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1104 | hammerdb | x.x.x.x:56978 | hammerdb | Query | 0 | statistics | SELECT count(c_id) INTO namecnt
FROM customer
WHERE c_last = p_c_last AND c_d_id = p_c_d_id AND c_w_id = p_c_w_id |
| 1106 | hammerdb | x.x.x.x:57002 | hammerdb | Query | 0 | statistics | SELECT count(c_id) INTO namecnt
FROM customer
WHERE c_last = p_c_last AND c_d_id = p_c_d_id AND c_w_id = p_c_w_id |
| 1107 | hammerdb | x.x.x.x:57004 | hammerdb | Query | 2 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1108 | hammerdb | x.x.x.x:57010 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1109 | hammerdb | x.x.x.x:57026 | hammerdb | Query | 0 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_dist_info)
VALUES (o_id, no_d_id, no_w_id, loop_counter, no_ol_i_id, no_ol_supply_w_id, no_ol_quantity, no_ol_amount, no_ol_dist_info) |
| 1110 | hammerdb | x.x.x.x:57040 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1111 | hammerdb | x.x.x.x:57050 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1113 | hammerdb | x.x.x.x:57072 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1114 | hammerdb | x.x.x.x:57080 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1115 | hammerdb | x.x.x.x:57082 | hammerdb | Query | 0 | update | INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES (o_id, no_d_id, no_w_id, no_c_id, timestamp, no_o_ol_cnt, no_o_all_local) |
| 1116 | hammerdb | x.x.x.x:57090 | hammerdb | Query | 0 | update | INSERT INTO new_order (no_o_id, no_d_id, no_w_id) VALUES (o_id, no_d_id, no_w_id) |
| 1117 | hammerdb | x.x.x.x:58902 | hammerdb | Query | 0 | statistics | SELECT c_discount, c_last, c_credit, w_tax
INTO no_c_discount, no_c_last, no_c_credit, no_w_tax
FROM customer, warehouse
WHERE warehouse.w_id = no_w_id AND customer.c_w_id = no_w_id AND
customer.c_d_id = no_d_id AND customer.c_id = no_c_id |
| 1118 | hammerdb | x.x.x.x:58918 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1119 | hammerdb | x.x.x.x:58924 | hammerdb | Query | 1 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1121 | root | 127.0.0.1:52596 | NULL | Sleep | 1 | | NULL |
| 1122 | hammerdb | x.x.x.x:58950 | hammerdb | Sleep | 0 | | NULL |
| 1123 | hammerdb | x.x.x.x:58952 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1124 | hammerdb | x.x.x.x:58958 | hammerdb | Query | 0 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1125 | hammerdb | x.x.x.x:58966 | hammerdb | Query | 0 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1126 | hammerdb | x.x.x.x:58974 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1127 | hammerdb | x.x.x.x:58986 | hammerdb | Query | 1 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1129 | hammerdb | x.x.x.x:59006 | hammerdb | Query | 0 | update | INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_dist_info)
VALUES (o_id, no_d_id, no_w_id, loop_counter, no_ol_i_id, no_ol_supply_w_id, no_ol_quantity, no_ol_amount, no_ol_dist_info) |
| 1130 | hammerdb | x.x.x.x:59016 | hammerdb | Query | 0 | statistics | SELECT no_o_id INTO d_no_o_id FROM new_order WHERE no_w_id = d_w_id AND no_d_id = d_d_id LIMIT 1 |
| 1131 | hammerdb | x.x.x.x:59018 | hammerdb | Query | 0 | updating | UPDATE warehouse SET w_ytd = w_ytd + p_h_amount
WHERE w_id = p_w_id |
| 1132 | hammerdb | x.x.x.x:59026 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1133 | hammerdb | x.x.x.x:59040 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1134 | hammerdb | x.x.x.x:59042 | hammerdb | Query | 1 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1136 | hammerdb | x.x.x.x:59066 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1137 | hammerdb | x.x.x.x:59076 | hammerdb | Query | 1 | executing | SELECT COUNT(DISTINCT (s_i_id)) INTO stock_count
FROM order_line, stock
WHERE ol_w_id = st_w_id AND
ol_d_id = st_d_id AND (ol_o_id < st_o_id) AND
ol_o_id >= (st_o_id - 20) AND s_w_id = st_w_id AND
s_i_id = ol_i_id AND s_quantity < threshold |
| 1138 | hammerdb | x.x.x.x:59092 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1139 | hammerdb | x.x.x.x:59094 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1140 | hammerdb | x.x.x.x:59100 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1142 | hammerdb | x.x.x.x:56820 | hammerdb | Query | 0 | System lock | UPDATE customer SET c_balance = p_c_balance
WHERE c_w_id = p_c_w_id AND c_d_id = p_c_d_id AND
c_id = p_c_id |
| 1143 | hammerdb | x.x.x.x:56824 | hammerdb | Query | 0 | statistics | SELECT no_o_id INTO d_no_o_id FROM new_order WHERE no_w_id = d_w_id AND no_d_id = d_d_id LIMIT 1 |
| 1145 | hammerdb | x.x.x.x:56852 | hammerdb | Query | 0 | update | INSERT INTO new_order (no_o_id, no_d_id, no_w_id) VALUES (o_id, no_d_id, no_w_id) |
| 1146 | hammerdb | x.x.x.x:56854 | hammerdb | Query | 0 | update | INSERT INTO orders (o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VALUES (o_id, no_d_id, no_w_id, no_c_id, timestamp, no_o_ol_cnt, no_o_all_local) |
| 1147 | hammerdb | x.x.x.x:56860 | hammerdb | Query | 0 | statistics | SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10
INTO no_s_quantity, no_s_data, no_s_dist_01, no_s_dist_02, no_s_dist_03, no_s_dist_04, no_s_dist_05, no_s_dist_06, no_s_dist_07, no_s_dist_08, no_s_dist_09, no_s_dist_10
FROM stock WHERE s_i_id = no_ol_i_id AND s_w_id = no_ol_supply_w_id |
| 1148 | hammerdb | x.x.x.x:56864 | hammerdb | Query | 0 | waiting for handler commit | COMMIT |
| 1149 | hammerdb | x.x.x.x:56880 | hammerdb | Query | 0 | executing | CALL PAYMENT(400,3,227,4,@p_c_id,1,1782,@p_c_last,@p_w_street_1,@p_w_street_2,@p_w_city,@p_w_state,@p_w_zip,@p_d_street_1,@p_d_street_2,@p_d_city,@p_d_state,@p_d_zip,@p_c_first,@p_c_middle,@p_c_street_1,@p_c_street_2,@p_c_city,@p_c_state,@p_c_zip,@p_c_phone,@p_c_since,@p_c_credit,@p_c_credit_lim,@p_c_discount,@p_c_balance,@p_c_data,str_to_date(20230421185136,'%Y%m%d%H%i%s')) |
| 1176 | root | 127.0.0.1:43296 | NULL | Sleep | 0 | | NULL |
+------+-----------------+-------------------+----------+---------+------+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
106 rows in set (0.081 sec)