## memory usage shown is very small as this test box has 256G RAM -- 5.6.29 (all default) scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.6.29 --datadir=/export/umesh/server/binaries/mysql-5.6.29/80645 bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.6.29 --datadir=/export/umesh/server/binaries/mysql-5.6.29/80645 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.29/80645/log.err 2>&1 & # Record memory usage rm -rf /tmp/pidstat.out pidstat -r -p `pidof mysqld` 5 > /tmp/pidstat.out - drop ./trigger-create.sh -d |bin/mysql -uroot -S/tmp/mysql_ushastry.sock - create schema ./trigger-create.sh -i |bin/mysql -uroot -S/tmp/mysql_ushastry.sock # restart mysqld bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.6.29 --datadir=/export/umesh/server/binaries/mysql-5.6.29/80645 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.29/80645/log.err 2>&1 & # Record memory usage pidstat -r -p `pidof mysqld` 5 >> /tmp/pidstat.out - create tables/triggers ./trigger-create.sh -c -r |bin/mysql -uroot -S/tmp/mysql_ushastry.sock - wait, flush tables bin/mysql -uroot -S /tmp/mysql_ushastry.sock --execute="SELECT SLEEP(600)" bin/mysql -uroot -S /tmp/mysql_ushastry.sock --execute="FLUSH TABLES" # stop mysqld bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.29: cat /tmp/pidstat.out Linux 3.8.13-98.2.2.el7uek.x86_64 (hod03) 03/10/2016 _x86_64_ (32 CPU) 09:29:05 AM UID PID minflt/s majflt/s VSZ RSS %MEM Command 09:29:10 AM 10919 14409 0.00 0.00 1075616 454284 0.17 mysqld 09:29:15 AM 10919 14409 0.00 0.00 1075616 454284 0.17 mysqld 09:29:20 AM 10919 14409 5330.20 0.00 1141412 560672 0.21 mysqld 09:29:25 AM 10919 14409 1928.20 0.00 1403556 599216 0.23 mysqld 09:29:30 AM 10919 14409 480.20 0.00 1403556 608984 0.23 mysqld 09:29:35 AM 10919 14409 481.00 0.00 1403556 618488 0.23 mysqld 09:29:40 AM 10919 14409 477.60 0.00 1403556 627992 0.24 mysqld 09:29:45 AM 10919 14409 473.60 0.00 1403556 637496 0.24 mysqld 09:29:50 AM 10919 14409 295.20 0.00 1469092 642668 0.24 mysqld 09:29:55 AM 10919 14409 8.80 0.00 1469092 642928 0.24 mysqld 09:30:00 AM 10919 14409 0.20 0.00 1469092 642928 0.24 mysqld 09:30:05 AM 10919 14409 59.40 0.00 1469092 643984 0.24 mysqld 09:30:10 AM 10919 14409 9966.20 0.00 1796772 834988 0.32 mysqld 09:30:15 AM 10919 14409 7356.20 0.00 1927844 977700 0.37 mysqld 09:30:20 AM 10919 14409 538.00 0.00 1927844 983012 0.37 mysqld 09:30:25 AM 10919 14409 281.40 0.00 1927844 984124 0.37 mysqld -- 5.6.29 with table_open_cache 400 instead od default 2000 rm -rf 80645 scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.6.29 --datadir=/export/umesh/server/binaries/mysql-5.6.29/80645 bin/mysqld --table_open_cache=400 --basedir=/export/umesh/server/binaries/mysql-5.6.29 --datadir=/export/umesh/server/binaries/mysql-5.6.29/80645 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.29/80645/log.err 2>&1 & # Record memory usage rm -rf /tmp/pidstat.out pidstat -r -p `pidof mysqld` 5 > /tmp/pidstat.out - drop ./trigger-create.sh -d |bin/mysql -uroot -S/tmp/mysql_ushastry.sock - create schema ./trigger-create.sh -i |bin/mysql -uroot -S/tmp/mysql_ushastry.sock # restart mysqld bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown bin/mysqld --table_open_cache=400 --basedir=/export/umesh/server/binaries/mysql-5.6.29 --datadir=/export/umesh/server/binaries/mysql-5.6.29/80645 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.29/80645/log.err 2>&1 & # Record memory usage pidstat -r -p `pidof mysqld` 5 >> /tmp/pidstat.out - create tables/triggers ./trigger-create.sh -c -r |bin/mysql -uroot -S/tmp/mysql_ushastry.sock - wait, flush tables bin/mysql -uroot -S /tmp/mysql_ushastry.sock --execute="SELECT SLEEP(600)" bin/mysql -uroot -S /tmp/mysql_ushastry.sock --execute="FLUSH TABLES" # stop mysqld bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.29: cat /tmp/pidstat.out Linux 3.8.13-98.2.2.el7uek.x86_64 (hod03) 03/10/2016 _x86_64_ (32 CPU) 10:04:59 AM UID PID minflt/s majflt/s VSZ RSS %MEM Command 10:05:04 AM 10919 25295 0.20 0.00 671868 111572 0.04 mysqld 10:05:09 AM 10919 25295 0.00 0.00 671868 111572 0.04 mysqld 10:05:14 AM 10919 25295 0.00 0.00 671868 111572 0.04 mysqld 10:05:19 AM 10919 25295 2831.20 0.00 803200 167260 0.06 mysqld 10:05:24 AM 10919 25295 5023.20 0.00 999808 259024 0.10 mysqld 10:05:29 AM 10919 25295 1006.60 0.00 1065344 270448 0.10 mysqld 10:05:34 AM 10919 25295 608.80 0.00 1065344 281860 0.11 mysqld 10:05:39 AM 10919 25295 596.00 0.00 1065344 292896 0.11 mysqld 10:05:44 AM 10919 25295 545.80 0.00 1065344 302836 0.11 mysqld 10:05:49 AM 10919 25295 99.20 0.00 1065344 304160 0.12 mysqld 10:05:54 AM 10919 25295 18.20 0.00 1065344 304424 0.12 mysqld 10:05:59 AM 10919 25295 3.00 0.00 1065344 304424 0.12 mysqld 10:06:04 AM 10919 25295 0.20 0.00 1065344 304424 0.12 mysqld 10:06:09 AM 10919 25295 4071.60 0.00 1327488 374224 0.14 mysqld After, flush tables 10:06:49 AM 10919 25295 0.80 0.00 1196416 305704 0.12 mysqld 10:06:54 AM 10919 25295 0.00 0.00 1196416 305704 0.12 mysqld ############################## ############################## ############################## ############################## with valgrind ############################## rm -rf 80645 scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.6.29 --datadir=/export/umesh/server/binaries/mysql-5.6.29/80645 bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.6.29 --datadir=/export/umesh/server/binaries/mysql-5.6.29/80645 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.29/80645/log.err 2>&1 & # Record memory usage rm -rf /tmp/pidstat.out pidstat -r -p `pidof mysqld` 5 > /tmp/pidstat.out - drop ./trigger-create.sh -d |bin/mysql -uroot -S/tmp/mysql_ushastry.sock - create schema ./trigger-create.sh -i |bin/mysql -uroot -S/tmp/mysql_ushastry.sock # restart mysqld bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown valgrind --tool=massif --massif-out-file=/tmp/massif.out bin/mysqld --basedir=/export/umesh/server/binaries/mysql-5.6.29 --datadir=/export/umesh/server/binaries/mysql-5.6.29/80645 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.6.29/80645/log.err # Record memory usage rm -rf /tmp/pidstat.out pidstat -r -p `pidof mysqld` 5 >> /tmp/pidstat.out - create tables/triggers ./trigger-create.sh -c -r |bin/mysql -uroot -S/tmp/mysql_ushastry.sock - wait, flush tables bin/mysql -uroot -S /tmp/mysql_ushastry.sock --execute="SELECT SLEEP(600)" bin/mysql -uroot -S /tmp/mysql_ushastry.sock --execute="FLUSH TABLES" # stop mysqld bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown