安装和使用TPCC-MySQL工具遇到的问题_MySQL
bitsCN.com
安装和使用TPCC-MySQL工具遇到的问题
本文主要讲述 TPCC-MySQL 工具在获取和使用时遇到的问题。
============= 我是分割线 ===============
Tpcc-mysql 是 percona 基于 tpcc 衍生出来的产品，专用于 mysql 基准测试，其源码放在 bazaar 上（ Bazaar 是一个分布式的版本控制系统，采用 GPL 许可协议，可运行于 Windows、GNU/Linux、UNIX 以及 Mac OS 系统之上。Bazaar 由 Canonical 公司（Ubuntu 母公司）赞助），因此还需要先安装 bazaar 客户端。
【工具的获取】
1. 安装 bzr 客户端
可以通过 yum -y install bzr 方式安装 bzr ，但默认会安装到 /usr/lib64/python2.4/site-packages 之中（我的系统为 CentOS release 5.6 (Final) ）。如果希望安装的位置是 /usr/local/lib/python2.7/site-packages ，通过 yum 方式可能无法满足（或者说我不知道怎么操作）。于是采用 pip 方式安装。
1
[root@Betty site-packages]# pip install bzr
安装成功后，可以看到
1
[root@Betty site-packages]# pip show bzr
2
---
3
Name: bzr
4
Version: 2.6.0
5
Location: /usr/local/lib/python2.7/site-packages
6
Requires:
7
[root@Betty site-packages]#
2. 用 bzr 客户端下载 tpcc-mysql 源码
首先需要登录到 https://launchpad.net/bzr 上注册帐号（假设注册后用户 ID 为 special-agent ），并登陆。
然后需要在 linux 下生成 SSH 使用的密钥。
01
[root@Betty WGET_DIR]# ssh-keygen -t rsa
02
Generating public/private rsa key pair.
03
Enter file in which to save the key (/root/.ssh/id_rsa):
04
Created directory '/root/.ssh'.
05
Enter passphrase (empty for no passphrase):
06
Enter same passphrase again:
07
Your identification has been saved in /root/.ssh/id_rsa.
08
Your public key has been saved in /root/.ssh/id_rsa.pub.
09
The key fingerprint is:
10
17:b3:91:e6:b2:47:5c:15:5f:d6:ee:8a:d8:b1:5c:da root@Betty
11
[root@Betty WGET_DIR]#
之后将公钥所在文件 id_rsa.pub 的内容复制到 https://launchpad.net/~special-agent/+editsshkeys 中的输入框中，并提交（红色部分换成你自己的 UserID）。
最后通过 bzr 命令下载 tpcc-mysql 源码。
01
[root@Betty WGET_DIR]# bzr help launchpad-login
02
Purpose: Show or set the Launchpad user ID.
03
Usage: bzr launchpad-login [NAME]
04
05
Options:
06
--usage Show usage message and options.
07
--no-check Don't check that the user name is valid.
08
-q, --quiet Only display errors and warnings.
09
-v, --verbose Display more information.
10
-h, --help Show help message.
11
12
Description:
13
When communicating with Launchpad, some commands need to know your
14
Launchpad user ID. This command can be used to set or show the
15
user ID that Bazaar will use for such communication.
16
17
Examples:
18
Show the Launchpad ID of the current user:
19
20
bzr launchpad-login
21
22
Set the Launchpad ID of the current user to 'bob':
23
24
bzr launchpad-login bob
25
26
Aliases: lp-login
27
From: plugin "launchpad"
1
[root@Betty WGET_DIR]# bzr launchpad-login special-agent
1
[root@Betty WGET_DIR]# bzr branch lp:~percona-dev/perconatools/tpcc-mysql
2
The authenticity of host 'bazaar.launchpad.net (91.189.95.84)' can't be established.
3
RSA key fingerprint is 9d:38:3a:63:b1:d5:6f:c4:44:67:53:49:2e:ee:fc:89.
4
Are you sure you want to continue connecting (yes/no)? yes
5
Warning: Permanently added 'bazaar.launchpad.net,91.189.95.84' (RSA) to the list of known hosts.
6
Branched 48 revisions.
7
[root@Betty WGET_DIR]#
查看下载下来的文件。
01
[root@Betty WGET_DIR]# ll tpcc-mysql/
02
total 36
03
-rw-r--r-- 1 root root 851 Jul 30 14:30 README
04
-rw-r--r-- 1 root root 1621 Jul 30 14:30 add_fkey_idx.sql
05
-rw-r--r-- 1 root root 317 Jul 30 14:30 count.sql
06
-rw-r--r-- 1 root root 3105 Jul 30 14:30 create_table.sql
07
-rw-r--r-- 1 root root 763 Jul 30 14:30 drop_cons.sql
08
-rw-r--r-- 1 root root 477 Jul 30 14:30 load.sh
09
drwxr-xr-x 2 root root 4096 Jul 30 14:30 schema2
10
drwxr-xr-x 5 root root 4096 Jul 30 14:30 scripts
11
drwxr-xr-x 2 root root 4096 Jul 30 14:30 src
12
[root@Betty WGET_DIR]#
可能需要对 Makefile 文件做调整才能通过编译。我的 改动如下：
01
#
02
# "make all" to build necessary executables.
03
#
04
05
LIBS= `mysql_config --libs_r` -lrt
06
INC= -I. `mysql_config --include` -I/usr/local/mysql/include/
07
#DEFS= -DDEBUG
08
CFLAGS= -w -O2 -g
09
TRANSACTIONS= neword.o payment.o ordstat.o delivery.o slev.o
10
OBJS= main.o spt_proc.o driver.o support.o sequence.o rthist.o $(TRANSACTIONS)
11
12
.SUFFIXES:
13
.SUFFIXES: .o .c
14
15
.c.o:
16
$(CC) $(CFLAGS) $(INC) $(DEFS) -c $*.c
17
18
all: ../tpcc_load ../tpcc_start
19
20
../tpcc_load : load.o support.o
21
$(CC) load.o support.o $(LIBS) -L/usr/local/mysql/lib/ -o ../tpcc_load
22
23
../tpcc_start : $(OBJS)
24
$(CC) $(OBJS) $(LIBS) -L/usr/local/mysql/lib/ -o ../tpcc_start
25
26
clean :
27
rm -f *.o
执行 make 后生成工具 tpcc_load 和 tpcc_start 。
01
[root@Betty src]#
02
[root@Betty src]# make
03
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c load.c
04
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c support.c
05
cc load.o support.o `mysql_config --libs_r` -lrt -L/usr/local/mysql/lib/ -o ../tpcc_load
06
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c main.c
07
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c spt_proc.c
08
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c driver.c
09
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c sequence.c
10
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c rthist.c
11
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c neword.c
12
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c payment.c
13
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c ordstat.c
14
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c delivery.c
15
cc -w -O2 -g -I. `mysql_config --include` -I/usr/local/mysql/include/ -c slev.c
16
cc main.o spt_proc.o driver.o support.o sequence.o rthist.o neword.o payment.o ordstat.o delivery.o slev.o `mysql_config --libs_r` -lrt -L/usr/local/mysql/lib/ -o ../tpcc_start
17
[root@Betty src]#
查看 README 文件的内容（简单实用的说明）
01
[root@Betty tpcc-mysql]# vi README
02
03
1. Build binaries
04
* cd scr ; make
05
( you should have mysql_config available in $PATH)
06
07
08
2. Load data
09
* create database
10
mysqladmin create tpcc1000
11
* create tables
12
mysql tpcc1000
13
* create indexes and FK ( this step can be done after loading data)
14
mysql tpcc1000
15
* populate data
16
- simple step
17
tpcc_load 127.0.0.1:33000 tpcc1000 root "" 1000
18
|hostname:port| |dbname| |user| |password| |WAREHOUSES|
19
ref. tpcc_load --help for all options
20
- load data in parallel
21
check load.sh script
22
23
24
3. start benchmark
25
* ./tpcc_start -h127.0.0.1 -P33000 -dtpcc1000 -uroot -w1000 -c32 -r10 -l10800
26
|hostname| |port| |dbname| |user| |WAREHOUSES| |CONNECTIONS| |WARMUP TIME| |BENCHMARK TIME|
27
* ref. tpcc_start --help for all options
查看两个工具的帮助命令。
01
[root@Betty tpcc-mysql]# ./tpcc_load --help
02
*************************************
03
*** ###easy### TPC-C Data Loader ***
04
*************************************
05
06
usage: tpcc_load [server] [DB] [user] [pass] [warehouse]
07
OR
08
tpcc_load [server] [DB] [user] [pass] [warehouse] [part] [min_wh] [max_wh]
09
10
* [part]: 1=ITEMS 2=WAREHOUSE 3=CUSTOMER 4=ORDERS
1
[root@Betty tpcc-mysql]# ./tpcc_start --help
2
***************************************
3
*** ###easy### TPC-C Load Generator ***
4
***************************************
5
./tpcc_start: invalid option -- -
6
Usage: tpcc_start -h server_host -P port -d database_name -u mysql_user -p mysql_password -w warehouses -c connections -r warmup_time -l running_time -i report_interval -f report_file -t trx_file
7
[root@Betty tpcc-mysql]#
【工具的简单使用】
创建库 tpcc100 。
1
[root@Betty tpcc-mysql]# mysqladmin create tpcc100
2
mysqladmin: connect to server at 'localhost' failed
3
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
4
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
5
[root@Betty tpcc-mysql]#
6
[root@Betty tpcc-mysql]# mysqladmin -S /tmp/mysql.sock create tpcc100
创建表。
1
[root@Betty tpcc-mysql]# mysql -S /tmp/mysql.sock tpcc100
创建索引和 FK 。
1
[root@Betty tpcc-mysql]# mysql -S /tmp/mysql.sock tpcc100
创建 100 个数据仓库并填充数据（即使100个仓库也花了好久时间）。
01
[root@Betty tpcc-mysql]#
02
[root@Betty tpcc-mysql]# ./tpcc_load localhost tpcc100 root "" 100
03
*************************************
04
*** ###easy### TPC-C Data Loader ***
05
*************************************
06
07
[server]: localhost
08
[port]: 3306
09
[DBname]: tpcc100
10
[user]: root
11
[pass]:
12
[warehouse]: 100
13
TPCC Data Load Started...
14
Loading Item
15
.................................................. 5000
16
.................................................. 10000
17
.................................................. 15000
18
19
20
...
21
22
23
Loading Orders for D=4, W= 100
24
.......... 1000
25
.......... 2000
26
.......... 3000
27
Orders Done.
28
Loading Orders for D=5, W= 100
29
.......... 1000
30
.......... 2000
31
.......... 3000
32
Orders Done.
33
Loading Orders for D=6, W= 100
34
.......... 1000
35
.......... 2000
36
.......... 3000
37
Orders Done.
38
Loading Orders for D=7, W= 100
39
.......... 1000
40
.......... 2000
41
.......... 3000
42
Orders Done.
43
Loading Orders for D=8, W= 100
44
.......... 1000
45
.......... 2000
46
.......... 3000
47
Orders Done.
48
Loading Orders for D=9, W= 100
49
.......... 1000
50
.......... 2000
51
.......... 3000
52
Orders Done.
53
Loading Orders for D=10, W= 100
54
.......... 1000
55
.......... 2000
56
.......... 3000
57
Orders Done.
58
59
60
...DATA LOADING COMPLETED SUCCESSFULLY.
61
[root@Betty tpcc-mysql]#
对 100 个数据仓库，预热 120 秒，100 个并发连接，运行 3600 秒， 结果存放在文件 tpcc100_20130730 中。
001
[root@Betty tpcc-mysql]#
002
[root@Betty tpcc-mysql]# ./tpcc_start -h localhost -d tpcc100 -u root -p '' -w 100 -c 100 -r 120 -l 3600 -f tpcc100_20130730
003
***************************************
004
*** ###easy### TPC-C Load Generator ***
005
***************************************
006
option h with value 'localhost'
007
option d with value 'tpcc100'
008
option u with value 'root'
009
option p with value ''
010
option w with value '100'
011
option c with value '100'
012
option r with value '120'
013
option l with value '3600'
014
option f with value 'tpcc100_20130730'
015
016
[server]: localhost
017
[port]: 3306
018
[DBname]: tpcc100
019
[user]: root
020
[pass]:
021
[warehouse]: 100
022
[connection]: 100
023
[rampup]: 120 (sec.)
024
[measure]: 3600 (sec.)
025
026
027
RAMP-UP TIME.(120 sec.)
028
payment 87:1
029
1205, HY000, Lock wait timeout exceeded; try restarting transaction
030
payment 71:1
031
1205, HY000, Lock wait timeout exceeded; try restarting transaction
032
033
034
MEASURING START.
035
036
037
10, 27(0):1.745|1.848, 25(0):0.339|0.351, 2(0):0.171|0.172, 3(0):1.866|1.924, 2(0):6.002|6.103
038
20, 24(0):1.626|1.741, 16(0):0.320|0.322, 1(0):0.000|0.124, 1(0):0.000|1.734, 4(0):3.972|5.976
039
30, 21(0):1.554|1.681, 13(0):0.311|0.316, 2(0):0.121|0.193, 4(0):1.750|1.833, 2(0):3.156|5.219
040
40, 12(0):1.482|1.538, 45(0):0.332|0.342, 2(0):0.109|0.126, 3(0):1.672|1.753, 1(0):0.000|5.898
041
50, 14(0):1.463|1.650, 21(0):0.311|0.329, 4(0):0.140|0.165, 1(0):0.000|1.763, 3(0):5.527|5.596
042
60, 52(0):1.597|1.701, 17(0):0.288|0.309, 1(0):0.000|0.163, 2(0):1.613|1.697, 2(0):3.245|5.850
043
payment 29:1
044
1205, HY000, Lock wait timeout exceeded; try restarting transaction
045
70, 36(0):1.587|1.604, 15(0):0.287|0.289, 5(0):0.128|0.148, 1(0):0.000|1.915, 3(0):4.057|4.169
046
80, 38(0):1.635|1.735, 13(0):0.306|0.319, 1(0):0.000|0.129, 1(0):0.000|1.656, 2(0):4.998|5.101
047
90, 3(0):0.942|1.556, 17(0):0.313|0.314, 1(0):0.000|0.103, 5(0):1.733|1.736, 4(0):4.676|5.341
048
100, 19(0):1.183|1.218, 8(0):0.263|0.273, 3(0):0.124|0.140, 2(0):1.678|1.749, 0(0):0.000|0.000
049
110, 13(0):1.471|1.637, 9(0):0.266|0.269, 0(0):0.000|0.000, 4(0):1.732|1.777, 2(0):3.457|3.528
050
payment 12:1
051
1205, HY000, Lock wait timeout exceeded; try restarting transaction
052
120, 16(0):1.659|1.698, 12(0):0.285|0.321, 2(0):0.102|0.161, 2(0):1.671|1.732, 0(0):0.000|0.000
053
130, 27(0):1.624|1.735, 12(0):0.299|0.312, 1(0):0.000|0.162, 2(0):1.673|1.692, 2(0):3.473|5.142
054
payment 46:1
055
1205, HY000, Lock wait timeout exceeded; try restarting transaction
056
payment 21:1
057
1205, HY000, Lock wait timeout exceeded; try restarting transaction
058
payment 50:1
059
1205, HY000, Lock wait timeout exceeded; try restarting transaction
060
140, 9(0):1.282|1.586, 11(0):0.282|0.343, 2(0):0.146|0.152, 1(0):0.000|1.686, 1(0):0.000|3.857
061
payment 76:1
062
1205, HY000, Lock wait timeout exceeded; try restarting transaction
063
150, 2(0):0.601|0.791, 31(0):0.320|0.462, 1(0):0.000|0.130, 0(0):0.000|0.000, 2(0):3.993|5.798
064
160, 0(0):0.000|0.000, 21(0):0.313|0.316, 2(0):0.139|0.153, 0(0):0.000|0.000, 2(0):3.716|3.848
065
170, 15(0):1.107|1.181, 10(0):0.310|0.313, 2(0):0.102|0.131, 0(0):0.000|0.000, 1(0):0.000|5.739
066
180, 22(0):1.540|1.562, 12(0):0.296|0.336, 1(0):0.000|0.123, 0(0):0.000|0.000, 3(0):4.844|6.041
067
190, 13(0):1.414|1.548, 25(0):0.318|0.332, 1(0):0.000|0.108, 3(0):1.633|1.650, 0(0):0.000|0.000
068
200, 19(0):1.458|1.504, 7(0):0.309|0.314, 2(0):0.147|0.148, 0(0):0.000|0.000, 2(0):4.069|4.663
069
210, 23(0):1.607|1.726, 8(0):0.294|0.301, 1(0):0.000|0.114, 4(0):1.818|1.834, 1(0):0.000|5.623
070
payment 59:1
071
1205, HY000, Lock wait timeout exceeded; try restarting transaction
072
220, 11(0):1.220|1.348, 10(0):0.292|0.309, 1(0):0.000|0.140, 3(0):1.788|1.842, 1(0):0.000|3.541
073
230, 27(0):1.573|1.647, 19(0):0.324|0.370, 3(0):0.111|0.146, 1(0):0.000|1.664, 3(0):3.467|3.842
074
240, 1(0):0.000|0.877, 16(0):0.314|0.344, 0(0):0.000|0.000, 2(0):1.653|1.685, 1(0):0.000|3.741
075
250, 31(0):1.580|1.661, 8(0):0.323|0.324, 3(0):0.136|0.146, 3(0):1.721|1.805, 1(0):0.000|3.888
076
payment 95:1
077
1205, HY000, Lock wait timeout exceeded; try restarting transaction
078
260, 24(0):1.638|1.661, 9(0):0.303|0.315, 0(0):0.000|0.000, 1(0):0.000|1.676, 1(0):0.000|5.115
079
270, 15(0):1.470|1.536, 11(0):0.276|0.302, 3(0):0.125|0.130, 3(0):1.566|1.763, 3(0):5.104|5.545
080
payment 53:1
081
1205, HY000, Lock wait timeout exceeded; try restarting transaction
082
280, 11(0):1.561|1.631, 18(0):0.304|0.324, 1(0):0.000|0.117, 1(0):0.000|1.810, 1(0):0.000|3.687
083
payment 38:1
084
1205, HY000, Lock wait timeout exceeded; try restarting transaction
085
290, 17(0):1.281|1.466, 15(0):0.307|0.356, 1(0):0.000|0.137, 3(0):1.647|1.738, 1(0):0.000|3.775
086
payment 16:1
087
1205, HY000, Lock wait timeout exceeded; try restarting transaction
088
payment 13:1
089
1205, HY000, Lock wait timeout exceeded; try restarting transaction
090
payment 4:1
091
1205, HY000, Lock wait timeout exceeded; try restarting transaction
092
300, 17(0):1.520|1.625, 12(0):0.277|0.312, 1(0):0.000|0.117, 0(0):0.000|0.000, 2(0):3.560|3.879
093
payment 83:1
094
1205, HY000, Lock wait timeout exceeded; try restarting transaction
095
payment 71:1
096
1205, HY000, Lock wait timeout exceeded; try restarting transaction
097
payment 24:1
098
1205, HY000, Lock wait timeout exceeded; try restarting transaction
099
310, 14(0):1.154|1.182, 20(0):0.312|0.325, 3(0):0.111|0.134, 2(0):1.629|1.664, 2(0):3.881|4.627
100
payment 66:1
101
1205, HY000, Lock wait timeout exceeded; try restarting transaction
102
payment 10:1
103
1205, HY000, Lock wait timeout exceeded; try restarting transaction
104
320, 9(0):1.420|1.579, 19(0):0.341|0.357, 2(0):0.128|0.166, 0(0):0.000|0.000, 1(0):0.000|5.537
105
payment 49:1
106
1205, HY000, Lock wait timeout exceeded; try restarting transaction
107
payment 60:1
108
1205, HY000, Lock wait timeout exceeded; try restarting transaction
109
330, 19(0):1.325|1.340, 16(0):0.298|0.300, 0(0):0.000|0.000, 2(0):1.715|1.827, 1(0):0.000|4.190
110
payment 65:1
111
1205, HY000, Lock wait timeout exceeded; try restarting transaction
112
340, 15(0):1.658|1.691, 13(0):0.291|0.372, 2(0):0.129|0.176, 1(0):0.000|1.741, 0(0):0.000|0.000
113
payment 4:1
114
1205, HY000, Lock wait timeout exceeded; try restarting transaction
115
payment 47:1
116
1205, HY000, Lock wait timeout exceeded; try restarting transaction
117
350, 16(0):1.537|1.705, 18(0):0.318|0.347, 1(0):0.000|0.100, 2(0):1.663|1.783, 3(0):3.911|5.872
118
payment 83:1
119
1205, HY000, Lock wait timeout exceeded; try restarting transaction
120
payment 39:1
121
1205, HY000, Lock wait timeout exceeded; try restarting transaction
122
payment 30:1
123
1205, HY000, Lock wait timeout exceeded; try restarting transaction
124
360, 8(0):1.171|1.334, 23(0):0.329|0.393, 3(0):0.145|0.166, 3(0):1.740|1.742, 1(0):0.000|3.870
125
payment 97:1
126
1205, HY000, Lock wait timeout exceeded; try restarting transaction
127
payment 10:1
128
1205, HY000, Lock wait timeout exceeded; try restarting transaction
129
payment 23:1
130
1205, HY000, Lock wait timeout exceeded; try restarting transaction
131
370, 5(0):1.248|1.441, 12(0):0.269|0.283, 0(0):0.000|0.000, 0(0):0.000|0.000, 2(0):3.495|4.072
132
payment 81:1
133
1205, HY000, Lock wait timeout exceeded; try restarting transaction
134
380, 27(0):1.645|1.737, 18(0):0.368|0.369, 3(0):0.101|0.118, 0(0):0.000|0.000, 1(0):0.000|3.680
135
payment 7:1
136
1205, HY000, Lock wait timeout exceeded; try restarting transaction
137
390, 10(0):1.119|1.504, 21(0):0.358|0.362, 1(0):0.000|0.117, 0(0):0.000|0.000, 3(0):3.920|6.066
138
payment 3:1
139
1205, HY000, Lock wait timeout exceeded; try restarting transaction
140
payment 53:1
141
1205, HY000, Lock wait timeout exceeded; try restarting transaction
142
400, 12(0):1.381|1.402, 12(0):0.300|0.346, 2(0):0.119|0.140, 3(0):1.693|1.721, 1(0):0.000|3.782
143
payment 62:1
144
1205, HY000, Lock wait timeout exceeded; try restarting transaction
145
410, 24(0):1.526|1.625, 23(0):0.397|0.402, 1(0):0.000|0.240, 2(0):1.567|1.628, 1(0):0.000|4.182
146
420, 8(0):1.548|1.589, 12(0):0.292|0.369, 1(0):0.000|0.114, 1(0):0.000|1.705, 3(0):3.859|4.125
147
payment 81:1
148
1205, HY000, Lock wait timeout exceeded; try restarting transaction
149
430, 26(0):1.576|1.596, 18(0):0.276|0.280, 3(0):0.105|0.143, 3(0):1.671|1.772, 1(0):0.000|4.054
150
440, 17(0):1.562|1.664, 22(0):0.307|0.321, 1(0):0.000|0.113, 3(0):1.708|1.718, 1(0):0.000|5.911
151
payment 3:1
152
1205, HY000, Lock wait timeout exceeded; try restarting transaction
153
payment 53:1
154
1205, HY000, Lock wait timeout exceeded; try restarting transaction
155
450, 13(0):1.471|1.621, 8(0):0.310|0.326, 2(0):0.107|0.121, 2(0):1.727|1.748, 2(0):3.655|5.935
156
payment 86:1
157
1205, HY000, Lock wait timeout exceeded; try restarting transaction
158
payment 11:1
159
1205, HY000, Lock wait timeout exceeded; try restarting transaction
160
460, 18(0):1.330|1.356, 13(0):0.308|0.312, 2(0):0.120|0.140, 2(0):1.698|1.709, 3(0):3.994|5.304
161
payment 45:1
162
1205, HY000, Lock wait timeout exceeded; try restarting transaction
163
470, 18(0):1.618|1.665, 26(0):0.317|0.370, 1(0):0.000|0.161, 2(0):1.755|1.782, 1(0):0.000|3.278
164
480, 18(0):1.471|1.550, 11(0):0.304|0.422, 2(0):0.132|0.137, 1(0):0.000|1.638, 2(0):3.614|5.653
165
490, 14(0):1.693|1.707, 16(0):0.294|0.307, 2(0):0.155|0.164, 1(0):0.000|1.731, 1(0):0.000|3.328
166
500, 17(0):1.450|1.600, 23(0):0.297|0.328, 2(0):0.132|0.150, 2(0):1.669|1.733, 1(0):0.000|3.543
167
payment 86:1
168
1205, HY000, Lock wait timeout exceeded; try restarting transaction
169
payment 7:1
170
1205, HY000, Lock wait timeout exceeded; try restarting transaction
171
payment 90:1
172
1205, HY000, Lock wait timeout exceeded; try restarting transaction
173
510, 28(0):1.574|1.664, 6(0):0.264|0.429, 1(0):0.000|0.122, 1(0):0.000|1.709, 3(0):3.879|3.894
174
payment 11:1
175
1205, HY000, Lock wait timeout exceeded; try restarting transaction
176
payment 73:1
177
1205, HY000, Lock wait timeout exceeded; try restarting transaction
178
520, 15(0):1.587|1.651, 35(0):0.335|0.411, 1(0):0.000|0.101, 0(0):0.000|0.000, 2(0):3.725|4.225
179
530, 0(0):0.000|0.000, 14(0):0.318|0.355, 2(0):0.125|0.137, 1(0):0.000|1.713, 2(0):4.142|4.331
180
payment 82:1
181
1205, HY000, Lock wait timeout exceeded; try restarting transaction
182
540, 26(0):1.524|1.648, 28(0):0.329|0.347, 2(0):0.109|0.164, 2(0):1.720|1.821, 1(0):0.000|2.981
183
payment 91:1
184
1205, HY000, Lock wait timeout exceeded; try restarting transaction
185
550, 8(0):1.498|1.518, 21(0):0.315|0.385, 2(0):0.150|0.156, 1(0):0.000|1.664, 0(0):0.000|0.000
186
560, 19(0):1.304|1.453, 15(0):0.288|0.293, 2(0):0.104|0.121, 3(0):1.727|1.844, 3(0):4.177|4.517
187
570, 24(0):1.679|1.691, 8(0):0.242|0.245, 1(0):0.000|0.146, 1(0):0.000|1.725, 2(0):3.718|4.960
188
580, 4(0):1.478|1.684, 23(0):0.323|0.325, 1(0):0.000|0.122, 1(0):0.000|1.663, 2(0):3.510|3.705
189
590, 38(0):1.572|1.633, 31(0):0.342|0.352, 4(0):0.117|0.128, 1(0):0.000|1.701, 1(0):0.000|4.539
190
600, 4(0):0.864|1.145, 13(0):0.303|0.311, 1(0):0.000|0.106, 1(0):0.000|1.846, 1(0):0.000|3.959
191
610, 0(0):0.000|0.000, 37(0):0.316|0.319, 2(0):0.106|0.148, 0(0):0.000|0.000, 4(0):3.801|4.133
192
620, 24(0):1.558|1.597, 29(0):0.299|0.304, 2(0):0.125|0.156, 3(0):1.671|1.748, 2(0):2.216|3.606
193
630, 24(0):1.492|1.552, 11(0):0.251|0.280, 2(0):0.135|0.158, 2(0):1.634|1.765, 0(0):0.000|0.000
194
640, 1(0):0.000|1.200, 16(0):0.310|0.315, 2(0):0.127|0.158, 1(0):0.000|1.861, 2(0):3.813|4.466
195
650, 42(0):1.638|1.674, 22(0):0.315|0.320, 1(0):0.000|0.106, 3(0):1.691|1.752, 1(0):0.000|6.426
196
660, 12(0):1.449|1.630, 25(0):0.309|0.318, 3(0):0.161|0.174, 1(0):0.000|1.721, 2(0):3.854|5.176
197
670, 4(0):1.457|1.540, 25(0):0.276|0.291, 1(0):0.000|0.162, 2(0):1.625|1.742, 5(0):4.867|4.882
198
680, 22(0):1.497|1.581, 7(0):0.259|0.273, 2(0):0.113|0.127, 2(0):1.680|1.784, 1(0):0.000|3.783
199
690, 27(0):1.697|1.724, 9(0):0.278|0.289, 1(0):0.000|0.183, 2(0):1.614|1.698, 1(0):0.000|4.243
200
700, 26(0):1.669|1.682, 13(0):0.292|0.333, 3(0):0.119|0.145, 1(0):0.000|1.619, 3(0):3.867|4.089
201
710, 19(0):1.469|1.709, 32(0):0.303|0.324, 2(0):0.116|0.137, 4(0):1.727|1.734, 0(0):0.000|0.000
202
720, 6(0):0.924|1.232, 24(0):0.300|0.331, 0(0):0.000|0.000, 0(0):0.000|0.000, 2(0):3.951|4.371
203
730, 5(0):1.495|1.643, 18(0):0.287|0.293, 3(0):0.132|0.147, 3(0):1.620|1.654, 2(0):3.817|6.235
204
740, 40(0):1.534|1.562, 24(0):0.295|0.699, 1(0):0.000|0.087, 1(0):0.000|1.637, 1(0):0.000|4.484
205
750, 8(0):1.522|1.590, 8(0):0.274|0.296, 3(0):0.122|0.188, 1(0):0.000|1.581, 2(0):4.844|5.300
206
760, 26(0):1.501|1.510, 24(0):0.300|0.394, 2(0):0.182|0.185, 2(0):1.642|1.689, 1(0):0.000|6.246
207
770, 10(0):1.501|1.563, 12(0):0.303|0.310, 1(0):0.000|0.124, 1(0):0.000|1.643, 3(0):5.352|5.502
208
780, 29(0):1.501|1.521, 32(0):0.339|0.409, 3(0):0.154|0.159, 1(0):0.000|1.570, 3(0):4.159|4.166
209
790, 14(0):1.453|1.457, 14(0):0.303|0.314, 2(0):0.149|0.151, 4(0):1.685|1.758, 2(0):4.091|4.878
210
800, 14(0):1.615|1.648, 30(0):0.309|0.312, 1(0):0.000|0.144, 1(0):0.000|1.702, 2(0):5.110|5.147
211
810, 26(0):1.577|1.670, 18(0):0.281|0.314, 3(0):0.139|0.142, 4(0):1.677|1.712, 0(0):0.000|0.000
212
820, 12(0):1.538|1.576, 24(0):0.297|0.367, 1(0):0.000|0.126, 0(0):0.000|0.000, 5(0):4.741|5.087
213
830, 44(0):1.527|1.530, 7(0):0.284|0.297, 2(0):0.129|0.156, 1(0):0.000|1.664, 1(0):0.000|4.410
214
840, 8(0):1.405|1.583, 32(0):0.305|0.320, 4(0):0.132|0.163, 1(0):0.000|1.821, 4(0):3.707|3.917
215
850, 29(0):1.590|1.633, 27(0):0.303|0.313, 1(0):0.000|0.139, 3(0):1.704|1.707, 0(0):0.000|0.000
216
860, 24(0):1.578|1.663, 12(0):0.298|0.309, 1(0):0.000|0.146, 1(0):0.000|1.694, 1(0):0.000|4.425
217
870, 2(0):1.467|1.621, 13(0):0.309|0.314, 1(0):0.000|0.155, 0(0):0.000|0.000, 3(0):5.616|5.632
218
880, 16(0):1.479|1.522, 29(0):0.311|0.326, 4(0):0.148|0.155, 5(0):1.670|1.717, 2(0):3.272|5.462
219
890, 8(0):1.562|1.610, 22(0):0.331|0.351, 2(0):0.115|0.156, 3(0):1.673|1.692, 3(0):5.080|5.298
220
900, 26(0):1.569|1.641, 14(0):0.268|0.282, 2(0):0.110|0.147, 0(0):0.000|0.000, 1(0):0.000|4.127
221
910, 26(0):1.547|1.724, 17(0):0.290|0.292, 1(0):0.000|0.134, 2(0):1.568|1.711, 1(0):0.000|4.834
222
920, 31(0):1.502|1.559, 6(0):0.281|0.301, 3(0):0.127|0.169, 3(0):1.677|1.693, 1(0):0.000|4.069
223
930, 44(0):1.643|1.733, 10(0):0.264|0.290, 2(0):0.145|0.156, 1(0):0.000|1.612, 5(0):3.918|5.227
224
940, 7(0):1.370|1.455, 22(0):0.279|0.282, 2(0):0.123|0.157, 4(0):1.679|1.727, 0(0):0.000|0.000
225
950, 10(0):0.950|1.313, 22(0):0.305|0.314, 1(0):0.000|0.139, 0(0):0.000|0.000, 5(0):4.910|5.002
226
960, 33(0):1.693|1.707, 38(0):0.302|0.311, 2(0):0.099|0.115, 4(0):1.646|1.663, 1(0):0.000|2.671
227
970, 3(0):1.238|1.240, 9(0):0.282|0.286, 3(0):0.146|0.170, 0(0):0.000|0.000, 2(0):3.523|5.265
228
980, 23(0):1.561|1.574, 35(0):0.301|0.340, 3(0):0.108|0.163, 6(0):1.678|1.705, 0(0):0.000|0.000
229
990, 25(0):1.617|1.640, 0(0):0.000|0.000, 1(0):0.000|0.107, 1(0):0.000|1.786, 4(0):4.266|5.280
230
1000, 21(0):1.528|1.541, 15(0):0.309|0.319, 0(0):0.000|0.000, 2(0):1.657|1.710, 0(0):0.000|0.000
231
1010, 33(0):1.589|1.600, 1(0):0.000|0.168, 2(0):0.149|0.151, 0(0):0.000|0.000, 3(0):3.805|5.220
232
1020, 3(0):1.228|1.360, 32(0):0.290|0.303, 3(0):0.133|0.158, 4(0):1.774|1.775, 2(0):3.775|5.501
233
1030, 32(0):1.435|1.489, 4(0):0.263|0.293, 1(0):0.000|0.111, 2(0):1.617|1.725, 1(0):0.000|3.648
234
1040, 10(0):1.615|1.622, 45(0):0.318|0.340, 2(0):0.140|0.146, 1(0):0.000|1.691, 2(0):5.049|5.139
235
1050, 10(0):1.517|1.630, 45(0):0.329|0.354, 3(0):0.122|0.162, 5(0):1.683|1.722, 2(0):1.645|3.772
236
1060, 9(0):0.900|1.686, 15(0):0.314|0.324, 3(0):0.127|0.130, 2(0):1.608|1.654, 3(0):4.027|4.120
237
1070, 27(0):1.583|1.704, 18(0):0.322|0.331, 1(0):0.000|0.131, 1(0):0.000|1.696, 2(0):5.235|5.549
238
1080, 27(0):1.626|1.656, 5(0):0.254|0.284, 4(0):0.142|0.171, 1(0):0.000|1.548, 3(0):3.753|5.217
239
1090, 18(0):1.629|1.721, 36(0):0.317|0.335, 1(0):0.000|0.128, 3(0):1.654|1.745, 0(0):0.000|0.000
240
payment 99:1
241
1205, HY000, Lock wait timeout exceeded; try restarting transaction
242
1100, 8(0):1.043|1.192, 18(0):0.294|0.295, 1(0):0.000|0.134, 2(0):1.574|1.689, 3(0):4.268|5.269
243
1110, 48(0):1.650|1.678, 17(0):0.282|0.310, 3(0):0.109|0.179, 3(0):1.706|1.778, 1(0):0.000|5.227
244
1120, 4(0):1.425|1.464, 21(0):0.260|0.331, 2(0):0.146|0.148, 2(0):1.554|1.649, 3(0):3.864|4.110
245
1130, 9(0):1.517|1.669, 45(0):0.313|0.322, 3(0):0.138|0.140, 1(0):0.000|1.719, 3(0):5.140|5.475
246
1140, 13(0):1.410|1.412, 13(0):0.287|0.290, 1(0):0.000|0.132, 0(0):0.000|0.000, 3(0):3.356|3.929
247
1150, 21(0):1.186|1.540, 12(0):0.319|0.322, 2(0):0.121|0.127, 2(0):1.537|1.690, 0(0):0.000|0.000
248
1160, 31(0):1.553|1.568, 19(0):0.297|0.298, 2(0):0.124|0.167, 5(0):1.682|1.701, 2(0):3.905|3.945
249
1170, 39(0):1.518|1.596, 18(0):0.289|0.306, 3(0):0.128|0.128, 5(0):1.675|1.779, 2(0):1.989|2.381
250
1180, 28(0):1.623|1.630, 8(0):0.320|0.338, 1(0):0.000|0.119, 1(0):0.000|1.656, 1(0):0.000|4.010
251
1190, 6(0):1.481|1.575, 25(0):0.279|0.307, 2(0):0.136|0.145, 2(0):1.601|1.662, 3(0):4.138|4.661
252
1200, 24(0):1.104|1.408, 12(0):0.281|0.311, 2(0):0.118|0.124, 0(0):0.000|0.000, 1(0):0.000|5.189
253
1210, 16(0):1.493|1.537, 51(0):0.319|0.354, 3(0):0.123|0.139, 3(0):1.610|1.668, 3(0):4.271|4.518
254
1220, 20(0):1.509|1.514, 15(0):0.294|0.295, 1(0):0.000|0.129, 2(0):1.612|1.635, 2(0):5.131|5.134
255
1230, 32(0):1.592|1.614, 37(0):0.316|0.387, 4(0):0.134|0.153, 3(0):1.542|1.594, 4(0):3.752|4.051
256
1240, 10(0):1.267|1.331, 32(0):0.320|0.325, 1(0):0.000|0.156, 2(0):1.576|1.579, 1(0):0.000|2.360
257
1250, 34(0):1.594|1.611, 13(0):0.300|0.319, 4(0):0.148|0.159, 2(0):1.624|1.672, 2(0):3.962|5.386
258
1260, 32(0):1.472|1.573, 19(0):0.304|0.317, 3(0):0.114|0.142, 1(0):0.000|1.640, 1(0):0.000|4.156
259
1270, 20(0):1.609|1.776, 27(0):0.275|0.282, 1(0):0.000|0.143, 1(0):0.000|1.684, 1(0):0.000|4.861
260
1280, 15(0):1.573|1.607, 1(0):0.000|0.306, 2(0):0.167|0.172, 2(0):1.566|1.628, 1(0):0.000|4.055
261
1290, 29(0):1.268|1.320, 25(0):0.309|0.310, 1(0):0.000|0.129, 1(0):0.000|1.570, 6(0):5.521|5.662
262
1300, 20(0):1.383|1.441, 33(0):0.291|0.316, 3(0):0.130|0.181, 6(0):1.637|1.690, 3(0):4.634|6.026
263
1310, 10(0):1.542|1.577, 19(0):0.323|0.338, 3(0):0.118|0.135, 0(0):0.000|0.000, 1(0):0.000|5.130
264
1320, 6(0):1.067|1.248, 19(0):0.342|0.363, 0(0):0.000|0.000, 0(0):0.000|0.000, 5(0):3.868|4.432
265
1330, 42(0):1.552|1.615, 28(0):0.293|0.331, 2(0):0.118|0.145, 1(0):0.000|1.449, 1(0):0.000|2.132
266
1340, 4(0):1.334|1.588, 23(0):0.321|0.323, 3(0):0.131|0.143, 0(0):0.000|0.000, 2(0):5.004|5.429
267
1350, 31(0):1.643|1.687, 19(0):0.299|0.311, 3(0):0.138|0.196, 6(0):1.646|1.648, 0(0):0.000|0.000
268
1360, 23(0):1.476|1.538, 21(0):0.314|0.317, 2(0):0.126|0.149, 6(0):1.589|1.666, 3(0):5.374|5.476
269
1370, 16(0):1.344|1.541, 12(0):0.276|0.295, 1(0):0.000|0.122, 0(0):0.000|0.000, 2(0):2.724|3.382
270
1380, 31(0):1.550|1.570, 18(0):0.267|0.288, 3(0):0.141|0.142, 2(0):1.629|1.739, 3(0):3.750|4.285
271
1390, 43(0):1.628|1.676, 12(0):0.287|0.297, 3(0):0.138|0.155, 4(0):1.688|1.820, 1(0):0.000|4.269
272
1400, 7(0):1.154|1.245, 29(0):0.301|0.316, 2(0):0.153|0.154, 1(0):0.000|1.722, 1(0):0.000|3.985
273
1410, 18(0):1.226|1.572, 7(0):0.233|0.298, 1(0):0.000|0.129, 4(0):1.658|1.784, 4(0):5.590|5.920
274
1420, 21(0):1.368|1.529, 28(0):0.296|0.298, 2(0):0.108|0.115, 5(0):1.688|1.703, 2(0):2.210|2.233
275
1430, 10(0):1.430|1.520, 43(0):0.308|0.338, 2(0):0.141|0.160, 0(0):0.000|0.000, 6(0):3.794|5.780
276
1440, 58(0):1.569|1.590, 32(0):0.299|0.301, 4(0):0.136|0.159, 2(0):1.661|1.662, 1(0):0.000|1.825
277
1450, 12(0):1.379|1.506, 25(0):0.295|0.309, 4(0):0.126|0.127, 1(0):0.000|1.705, 3(0):2.405|4.523
278
payment 37:3
279
1205, HY000, Lock wait timeout exceeded; try restarting transaction
280
1460, 17(0):1.388|1.438, 15(0):0.292|0.299, 1(0):0.000|0.142, 1(0):0.000|1.603, 2(0):3.332|4.471
281
1470, 26(0):1.550|1.552, 32(0):0.324|0.383, 3(0):0.145|0.159, 0(0):0.000|0.000, 1(0):0.000|4.060
282
1480, 33(0):1.379|1.480, 30(0):0.291|0.304, 2(0):0.124|0.149, 5(0):1.645|1.809, 0(0):0.000|0.000
283
1490, 9(0):1.268|1.343, 21(0):0.299|0.301, 2(0):0.103|0.136, 1(0):0.000|1.558, 4(0):3.920|4.899
284
1500, 9(0):1.246|1.555, 18(0):0.299|0.326, 2(0):0.133|0.174, 1(0):0.000|1.647, 2(0):3.707|4.138
285
1510, 33(0):1.440|1.495, 5(0):0.288|0.299, 1(0):0.000|0.149, 4(0):1.547|1.586, 5(0):4.769|4.804
286
1520, 27(0):1.503|1.516, 14(0):0.226|0.270, 3(0):0.137|0.140, 1(0):0.000|1.584, 0(0):0.000|0.000
287
1530, 41(0):1.587|1.592, 37(0):0.290|0.297, 2(0):0.113|0.154, 1(0):0.000|1.558, 1(0):0.000|5.070
288
1540, 7(0):1.390|1.481, 32(0):0.316|0.318, 2(0):0.126|0.164, 1(0):0.000|1.592, 5(0):3.880|4.876
289
1550, 12(0):1.271|1.288, 11(0):0.245|0.272, 3(0):0.142|0.152, 6(0):1.664|1.783, 2(0):4.112|4.498
290
1560, 36(0):1.464|1.476, 23(0):0.319|0.322, 2(0):0.121|0.124, 4(0):1.667|1.688, 2(0):3.261|3.436
291
1570, 38(0):1.546|1.612, 19(0):0.284|0.314, 3(0):0.134|0.154, 2(0):1.561|1.755, 0(0):0.000|0.000
292
1580, 15(0):1.530|1.541, 42(0):0.306|0.337, 2(0):0.124|0.137, 1(0):0.000|1.525, 3(0):4.036|5.095
293
1590, 29(0):1.574|1.613, 29(0):0.318|0.325, 4(0):0.155|0.170, 0(0):0.000|0.000, 5(0):4.724|5.398
294
1600, 16(0):1.262|1.347, 26(0):0.326|0.327, 3(0):0.135|0.152, 4(0):1.622|1.630, 3(0):4.019|5.191
295
1610, 12(0):0.986|1.129, 26(0):0.310|0.341, 2(0):0.105|0.160, 4(0):1.608|1.615, 3(0):4.898|5.000
296
1620, 28(0):1.370|1.470, 18(0):0.299|0.304, 2(0):0.125|0.159, 1(0):0.000|1.607, 1(0):0.000|4.386
297
1630, 17(0):1.327|1.422, 18(0):0.273|0.277, 2(0):0.129|0.152, 3(0):1.578|1.585, 2(0):3.403|3.813
298
1640, 49(0):1.543|1.625, 31(0):0.298|0.302, 2(0):0.110|0.160, 1(0):0.000|1.579, 3(0):3.726|4.206
299
1650, 23(0):1.452|1.574, 34(0):0.309|0.311, 4(0):0.158|0.167, 5(0):1.648|1.678, 2(0):2.492|2.857
300
1660, 11(0):1.195|1.408, 10(0):0.275|0.302, 1(0):0.000|0.106, 4(0):1.567|1.645, 3(0):4.138|5.617
301
1670, 41(0):1.451|1.458, 22(0):0.290|0.300, 2(0):0.119|0.152, 3(0):1.594|1.733, 2(0):4.980|5.214
302
1680, 5(0):1.188|1.314, 3(0):0.239|0.253, 3(0):0.143|0.160, 0(0):0.000|0.000, 3(0):5.220|5.242
303
1690, 43(0):1.465|1.469, 45(0):0.330|0.431, 2(0):0.124|0.145, 4(0):1.686|1.714, 3(0):4.694|5.239
304
1700, 11(0):1.202|1.530, 9(0):0.301|0.307, 3(0):0.117|0.127, 2(0):1.512|1.631, 2(0):3.425|4.134
305
1710, 44(0):1.583|1.600, 30(0):0.296|0.298, 3(0):0.153|0.162, 4(0):1.568|1.622, 2(0):4.665|4.811
306
1720, 20(0):1.582|1.664, 47(0):0.305|0.330, 4(0):0.135|0.142, 1(0):0.000|1.553, 1(0):0.000|2.156
307
1730, 20(0):1.324|1.461, 17(0):0.263|0.275, 0(0):0.000|0.000, 2(0):1.598|1.668, 4(0):4.273|4.558
308
1740, 20(0):1.536|1.570, 39(0):0.304|0.317, 3(0):0.122|0.134, 0(0):0.000|0.000, 4(0):4.686|5.206
309
1750, 18(0):1.161|1.218, 11(0):0.259|0.292, 3(0):0.115|0.164, 4(0):1.635|1.662, 1(0):0.000|3.824
310
1760, 8(0):1.341|1.375, 20(0):0.313|0.320, 2(0):0.143|0.160, 1(0):0.000|1.636, 3(0):3.658|4.987
311
1770, 53(0):1.533|1.582, 19(0):0.313|0.320, 1(0):0.000|0.110, 4(0):1.603|1.668, 2(0):2.039|3.947
312
1780, 22(0):1.582|1.658, 48(0):0.306|0.315, 5(0):0.136|0.165, 1(0):0.000|1.667, 3(0):3.326|3.471
313
1790, 9(0):1.517|1.604, 8(0):0.277|0.298, 2(0):0.134|0.140, 3(0):1.634|1.679, 1(0):0.000|3.406
314
1800, 33(0):1.625|1.673, 3(0):0.215|0.249, 1(0):0.000|0.148, 6(0):1.646|1.680, 3(0):3.380|5.789
315
1810, 19(0):1.336|1.559, 55(0):0.316|0.334, 3(0):0.156|0.157, 1(0):0.000|1.648, 1(0):0.000|5.019
316
1820, 12(0):1.401|1.427, 6(0):0.255|0.322, 2(0):0.114|0.149, 0(0):0.000|0.000, 2(0):4.044|5.146
317
1830, 61(0):1.571|1.625, 45(0):0.309|0.338, 3(0):0.129|0.160, 3(0):1.566|1.654, 3(0):3.714|5.327
318
1840, 9(0):1.519|1.583, 22(0):0.304|0.343, 2(0):0.121|0.124, 2(0):1.580|1.655, 2(0):3.767|4.426
319
1850, 9(0):1.318|1.334, 20(0):0.311|0.313, 3(0):0.121|0.142, 2(0):1.544|1.575, 4(0):4.400|5.615
320
1860, 46(0):1.536|1.581, 12(0):0.308|0.327, 1(0):0.000|0.154, 2(0):1.503|1.533, 2(0):3.705|5.424
321
1870, 11(0):1.117|1.147, 33(0):0.302|0.308, 3(0):0.147|0.161, 0(0):0.000|0.000, 3(0):5.475|5.483
322
1880, 12(0):1.479|1.526, 17(0):0.289|0.321, 2(0):0.112|0.145, 3(0):1.502|1.512, 2(0):3.797|4.380
323
neword 9:2
324
1205, HY000, Lock wait timeout exceeded; try restarting transaction
325
1890, 62(0):1.502|1.592, 28(0):0.275|0.277, 3(0):0.169|0.172, 4(0):1.492|1.537, 2(0):3.617|5.044
326
1900, 6(0):1.292|1.332, 34(0):0.313|0.322, 1(0):0.000|0.125, 2(0):1.442|1.559, 2(0):4.396|4.794
327
1910, 20(0):1.608|1.662, 22(0):0.301|0.305, 4(0):0.153|0.166, 4(0):1.536|1.562, 2(0):2.253|4.995
328
1920, 9(0):1.462|1.635, 27(0):0.284|0.294, 1(0):0.000|0.141, 1(0):0.000|1.554, 4(0):5.079|5.440
329
1930, 38(0):1.486|1.596, 18(0):0.312|0.317, 4(0):0.122|0.139, 2(0):1.434|1.687, 4(0):4.448|5.090
330
1940, 27(0):1.520|1.542, 35(0):0.313|0.315, 3(0):0.162|0.168, 3(0):1.486|1.506, 1(0):0.000|2.201
331
1950, 16(0):1.451|1.483, 14(0):0.269|0.283, 3(0):0.126|0.130, 8(0):1.598|1.644, 2(0):4.127|4.494
332
1960, 63(0):1.600|1.619, 8(0):0.292|0.305, 1(0):0.000|0.117, 2(0):1.571|1.634, 3(0):2.507|3.313
333
1970, 4(0):0.916|1.438, 18(0):0.266|0.279, 2(0):0.119|0.163, 0(0):0.000|0.000, 3(0):4.185|4.516
334
1980, 23(0):1.508|1.643, 36(0):0.301|0.328, 4(0):0.118|0.157, 4(0):1.620|1.665, 1(0):0.000|5.954
335
1990, 23(0):1.373|1.456, 46(0):0.317|0.336, 3(0):0.100|0.133, 1(0):0.000|1.634, 4(0):3.781|3.944
336
2000, 20(0):1.562|1.609, 24(0):0.307|0.324, 3(0):0.117|0.161, 2(0):1.620|1.629, 5(0):3.649|5.278
337
2010, 63(0):1.601|1.602, 18(0):0.308|0.320, 1(0):0.000|0.138, 2(0):1.609|1.623, 0(0):0.000|0.000
338
2020, 1(0):0.000|1.477, 28(0):0.299|0.301, 0(0):0.000|0.000, 1(0):0.000|1.545, 3(0):3.271|3.870
339
2030, 24(0):1.559|1.611, 35(0):0.302|0.319, 6(0):0.135|0.148, 4(0):1.567|1.579, 3(0):3.772|4.977
340
2040, 17(0):1.262|1.448, 22(0):0.305|0.333, 3(0):0.120|0.162, 1(0):0.000|1.599, 2(0):2.508|3.407
341
2050, 40(0):1.531|1.565, 29(0):0.311|0.312, 2(0):0.113|0.143, 1(0):0.000|1.670, 3(0):4.559|5.020
342
2060, 45(0):1.544|1.558, 29(0):0.307|0.314, 5(0):0.148|0.150, 4(0):1.514|1.592, 2(0):3.131|4.374
343
2070, 13(0):1.276|1.340, 33(0):0.319|0.361, 3(0):0.118|0.143, 3(0):1.564|1.603, 4(0):3.493|5.510
344
2080, 15(0):1.412|1.486, 7(0):0.215|0.219, 1(0):0.000|0.157, 6(0):1.493|1.562, 3(0):4.423|5.638
345
2090, 29(0):1.439|1.469, 26(0):0.312|0.322, 1(0):0.000|0.153, 5(0):1.624|1.700, 3(0):3.734|4.737
346
2100, 26(0):1.513|1.699, 31(0):0.310|0.347, 4(0):0.144|0.153, 5(0):1.588|1.639, 3(0):2.364|3.570
347
2110, 58(0):1.447|1.451, 23(0):0.317|0.327, 4(0):0.148|0.150, 3(0):1.651|1.811, 1(0):0.000|3.724
348
2120, 11(0):1.393|1.542, 9(0):0.304|0.408, 2(0):0.110|0.117, 3(0):1.695|1.725, 1(0):0.000|4.467
349
2130, 27(0):1.423|1.461, 51(0):0.307|0.325, 0(0):0.000|0.000, 0(0):0.000|0.000, 3(0):4.900|5.460
350
2140, 6(0):1.195|1.393, 36(0):0.310|0.323, 5(0):0.117|0.173, 0(0):0.000|0.000, 5(0):5.052|5.205
351
2150, 11(0):1.231|1.359, 20(0):0.295|0.315, 1(0):0.000|0.137, 2(0):1.569|1.607, 2(0):3.075|5.176
352
2160, 45(0):1.376|1.380, 21(0):0.317|0.320, 4(0):0.120|0.143, 4(0):1.649|1.680, 4(0):3.618|3.897
353
2170, 47(0):1.549|1.593, 19(0):0.317|0.321, 2(0):0.156|0.161, 2(0):1.582|1.830, 0(0):0.000|0.000
354
2180, 7(0):1.279|1.316, 39(0):0.305|0.308, 2(0):0.123|0.136, 2(0):1.603|1.635, 3(0):3.348|3.722
355
2190, 28(0):1.354|1.411, 21(0):0.315|0.322, 4(0):0.132|0.144, 2(0):1.563|1.574, 2(0):3.355|3.917
356
2200, 37(0):1.387|1.397, 35(0):0.299|0.310, 3(0):0.111|0.170, 5(0):1.625|1.643, 3(0):2.987|4.242
357
2210, 27(0):1.355|1.622, 28(0):0.274|0.314, 4(0):0.144|0.168, 2(0):1.586|1.588, 3(0):3.488|3.940
358
2220, 18(0):1.340|1.457, 39(0):0.285|0.292, 3(0):0.124|0.144, 0(0):0.000|0.000, 4(0):3.874|5.803
359
2230, 43(0):1.485|1.650, 34(0):0.290|0.315, 3(0):0.117|0.148, 4(0):1.559|1.591, 3(0):2.005|2.361
360
2240, 10(0):1.396|1.439, 20(0):0.295|0.315, 1(0):0.000|0.118, 2(0):1.519|1.563, 4(0):5.166|5.664
361
2250, 50(0):1.474|1.533, 28(0):0.298|0.312, 2(0):0.123|0.149, 4(0):1.555|1.580, 1(0):0.000|3.828
362
2260, 9(0):1.270|1.289, 25(0):0.299|0.306, 4(0):0.152|0.165, 1(0):0.000|1.524, 2(0):3.102|3.874
363
2270, 4(0):1.177|1.559, 15(0):0.304|0.312, 2(0):0.113|0.167, 8(0):1.608|1.752, 3(0):3.515|3.986
364
2280, 46(0):1.514|1.536, 31(0):0.295|0.306, 3(0):0.135|0.146, 5(0):1.628|1.645, 2(0):2.108|3.730
365
2290, 22(0):1.345|1.452, 19(0):0.303|0.315, 2(0):0.111|0.118, 5(0):1.579|1.587, 2(0):3.450|3.586
366
2300, 42(0):1.542|1.553, 0(0):0.000|0.000, 2(0):0.115|0.155, 1(0):0.000|1.566, 3(0):4.394|5.261
367
2310, 36(0):1.519|1.594, 64(0):0.326|0.344, 2(0):0.131|0.147, 0(0):0.000|0.000, 3(0):4.557|4.649
368
2320, 7(0):1.439|1.448, 32(0):0.302|0.307, 4(0):0.155|0.169, 0(0):0.000|0.000, 3(0):2.762|2.944
369
2330, 24(0):1.430|1.475, 17(0):0.287|0.311, 4(0):0.139|0.167, 6(0):1.638|1.657, 3(0):3.151|3.305
370
2340, 64(0):1.516|1.636, 26(0):0.305|0.316, 0(0):0.000|0.000, 1(0):0.000|1.556, 0(0):0.000|0.000
371
2350, 9(0):1.458|1.485, 27(0):0.317|0.317, 0(0):0.000|0.000, 0(0):0.000|0.000, 5(0):4.686|5.293
372
2360, 40(0):1.525|1.625, 11(0):0.258|0.276, 6(0):0.150|0.162, 4(0):1.587|1.632, 4(0):4.241|4.751
373
2370, 10(0):1.473|1.574, 6(0):0.306|0.316, 4(0):0.135|0.165, 1(0):0.000|1.616, 4(0):4.574|4.686
374
2380, 10(0):1.039|1.089, 48(0):0.292|0.312, 3(0):0.121|0.151, 6(0):1.656|1.700, 2(0):1.824|3.927
375
2390, 30(0):1.364|1.493, 41(0):0.339|0.371, 2(0):0.091|0.108, 5(0):1.638|1.676, 2(0):2.278|4.603
376
2400, 19(0):1.393|1.535, 20(0):0.266|0.280, 3(0):0.131|0.150, 1(0):0.000|1.471, 1(0):0.000|3.694
377
2410, 22(0):1.574|1.585, 41(0):0.308|0.310, 1(0):0.000|0.141, 2(0):1.622|1.662, 3(0):3.464|3.621
378
2420, 41(0):1.501|1.530, 30(0):0.324|0.396, 5(0):0.110|0.142, 1(0):0.000|1.459, 2(0):2.495|3.148
379
2430, 35(0):1.477|1.607, 37(0):0.295|0.302, 3(0):0.121|0.148, 1(0):0.000|1.463, 5(0):4.391|4.873
380
2440, 24(0):1.350|1.471, 17(0):0.308|0.312, 2(0):0.150|0.169, 3(0):1.511|1.583, 4(0):3.253|3.362
381
2450, 25(0):1.220|1.353, 0(0):0.000|0.000, 1(0):0.000|0.123, 1(0):0.000|1.636, 1(0):0.000|2.463
382
2460, 41(0):1.374|1.554, 57(0):0.306|0.332, 5(0):0.135|0.136, 3(0):1.537|1.546, 2(0):2.049|2.141
383
2470, 43(0):1.523|1.578, 26(0):0.293|0.297, 2(0):0.150|0.163, 0(0):0.000|0.000, 2(0):2.209|2.302
384
2480, 9(0):1.214|1.278, 33(0):0.313|0.356, 2(0):0.111|0.158, 0(0):0.000|0.000, 5(0):3.738|5.340
385
2490, 60(0):1.540|1.657, 26(0):0.296|0.315, 4(0):0.150|0.162, 6(0):1.567|1.618, 3(0):3.984|4.670
386
2500, 15(0):1.509|1.529, 16(0):0.285|0.303, 2(0):0.129|0.177, 5(0):1.673|1.711, 0(0):0.000|0.000
387
2510, 23(0):1.520|1.552, 0(0):0.000|0.000, 2(0):0.137|0.156, 3(0):1.635|1.640, 3(0):4.609|4.893
388
2520, 24(0):1.441|1.467, 49(0):0.322|0.413, 3(0):0.150|0.157, 4(0):1.581|1.649, 4(0):4.923|5.427
389
2530, 6(0):0.980|1.208, 41(0):0.307|0.312, 4(0):0.122|0.168, 1(0):0.000|1.453, 2(0):2.175|5.389
390
2540, 6(0):0.890|1.192, 22(0):0.289|0.295, 1(0):0.000|0.136, 3(0):1.495|1.505, 3(0):3.430|3.484
391
2550, 52(0):1.361|1.411, 24(0):0.279|0.352, 4(0):0.136|0.146, 9(0):1.645|1.668, 3(0):2.232|4.955
392
2560, 12(0):1.315|1.336, 23(0):0.293|0.321, 1(0):0.000|0.143, 0(0):0.000|0.000, 3(0):3.762|4.886
393
2570, 44(0):1.632|1.666, 28(0):0.309|0.325, 4(0):0.131|0.154, 0(0):0.000|0.000, 1(0):0.000|3.279
394
2580, 12(0):1.404|1.551, 20(0):0.290|0.326, 3(0):0.130|0.147, 1(0):0.000|1.554, 4(0):3.637|4.587
395
2590, 41(0):1.507|1.600, 43(0):0.278|0.288, 0(0):0.000|0.000, 4(0):1.562|1.597, 3(0):5.010|5.340
396
2600, 45(0):1.527|1.682, 34(0):0.321|0.323, 7(0):0.141|0.148, 4(0):1.633|1.689, 4(0):3.128|3.432
397
2610, 9(0):1.128|1.310, 19(0):0.284|0.316, 3(0):0.140|0.158, 0(0):0.000|0.000, 4(0):4.326|4.719
398
2620, 46(0):1.409|1.457, 27(0):0.272|0.288, 2(0):0.082|0.135, 5(0):1.539|1.563, 2(0):2.525|2.812
399
2630, 34(0):1.455|1.492, 28(0):0.268|0.293, 3(0):0.107|0.158, 3(0):1.627|1.696, 2(0):2.989|4.621
400
2640, 17(0):1.473|1.656, 33(0):0.334|0.340, 2(0):0.093|0.117, 0(0):0.000|0.000, 2(0):3.687|3.829
401
2650, 49(0):1.590|1.644, 27(0):0.297|0.308, 4(0):0.152|0.157, 3(0):1.502|1.660, 1(0):0.000|6.007
402
2660, 8(0):1.488|1.632, 45(0):0.298|0.310, 3(0):0.126|0.149, 1(0):0.000|1.596, 4(0):4.308|4.780
403
2670, 11(0):1.406|1.547, 19(0):0.328|0.340, 0(0):0.000|0.000, 1(0):0.000|1.570, 5(0):4.079|4.197
404
2680, 42(0):1.257|1.352, 25(0):0.293|0.296, 3(0):0.113|0.154, 5(0):1.554|1.617, 2(0):2.777|3.249
405
2690, 19(0):1.502|1.530, 26(0):0.311|0.336, 5(0):0.137|0.147, 3(0):1.565|1.631, 3(0):4.378|4.986
406
2700, 47(0):1.537|1.601, 38(0):0.303|0.309, 4(0):0.150|0.163, 4(0):1.529|1.541, 3(0):3.760|4.691
407
2710, 10(0):1.259|1.485, 20(0):0.298|0.307, 2(0):0.136|0.161, 0(0):0.000|0.000, 5(0):4.034|4.140
408
2720, 41(0):1.489|1.509, 23(0):0.297|0.301, 2(0):0.087|0.156, 1(0):0.000|1.585, 0(0):0.000|0.000
409
2730, 31(0):1.443|1.594, 33(0):0.299|0.302, 2(0):0.105|0.122, 3(0):1.614|1.671, 2(0):4.761|5.073
410
2740, 8(0):1.501|1.712, 30(0):0.295|0.318, 3(0):0.119|0.135, 5(0):1.522|1.568, 5(0):4.204|5.063
411
2750, 33(0):1.396|1.408, 18(0):0.312|0.316, 2(0):0.098|0.104, 1(0):0.000|1.402, 2(0):1.739|5.190
412
2760, 18(0):1.570|1.609, 28(0):0.282|0.291, 3(0):0.145|0.190, 4(0):1.619|1.645, 0(0):0.000|0.000
413
2770, 34(0):1.599|1.639, 14(0):0.281|0.312, 2(0):0.089|0.155, 6(0):1.615|1.624, 2(0):3.841|4.856
414
2780, 13(0):1.576|1.658, 25(0):0.301|0.305, 2(0):0.140|0.159, 1(0):0.000|1.560, 4(0):4.431|4.884
415
2790, 41(0):1.565|1.587, 34(0):0.336|0.399, 4(0):0.134|0.152, 8(0):1.564|1.580, 2(0):3.417|5.534
416
2800, 13(0):1.107|1.323, 32(0):0.311|0.317, 3(0):0.128|0.134, 1(0):0.000|1.561, 3(0):4.803|5.950
417
2810, 23(0):1.537|1.588, 16(0):0.309|0.324, 3(0):0.148|0.162, 0(0):0.000|0.000, 3(0):3.315|4.758
418
2820, 31(0):1.391|1.550, 17(0):0.274|0.286, 2(0):0.130|0.140, 8(0):1.625|1.694, 3(0):4.817|5.236
419
2830, 41(0):1.466|1.637, 28(0):0.325|0.345, 2(0):0.103|0.155, 9(0):1.671|1.702, 3(0):4.322|4.365
420
2840, 29(0):1.399|1.440, 48(0):0.326|0.339, 4(0):0.157|0.159, 0(0):0.000|0.000, 3(0):3.241|3.551
421
2850, 25(0):1.344|1.452, 30(0):0.292|0.304, 3(0):0.128|0.140, 0(0):0.000|0.000, 3(0):3.540|3.586
422
2860, 31(0):1.529|1.598, 28(0):0.302|0.311, 3(0):0.142|0.146, 2(0):1.574|1.593, 2(0):2.597|3.812
423
2870, 45(0):1.446|1.454, 24(0):0.288|0.325, 2(0):0.136|0.189, 0(0):0.000|0.000, 4(0):3.746|4.560
424
2880, 12(0):1.458|1.519, 28(0):0.325|0.417, 4(0):0.136|0.151, 2(0):1.536|1.553, 2(0):2.441|2.995
425
2890, 32(0):1.488|1.646, 33(0):0.301|0.308, 0(0):0.000|0.000, 0(0):0.000|0.000, 2(0):5.043|5.148
426
2900, 51(0):1.486|1.493, 46(0):0.322|0.347, 7(0):0.144|0.148, 2(0):1.537|1.578, 7(0):3.354|3.750
427
2910, 39(0):1.522|1.573, 2(0):0.221|0.226, 1(0):0.000|0.125, 1(0):0.000|1.556, 1(0):0.000|2.919
428
2920, 17(0):1.443|1.538, 38(0):0.304|0.366, 3(0):0.134|0.160, 4(0):1.546|1.553, 4(0):4.341|4.353
429
2930, 30(0):1.259|1.396, 39(0):0.315|0.361, 3(0):0.147|0.176, 9(0):1.597|1.655, 3(0):2.348|3.476
430
2940, 28(0):1.379|1.505, 28(0):0.323|0.328, 2(0):0.134|0.162, 1(0):0.000|1.595, 1(0):0.000|3.689
431
2950, 28(0):1.470|1.651, 45(0):0.310|0.311, 4(0):0.147|0.148, 2(0):1.462|1.508, 4(0):4.724|4.996
432
2960, 37(0):1.464|1.520, 16(0):0.311|0.316, 3(0):0.136|0.160, 1(0):0.000|1.576, 4(0):4.056|4.553
433
2970, 17(0):1.404|1.472, 43(0):0.322|0.332, 5(0):0.165|0.168, 2(0):1.471|1.545, 2(0):3.539|4.538
434
2980, 10(0):0.913|1.147, 19(0):0.287|0.432, 2(0):0.097|0.125, 4(0):1.633|1.658, 5(0):4.890|4.931
435
2990, 26(0):1.490|1.597, 18(0):0.282|0.291, 2(0):0.134|0.155, 3(0):1.573|1.582, 2(0):2.304|2.920
436
3000, 53(0):1.388|1.521, 32(0):0.313|0.334, 3(0):0.118|0.128, 1(0):0.000|1.611, 1(0):0.000|5.011
437
3010, 47(0):1.503|1.560, 35(0):0.306|0.307, 4(0):0.117|0.151, 3(0):1.533|1.572, 3(0):5.144|5.165
438
3020, 17(0):1.436|1.628, 13(0):0.271|0.272, 1(0):0.000|0.117, 2(0):1.527|1.568, 2(0):3.385|5.122
439
3030, 24(0):1.255|1.520, 44(0):0.315|0.399, 3(0):0.156|0.167, 5(0):1.604|1.618, 4(0):3.752|4.007
440
3040, 7(0):0.849|1.583, 15(0):0.298|0.304, 3(0):0.153|0.154, 3(0):1.552|1.615, 3(0):4.092|4.500
441
3050, 49(0):1.585|1.608, 17(0):0.297|0.314, 3(0):0.155|0.156, 5(0):1.620|1.868, 4(0):4.044|4.145
442
3060, 10(0):1.468|1.737, 44(0):0.308|0.314, 4(0):0.154|0.165, 6(0):1.646|1.701, 2(0):3.676|5.080
443
3070, 32(0):1.450|1.452, 22(0):0.274|0.313, 1(0):0.000|0.136, 1(0):0.000|1.734, 3(0):3.020|5.212
444
3080, 47(0):1.547|1.550, 0(0):0.000|0.000, 3(0):0.158|0.163, 0(0):0.000|0.000, 2(0):3.465|3.818
445
3090, 5(0):0.618|0.981, 28(0):0.299|0.308, 2(0):0.107|0.129, 1(0):0.000|1.539, 4(0):3.623|3.996
446
3100, 38(0):1.464|1.470, 50(0):0.292|0.300, 4(0):0.138|0.153, 4(0):1.494|1.529, 1(0):0.000|3.709
447
3110, 25(0):1.544|1.628, 44(0):0.325|0.340, 4(0):0.151|0.155, 7(0):1.661|1.708, 3(0):3.685|4.578
448
3120, 29(0):1.268|1.518, 37(0):0.315|0.316, 3(0):0.117|0.131, 1(0):0.000|1.608, 4(0):4.622|4.662
449
3130, 19(0):1.325|1.356, 14(0):0.290|0.337, 2(0):0.135|0.156, 1(0):0.000|1.537, 3(0):4.496|4.970
450
3140, 43(0):1.442|1.453, 34(0):0.287|0.289, 4(0):0.141|0.165, 7(0):1.606|1.628, 4(0):4.401|4.848
451
3150, 23(0):1.572|1.599, 29(0):0.301|0.316, 3(0):0.168|0.181, 4(0):1.547|1.558, 1(0):0.000|3.308
452
3160, 40(0):1.609|1.630, 31(0):0.315|0.339, 2(0):0.137|0.158, 0(0):0.000|0.000, 3(0):3.634|4.792
453
3170, 23(0):1.377|1.389, 27(0):0.312|0.319, 4(0):0.143|0.146, 8(0):1.607|1.740, 1(0):0.000|3.588
454
3180, 36(0):1.495|1.534, 30(0):0.302|0.319, 2(0):0.098|0.164, 2(0):1.593|1.751, 2(0):3.400|3.721
455
3190, 24(0):1.459|1.537, 40(0):0.304|0.312, 3(0):0.138|0.148, 0(0):0.000|0.000, 3(0):3.197|3.537
456
3200, 47(0):1.554|1.591, 19(0):0.280|0.311, 3(0):0.152|0.153, 2(0):1.569|1.619, 2(0):4.693|4.935
457
3210, 26(0):1.469|1.577, 6(0):0.293|0.312, 3(0):0.129|0.164, 3(0):1.664|1.689, 3(0):3.310|3.896
458
3220, 14(0):1.402|1.539, 33(0):0.305|0.316, 2(0):0.102|0.131, 0(0):0.000|0.000, 6(0):4.070|4.495
459
3230, 17(0):1.535|1.599, 46(0):0.304|0.315, 3(0):0.123|0.138, 5(0):1.660|1.708, 4(0):3.431|3.501
460
3240, 40(0):1.457|1.466, 17(0):0.316|0.339, 1(0):0.000|0.136, 2(0):1.630|1.668, 1(0):0.000|2.833
461
3250, 11(0):1.383|1.446, 31(0):0.296|0.325, 3(0):0.145|0.160, 2(0):1.706|1.743, 3(0):4.921|5.123
462
3260, 43(0):1.389|1.455, 29(0):0.308|0.323, 3(0):0.138|0.152, 4(0):1.637|1.678, 3(0):3.343|3.593
463
3270, 15(0):1.447|1.450, 24(0):0.307|0.310, 5(0):0.155|0.172, 3(0):1.625|1.662, 0(0):0.000|0.000
464
3280, 43(0):1.488|1.540, 20(0):0.302|0.316, 2(0):0.123|0.142, 3(0):1.590|1.602, 6(0):3.308|5.052
465
3290, 34(0):1.382|1.455, 37(0):0.289|0.341, 3(0):0.146|0.148, 7(0):1.622|1.630, 4(0):3.708|4.723
466
3300, 5(0):1.193|1.256, 43(0):0.299|0.309, 4(0):0.138|0.152, 2(0):1.616|1.617, 5(0):3.218|5.026
467
3310, 65(0):1.478|1.622, 31(0):0.299|0.316, 2(0):0.123|0.143, 1(0):0.000|1.557, 1(0):0.000|4.146
468
3320, 18(0):1.453|1.469, 30(0):0.290|0.291, 3(0):0.130|0.149, 6(0):1.548|1.595, 4(0):4.243|4.282
469
3330, 23(0):1.450|1.578, 28(0):0.330|0.332, 2(0):0.124|0.126, 2(0):1.554|1.560, 1(0):0.000|2.078
470
3340, 42(0):1.547|1.568, 24(0):0.296|0.322, 4(0):0.146|0.150, 2(0):1.610|1.665, 5(0):4.460|5.338
471
3350, 25(0):1.459|1.671, 37(0):0.318|0.329, 3(0):0.149|0.251, 3(0):1.712|1.809, 3(0):3.757|4.474
472
3360, 19(0):1.381|1.580, 26(0):0.311|0.317, 3(0):0.143|0.159, 4(0):1.602|1.627, 3(0):4.010|4.259
473
3370, 43(0):1.605|1.612, 35(0):0.300|0.327, 3(0):0.155|0.165, 9(0):1.723|1.804, 0(0):0.000|0.000
474
3380, 14(0):1.314|1.564, 34(0):0.318|0.327, 4(0):0.154|0.159, 0(0):0.000|0.000, 3(0):3.072|4.648
475
3390, 6(0):0.970|1.513, 12(0):0.293|0.301, 1(0):0.000|0.140, 1(0):0.000|1.563, 3(0):4.867|5.551
476
3400, 77(0):1.569|1.601, 20(0):0.286|0.304, 4(0):0.147|0.175, 2(0):1.653|1.733, 2(0):4.451|4.948
477
3410, 11(0):1.295|1.347, 19(0):0.293|0.312, 2(0):0.132|0.162, 2(0):1.538|1.577, 5(0):4.110|4.536
478
3420, 47(0):1.520|1.536, 54(0):0.295|0.317, 3(0):0.121|0.158, 1(0):0.000|1.621, 1(0):0.000|2.675
479
3430, 10(0):1.498|1.557, 16(0):0.305|0.325, 3(0):0.143|0.153, 1(0):0.000|1.613, 5(0):4.564|4.745
480
3440, 21(0):1.331|1.406, 41(0):0.317|0.318, 3(0):0.155|0.173, 3(0):1.633|1.718, 4(0):3.226|3.596
481
3450, 25(0):1.308|1.379, 19(0):0.292|0.296, 3(0):0.116|0.149, 3(0):1.545|1.640, 3(0):4.572|4.784
482
3460, 43(0):1.581|1.599, 36(0):0.309|0.321, 2(0):0.130|0.161, 2(0):1.573|1.598, 2(0):4.519|4.619
483
3470, 20(0):1.420|1.445, 29(0):0.304|0.311, 4(0):0.140|0.162, 3(0):1.627|1.629, 3(0):3.312|3.988
484
3480, 42(0):1.560|1.574, 32(0):0.330|0.346, 4(0):0.147|0.165, 3(0):1.570|1.617, 2(0):2.714|5.020
485
3490, 41(0):1.542|1.556, 29(0):0.311|0.333, 1(0):0.000|0.113, 2(0):1.495|1.675, 4(0):4.637|4.934
486
3500, 25(0):1.580|1.719, 31(0):0.305|0.351, 5(0):0.166|0.189, 0(0):0.000|0.000, 1(0):0.000|2.893
487
3510, 27(0):1.370|1.573, 38(0):0.301|0.302, 2(0):0.138|0.150, 3(0):1.549|1.637, 3(0):3.627|3.787
488
3520, 5(0):1.356|1.387, 17(0):0.297|0.304, 1(0):0.000|0.124, 2(0):1.546|1.625, 3(0):4.802|4.881
489
3530, 60(0):1.590|1.616, 27(0):0.283|0.332, 5(0):0.149|0.156, 6(0):1.627|1.674, 2(0):1.921|3.842
490
3540, 6(0):1.248|1.477, 42(0):0.381|0.382, 0(0):0.000|0.000, 2(0):1.499|1.594, 3(0):3.671|3.801
491
3550, 34(0):1.519|1.534, 10(0):0.253|0.262, 4(0):0.144|0.154, 1(0):0.000|1.455, 4(0):3.250|3.927
492
3560, 18(0):1.378|1.469, 31(0):0.307|0.309, 4(0):0.136|0.147, 1(0):0.000|1.524, 4(0):4.335|4.579
493
3570, 17(0):1.517|1.520, 31(0):0.312|0.319, 2(0):0.154|0.161, 3(0):1.499|1.522, 3(0):3.342|3.510
494
3580, 60(0):1.477|1.480, 28(0):0.289|0.298, 4(0):0.136|0.155, 10(0):1.593|1.679, 4(0):4.410|4.641
495
3590, 28(0):1.660|1.689, 44(0):0.307|0.311, 3(0):0.158|0.161, 7(0):1.684|1.720, 4(0):2.535|2.858
496
3600, 34(0):1.181|1.563, 38(0):0.289|0.331, 5(0):0.147|0.148, 3(0):1.637|1.641, 1(0):0.000|4.744
497
498
499
STOPPING THREADS....................................................................................................
500
501
502
503
[0] sc:8607 lt:0 rt:1 fl:0
504
[1] sc:8617 lt:0 rt:48 fl:0
505
[2] sc:861 lt:0 rt:0 fl:0
506
[3] sc:853 lt:0 rt:0 fl:0
507
[4] sc:861 lt:0 rt:0 fl:0
508
in 3600 sec.
509
510
511
512
[0] sc:8607 lt:0 rt:1 fl:0
513
[1] sc:8637 lt:0 rt:49 fl:0
514
[2] sc:861 lt:0 rt:0 fl:0
515
[3] sc:853 lt:0 rt:0 fl:0
516
[4] sc:861 lt:0 rt:0 fl:0
517
518
519
520
[transaction percentage]
521
Payment: 43.52% (>=43.0%) [OK]
522
Order-Status: 4.35% (>= 4.0%) [OK]
523
Delivery: 4.31% (>= 4.0%) [OK]
524
Stock-Level: 4.35% (>= 4.0%) [OK]
525
[response time (at least 90% passed)]
526
New-Order: 100.00% [OK]
527
핫 AI 도구
Undresser.AI Undress
사실적인 누드 사진을 만들기 위한 AI 기반 앱
AI Clothes Remover
사진에서 옷을 제거하는 온라인 AI 도구입니다.
Undress AI Tool
무료로 이미지를 벗다
Clothoff.io
AI 옷 제거제
Video Face Swap
완전히 무료인 AI 얼굴 교환 도구를 사용하여 모든 비디오의 얼굴을 쉽게 바꾸세요!
인기 기사
뜨거운 도구
메모장++7.3.1
사용하기 쉬운 무료 코드 편집기
SublimeText3 중국어 버전
중국어 버전, 사용하기 매우 쉽습니다.
스튜디오 13.0.1 보내기
강력한 PHP 통합 개발 환경
드림위버 CS6
시각적 웹 개발 도구
SublimeText3 Mac 버전
신 수준의 코드 편집 소프트웨어(SublimeText3)
MySQL의 역할 : 웹 응용 프로그램의 데이터베이스
Apr 17, 2025 am 12:23 AM
웹 응용 프로그램에서 MySQL의 주요 역할은 데이터를 저장하고 관리하는 것입니다. 1. MySQL은 사용자 정보, 제품 카탈로그, 트랜잭션 레코드 및 기타 데이터를 효율적으로 처리합니다. 2. SQL 쿼리를 통해 개발자는 데이터베이스에서 정보를 추출하여 동적 컨텐츠를 생성 할 수 있습니다. 3.mysql은 클라이언트-서버 모델을 기반으로 작동하여 허용 가능한 쿼리 속도를 보장합니다.
LARAVEL 소개 예
Apr 18, 2025 pm 12:45 PM
Laravel은 웹 응용 프로그램을 쉽게 구축하기위한 PHP 프레임 워크입니다. 설치 : Composer를 사용하여 전 세계적으로 Laravel CLI를 설치하고 프로젝트 디렉토리에서 응용 프로그램을 작성하는 등 다양한 기능을 제공합니다. 라우팅 : Routes/Web.php에서 URL과 핸들러 간의 관계를 정의하십시오. 보기 : 리소스/뷰에서보기를 작성하여 응용 프로그램의 인터페이스를 렌더링합니다. 데이터베이스 통합 : MySQL과 같은 데이터베이스와 상자 외 통합을 제공하고 마이그레이션을 사용하여 테이블을 작성하고 수정합니다. 모델 및 컨트롤러 : 모델은 데이터베이스 엔티티를 나타내고 컨트롤러는 HTTP 요청을 처리합니다.
MySQL 및 Phpmyadmin : 핵심 기능 및 기능
Apr 22, 2025 am 12:12 AM
MySQL 및 Phpmyadmin은 강력한 데이터베이스 관리 도구입니다. 1) MySQL은 데이터베이스 및 테이블을 작성하고 DML 및 SQL 쿼리를 실행하는 데 사용됩니다. 2) PHPMYADMIN은 데이터베이스 관리, 테이블 구조 관리, 데이터 운영 및 사용자 권한 관리에 직관적 인 인터페이스를 제공합니다.
MySQL 대 기타 프로그래밍 언어 : 비교
Apr 19, 2025 am 12:22 AM
다른 프로그래밍 언어와 비교할 때 MySQL은 주로 데이터를 저장하고 관리하는 데 사용되는 반면 Python, Java 및 C와 같은 다른 언어는 논리적 처리 및 응용 프로그램 개발에 사용됩니다. MySQL은 데이터 관리 요구에 적합한 고성능, 확장 성 및 크로스 플랫폼 지원으로 유명하며 다른 언어는 데이터 분석, 엔터프라이즈 애플리케이션 및 시스템 프로그래밍과 같은 해당 분야에서 이점이 있습니다.
데이터베이스 연결 문제 해결 : Minii/DB 라이브러리 사용 실질적인 사례
Apr 18, 2025 am 07:09 AM
작은 응용 프로그램을 개발할 때 까다로운 문제가 발생했습니다. 가벼운 데이터베이스 운영 라이브러리를 신속하게 통합해야합니다. 여러 라이브러리를 시도한 후에는 기능이 너무 많거나 호환되지 않는다는 것을 알았습니다. 결국, 나는 내 문제를 완벽하게 해결하는 YII2를 기반으로 단순화 된 버전 인 Minii/DB를 발견했습니다.
Laravel 프레임 워크 설치 방법
Apr 18, 2025 pm 12:54 PM
기사 요약 :이 기사는 Laravel 프레임 워크를 쉽게 설치하는 방법에 대한 독자들을 안내하기위한 자세한 단계별 지침을 제공합니다. Laravel은 웹 애플리케이션의 개발 프로세스를 가속화하는 강력한 PHP 프레임 워크입니다. 이 자습서는 시스템 요구 사항에서 데이터베이스 구성 및 라우팅 설정에 이르기까지 설치 프로세스를 다룹니다. 이러한 단계를 수행함으로써 독자들은 라벨 프로젝트를위한 탄탄한 토대를 빠르고 효율적으로 놓을 수 있습니다.
초보자를위한 MySQL : 데이터베이스 관리를 시작합니다
Apr 18, 2025 am 12:10 AM
MySQL의 기본 작업에는 데이터베이스, 테이블 작성 및 SQL을 사용하여 데이터에서 CRUD 작업을 수행하는 것이 포함됩니다. 1. 데이터베이스 생성 : createAbasemy_first_db; 2. 테이블 만들기 : CreateTableBooks (idintauto_incrementprimarykey, titlevarchar (100) notnull, authorvarchar (100) notnull, published_yearint); 3. 데이터 삽입 : InsertIntobooks (Title, Author, Published_year) VA
MySQL 모드 해결 문제 : theliamysqlmodeschecker 모듈 사용 경험
Apr 18, 2025 am 08:42 AM
Thelia를 사용하여 전자 상거래 웹 사이트를 개발할 때 까다로운 문제가 발생했습니다. MySQL 모드가 제대로 설정되지 않아 일부 기능이 제대로 작동하지 않습니다. 약간의 탐색 후, 나는 theliamysqlmodeschecker라는 모듈을 발견했습니다.이 모듈은 Thelia가 요구하는 MySQL 패턴을 자동으로 수정하여 내 문제를 완전히 해결할 수 있습니다.
