在準備壓測的數(shù)據(jù)庫上創(chuàng)建用戶和數(shù)據(jù)庫信息: grant all privileges on *.* to sysbench identified by 'sysbench'; flush privileges; create database sysbench_db;
Creating table 'sbtest14'... Creating table 'sbtest12'... Creating table 'sbtest3'... Creating table 'sbtest5'... Creating table 'sbtest11'... Creating table 'sbtest4'... Creating table 'sbtest13'... Creating table 'sbtest10'... Creating table 'sbtest9'... Creating table 'sbtest8'... Creating table 'sbtest15'... Creating table 'sbtest1'... Creating table 'sbtest2'... Creating table 'sbtest6'... Creating table 'sbtest7'... Inserting 500000 records into 'sbtest12' Inserting 500000 records into 'sbtest11' Inserting 500000 records into 'sbtest10' Inserting 500000 records into 'sbtest2' Inserting 500000 records into 'sbtest5' Inserting 500000 records into 'sbtest8' Inserting 500000 records into 'sbtest13' Inserting 500000 records into 'sbtest4' Inserting 500000 records into 'sbtest3' Inserting 500000 records into 'sbtest7' Inserting 500000 records into 'sbtest15' Inserting 500000 records into 'sbtest1' Inserting 500000 records into 'sbtest6' Inserting 500000 records into 'sbtest9' Inserting 500000 records into 'sbtest14' Creating a secondary index on 'sbtest9'... Creating a secondary index on 'sbtest11'... Creating a secondary index on 'sbtest1'... Creating a secondary index on 'sbtest5'... Creating a secondary index on 'sbtest14'... Creating a secondary index on 'sbtest6'... Creating a secondary index on 'sbtest13'... Creating a secondary index on 'sbtest4'... Creating a secondary index on 'sbtest15'... Creating a secondary index on 'sbtest8'... Creating a secondary index on 'sbtest2'... Creating a secondary index on 'sbtest7'... Creating a secondary index on 'sbtest12'... Creating a secondary index on 'sbtest3'... Creating a secondary index on 'sbtest10'...
Running the test with following options: Number of threads: 128 Report intermediate results every 10 second(s) Initializing random number generator from current time