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
|
########################################################################
bulk_insert.lua + MySQL tests
########################################################################
$ . $SBTEST_INCDIR/mysql_common.sh
$ . $SBTEST_INCDIR/script_bulk_insert_common.sh
Creating table 'sbtest1'...
Creating table 'sbtest2'...
*************************** 1. row ***************************
sbtest1
CREATE TABLE `sbtest1` (
`id` int* NOT NULL, (glob)
`k` int* NOT NULL DEFAULT '0', (glob)
PRIMARY KEY (`id`)
) ENGINE=InnoDB * (glob)
*************************** 1. row ***************************
sbtest2
CREATE TABLE `sbtest2` (
`id` int* NOT NULL, (glob)
`k` int* NOT NULL DEFAULT '0', (glob)
PRIMARY KEY (`id`)
) ENGINE=InnoDB * (glob)
ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest3' doesn't exist
sysbench * (glob)
Running the test with following options:
Number of threads: 2
Initializing random number generator from current time
Initializing worker threads...
Threads started!
SQL statistics:
queries performed:
read: 0
write: [12] (re)
other: 0
total: [12] (re)
transactions: 100 (* per sec.) (glob)
queries: [12] \(.* per sec.\) (re)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)
General statistics:
total time: *s (glob)
total number of events: 100
Latency (ms):
min: *.* (glob)
avg: *.* (glob)
max: *.* (glob)
95th percentile: *.* (glob)
sum: *.* (glob)
Threads fairness:
events (avg/stddev):* (glob)
execution time (avg/stddev):* (glob)
Dropping table 'sbtest1'...
Dropping table 'sbtest2'...
ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest1' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest2' doesn't exist
ERROR 1146 (42S02) at line 1: Table 'sbtest.sbtest3' doesn't exist
|
