CREATE DATABASE tdb01; CREATE USER 'root'@'192.168.0.130' IDENTIFIED BY 'root123'; GRANT ALL PRIVILEGES ON tdb01.* TO ‘'root'@'192.168.0.130'; FLUSH PRIVILEGES;
Creating table 'sbtest10'... Creating table 'sbtest1'... Creating table 'sbtest7'... Creating table 'sbtest9'... Creating table 'sbtest6'... Creating table 'sbtest8'... Creating table 'sbtest3'... Creating table 'sbtest2'... Creating table 'sbtest5'... Creating table 'sbtest4'... Inserting 5000000 records into 'sbtest1' Inserting 5000000 records into 'sbtest2' Inserting 5000000 records into 'sbtest7' Inserting 5000000 records into 'sbtest5' Inserting 5000000 records into 'sbtest10' Inserting 5000000 records into 'sbtest4' Inserting 5000000 records into 'sbtest3' Inserting 5000000 records into 'sbtest9' Inserting 5000000 records into 'sbtest6' Inserting 5000000 records into 'sbtest8' Creating a secondary index on 'sbtest4'... Creating a secondary index on 'sbtest6'... Creating a secondary index on 'sbtest5'... Creating a secondary index on 'sbtest1'... Creating a secondary index on 'sbtest9'... Creating a secondary index on 'sbtest8'... Creating a secondary index on 'sbtest2'... Creating a secondary index on 'sbtest7'... Creating a secondary index on 'sbtest10'... Creating a secondary index on 'sbtest3'... [root@mdb01 lua]#
Running the test with following options: Number of threads: 300 Report intermediate results every 10 second(s) Initializing random number generator from current time