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
Post a Comment