# Percona Server for MySQL 5.7 **URL:** https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=1 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 2 --- ## [Exec\_Master\_Log\_Pos always behind Read\_Master\_Log\_Pos](https://forums.percona.com/t/exec-master-log-pos-always-behind-read-master-log-pos/28021)
**Author:** [@Add](https://forums.percona.com/u/Add)\ **Replies:** 2\ **Last updated:** [January 26, 2024, 9:55am UTC](https://forums.percona.com/t/exec-master-log-pos-always-behind-read-master-log-pos/28021 "2024-01-26T09:55:21Z")
I’m checking the health of the replication comparing Exec\_Master\_Log\_Pos and Read\_Master\_Log\_Pos. All is fine in general, except on the one node we have 8.0 instead of 5.7. Exec on that node absolutely never catches up, … --- ## [mysqldump not releasing memory after completion](https://forums.percona.com/t/mysqldump-not-releasing-memory-after-completion/5441)
**Author:** [@Machiel](https://forums.percona.com/u/Machiel)\ **Replies:** 4\ **Last updated:** [December 29, 2023, 2:53pm UTC](https://forums.percona.com/t/mysqldump-not-releasing-memory-after-completion/5441 "2023-12-29T14:53:27Z")
Good day all We are running Percona server 5.7 on a server with 128Gb of Memory and 32Gb of Swap Space. We have had a lot of issues with the memory filling up and using up swap space on a daily basis requiring the data… --- ## [Pt-online-schema-change id ID](https://forums.percona.com/t/pt-online-schema-change-id-id/27121)
**Author:** [@ArtemGob](https://forums.percona.com/u/ArtemGob)\ **Replies:** 2\ **Last updated:** [December 15, 2023, 12:54am UTC](https://forums.percona.com/t/pt-online-schema-change-id-id/27121 "2023-12-15T00:54:06Z")
Hello. I used the pt-online-schema-change tool and did not understand one logic. There is a test database mybases, there is a test table sbtest1, the table has an id column (special attention that it is in lower case) … --- ## [Pstress build problem](https://forums.percona.com/t/pstress-build-problem/27139)
**Author:** [@Ani\_Ghoghoberidze](https://forums.percona.com/u/Ani_Ghoghoberidze)\ **Replies:** 3\ **Last updated:** [December 14, 2023, 7:53pm UTC](https://forums.percona.com/t/pstress-build-problem/27139 "2023-12-14T19:53:27Z")
Hi. I want to make a stress test for Percona MySQL 5.7. and want to use pstress Couldn’t fined a well documented guide how to install pstress. Using github one : pstress/README.md at master · Percona-QA/pstress · Git… --- ## [Percona server for MySQL Query Anlytics](https://forums.percona.com/t/percona-server-for-mysql-query-anlytics/27083)
**Author:** [@jayt](https://forums.percona.com/u/jayt)\ **Replies:** 2\ **Last updated:** [December 12, 2023, 3:20pm UTC](https://forums.percona.com/t/percona-server-for-mysql-query-anlytics/27083 "2023-12-12T15:20:30Z")
When I run any query from direct my database it reflect in Percona server in QAN field but when I run any query from my project, but it does not reflect in Percona server QAN. how to solve this? I want that, when i refre… --- ## [MySQL 5.7 Install](https://forums.percona.com/t/mysql-5-7-install/27088)
**Author:** [@myoungct](https://forums.percona.com/u/myoungct)\ **Replies:** 1\ **Last updated:** [December 12, 2023, 2:34pm UTC](https://forums.percona.com/t/mysql-5-7-install/27088 "2023-12-12T14:34:45Z")
The binaries for Percona MySQL 5.7 are no longer in the repo Percona Repo Is there a location I can install the legacy version from --- ## [Percona Server for MySQL 5.7.44-48 Released](https://forums.percona.com/t/percona-server-for-mysql-5-7-44-48-released/26975)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [December 6, 2023, 11:17am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-7-44-48-released/26975 "2023-12-06T11:17:39Z")
December 5, 2023 - Find release notes at Percona Server for MySQL 5.7.44-48 (2023-12-05) - Percona Server for MySQL --- ## [Possible Bug in DATA\_FREE Reporting for Partitioned Tables](https://forums.percona.com/t/possible-bug-in-data-free-reporting-for-partitioned-tables/26745)
**Author:** [@msutic](https://forums.percona.com/u/msutic)\ **Replies:** 4\ **Last updated:** [November 29, 2023, 12:36pm UTC](https://forums.percona.com/t/possible-bug-in-data-free-reporting-for-partitioned-tables/26745 "2023-11-29T12:36:52Z")
Hello, I’ve encountered a potential issue with the reporting of the DATA\_FREE value for partitioned tables in MySQL (5.7.42-46). When I run SHOW TABLE STATUS LIKE 'testtab'; , I get a DATA\_FREE value of 47555018752 . H… --- ## [Changing Synchronous Node To Asynchronous](https://forums.percona.com/t/changing-synchronous-node-to-asynchronous/25889)
**Author:** [@shahidbashir7861](https://forums.percona.com/u/shahidbashir7861)\ **Replies:** 2\ **Last updated:** [November 20, 2023, 4:32pm UTC](https://forums.percona.com/t/changing-synchronous-node-to-asynchronous/25889 "2023-11-20T16:32:55Z")
Hello, I have a node in Percoran Xtradb cluster that I want to change to asynchronous replication due to slowness reasons. I have binary logs enabled on the node that will act as master. I want to know what configuraton… --- ## [To know number of avg transactions and avg inserts hourly/daily in mysql database](https://forums.percona.com/t/to-know-number-of-avg-transactions-and-avg-inserts-hourly-daily-in-mysql-database/26507)
**Author:** [@virin\_t](https://forums.percona.com/u/virin_t)\ **Replies:** 4\ **Last updated:** [November 14, 2023, 11:10pm UTC](https://forums.percona.com/t/to-know-number-of-avg-transactions-and-avg-inserts-hourly-daily-in-mysql-database/26507 "2023-11-14T23:10:46Z")
Hi I would like to get avg number of inserts hourly and also avgg number of transactions running in database We have performace\_schema enabled but need confirmation of other possible ways to get , may triggers or using… --- ## [Mysqlstat is a command-line tool designed for real-time monitoring and analysis of performance metrics and related information of MySQL servers](https://forums.percona.com/t/mysqlstat-is-a-command-line-tool-designed-for-real-time-monitoring-and-analysis-of-performance-metrics-and-related-information-of-mysql-servers/26247)
**Author:** [@hiller1231](https://forums.percona.com/u/hiller1231)\ **Replies:** 2\ **Last updated:** [October 31, 2023, 6:18am UTC](https://forums.percona.com/t/mysqlstat-is-a-command-line-tool-designed-for-real-time-monitoring-and-analysis-of-performance-metrics-and-related-information-of-mysql-servers/26247 "2023-10-31T06:18:37Z")
mysqlstat is a command-line tool designed for real-time monitoring and analysis of performance metrics and related information of MySQL servers. It assists DBAs (Database Administrators) and developers in identifying an… --- ## [Mysql, percona, backup](https://forums.percona.com/t/mysql-percona-backup/26209)
**Author:** [@Riktofer\_Ssr](https://forums.percona.com/u/Riktofer_Ssr)\ **Replies:** 1\ **Last updated:** [October 30, 2023, 2:34pm UTC](https://forums.percona.com/t/mysql-percona-backup/26209 "2023-10-30T14:34:22Z")
Hello everyone. I’m using MySQL 5.7 and recently installed PMM monitoring to monitor database performance. My question is regarding the “Backup” option. The documentation states that, currently, backup functionality is … --- ## [\[SOLVED\] \[but painfully\] Keyring\_vault.conf file is NOT a conf file](https://forums.percona.com/t/solved-but-painfully-keyring-vault-conf-file-is-not-a-conf-file/6716)
**Author:** [@fthu](https://forums.percona.com/u/fthu)\ **Replies:** 3\ **Last updated:** [October 13, 2023, 9:09am UTC](https://forums.percona.com/t/solved-but-painfully-keyring-vault-conf-file-is-not-a-conf-file/6716 "2023-10-13T09:09:02Z")
I’ve spent the whole night struggling to have our production server restart… After we had to reboot the linux server, the mysql server didn’t restart. It quickly turned out that the vault token had expired - so I commen… --- ## [Calculate PK usage for tables with composite key as Primary key](https://forums.percona.com/t/calculate-pk-usage-for-tables-with-composite-key-as-primary-key/25612)
**Author:** [@virin\_t](https://forums.percona.com/u/virin_t)\ **Replies:** 5\ **Last updated:** [October 11, 2023, 1:22pm UTC](https://forums.percona.com/t/calculate-pk-usage-for-tables-with-composite-key-as-primary-key/25612 "2023-10-11T13:22:34Z")
Hi, I am trying to get primary % used on table in percona mysql 5.7 version db, it is straight when there a only one column as Primary Key. but, what is correct approach when , I have table where primary is on two colu… --- ## [Issue with max\_execution\_time and innodb\_thread\_concurrency variable during spike in active DB threads](https://forums.percona.com/t/issue-with-max-execution-time-and-innodb-thread-concurrency-variable-during-spike-in-active-db-threads/24927)
**Author:** [@pravata\_dash](https://forums.percona.com/u/pravata_dash)\ **Replies:** 6\ **Last updated:** [September 13, 2023, 6:49am UTC](https://forums.percona.com/t/issue-with-max-execution-time-and-innodb-thread-concurrency-variable-during-spike-in-active-db-threads/24927 "2023-09-13T06:49:21Z")
Context: Our application experienced a problem that caused the number of active threads to increase dramatically, reaching a level that was 100 times higher than normal. This led to an outage. Impact: The number of acti… --- ## [Pt-online-schema-change: Alternatives to "REPLACE INTO"](https://forums.percona.com/t/pt-online-schema-change-alternatives-to-replace-into/24996)
**Author:** [@mani.swami](https://forums.percona.com/u/mani.swami)\ **Replies:** 3\ **Last updated:** [September 9, 2023, 12:35am UTC](https://forums.percona.com/t/pt-online-schema-change-alternatives-to-replace-into/24996 "2023-09-09T00:35:21Z")
Hello, I was looking into the source code for pt-online-schema-change here: https://github.com/percona/percona-toolkit/blob/3.x/bin/pt-online-schema-change#L11417). I noticed that the After Update trigger is doing a REP… --- ## [MySQL 5.7 to 8.0 Upgrade](https://forums.percona.com/t/mysql-5-7-to-8-0-upgrade/24787)
**Author:** [@ahmadzadaa](https://forums.percona.com/u/ahmadzadaa)\ **Replies:** 5\ **Last updated:** [August 30, 2023, 7:47pm UTC](https://forums.percona.com/t/mysql-5-7-to-8-0-upgrade/24787 "2023-08-30T19:47:56Z")
Hi All, can you please let me know how important following “And remember you should be using the four-byte UTF8MB4 character set,” ? from https://www.percona.com/blog/mysql-5-7-to-8-0-upgrade-in-place-or-logical-upgrade/ … --- ## [Why is Percona-Server-shared-compat-57 a dependency of Percona-Server-client-57?](https://forums.percona.com/t/why-is-percona-server-shared-compat-57-a-dependency-of-percona-server-client-57/24603)
**Author:** [@resuni](https://forums.percona.com/u/resuni)\ **Replies:** 6\ **Last updated:** [August 24, 2023, 9:52pm UTC](https://forums.percona.com/t/why-is-percona-server-shared-compat-57-a-dependency-of-percona-server-client-57/24603 "2023-08-24T21:52:00Z")
Hello, We’re running Percona 5.7 on RHEL 8. When using dnf to install Percona from the yum repos, it wants to install Percona-Server-shared-compat-57. $ sudo dnf install Percona-Server-server-57 Last metadata expiratio… --- ## [my.cnf vars evaluated before plugin](https://forums.percona.com/t/my-cnf-vars-evaluated-before-plugin/5617)
**Author:** [@guido.iaquinti](https://forums.percona.com/u/guido.iaquinti)\ **Replies:** 1\ **Last updated:** [August 6, 2023, 8:50pm UTC](https://forums.percona.com/t/my-cnf-vars-evaluated-before-plugin/5617 "2023-08-06T20:50:32Z")
MySQL fails to start on new installations if my.cnf contains an option that depends on a plugin. # my.cnf plugin-load = QUERY\_RESPONSE\_TIME\_AUDIT=query\_response\_time.so;QUERY\_RESPONSE\_TIME\_READ=query\_response\_time.so;Q… --- ## [Planning migration from MySQL 5.7 to 8.0](https://forums.percona.com/t/planning-migration-from-mysql-5-7-to-8-0/21778)
**Author:** [@joe.brockmeier](https://forums.percona.com/u/joe.brockmeier)\ **Replies:** 5\ **Last updated:** [July 25, 2023, 1:05am UTC](https://forums.percona.com/t/planning-migration-from-mysql-5-7-to-8-0/21778 "2023-07-25T01:05:04Z")
The upstream MySQL 5.7 release will be end of life in October 2023. David Stokes has a blog post about the upcoming EOL and suggestions for managing your upgrade from 5.7 to 8.0. We’d love to hear from users still on 5.… --- ## [Pt-osc on mysql version 5.7](https://forums.percona.com/t/pt-osc-on-mysql-version-5-7/23823)
**Author:** [@virin\_t](https://forums.percona.com/u/virin_t)\ **Replies:** 2\ **Last updated:** [July 22, 2023, 7:06am UTC](https://forums.percona.com/t/pt-osc-on-mysql-version-5-7/23823 "2023-07-22T07:06:57Z")
Hi, I did a pt-osc for a table, as pre check I can confirm that there no triggers on table using SELECT TRIGGER\_NAME FROM INFORMATION\_SCHEMA.TRIGGERS WHERE TRIGGER\_SCHEMA=‘’ AND event\_object\_table=‘ ’; However, after ex… --- ## [Strange replication's stuck](https://forums.percona.com/t/strange-replications-stuck/23382)
**Author:** [@Deniska80](https://forums.percona.com/u/Deniska80)\ **Replies:** 10\ **Last updated:** [July 6, 2023, 10:45am UTC](https://forums.percona.com/t/strange-replications-stuck/23382 "2023-07-06T10:45:17Z")
Hello, i’ve got strange situation with gtid replication. I’ve single master and 3 replicas, all’s went well for years. But suddenly, i notice, that Replication lag grows on all my replicas, while Slave\_IO\_Running and S… --- ## [During restore steps, how do you stop and start your node in k8s cluster](https://forums.percona.com/t/during-restore-steps-how-do-you-stop-and-start-your-node-in-k8s-cluster/23109)
**Author:** [@shrishail](https://forums.percona.com/u/shrishail)\ **Replies:** 1\ **Last updated:** [June 27, 2023, 1:01pm UTC](https://forums.percona.com/t/during-restore-steps-how-do-you-stop-and-start-your-node-in-k8s-cluster/23109 "2023-06-27T13:01:11Z")
I have deployed xtradb clusters in k8s env say cluster1 and cluster2 cluster1 will use for backup cluster2 will use for restore As a backup process, I will take backup from node1 of cluster1 successfully generates ba… --- ## [Show Slave Status - Impossible coordinates?](https://forums.percona.com/t/show-slave-status-impossible-coordinates/22707)
**Author:** [@ChrisDK](https://forums.percona.com/u/ChrisDK)\ **Replies:** 2\ **Last updated:** [June 9, 2023, 7:07pm UTC](https://forums.percona.com/t/show-slave-status-impossible-coordinates/22707 "2023-06-09T19:07:44Z")
Recently I have a replication node that has errored. I noticed something that I think is impossible, but want to confirm: The coordinates in the show slave status command seems impossible. Please note both IO and SQL t… --- ## [Got fatal error 1236 from master when reading data from binary log](https://forums.percona.com/t/got-fatal-error-1236-from-master-when-reading-data-from-binary-log/22683)
**Author:** [@ChrisDK](https://forums.percona.com/u/ChrisDK)\ **Replies:** 3\ **Last updated:** [June 9, 2023, 2:45pm UTC](https://forums.percona.com/t/got-fatal-error-1236-from-master-when-reading-data-from-binary-log/22683 "2023-06-09T14:45:39Z")
Hello. This is the error I see when running ‘show slave status’. Got fatal error 1236 from master when reading data from binary log: ‘log event entry exceeded max\_allowed\_packet; Increase max\_allowed\_packet on master; … --- ## [Disk Divergence across Master and Slaves](https://forums.percona.com/t/disk-divergence-across-master-and-slaves/14022)
**Author:** [@sachin\_japate](https://forums.percona.com/u/sachin_japate)\ **Replies:** 18\ **Last updated:** [June 5, 2023, 5:26pm UTC](https://forums.percona.com/t/disk-divergence-across-master-and-slaves/14022 "2023-06-05T17:26:17Z")
We have deployed MySQL cluster version - 5.7.22-22 on Debian GNU/Linux 9, 1 Master, and 2 replicas(slaves). From the hardware, software, and MySQL configuration point of view, all the instances are identical. Both the sl… --- ## [What are "Explicit LOCK TABLES" and "Fast Hash UDFs"?](https://forums.percona.com/t/what-are-explicit-lock-tables-and-fast-hash-udfs/22493)
**Author:** [@jshirley](https://forums.percona.com/u/jshirley)\ **Replies:** 1\ **Last updated:** [June 1, 2023, 8:59pm UTC](https://forums.percona.com/t/what-are-explicit-lock-tables-and-fast-hash-udfs/22493 "2023-06-01T20:59:16Z")
Hello, I am trying to compare the differences between 2 mysql percona instances and noticed 2 differences being reported by pt-mysql-summary: Explicit LOCK TABLES Fast Hash UDFs What I would like to understand is wha… --- ## [Percona Server for MySQL 5.7.42-46 Released](https://forums.percona.com/t/percona-server-for-mysql-5-7-42-46-released/22475)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [June 1, 2023, 11:04am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-7-42-46-released/22475 "2023-06-01T11:04:18Z")
June 01, 2023 - Find release notes at Percona Server for MySQL 5.7.42-46 (2023-06-01) - Percona Server for MySQL --- ## [Backup MySQL using LVM snapshot](https://forums.percona.com/t/backup-mysql-using-lvm-snapshot/16778)
**Author:** [@sachin\_japate](https://forums.percona.com/u/sachin_japate)\ **Replies:** 7\ **Last updated:** [May 24, 2023, 11:28am UTC](https://forums.percona.com/t/backup-mysql-using-lvm-snapshot/16778 "2023-05-24T11:28:28Z")
Hi, We are running 3 nodes (VM) cluster, 1 Master and 2 Replicas, replicas are enabled with multi-threaded NON-GTID replication. slave\_parallel\_workers = 8 and slave\_parallel\_type = LOGICAL\_CLOCK. We take a backup from … --- ## [Compilation issue Mac Ventura & Percona Server 5.7.26-29](https://forums.percona.com/t/compilation-issue-mac-ventura-percona-server-5-7-26-29/22125)
**Author:** [@Nathan\_Janken](https://forums.percona.com/u/Nathan_Janken)\ **Replies:** 0\ **Last updated:** [May 18, 2023, 7:17am UTC](https://forums.percona.com/t/compilation-issue-mac-ventura-percona-server-5-7-26-29/22125 "2023-05-18T07:17:30Z")
I am having some trouble compiling Percona Server 5.7.26-29 on a Mac running the Ventura OS and I’m hoping someone can help. I’ve tried following the instructions But neither of them seem to work. I have done this b… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=2)