hunterhuang8810

How to generate QPS/TPS metrics with postgres_exporter?

4

Hi, I'm using postgres_exporter in our production database, I prefer to know is there methd to generate QPS/TPS metrics for Postgres instance? or via extend.query-path how to achieve that? Thanks...

postgres replication state metrics

4

Hi expert, to monitor mysql replication stopped or not, mysql_exporter has metrics IO_THREADS_STATUS and SQL_THREAD_STATUS . is there same metris in postgresql to check is the pg replication work well?...

Adding new metrics via a config file problem

2

Hi Team, From doc I see we can add new metrics via config file: Adding new metrics via a config file The -extend.query-path command-line argument specifies a YAML file containing...

gh-ost completed success but print Errors

2

I used below command to add column to table: gh-ost --chunk-size=200000 --host=x.x.x.x --verbose --timestamp-old-table --ask-pass --port=xxx--user=dbauser --database=game_usercenter_01 --table=game_player_10 --allow-on-master --ok-to-drop-table --max-lag-millis=100 --alter="add column game_mode tinyint(4) DEFAULT '0' COMMENT 'xxx'" --execute...