リアルタイム表示ツール

DB

 

(8.0.29)

https://ja.getdocs.org/how-to-use-mytop-to-monitor-mysql-performance

mytop


yum install epel-release -y

yum install mytop -y

vim /root/.mytop

host=localhost
db=test
delay=5
port=3306
socket=
batchmode=0
color=1
idle=1

※下記エラー回避のための追加設定
Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: 共有オブジェクトファイルを開けません: そのようなファイルやディレクトリはありません

alter user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';


mytop --prompt

 

(19c)
https://www.usn-it.de/2019/09/30/oratop-in-oracle-19c/
https://www.intellilink.co.jp/column/oracle/2014/122500.aspx
https://pankajconnect.medium.com/oratop-tool-real-time-database-performance-monitoring-tool-c592c5fa824e


oratop

cd $ORACLE_HOME/suptools/oratop

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

./oratop -i 5 / as sysdba

 

(14)
https://severalnines.com/blog/dynamic-monitoring-postgresql-instances-using-pgtop/
http://pgsqldeepdive.blogspot.com/2012/12/postgresqltoppgtop.html


pg_top


dnf install epel-release
dnf install pg_top

 

pg_top -h 127.0.0.1 -p 5432 -d test -U postgres

 

 

 

 

(2019)

https://docs.microsoft.com/ja-jp/sql/relational-databases/performance/performance-monitoring-and-tuning-tools?view=sql-server-ver15

SQL Server Management Studio の利用状況モニター