############################################################################### # ==== Purpose ==== # This test verifies following for 'Log_event' event name in replica: # - Verify that current_number_of_bytes_used entry in performance schema # memory_summary_by_thread_by_event_name table is matching before and after # the transactions # - Verify that current_number_of_bytes_used entry in performance schema # memory_summary_by_thread_by_event_name and # memory_summary_global_by_event_name are matching before and after the # transactions # # ==== Requirements ==== # 1) At thread level, after the transaction, performance schema instrumented # current_number_of_bytes_used count should be same as the before count. # 2) Thread level performance schema instrumented current_number_of_bytes_used # count should match with corresponding global level count before and after # the transactions # # ==== Implementation ==== # 1. Initial setup # 2. Verify that current_number_of_bytes_used for 'memory/sql/Log_event' is # same at global and thread level # 3. Perform transactions and sync with replica # 4. Verify that current_number_of_bytes_used for 'memory/sql/Log_event' is # same at global and thread level after transactions # 5. Verify that current_number_of_bytes_used for 'memory/sql/Log_event' is # same at thread level before and after transactions # 6. Cleanup # # ==== References ==== # BUG#35546877: Memory consumption isssue ############################################################################### --source include/have_binlog_format_row.inc --source include/only_mts_replica_parallel_workers.inc --echo --echo # 1. Initial setup --source include/master-slave.inc --echo --echo # 2. Verify that current_number_of_bytes_used for 'memory/sql/Log_event' --echo # is same at global and thread level --source include/rpl_connection_slave.inc --let $thread_current_number_of_bytes_used_before = `SELECT SUM(CURRENT_NUMBER_OF_BYTES_USED) AS THREAD FROM performance_schema.memory_summary_by_thread_by_event_name WHERE EVENT_NAME = 'memory/sql/Log_event' GROUP BY EVENT_NAME` --let $global_current_number_of_bytes_used_before = `SELECT CURRENT_NUMBER_OF_BYTES_USED FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME='memory/sql/Log_event'` --let $assert_cond= [ SELECT $thread_current_number_of_bytes_used_before = $global_current_number_of_bytes_used_before] --let $assert_text= Before memory count matches --source include/assert.inc --echo --echo # 3. Perform transactions and sync with replica --source include/rpl_connection_master.inc CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY); INSERT INTO t1 VALUES (1); UPDATE t1 SET c1 = 10; DELETE FROM t1; --source include/sync_slave_sql_with_master.inc # Sleep an extra second for replica to settle --sleep 1 --echo --echo # 4. Verify that current_number_of_bytes_used for 'memory/sql/Log_event' --echo # is same at global and thread level after transactions --let $thread_current_number_of_bytes_used_after = `SELECT SUM(CURRENT_NUMBER_OF_BYTES_USED) AS THREAD FROM performance_schema.memory_summary_by_thread_by_event_name WHERE EVENT_NAME = 'memory/sql/Log_event' group by EVENT_NAME` --let $global_current_number_of_bytes_used_after = `SELECT CURRENT_NUMBER_OF_BYTES_USED FROM performance_schema.memory_summary_global_by_event_name WHERE EVENT_NAME='memory/sql/Log_event'` --let $assert_cond= [ SELECT $thread_current_number_of_bytes_used_after = $global_current_number_of_bytes_used_after] --let $assert_text= After memory count matches --source include/assert.inc --echo --echo # 5. Verify that current_number_of_bytes_used for 'memory/sql/Log_event' --echo # is same at thread level before and after transactions --let $assert_cond= [ SELECT $thread_current_number_of_bytes_used_before = $thread_current_number_of_bytes_used_after] --let $assert_text= Thread Memory count matches --source include/assert.inc --echo --echo # 6. Cleanup --source include/rpl_connection_master.inc DROP TABLE t1; --source include/rpl_end.inc