####################################### 5.6.42 ####################################### rm -rf 93875/ scripts/mysql_install_db --basedir=$PWD --datadir=$PWD/93875 -v bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/93875 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/93875/log.err 2>&1 & ####################################### 5.7/8.0 ####################################### rm -rf 93875 bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/93875 --log-error-verbosity=3 --skip-log-bin bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/93875 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/93875/log.err --log-error-verbosity=3 2>&1 & wget -c https://downloads.mysql.com/docs/sakila-db.tar.gz tar xzf sakila-db.tar.gz - bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e 'create database if not exists test;create database sakila;select version();' bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila < /tmp/sakila-db/sakila-schema.sql bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila < /tmp/sakila-db/sakila-data.sql -- only sakila, per-table time bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila -BNe 'show tables' 2>/dev/null | while read line; do bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila $line > /tmp/$line.sql 2>/dev/null ; done -- only sakila, whole database time bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila > /tmp/sakila.sql 2>/dev/null -- create large number of tables in test time for i in $(seq 300000); do echo "create table t$i(id int)engine=innodb;"; done | bin/mysql -uroot -S /tmp/mysql_ushastry.sock test 2>/dev/null -- many tables in test, sakila, per-table time bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila -BNe 'show tables' 2>/dev/null | while read line; do bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila $line > /tmp/$line.sql 2>/dev/null ; done -- many tables in test, sakila, whole database" time bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila > /tmp/sakila.sql 2>/dev/null ########################## -- 5.6 ########################## [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e 'create database if not exists test;create database sakila;select version();' +---------------------------------------+ | version() | +---------------------------------------+ | 5.6.42-enterprise-commercial-advanced | +---------------------------------------+ [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila < /tmp/sakila-db/sakila-schema.sql [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila < /tmp/sakila-db/sakila-data.sql [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila -BNe 'show tables' 2>/dev/null | while read line; do bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila $line > /tmp/$line.sql 2>/dev/null ; done real 0m0.618s user 0m0.099s sys 0m0.073s [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: time bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila > /tmp/sakila.sql 2>/dev/null real 0m0.248s user 0m0.074s sys 0m0.015s [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: for i in $(seq 300000); do echo "create table t$i(id int)engine=innodb;"; done | bin/mysql -uroot -S /tmp/mysql_ushastry.sock test 2>/dev/null [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila -BNe 'show tables' 2>/dev/null | while read line; do bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila $line > /tmp/$line.sql 2>/dev/null ; done real 0m0.833s user 0m0.092s sys 0m0.076s -- many tables in test, sakila, whole database [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: time bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila > /tmp/sakila.sql 2>/dev/null real 0m0.306s user 0m0.074s sys 0m0.015s ########################## -- 5.7 ########################## [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/93875 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/93875/log.err --log-error-verbosity=3 --skip-log-bin 2>&1 & [1] 30557 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e 'create database if not exists test;create database sakila;select version();' +-----------+ | version() | +-----------+ | 5.7.24 | +-----------+ [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila < /tmp/sakila-db/sakila-schema.sql [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila < /tmp/sakila-db/sakila-data.sql [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila -BNe 'show tables' 2>/dev/null | while read line; do bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila $line > /tmp/$line.sql 2>/dev/null ; done real 0m0.548s user 0m0.109s sys 0m0.063s [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: time bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila > /tmp/sakila.sql 2>/dev/null real 0m0.259s user 0m0.085s sys 0m0.011s [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: time for i in $(seq 300000); do echo "create table t$i(id int)engine=innodb;"; done | bin/mysql -uroot -S /tmp/mysql_ushastry.sock test 2>/dev/null real 14m46.225s user 0m7.026s sys 0m6.722s [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila -BNe 'show tables' 2>/dev/null | while read line; do bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila $line > /tmp/$line.sql 2>/dev/null ; done real 1m25.233s user 0m0.126s sys 0m0.082s [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: time bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila > /tmp/sakila.sql 2>/dev/null real 0m3.956s user 0m0.080s sys 0m0.014s ########################## -- 8.0 ########################## [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e 'create database if not exists test;create database sakila;select version();' +-----------+ | version() | +-----------+ | 8.0.13 | +-----------+ [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila < /tmp/sakila-db/sakila-schema.sql [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila < /tmp/sakila-db/sakila-data.sql [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila -BNe 'show tables' 2>/dev/null | while read line; do bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila $line > /tmp/$line.sql 2>/dev/null ; done real 0m0.780s user 0m0.141s sys 0m0.089s [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: time bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila > /tmp/sakila.sql 2>/dev/null real 0m0.334s user 0m0.080s sys 0m0.015s [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: time for i in $(seq 300000); do echo "create table t$i(id int)engine=innodb;"; done | bin/mysql -uroot -S /tmp/mysql_ushastry.sock test 2>/dev/null real 24m14.300s user 0m7.060s sys 0m5.462s [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: time bin/mysql -uroot -S /tmp/mysql_ushastry.sock sakila -BNe 'show tables' 2>/dev/null | while read line; do bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila $line > /tmp/$line.sql 2>/dev/null ; done real 0m25.977s user 0m0.157s sys 0m0.104s [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: time bin/mysqldump -uroot -S /tmp/mysql_ushastry.sock --max_allowed_packet=1024M --force --compress --hex-blob --skip-extended-insert --opt --quote-names --routines --single-transaction --default-character-set=utf8 sakila > /tmp/sakila.sql 2>/dev/null real 0m4.163s user 0m0.078s sys 0m0.019s