## Start up cleanly scripts/mysql_install_db --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/dev/shm/77344 bin/mysqld --no-defaults --innodb_buffer_pool_size=4G --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/dev/shm/77344 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/dev/shm/77344/log.err 2>&1 & # Prepare schema bin/sysbench --test=sysbench/tests/db/oltp.lua --oltp-tables-count=500000 --mysql-user=root --mysql-socket=/tmp/mysql_ushastry.sock --oltp-table-size=10 prepare ## Restart mysqld with ## --performance_schema=on --table_definition_cache=30000 valgrind --tool=massif --massif-out-file=/tmp/massif_with_ps.out bin/mysqld --no-defaults --innodb_buffer_pool_size=4G --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/dev/shm/77344 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/dev/shm/77344/log.err --performance_schema=on --table_definition_cache=30000 2015-06-16 10:53:45 4721 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-06-16 10:53:45 4721 [Note] InnoDB: The InnoDB memory heap is disabled 2015-06-16 10:53:45 4721 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-06-16 10:53:45 4721 [Note] InnoDB: Memory barrier is not used 2015-06-16 10:53:45 4721 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-06-16 10:53:45 4721 [Note] InnoDB: Using Linux native AIO 2015-06-16 10:53:45 4721 [Note] InnoDB: Using CPU crc32 instructions 2015-06-16 10:53:45 4721 [Note] InnoDB: Initializing buffer pool, size = 4.0G 2015-06-16 10:53:50 4721 [Note] InnoDB: Completed initialization of buffer pool 2015-06-16 10:53:50 4721 [Note] InnoDB: Highest supported file format is Barracuda. 2015-06-16 11:04:55 4721 [Note] InnoDB: 128 rollback segment(s) are active. 2015-06-16 11:04:55 4721 [Note] InnoDB: Waiting for purge to start 2015-06-16 11:04:55 4721 [Note] InnoDB: 5.6.25 started; log sequence number 7004428827 2015-06-16 11:04:55 4721 [Note] Server hostname (bind-address): '*'; port: 15000 2015-06-16 11:04:55 4721 [Note] IPv6 is available. 2015-06-16 11:04:55 4721 [Note] - '::' resolves to '::'; 2015-06-16 11:04:55 4721 [Note] Server socket created on IP: '::'. 2015-06-16 11:04:56 4721 [Note] Event Scheduler: Loaded 0 events 2015-06-16 11:04:56 4721 [Note] bin/mysqld: ready for connections. Version: '5.6.25' socket: '/tmp/mysql_ushastry.sock' port: 15000 MySQL Community Server (GPL) ## Restart mysqld with ## --performance_schema=off --table_definition_cache=30000 valgrind --tool=massif --massif-out-file=/tmp/massif_without_ps.out bin/mysqld --no-defaults --innodb_buffer_pool_size=4G --basedir=/export/umesh/server/binaries/mysql-5.6.25 --datadir=/dev/shm/77344 --core-file --socket=/tmp/mysql_ushastry.sock --port=15000 --log-error=/dev/shm/77344/log.err --performance_schema=off --table_definition_cache=30000 2015-06-16 11:11:21 5924 [Note] InnoDB: Using atomics to ref count buffer pool pages 2015-06-16 11:11:21 5924 [Note] InnoDB: The InnoDB memory heap is disabled 2015-06-16 11:11:21 5924 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2015-06-16 11:11:21 5924 [Note] InnoDB: Memory barrier is not used 2015-06-16 11:11:21 5924 [Note] InnoDB: Compressed tables use zlib 1.2.3 2015-06-16 11:11:21 5924 [Note] InnoDB: Using Linux native AIO 2015-06-16 11:11:21 5924 [Note] InnoDB: Using CPU crc32 instructions 2015-06-16 11:11:21 5924 [Note] InnoDB: Initializing buffer pool, size = 4.0G 2015-06-16 11:11:25 5924 [Note] InnoDB: Completed initialization of buffer pool 2015-06-16 11:11:25 5924 [Note] InnoDB: Highest supported file format is Barracuda. 2015-06-16 11:12:37 5924 [Note] InnoDB: 128 rollback segment(s) are active. 2015-06-16 11:12:38 5924 [Note] InnoDB: Waiting for purge to start 2015-06-16 11:12:38 5924 [Note] InnoDB: 5.6.25 started; log sequence number 7004428847 2015-06-16 11:12:38 5924 [Note] Server hostname (bind-address): '*'; port: 15000 2015-06-16 11:12:38 5924 [Note] IPv6 is available. 2015-06-16 11:12:38 5924 [Note] - '::' resolves to '::'; 2015-06-16 11:12:38 5924 [Note] Server socket created on IP: '::'. 2015-06-16 11:12:38 5924 [Note] Event Scheduler: Loaded 0 events 2015-06-16 11:12:38 5924 [Note] bin/mysqld: ready for connections. Version: '5.6.25' socket: '/tmp/mysql_ushastry.sock' port: 15000 MySQL Community Server (GPL)