67 lines
2.3 KiB
Perl
67 lines
2.3 KiB
Perl
########################################################################
|
|
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.)
|
|
|
|
Throughput:
|
|
events/s (eps): *.* (glob)
|
|
time elapsed: *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
|