MySQL and Onesql parallel insert performance comparison

According to my style, I don't have a diagram.

Environment

The following is inspired by Ye Jinlong teachers to explain the relevant environment clearly

The key parameters for MySQL and Onesql are configured as follows

Database	Sync_binlog	Innodb_flush_log_at_trx_commit	Innodb_log_file_size	Innodb_buffer_pool_size
Onesql	0	1	1000M	8G
Mysql	0	1	1000M	8G

Hardware Environment

Memory	Cpu	Disk
32g	8c two hyper-threading on each core Intel (R) Xeon (R) CPUs E5620 @ 2.40GHz	2 pieces of RAID0 7500r

Test Cases

Table structure

CREATE TABLE ' Dumptest ' (
' ID ' bigint () not NULL,
' Start ' datetime DEFAULT NULL,
' Icol3 ' int (one) DEFAULT NULL COMMENT ' 1-10 ',
' Icol4 ' int (one) DEFAULT NULL COMMENT ' 1-100 ',
' Icol5 ' int (one) DEFAULT NULL COMMENT ' 1-1000 ',
' Icol6 ' int (one) DEFAULT NULL,
' vcol7 ' varchar DEFAULT NULL,
' Vcol8 ' varchar DEFAULT NULL,
' VCOL9 ' varchar (+) DEFAULT NULL,
' vcol10 ' varchar DEFAULT NULL,
PRIMARY KEY (' id ')
)

Test tools

Lou Fangxin mydbtest (http://www.onexsoft.com/software/mydbtest_linux64.zip) tool, test configuration file

Cat DUMPTEST-INSERT.CNF

#################################################

Option
User Test/[email Protected]:3316:test
Time 60m
Log/dev/null
Declare
Vid bigseq 1 10000000000
Vstart DATE-10 10
VICOL3 int 1 10
VICOL4 int 1 100
VICOL5 int 1 1000
VICOL6 int 1 100000
VVCOL7 Char 10 19
Vvcol8 Char 10 19
Vvcol9 Char 10 29
Vvcol10 Char 10 19
Begin
INSERT into Dumptest (ID, start, icol3, Icol4, Icol5, Icol6, Vcol7, Vcol8, VCOL9, Vcol10) VALUES (: Vid,: Vstart,: V Icol3,: Vicol4,: Vicol5,: vicol6,: Vvcol7,: Vvcol8,: vvcol9,: VVCOL10);
End

###################################################

Test command

./mydbtest_linux64.bin query=dumptest-insert.cnf degree=256

The test duration is 1 hours, the test results are as follows

Thread	INSERT	Database
256	66826	Onesql
256	42781	Mysql

If you have questions or seek cooperation, please contact onesoft007 or Weibo @mark gentle man

MySQL and Onesql parallel insert performance comparison