[umshastr@hod03]/export/umesh/sandbox/mysql-sandbox-master: export PERL5LIB=/home/umshastr/perl5/lib/perl5/ [umshastr@hod03]/export/umesh/sandbox/mysql-sandbox-master: bin/make_replication_sandbox --master_master /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz installing node 1 installing node 2 # server: 1: # server: 2: # server: 1: # server: 2: # server: 1: # server: 2: Circular replication activated group directory installed in $HOME/sandboxes/rcsandbox_mysql-5_7_17 [umshastr@hod03]/export/umesh/sandbox/mysql-sandbox-master: cd $HOME/sandboxes/rcsandbox_mysql-5_7_17 [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: for i in {1..2}; do echo "sync_relay_log_info=1" >> node$i/my.sandbox.cnf ; done [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: for i in {1..2}; do echo "performance-schema-instrument='memory%=ON' " >> node$i/my.sandbox.cnf ; done [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: ./enable_gtid # option 'master-info-repository=table' added to node1 configuration file # option 'relay-log-info-repository=table' added to node1 configuration file # option 'gtid_mode=ON' added to node1 configuration file # option 'log-slave-updates' already exists in node1 configuration file # option 'enforce-gtid-consistency' added to node1 configuration file # option 'master-info-repository=table' added to node2 configuration file # option 'relay-log-info-repository=table' added to node2 configuration file # option 'gtid_mode=ON' added to node2 configuration file # option 'log-slave-updates' already exists in node2 configuration file # option 'enforce-gtid-consistency' added to node2 configuration file # executing "stop" on /home/umshastr/sandboxes/rcsandbox_mysql-5_7_17 # server: 1: # server: 2: executing "stop" on node 1 executing "stop" on node 2 # executing "start" on /home/umshastr/sandboxes/rcsandbox_mysql-5_7_17 executing "start" on node 1 . sandbox server started executing "start" on node 2 . sandbox server started # server: 1: # server: 2: [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: ./n1 -e 'create database sbtest1' [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: ps aux|grep rcsandbox_mysql-5_7_17|grep .sock|awk '{print "vsz: "$5/1024" MB","rss: "$6/1024" MB",$19}' vsz: 1470.28 MB rss: 172.484 MB --port=15701 vsz: 1534.28 MB rss: 172.742 MB --port=15702 [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: ./use_all 'select * from sys.memory_global_total' # server: 1: total_allocated 324.68 MiB # server: 2: total_allocated 324.75 MiB ### [umshastr@hod03]~/bugs/sysbench: sysbench/sysbench --num-threads=16 --max-requests=300000 --db-driver=mysql --test=/home/umshastr/bugs/sysbench/sysbench/tests/db/oltp.lua --mysql-table-engine=InnoDB --mysql-db=sbtest1 --mysql-user=msandbox --mysql-password=msandbox --oltp-table-size=1000000 --mysql-socket=/tmp/mysql_sandbox15701.sock prepare sysbench 0.5: multi-threaded system evaluation benchmark Creating table 'sbtest1'... Inserting 1000000 records into 'sbtest1' [umshastr@hod03]~/bugs/sysbench: sysbench/sysbench --num-threads=16 --max-requests=300000 --db-driver=mysql --test=/home/umshastr/bugs/sysbench/sysbench/tests/db/oltp.lua --mysql-table-engine=InnoDB --mysql-db=sbtest1 --mysql-user=msandbox --mysql-password=msandbox --oltp-table-size=1000000 --mysql-socket=/tmp/mysql_sandbox15701.sock run sysbench 0.5: multi-threaded system evaluation benchmark Running the test with following options: Number of threads: 16 Random number generator seed is 0 and will be ignored Threads started! OLTP test statistics: queries performed: read: 4206370 write: 1201173 other: 600669 total: 6008212 transactions: 300214 (1916.67 per sec.) deadlocks: 241 (1.54 per sec.) read/write requests: 5407543 (34523.58 per sec.) other operations: 600669 (3834.87 per sec.) General statistics: total time: 156.6333s total number of events: 300214 total time taken by event execution: 2505.4769s response time: min: 2.95ms avg: 8.35ms max: 993.97ms approx. 95 percentile: 27.03ms Threads fairness: events (avg/stddev): 18763.3750/80.02 execution time (avg/stddev): 156.5923/0.00 ########## Wait for replication to catch up [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: ./use_all 'select * from sys.memory_global_total' # server: 1: total_allocated 1.40 GiB # server: 2: total_allocated 335.40 MiB [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: ps aux|grep rcsandbox_mysql-5_7_17|grep .sock|awk '{print "vsz: "$5/1024" MB","rss: "$6/1024" MB",$19}' vsz: 3843.34 MB rss: 1421.93 MB --port=15701 vsz: 1726.28 MB rss: 300.211 MB --port=15702 [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: ./n2 -e 'SHOW SLAVE STATUS\G'|grep Seconds_Behind_Master Seconds_Behind_Master: 0 [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: ./n1 -e 'select event_name, high_number_of_bytes_used/1024/1024 high_number_of_bytes_used_MB from performance_schema.memory_summary_global_by_event_name order by high_number_of_bytes_used desc limit 10;' +----------------------------------------------------------------------+------------------------------+ | event_name | high_number_of_bytes_used_MB | +----------------------------------------------------------------------+------------------------------+ | memory/sql/thd::main_mem_root | 1079.08799744 | | memory/innodb/buf_buf_pool | 131.06250000 | | memory/innodb/log0log | 32.00839996 | | memory/sql/XID | 19.00152588 | | memory/innodb/lock0lock | 14.35904694 | | memory/performance_schema/events_statements_history_long | 13.65661621 | | memory/innodb/fil0fil | 10.22176933 | | memory/performance_schema/events_statements_summary_by_digest.tokens | 9.76562500 | | memory/performance_schema/events_statements_history_long.tokens | 9.76562500 | | memory/performance_schema/events_statements_history_long.sqltext | 9.76562500 | +----------------------------------------------------------------------+------------------------------+ [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: ./n1 -e 'select thread_id tid, user, current_count_used ccu, current_allocated ca, current_avg_alloc caa, current_max_alloc cma, total_allocated from sys.memory_by_thread_by_current_bytes limit 10;' +-----+--------------------------+--------+------------+-----------+------------+-----------------+ | tid | user | ccu | ca | caa | cma | total_allocated | +-----+--------------------------+--------+------------+-----------+------------+-----------------+ | 36 | sql/slave_sql | 481654 | 1.07 GiB | 2.33 KiB | 1.05 GiB | 11.61 GiB | | 1 | sql/main | 28185 | 189.36 MiB | 6.88 KiB | 131.06 MiB | 220.49 MiB | | 67 | msandbox@localhost | 54 | 721.79 KiB | 13.37 KiB | 256.00 KiB | 755.51 KiB | | 35 | sql/slave_io | 376 | 107.74 KiB | 293 bytes | 32.01 KiB | 7.06 MiB | | 37 | rsandbox@localhost | 18 | 13.04 KiB | 742 bytes | 8.00 KiB | 62.40 KiB | | 24 | innodb/dict_stats_thread | 28 | 576 bytes | 21 bytes | 928 bytes | 6.23 MiB | | 23 | innodb/buf_dump_thread | 4 | 128 bytes | 32 bytes | 128 bytes | 609.20 KiB | | 22 | innodb/srv_worker_thread | 0 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | | 27 | sql/signal_handler | 0 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | | 29 | sql/compress_gtid_table | 0 | 0 bytes | 0 bytes | 0 bytes | 0 bytes | +-----+--------------------------+--------+------------+-----------+------------+-----------------+ [umshastr@hod03]~/sandboxes/rcsandbox_mysql-5_7_17: