# Slow "SHOW BINARY LOGS" @8.0.23 server

**URL:** <https://forums.percona.com/t/slow-show-binary-logs-8-0-23-server/10564>\
**Category:** Percona Server for MySQL 8.0\
**Created:** [May 24, 2021, 7:49am UTC](https://forums.percona.com/t/slow-show-binary-logs-8-0-23-server/10564 "2021-05-24T07:49:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jiri\_Sula](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jiri_sula/32/4770_2.png) [@Jiri\_Sula](https://forums.percona.com/u/Jiri_Sula)\
**Post date:** [May 24, 2021, 7:49am UTC](https://forums.percona.com/t/slow-show-binary-logs-8-0-23-server/10564/1 "2021-05-24T07:49:04Z")

</div>

Dear all,  
after upgrading into 8.0.23 we are facing pretty frequent slow log spamming (via pmm client) and even executing by hand “SHOW BINARY LOGS” took very long time (5-10seconds). I tried to profile this query, looks like 99.9% of time is during “starting” phase.  
Any ideas how can I improve this or is it already known bug? Number of binlog files in output is not that huge (\<500).  
Thank you, very appreciated!  
Jiri

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [May 24, 2021, 1:11pm UTC](https://forums.percona.com/t/slow-show-binary-logs-8-0-23-server/10564/2 "2021-05-24T13:11:08Z")

</div>

Hi @Jiri_Sula , thank you for posting your question on the Percona forums!  
You can set the frequency that the data is collected by modifying the metrics resolution parameter:

> **[Configure - Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/how-to/configure.html)**
>
> Documentation

`SHOW BINARY LOGS` is designed to list the names and sizes of each binary log on disk. If you are seeing 5-10 seconds then it sounds like you may need to look at your disk performance, as that duration to list ~500 files is excessive.  
[https://dev.mysql.com/doc/refman/8.0/en/show-binary-logs.html](https://dev.mysql.com/doc/refman/8.0/en/show-binary-logs.html)

---

<div class="post-metadata">

**Author:** ![Jiri\_Sula](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jiri_sula/32/4770_2.png) [@Jiri\_Sula](https://forums.percona.com/u/Jiri_Sula)\
**Post date:** [May 26, 2021, 8:50am UTC](https://forums.percona.com/t/slow-show-binary-logs-8-0-23-server/10564/3 "2021-05-26T08:50:04Z")

</div>

Hello, Michael!  
Thank you for your interest!  
Disk is in 100% condition, change appeared with upgrading into 8.0.23, no trace about it in previous versions. As far as downgrade is not possible, we need to adjust pmm settings (till 8.0.24 is out there). Thanks!  
Jiri

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [May 26, 2021, 12:38pm UTC](https://forums.percona.com/t/slow-show-binary-logs-8-0-23-server/10564/4 "2021-05-26T12:38:08Z")

</div>