java - MySQL 5.5.44 "native" 32% faster than dockerized MySQL 5.5.44 -


i have mysql 5.5.44 installed native on lenovo x6 box many cores, ssd, etc. /var/lib/mysql symlinked off dir on ssd.

i have docker 5.5.44 image present. image started way:

sudo docker run --name buzz-mysql0 -v /data/2/mysqlvarlib/0:/var/lib/mysql -e mysql_root_password=password -p 24000:3306 -d mysql:5.5 

as can see, /var/lib/mysql volume mapped out of container host on ssd. same ssd native mysql. host can talk instance on port 24000.

both instances out-of-the-box. no special conf options, tunings, etc.

i have little java program runs in tight loop autocommit(false)/commit() wrappers , inserts 6 columns of short strings , 2 dates. uses mysql-connector-java-5.1.36-bin.jar.
run against mysql @ port 3306 (native), runs @ 5000 inserts/sec. run against mysql @ port 24000 dockerized image, runs @ 3400 inserts/sec. that's 32% slower. 1 test run @ time , results not vary.

i hoping matter of tuning , not volume mapping or port forwarding contributing slowness. if 10% slower wouldn't care 32% bit steep.


Comments