Description:
I have a stand alone server:
mysql> show slave status\G
Empty set, 1 warning (0.01 sec)
mysql>
When starting the agent the delay monitor show 1.5year delay.
pmm-agent --version
ProjectName: pmm-agent
Version: 2.32.0
PMMVersion: 2.32.0
my.cnf
[mysql]
socket=/data/mysql/mysql.sock
[mysqld]
# PMM
performance_schema=ON
performance-schema-instrument='statement/%=ON'
performance-schema-consumer-statements-digest=ON
innodb_monitor_enable=all
skip-name-resolve
default-authentication-plugin=mysql_native_password
datadir=/data/mysql
socket=/data/mysql/mysql.sock
log-error=/var/log/mysql/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
pid-file=/var/run/mysqld/mysqld.pid
slow_query_log_file=/var/log/mysqlslow.log
slow_query_log=1
long_query_time=1
log_queries_not_using_indexes=1
innodb-buffer-pool-size = 4G
innodb_file_per_table=1
max_connections = 2048
server-id=1111111
log-bin=pushdb-bin
expire-logs-days=7
gtid-mode=ON
enforce-gtid-consistency=true
### enable for all schemes (Alexey)
#binlog-do-db=notif_android
#binlog-do-db=notif_ios
#binlog-do-db=notif_web
tmp_table_size=2G
max_heap_table_size=2G
Any idea what need to be configure?
TX
