https://github.com/go-sql-driver/sql-benchmark

_.md

uname -a

Linux MBA62-LNX 3.19.0-23-generic #24-Ubuntu SMP Tue Jul 7 18:52:55 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux

lsb_release -a

No LSB modules are available.
Distributor ID:	Ubuntu
Description:	Ubuntu 15.04
Release:	15.04
Codename:	vivid

cat /proc/cpuinfo

processor	: 0
vendor_id	: GenuineIntel
cpu family	: 6
model		: 69
model name	: Intel(R) Core(TM) i7-4650U CPU @ 1.70GHz
stepping	: 1
microcode	: 0x1c
cpu MHz		: 2838.613
cache size	: 4096 KB
physical id	: 0
siblings	: 4
core id		: 0
cpu cores	: 2
apicid		: 0
initial apicid	: 0
fpu		: yes
fpu_exception	: yes
cpuid level	: 13
wp		: yes
flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm ida arat epb pln pts dtherm tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt
bugs		:
bogomips	: 4600.36
clflush size	: 64
cache_alignment	: 64
address sizes	: 39 bits physical, 48 bits virtual
power management:

processor	: 1
vendor_id	: GenuineIntel
cpu family	: 6
model		: 69
model name	: Intel(R) Core(TM) i7-4650U CPU @ 1.70GHz
stepping	: 1
microcode	: 0x1c
cpu MHz		: 2846.609
cache size	: 4096 KB
physical id	: 0
siblings	: 4
core id		: 1
cpu cores	: 2
apicid		: 2
initial apicid	: 2
fpu		: yes
fpu_exception	: yes
cpuid level	: 13
wp		: yes
flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm ida arat epb pln pts dtherm tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt
bugs		:
bogomips	: 4600.36
clflush size	: 64
cache_alignment	: 64
address sizes	: 39 bits physical, 48 bits virtual
power management:

processor	: 2
vendor_id	: GenuineIntel
cpu family	: 6
model		: 69
model name	: Intel(R) Core(TM) i7-4650U CPU @ 1.70GHz
stepping	: 1
microcode	: 0x1c
cpu MHz		: 2838.613
cache size	: 4096 KB
physical id	: 0
siblings	: 4
core id		: 0
cpu cores	: 2
apicid		: 1
initial apicid	: 1
fpu		: yes
fpu_exception	: yes
cpuid level	: 13
wp		: yes
flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm ida arat epb pln pts dtherm tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt
bugs		:
bogomips	: 4600.36
clflush size	: 64
cache_alignment	: 64
address sizes	: 39 bits physical, 48 bits virtual
power management:

processor	: 3
vendor_id	: GenuineIntel
cpu family	: 6
model		: 69
model name	: Intel(R) Core(TM) i7-4650U CPU @ 1.70GHz
stepping	: 1
microcode	: 0x1c
cpu MHz		: 2838.613
cache size	: 4096 KB
physical id	: 0
siblings	: 4
core id		: 1
cpu cores	: 2
apicid		: 3
initial apicid	: 3
fpu		: yes
fpu_exception	: yes
cpuid level	: 13
wp		: yes
flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx smx est tm2 ssse3 fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm ida arat epb pln pts dtherm tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid xsaveopt
bugs		:
bogomips	: 4600.36
clflush size	: 64
cache_alignment	: 64
address sizes	: 39 bits physical, 48 bits virtual
power management:

cat /proc/meminfo

MemTotal:        8114604 kB
MemFree:          484928 kB
MemAvailable:    2754272 kB
Buffers:          317760 kB
Cached:          2856200 kB
SwapCached:        22968 kB
Active:          4814264 kB
Inactive:        2253912 kB
Active(anon):    3553784 kB
Inactive(anon):  1171352 kB
Active(file):    1260480 kB
Inactive(file):  1082560 kB
Unevictable:         132 kB
Mlocked:             132 kB
SwapTotal:       4802556 kB
SwapFree:        4333372 kB
Dirty:              5788 kB
Writeback:             0 kB
AnonPages:       3883920 kB
Mapped:           726364 kB
Shmem:            830920 kB
Slab:             399884 kB
SReclaimable:     179708 kB
SUnreclaim:       220176 kB
KernelStack:       15312 kB
PageTables:        72780 kB
NFS_Unstable:          0 kB
Bounce:                0 kB
WritebackTmp:          0 kB
CommitLimit:     8859856 kB
Committed_AS:   13242796 kB
VmallocTotal:   34359738367 kB
VmallocUsed:      457236 kB
VmallocChunk:   34359230924 kB
HardwareCorrupted:     0 kB
AnonHugePages:    886784 kB
CmaTotal:              0 kB
CmaFree:               0 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB
DirectMap4k:      451236 kB
DirectMap2M:     7876608 kB
DirectMap1G:           0 kB

mysqld --version

mysqld  Ver 5.6.25-0ubuntu0.15.04.1 for debian-linux-gnu on x86_64 ((Ubuntu))

go version

go version go1.4.2 linux/amd64

cd github.com/ziutek/mymysql && git log -1

commit 1294234e9635d40b24107b0ab0e980add015f4b5
Merge: e08c2f3 217a1df
Author: Michał Derkacz <[email protected]>
Date:   Mon May 4 16:11:06 2015 +0200

    Merge pull request #110 from ASAPPinc/conn-params
    
    Add ability to pass in mysql connection parameters via the source string...

cd github.com/go-sql-driver/mysql && git log -1

commit fb7299726d2e68745a8805b14f2ff44b5c2cfa84
Author: Julien Schmidt <[email protected]>
Date:   Sat Jun 20 22:03:12 2015 +0200

    AUTHORS: Sort

benchmark.log

Warming up mymysql godrv...
Warming up Go-MySQL-Driver...

Run Benchmarks...

SimpleExec 250000 iterations
mymysql godrv
 4.624453971s 	    54060 queries/sec	    8 allocs/query	    344 B/query
 4.422202432s 	    56533 queries/sec	    8 allocs/query	    344 B/query
 4.584466255s 	    54532 queries/sec	    8 allocs/query	    344 B/query
 -- avg 55042 qps;  median 54532 qps
Go-MySQL-Driver
 4.149071127s 	    60254 queries/sec	    3 allocs/query	    64 B/query
 4.106802647s 	    60875 queries/sec	    3 allocs/query	    64 B/query
 4.075669671s 	    61340 queries/sec	    3 allocs/query	    64 B/query
 -- avg 60823 qps;  median 60875 qps

PreparedExec 250000 iterations
mymysql godrv
 4.234601021s 	    59037 queries/sec	    10 allocs/query	    432 B/query
 4.180508207s 	    59801 queries/sec	    10 allocs/query	    432 B/query
 4.110999985s 	    60812 queries/sec	    10 allocs/query	    432 B/query
 -- avg 59884 qps;  median 59801 qps
Go-MySQL-Driver
 3.765635465s 	    66390 queries/sec	    6 allocs/query	    112 B/query
 3.786407986s 	    66026 queries/sec	    6 allocs/query	    112 B/query
 3.825129212s 	    65357 queries/sec	    6 allocs/query	    112 B/query
 -- avg 65924 qps;  median 66026 qps

SimpleQueryRow 250000 iterations
mymysql godrv
 6.826624606s 	    36621 queries/sec	    31 allocs/query	    1362 B/query
 6.88167572s 	    36328 queries/sec	    31 allocs/query	    1362 B/query
 6.904913289s 	    36206 queries/sec	    31 allocs/query	    1362 B/query
 -- avg 36385 qps;  median 36328 qps
Go-MySQL-Driver
 5.570793834s 	    44877 queries/sec	    13 allocs/query	    328 B/query
 5.722397302s 	    43688 queries/sec	    13 allocs/query	    328 B/query
 6.815752929s 	    36680 queries/sec	    13 allocs/query	    328 B/query
 -- avg 41748 qps;  median 43688 qps

PreparedQueryRow 250000 iterations
mymysql godrv
 8.846550468s 	    28260 queries/sec	    36 allocs/query	    1487 B/query
 7.509967944s 	    33289 queries/sec	    36 allocs/query	    1487 B/query
 7.977087862s 	    31340 queries/sec	    36 allocs/query	    1487 B/query
 -- avg 30963 qps;  median 31340 qps
Go-MySQL-Driver
 6.07195922s 	    41173 queries/sec	    16 allocs/query	    344 B/query
 5.575949563s 	    44835 queries/sec	    16 allocs/query	    344 B/query
 5.448019745s 	    45888 queries/sec	    16 allocs/query	    344 B/query
 -- avg 43966 qps;  median 44835 qps

PreparedQueryRowParam 250000 iterations
mymysql godrv
 8.087083761s 	    30913 queries/sec	    42 allocs/query	    1543 B/query
 8.007159747s 	    31222 queries/sec	    42 allocs/query	    1543 B/query
 9.281022827s 	    26937 queries/sec	    42 allocs/query	    1543 B/query
 -- avg 29691 qps;  median 30913 qps
Go-MySQL-Driver
 6.464110457s 	    38675 queries/sec	    19 allocs/query	    376 B/query
 6.215038906s 	    40225 queries/sec	    19 allocs/query	    376 B/query
 6.39618069s 	    39086 queries/sec	    19 allocs/query	    376 B/query
 -- avg 39329 qps;  median 39086 qps

EchoMixed5 250000 iterations
mymysql godrv
 12.148546726s 	    20579 queries/sec	    85 allocs/query	    3301 B/query
 12.473556059s 	    20042 queries/sec	    85 allocs/query	    3301 B/query
 12.269629798s 	    20376 queries/sec	    85 allocs/query	    3301 B/query
 -- avg 20332 qps;  median 20376 qps
Go-MySQL-Driver
 7.551880592s 	    33104 queries/sec	    25 allocs/query	    641 B/query
 7.441181776s 	    33597 queries/sec	    25 allocs/query	    641 B/query
 7.661993664s 	    32629 queries/sec	    25 allocs/query	    641 B/query
 -- avg 33110 qps;  median 33104 qps

SelectLargeString 50000 iterations
mymysql godrv
 5.917129282s 	    8450 queries/sec	    32 allocs/query	    24006 B/query
 5.759210596s 	    8682 queries/sec	    32 allocs/query	    24006 B/query
 5.739298026s 	    8712 queries/sec	    32 allocs/query	    24006 B/query
 -- avg 8615 qps;  median 8682 qps
Go-MySQL-Driver
 4.266202093s 	    11720 queries/sec	    13 allocs/query	    10853 B/query
 4.267677519s 	    11716 queries/sec	    13 allocs/query	    10852 B/query
 4.511868165s 	    11082 queries/sec	    13 allocs/query	    10852 B/query
 -- avg 11506 qps;  median 11716 qps

SelectPreparedLargeString 50000 iterations
mymysql godrv
 5.741990516s 	    8708 queries/sec	    38 allocs/query	    24132 B/query
 5.379436499s 	    9295 queries/sec	    38 allocs/query	    24132 B/query
 5.738036851s 	    8714 queries/sec	    38 allocs/query	    24132 B/query
 -- avg 8905 qps;  median 8714 qps
Go-MySQL-Driver
 4.507992166s 	    11091 queries/sec	    16 allocs/query	    10865 B/query
 4.14279628s 	    12069 queries/sec	    16 allocs/query	    10865 B/query
 4.080860435s 	    12252 queries/sec	    16 allocs/query	    10865 B/query
 -- avg 11804 qps;  median 12069 qps

SelectLargeBytes 50000 iterations
mymysql godrv
 6.183231259s 	    8086 queries/sec	    32 allocs/query	    24006 B/query
 5.760073964s 	    8680 queries/sec	    32 allocs/query	    24006 B/query
 5.836954228s 	    8566 queries/sec	    31 allocs/query	    24006 B/query
 -- avg 8444 qps;  median 8566 qps
Go-MySQL-Driver
 4.286413494s 	    11665 queries/sec	    13 allocs/query	    10852 B/query
 4.652549106s 	    10747 queries/sec	    13 allocs/query	    10852 B/query
 4.580618983s 	    10916 queries/sec	    13 allocs/query	    10852 B/query
 -- avg 11109 qps;  median 10916 qps

SelectPreparedLargeBytes 50000 iterations
mymysql godrv
 5.729403469s 	    8727 queries/sec	    38 allocs/query	    24132 B/query
 5.739142448s 	    8712 queries/sec	    38 allocs/query	    24132 B/query
 5.710470772s 	    8756 queries/sec	    38 allocs/query	    24132 B/query
 -- avg 8732 qps;  median 8727 qps
Go-MySQL-Driver
 4.457471352s 	    11217 queries/sec	    16 allocs/query	    10865 B/query
 4.175498358s 	    11975 queries/sec	    16 allocs/query	    10865 B/query
 4.463103515s 	    11203 queries/sec	    16 allocs/query	    10865 B/query
 -- avg 11465 qps;  median 11217 qps

SelectLargeRaw 50000 iterations
mymysql godrv
 4.992696407s 	    10015 queries/sec	    29 allocs/query	    12631 B/query
 5.021601201s 	    9957 queries/sec	    29 allocs/query	    12631 B/query
 4.67126728s 	    10704 queries/sec	    29 allocs/query	    12631 B/query
 -- avg 10225 qps;  median 10015 qps
Go-MySQL-Driver
 4.099911227s 	    12195 queries/sec	    11 allocs/query	    320 B/query
 3.814189378s 	    13109 queries/sec	    11 allocs/query	    320 B/query
 4.068882682s 	    12288 queries/sec	    11 allocs/query	    320 B/query
 -- avg 12531 qps;  median 12288 qps

SelectPreparedLargeRaw 50000 iterations
mymysql godrv
 4.931913906s 	    10138 queries/sec	    35 allocs/query	    12749 B/query
 4.576523542s 	    10925 queries/sec	    35 allocs/query	    12749 B/query
 4.99337385s 	    10013 queries/sec	    35 allocs/query	    12749 B/query
 -- avg 10359 qps;  median 10138 qps
Go-MySQL-Driver
 3.929587234s 	    12724 queries/sec	    14 allocs/query	    328 B/query
 3.544663648s 	    14106 queries/sec	    14 allocs/query	    328 B/query
 3.737929706s 	    13376 queries/sec	    14 allocs/query	    328 B/query
 -- avg 13402 qps;  median 13376 qps

PreparedExecConcurrent1 500000 iterations
mymysql godrv
 10.695777502s 	    46747 queries/sec	    10 allocs/query	    432 B/query
 10.629885108s 	    47037 queries/sec	    10 allocs/query	    432 B/query
 10.462960917s 	    47788 queries/sec	    10 allocs/query	    432 B/query
 -- avg 47191 qps;  median 47037 qps
Go-MySQL-Driver
 9.682270618s 	    51641 queries/sec	    5 allocs/query	    112 B/query
 9.668466919s 	    51715 queries/sec	    5 allocs/query	    112 B/query
 10.014604683s 	    49927 queries/sec	    5 allocs/query	    112 B/query
 -- avg 51094 qps;  median 51641 qps

PreparedExecConcurrent2 500000 iterations
mymysql godrv
 8.511072776s 	    58747 queries/sec	    9 allocs/query	    432 B/query
 8.284437549s 	    60354 queries/sec	    9 allocs/query	    432 B/query
 8.900319471s 	    56178 queries/sec	    9 allocs/query	    432 B/query
 -- avg 58426 qps;  median 58747 qps
Go-MySQL-Driver
 7.568870589s 	    66060 queries/sec	    5 allocs/query	    112 B/query
 8.424280054s 	    59352 queries/sec	    5 allocs/query	    112 B/query
 7.704950439s 	    64893 queries/sec	    5 allocs/query	    112 B/query
 -- avg 63435 qps;  median 64893 qps

PreparedExecConcurrent4 500000 iterations
mymysql godrv
 6.692205332s 	    74714 queries/sec	    9 allocs/query	    432 B/query
 6.296904703s 	    79404 queries/sec	    9 allocs/query	    432 B/query
 7.265710699s 	    68816 queries/sec	    9 allocs/query	    432 B/query
 -- avg 74311 qps;  median 74714 qps
Go-MySQL-Driver
 5.993479883s 	    83424 queries/sec	    6 allocs/query	    112 B/query
 5.482751339s 	    91195 queries/sec	    6 allocs/query	    112 B/query
 5.91848556s 	    84481 queries/sec	    6 allocs/query	    112 B/query
 -- avg 86367 qps;  median 84481 qps

PreparedExecConcurrent8 500000 iterations
mymysql godrv
 6.677131953s 	    74882 queries/sec	    10 allocs/query	    432 B/query
 7.224970715s 	    69204 queries/sec	    10 allocs/query	    432 B/query
 6.463412048s 	    77359 queries/sec	    10 allocs/query	    432 B/query
 -- avg 73815 qps;  median 74882 qps
Go-MySQL-Driver
 6.314177142s 	    79187 queries/sec	    6 allocs/query	    112 B/query
 6.209301905s 	    80524 queries/sec	    6 allocs/query	    112 B/query
 6.012707656s 	    83157 queries/sec	    6 allocs/query	    112 B/query
 -- avg 80956 qps;  median 80524 qps

PreparedExecConcurrent16 500000 iterations
mymysql godrv
 7.147038375s 	    69959 queries/sec	    10 allocs/query	    432 B/query
 7.137880543s 	    70049 queries/sec	    10 allocs/query	    432 B/query
 6.736485424s 	    74223 queries/sec	    10 allocs/query	    432 B/query
 -- avg 71410 qps;  median 70049 qps
Go-MySQL-Driver
 6.663276044s 	    75038 queries/sec	    6 allocs/query	    112 B/query
 6.282452349s 	    79587 queries/sec	    6 allocs/query	    112 B/query
 6.544655742s 	    76398 queries/sec	    6 allocs/query	    112 B/query
 -- avg 77008 qps;  median 76398 qps

PreparedQueryConcurrent1 500000 iterations
mymysql godrv
 18.986026389s 	    26335 queries/sec	    52 allocs/query	    1832 B/query
 19.137300149s 	    26127 queries/sec	    52 allocs/query	    1832 B/query
 19.133562858s 	    26132 queries/sec	    52 allocs/query	    1832 B/query
 -- avg 26198 qps;  median 26132 qps
Go-MySQL-Driver
 13.91715076s 	    35927 queries/sec	    21 allocs/query	    440 B/query
 13.951464801s 	    35839 queries/sec	    21 allocs/query	    440 B/query
 14.298133725s 	    34970 queries/sec	    21 allocs/query	    440 B/query
 -- avg 35578 qps;  median 35839 qps

PreparedQueryConcurrent2 500000 iterations
mymysql godrv
 13.720134556s 	    36443 queries/sec	    52 allocs/query	    1832 B/query
 13.72965446s 	    36418 queries/sec	    52 allocs/query	    1832 B/query
 14.699852431s 	    34014 queries/sec	    52 allocs/query	    1832 B/query
 -- avg 35625 qps;  median 36418 qps
Go-MySQL-Driver
 10.835672482s 	    46144 queries/sec	    21 allocs/query	    440 B/query
 10.987967526s 	    45504 queries/sec	    21 allocs/query	    440 B/query
 11.237904111s 	    44492 queries/sec	    21 allocs/query	    440 B/query
 -- avg 45380 qps;  median 45504 qps

PreparedQueryConcurrent4 500000 iterations
mymysql godrv
 12.894007044s 	    38778 queries/sec	    52 allocs/query	    1832 B/query
 13.284189964s 	    37639 queries/sec	    52 allocs/query	    1832 B/query
 13.241624427s 	    37760 queries/sec	    52 allocs/query	    1832 B/query
 -- avg 38059 qps;  median 37760 qps
Go-MySQL-Driver
 8.472530638s 	    59014 queries/sec	    21 allocs/query	    440 B/query
 7.829091753s 	    63864 queries/sec	    21 allocs/query	    440 B/query
 8.485103878s 	    58927 queries/sec	    21 allocs/query	    440 B/query
 -- avg 60602 qps;  median 59014 qps

PreparedQueryConcurrent8 500000 iterations
mymysql godrv
 13.434507585s 	    37218 queries/sec	    52 allocs/query	    1832 B/query
 14.073288562s 	    35528 queries/sec	    52 allocs/query	    1832 B/query
 13.730604428s 	    36415 queries/sec	    52 allocs/query	    1832 B/query
 -- avg 36387 qps;  median 36415 qps
Go-MySQL-Driver
 9.041146892s 	    55303 queries/sec	    21 allocs/query	    440 B/query
 8.761427639s 	    57068 queries/sec	    21 allocs/query	    440 B/query
 9.039477789s 	    55313 queries/sec	    21 allocs/query	    440 B/query
 -- avg 55895 qps;  median 55313 qps

PreparedQueryConcurrent16 500000 iterations
mymysql godrv
 14.898630755s 	    33560 queries/sec	    52 allocs/query	    1830 B/query
 14.256374614s 	    35072 queries/sec	    52 allocs/query	    1830 B/query
 14.729050762s 	    33947 queries/sec	    52 allocs/query	    1830 B/query
 -- avg 34193 qps;  median 33947 qps
Go-MySQL-Driver
 9.285356373s 	    53848 queries/sec	    21 allocs/query	    440 B/query
 8.915457566s 	    56082 queries/sec	    21 allocs/query	    440 B/query
 9.485257518s 	    52713 queries/sec	    21 allocs/query	    440 B/query
 -- avg 54215 qps;  median 53848 qps

Finished... Total running time: 16m58.913077599s