redo出力量確認

DB

(8.0.22)

Innodb_os_log_written
→The number of bytes written to the InnoDB redo log files.

show status where Variable_name like 'Innodb_os_log_written';

 

(19c)

select b.value
from v$statname a, v$sysstat b
where a.statistic# = b.statistic#
and a.name = 'redo size'
;

select * from v$log_history;

 

(13)

select pg_current_wal_insert_lsn();
select pg_current_wal_lsn();
select pg_current_wal_flush_lsn();

select pg_walfile_name_offset(pg_current_wal_insert_lsn());
select pg_walfile_name_offset(pg_current_wal_lsn());
select pg_walfile_name_offset(pg_current_wal_flush_lsn());


select pg_wal_lsn_diff('2/D8644000', '2/B5444978')/1024/1024 mb;

-- WALディレクトリ内のファイルの名前、サイズ、最終更新時刻を一覧表示します
select pg_ls_waldir();

(2019)

https://docs.microsoft.com/ja-jp/sql/t-sql/database-console-commands/dbcc-sqlperf-transact-sql?view=sql-server-ver15#Remarks
https://www.fenet.jp/dotnet/column/tool/1620/

select * from sys.dm_db_log_space_usage;

 

-- 実行中トランザクションのredo出力量確認
select transaction_id, database_id,database_transaction_log_bytes_used from sys.dm_tran_database_transactions