# PMM shows 1.5years replication delay for a stand alone server

**URL:** <https://forums.percona.com/t/pmm-shows-1-5years-replication-delay-for-a-stand-alone-server/28489>\
**Category:** PMM 2.x\
**Created:** [February 15, 2024, 12:37pm UTC](https://forums.percona.com/t/pmm-shows-1-5years-replication-delay-for-a-stand-alone-server/28489 "2024-02-15T12:37:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Roni\_Alboim](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roni_alboim/32/12405_2.png) [@Roni\_Alboim](https://forums.percona.com/u/Roni_Alboim)\
**Post date:** [February 15, 2024, 12:37pm UTC](https://forums.percona.com/t/pmm-shows-1-5years-replication-delay-for-a-stand-alone-server/28489/1 "2024-02-15T12:37:34Z")

</div>

## Description:

I have a stand alone server:

```auto
mysql> show slave status\G
Empty set, 1 warning (0.01 sec)

mysql>

```

When starting the agent the delay monitor show 1.5year delay.

```auto
pmm-agent --version
ProjectName: pmm-agent
Version: 2.32.0
PMMVersion: 2.32.0

```

**my.cnf**

```auto
[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

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [February 16, 2024, 3:05pm UTC](https://forums.percona.com/t/pmm-shows-1-5years-replication-delay-for-a-stand-alone-server/28489/2 "2024-02-16T15:05:34Z")

</div>

Hi Roni, you might be hitting a bug with the expression used in the graph. Can you show us exactly where do you see the 1.5 delay being reported?

---

<div class="post-metadata">

**Author:** ![Roni\_Alboim](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/roni_alboim/32/12405_2.png) [@Roni\_Alboim](https://forums.percona.com/u/Roni_Alboim)\
**Post date:** [February 18, 2024, 5:31am UTC](https://forums.percona.com/t/pmm-shows-1-5years-replication-delay-for-a-stand-alone-server/28489/3 "2024-02-18T05:31:51Z")

</div>

![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/9/942d3dcff507aa5738f69b239d4ac0d3fa6d48b6.png)

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [February 19, 2024, 11:37am UTC](https://forums.percona.com/t/pmm-shows-1-5years-replication-delay-for-a-stand-alone-server/28489/4 "2024-02-19T11:37:20Z")

</div>

Hi Roni, that one doesn’t look like one of the PMM built-in dashboards as far as I can tell. Can you share the expression for the metric you are using?