# Percona Server for MySQL 5.7 **URL:** https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=3 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 4 --- ## [Percona Server for MySQL 5.7.38-41 Released](https://forums.percona.com/t/percona-server-for-mysql-5-7-38-41-released/16014)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [June 7, 2022, 8:43am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-7-38-41-released/16014 "2022-06-07T08:43:06Z")
June 2, 2022 - Find release notes at Percona Server for MySQL 5.7.38-41 (2022-06-02) --- ## [Mysql.innodb\_table\_stats & mysql.innodb\_index\_stats not updating](https://forums.percona.com/t/mysql-innodb-table-stats-mysql-innodb-index-stats-not-updating/15181)
**Author:** [@Jamie\_Downs](https://forums.percona.com/u/Jamie_Downs)\ **Replies:** 1\ **Last updated:** [May 3, 2022, 6:43pm UTC](https://forums.percona.com/t/mysql-innodb-table-stats-mysql-innodb-index-stats-not-updating/15181 "2022-05-03T18:43:20Z")
Hello, I believe I have persitent stats configured correctly and there are records in INFORMATION\_SCHEMA.STATISTICS table but the following tables have no data for many of the tables/indexes. mysql.innodb\_table\_stats & … --- ## [2 Nodes failing to reconnect to the cluster, after restart](https://forums.percona.com/t/2-nodes-failing-to-reconnect-to-the-cluster-after-restart/12964)
**Author:** [@ppitta](https://forums.percona.com/u/ppitta)\ **Replies:** 2\ **Last updated:** [April 26, 2022, 8:19am UTC](https://forums.percona.com/t/2-nodes-failing-to-reconnect-to-the-cluster-after-restart/12964 "2022-04-26T08:19:36Z")
Hi, i have cluster of 3 nodes, for some reasons the the infrastructure went done, and it has been done for some time. now i’m attempting to bring back the cluster. 1 node have been bootstrapped but reconnecting other t… --- ## [AWS KMS encryption](https://forums.percona.com/t/aws-kms-encryption/9357)
**Author:** [@Robert\_Gates](https://forums.percona.com/u/Robert_Gates)\ **Replies:** 4\ **Last updated:** [April 13, 2022, 10:11pm UTC](https://forums.percona.com/t/aws-kms-encryption/9357 "2022-04-13T22:11:31Z")
I’ve read various articles that suggest an AWS KMS keyring being made available for percona 5.7. Is there any work in progress here? If I wish to encrypt my tables with KMS what are my options? --- ## [Get wsrep version](https://forums.percona.com/t/get-wsrep-version/15094)
**Author:** [@stofa.kenida](https://forums.percona.com/u/stofa.kenida)\ **Replies:** 1\ **Last updated:** [April 7, 2022, 1:59am UTC](https://forums.percona.com/t/get-wsrep-version/15094 "2022-04-07T01:59:53Z")
Hi There, How is it possible to retrieve the wsep version used in Percona Xtradb release. By reading the variables status wsrep\_provider\_version is not giving the full information. SHOW GLOBAL STATUS LIKE ‘wsrep\_pr… --- ## [MySQL 5.7 parallel replication](https://forums.percona.com/t/mysql-5-7-parallel-replication/14935)
**Author:** [@caseyrubick](https://forums.percona.com/u/caseyrubick)\ **Replies:** 1\ **Last updated:** [March 28, 2022, 5:19pm UTC](https://forums.percona.com/t/mysql-5-7-parallel-replication/14935 "2022-03-28T17:19:42Z")
Hello, could you please help with setting up parallel replication? Currently I tried a lot of things. Here is my master configuratuion on slave: slave\_parallel\_workers=8 slave\_parallel\_type=LOGICAL\_CLOCK slave-preser… --- ## [Percona Server 5.7.37 release date](https://forums.percona.com/t/percona-server-5-7-37-release-date/14891)
**Author:** [@Hammad](https://forums.percona.com/u/Hammad)\ **Replies:** 1\ **Last updated:** [March 25, 2022, 3:35pm UTC](https://forums.percona.com/t/percona-server-5-7-37-release-date/14891 "2022-03-25T15:35:19Z")
Hello, We are currently using Percona server 5.7.19 and as per Oracle Advisory (Oracle Critical Patch Update Advisory - January 2022), MySQL 5.7.36 and prior versions are affected by multiple vulnerabilities and your la… --- ## [Wrong index chosen](https://forums.percona.com/t/wrong-index-chosen/13263)
**Author:** [@Jamie\_Downs](https://forums.percona.com/u/Jamie_Downs)\ **Replies:** 9\ **Last updated:** [February 16, 2022, 7:11pm UTC](https://forums.percona.com/t/wrong-index-chosen/13263 "2022-02-16T19:11:28Z")
Hello, I would truely appreciate any pointers on this as I’m out of ideas. I have the following query, schema and plan. There are about 18 million records in the table and last week the optimizer chose to use the dele… --- ## [Identify MySQL query for read & write](https://forums.percona.com/t/identify-mysql-query-for-read-write/14431)
**Author:** [@venkatesh](https://forums.percona.com/u/venkatesh)\ **Replies:** 1\ **Last updated:** [February 16, 2022, 3:46pm UTC](https://forums.percona.com/t/identify-mysql-query-for-read-write/14431 "2022-02-16T15:46:55Z")
Hi, I have a scenario where 3 MySQL database server nodes are maintained and currently the writes are performed to all the 3 nodes. Ideally, I’m assuming to handle the write to a single node and read to the other 2 nod… --- ## [Bullseye repo for Percona 5.7?](https://forums.percona.com/t/bullseye-repo-for-percona-5-7/13002)
**Author:** [@maartenlyssens](https://forums.percona.com/u/maartenlyssens)\ **Replies:** 7\ **Last updated:** [February 16, 2022, 1:41pm UTC](https://forums.percona.com/t/bullseye-repo-for-percona-5-7/13002 "2022-02-16T13:41:10Z")
Hi, I noticed that there are currently no percona-server 5.7 (mysql) packages for Debian bullseye: https://repo.percona.com/ps-57/apt/pool/main/p/percona-server-5.7/ Is there any idea when these packages will be releas… --- ## [Unable to install Percona MySQL 5.7.x software on Debian 10 buster](https://forums.percona.com/t/unable-to-install-percona-mysql-5-7-x-software-on-debian-10-buster/14281)
**Author:** [@jbiancot](https://forums.percona.com/u/jbiancot)\ **Replies:** 3\ **Last updated:** [February 8, 2022, 3:22pm UTC](https://forums.percona.com/t/unable-to-install-percona-mysql-5-7-x-software-on-debian-10-buster/14281 "2022-02-08T15:22:28Z")
Hi, I am unable to install Percona MySQL 5.7.x software “Client, Common, etc” on Debian 10 buster. I have used these command a bunch of times on different servers, but now this is failing? apt install gnupg2 wget htt… --- ## [Enabling TokuDB in Docker with custom config](https://forums.percona.com/t/enabling-tokudb-in-docker-with-custom-config/14192)
**Author:** [@dockerhelp34534](https://forums.percona.com/u/dockerhelp34534)\ **Replies:** 2\ **Last updated:** [February 1, 2022, 4:28pm UTC](https://forums.percona.com/t/enabling-tokudb-in-docker-with-custom-config/14192 "2022-02-01T16:28:16Z")
I’m using docker-compose to build my stack. Mysql will throw an error if you have references to tokudb\_ in the config before TokuDB is enabled, so how do I enable TokuDB and then use my own config? --- ## [Unable to install myrocks storage engine on percona-server 5.7](https://forums.percona.com/t/unable-to-install-myrocks-storage-engine-on-percona-server-5-7/14135)
**Author:** [@Saaharjit\_Singh](https://forums.percona.com/u/Saaharjit_Singh)\ **Replies:** 7\ **Last updated:** [January 31, 2022, 12:22am UTC](https://forums.percona.com/t/unable-to-install-myrocks-storage-engine-on-percona-server-5-7/14135 "2022-01-31T00:22:36Z")
Hi, I wanted to test out the myrocks storage engine with percona -server5.7. I am trying to follow the instructions listed here but I keep running into the error below. We are currently running Server version: 5.7.23-25… --- ## [Failure in systemd while using auth\_pam\_compat](https://forums.percona.com/t/failure-in-systemd-while-using-auth-pam-compat/13944)
**Author:** [@Alex\_Tkachuk](https://forums.percona.com/u/Alex_Tkachuk)\ **Replies:** 3\ **Last updated:** [January 17, 2022, 2:09pm UTC](https://forums.percona.com/t/failure-in-systemd-while-using-auth-pam-compat/13944 "2022-01-17T14:09:50Z")
There is a piece of code in init.d script that checks if mysql is operational. /etc/init.d/mysql 128 if ! $(mysqladmin --no-defaults --socket=“$socket” --user=UNKNOWN\_MYSQL\_USER ping &\>/dev/null) ;then 129 … --- ## [Percona Server for MySQL 5.7.36-39 Released](https://forums.percona.com/t/percona-server-for-mysql-5-7-36-39-released/13619)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [December 23, 2021, 6:19am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-7-36-39-released/13619 "2021-12-23T06:19:01Z")
December 22, 2021 - Find release notes at Percona Server for MySQL 5.7.36-39 — Percona Server 5.7 Documentation --- ## [Database backup restoration getting corrupted](https://forums.percona.com/t/database-backup-restoration-getting-corrupted/13593)
**Author:** [@Rahul\_Kanaujia](https://forums.percona.com/u/Rahul_Kanaujia)\ **Replies:** 4\ **Last updated:** [December 22, 2021, 1:57pm UTC](https://forums.percona.com/t/database-backup-restoration-getting-corrupted/13593 "2021-12-22T13:57:09Z")
Hi I am using Percona-MySQL 5.7.13 community edition. We have taken backup from production server and trying to restore it on one of our broken slave server. xtrabackup version is 2.4.4 OS: RHEL - 6 Backup command: … --- ## [Mysql hangs and crashes eventually](https://forums.percona.com/t/mysql-hangs-and-crashes-eventually/13415)
**Author:** [@GeertM](https://forums.percona.com/u/GeertM)\ **Replies:** 2\ **Last updated:** [December 17, 2021, 9:24am UTC](https://forums.percona.com/t/mysql-hangs-and-crashes-eventually/13415 "2021-12-17T09:24:58Z")
Hello, we have a 5.6 master and 5.7 slave The 5.7 slave hangs after some time and crashes some time later We have this message in the error log of the slave: SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation coun… --- ## [Too many open tables and increasing indefinately](https://forums.percona.com/t/too-many-open-tables-and-increasing-indefinately/13163)
**Author:** [@Hussain\_Patel](https://forums.percona.com/u/Hussain_Patel)\ **Replies:** 19\ **Last updated:** [December 17, 2021, 12:17am UTC](https://forums.percona.com/t/too-many-open-tables-and-increasing-indefinately/13163 "2021-12-17T00:17:36Z")
Hi Team, i am facing issue where the tables keep on opening and reaches a limit and server hangs Server version: 5.7.31-34-log Percona Server (GPL), Release 34, Revision 2e68637 Can you guide if there is any bug in th… --- ## [Security issues in 5.7.35](https://forums.percona.com/t/security-issues-in-5-7-35/12850)
**Author:** [@ScottGrantham](https://forums.percona.com/u/ScottGrantham)\ **Replies:** 5\ **Last updated:** [December 16, 2021, 4:29pm UTC](https://forums.percona.com/t/security-issues-in-5-7-35/12850 "2021-12-16T16:29:40Z")
Hello Percona, When can we expect the Percona build of MySQL 5.7.36? There are some critical vulnerabilities noted for 5.7.35. https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-36.html Thank you. --- ## [Cannot install/find percona-server-server-5.7](https://forums.percona.com/t/cannot-install-find-percona-server-server-5-7/13485)
**Author:** [@sspown](https://forums.percona.com/u/sspown)\ **Replies:** 2\ **Last updated:** [December 15, 2021, 2:27pm UTC](https://forums.percona.com/t/cannot-install-find-percona-server-server-5-7/13485 "2021-12-15T14:27:12Z")
hi, i use this tutorial: Installing Percona Server for MySQL on Debian and Ubuntu — Percona Server 8.0 Documentation and on 5 step have a problem: # sudo apt-get install percona-server-server-5.7 Reading package lists… --- ## [Toku Hot Backup 5.7.35-38 fails with copier.cc:174 copy error fname=/mysql/proc.MYD r=28](https://forums.percona.com/t/toku-hot-backup-5-7-35-38-fails-with-copier-cc-174-copy-error-fname-mysql-proc-myd-r-28/13484)
**Author:** [@zentavr](https://forums.percona.com/u/zentavr)\ **Replies:** 1\ **Last updated:** [December 15, 2021, 10:14am UTC](https://forums.percona.com/t/toku-hot-backup-5-7-35-38-fails-with-copier-cc-174-copy-error-fname-mysql-proc-myd-r-28/13484 "2021-12-15T10:14:51Z")
Suddenly TokuDB Hot Backup started to fail at one of our servers. While we set up set tokudb\_backup\_dir='/home/bacula/mysql/2021-12-14\_22-08-49/'; in the MySQL console and some time pass - somewhere at 30…39% the process… --- ## [mysql\_config\_editor missing from percona-server-client-5.7?](https://forums.percona.com/t/mysql-config-editor-missing-from-percona-server-client-5-7/5437)
**Author:** [@perler](https://forums.percona.com/u/perler)\ **Replies:** 3\ **Last updated:** [December 8, 2021, 9:04am UTC](https://forums.percona.com/t/mysql-config-editor-missing-from-percona-server-client-5-7/5437 "2021-12-08T09:04:12Z")
I installed percona 5.7 per instructions from the repo on ubuntu 16.04. I want to use mysql\_config\_editor but get # mysql\_config\_editor The program 'mysql\_config\_editor' is currently not installed. You can install it by… --- ## [MySQL audit audit\_log\_include\_accounts all users from host?](https://forums.percona.com/t/mysql-audit-audit-log-include-accounts-all-users-from-host/13056)
**Author:** [@mschu](https://forums.percona.com/u/mschu)\ **Replies:** 1\ **Last updated:** [November 16, 2021, 1:21pm UTC](https://forums.percona.com/t/mysql-audit-audit-log-include-accounts-all-users-from-host/13056 "2021-11-16T13:21:15Z")
Hi I’d like to audit all users from speciffic host. I cant get wildcard to work. does wildcards work at all in audit\_log\_include\_accounts \`? what I’d like to work was something in the ballpark of:: '@‘10.10.10.%’ ‘%… --- ## [Laggy master-master gtid replication in 5.7.32](https://forums.percona.com/t/laggy-master-master-gtid-replication-in-5-7-32/12618)
**Author:** [@Jiri\_Sula](https://forums.percona.com/u/Jiri_Sula)\ **Replies:** 2\ **Last updated:** [November 3, 2021, 11:19am UTC](https://forums.percona.com/t/laggy-master-master-gtid-replication-in-5-7-32/12618 "2021-11-03T11:19:00Z")
Dear all, we’re facing performance issues within master-master gtid replication. Secondary master(read only) is trying to catch Primary master with no luck. Write-bound workload is producing around 1GB of binlog per 10 … --- ## [Error when running mysqldump restore Re: ERROR 1100 (HY000) at line : Table was not locked with LOCK TABLES](https://forums.percona.com/t/error-when-running-mysqldump-restore-re-error-1100-hy000-at-line-table-was-not-locked-with-lock-tables/12429)
**Author:** [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Replies:** 4\ **Last updated:** [October 28, 2021, 1:45pm UTC](https://forums.percona.com/t/error-when-running-mysqldump-restore-re-error-1100-hy000-at-line-table-was-not-locked-with-lock-tables/12429 "2021-10-28T13:45:54Z")
I’m trying to restore a dumpfile. The source is mysql 5.7 and the destination is mysql 8.0 I get errors because the mysqldump file doesnt lock all necessary tables. Is there a way to dump or restore so that I don’t ge… --- ## [replication performance binlog\_cache\_size and binlog\_stmt\_cache\_size](https://forums.percona.com/t/replication-performance-binlog-cache-size-and-binlog-stmt-cache-size/8209)
**Author:** [@Kry](https://forums.percona.com/u/Kry)\ **Replies:** 3\ **Last updated:** [October 13, 2021, 3:31pm UTC](https://forums.percona.com/t/replication-performance-binlog-cache-size-and-binlog-stmt-cache-size/8209 "2021-10-13T15:31:07Z")
Hey. It is not entirely clear how to configure two variables to improve replication performance. binlog\_cache\_size and binlog\_stmt\_cache\_size The description says that the Binlog\_stmt\_cache\_use and Binlog\_stmt\_cache\_d… --- ## [GTID\_PURGED MISSING (global var)](https://forums.percona.com/t/gtid-purged-missing-global-var/12375)
**Author:** [@Mike\_Torn](https://forums.percona.com/u/Mike_Torn)\ **Replies:** 1\ **Last updated:** [October 3, 2021, 11:07am UTC](https://forums.percona.com/t/gtid-purged-missing-global-var/12375 "2021-10-03T11:07:41Z")
Hi Guys , I’ve got schema Master+Slave1+Slave2 with gtid ON , recently found that on my master server gtid\_purged global env has empty value. show global variables like ‘gtid\_purged’; ±--------------±------+ | Varia… --- ## [Converting thousands of tables from UTF8(utf8mb3) to utf8mb4 when upgrading from 5.7 to 8.0](https://forums.percona.com/t/converting-thousands-of-tables-from-utf8-utf8mb3-to-utf8mb4-when-upgrading-from-5-7-to-8-0/12286)
**Author:** [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Replies:** 1\ **Last updated:** [September 24, 2021, 5:29pm UTC](https://forums.percona.com/t/converting-thousands-of-tables-from-utf8-utf8mb3-to-utf8mb4-when-upgrading-from-5-7-to-8-0/12286 "2021-09-24T17:29:17Z")
Hi everyone, I am getting a warning when running prechecks for the 5.7 to 8.0 upgrade regarding tables with UTF8(utf8mb3). Problem is there are thousands of tables with utf8mb3 that I have to convert. Is there a utili… --- ## [Does percona have a "client" only installation to connect to percona server?](https://forums.percona.com/t/does-percona-have-a-client-only-installation-to-connect-to-percona-server/12262)
**Author:** [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Replies:** 1\ **Last updated:** [September 22, 2021, 6:13pm UTC](https://forums.percona.com/t/does-percona-have-a-client-only-installation-to-connect-to-percona-server/12262 "2021-09-22T18:13:39Z")
Does percona have a “client” only installation to connect to percona server? --- ## [Something seems to be stopping MySQL 5.7 (never happened for MySQL 5.6)](https://forums.percona.com/t/something-seems-to-be-stopping-mysql-5-7-never-happened-for-mysql-5-6/11989)
**Author:** [@Vamsi\_P](https://forums.percona.com/u/Vamsi_P)\ **Replies:** 3\ **Last updated:** [September 1, 2021, 2:50pm UTC](https://forums.percona.com/t/something-seems-to-be-stopping-mysql-5-7-never-happened-for-mysql-5-6/11989 "2021-09-01T14:50:41Z")
Hi there, We started testing with Percona MySQL 5.7 in our dev and test environment that has ubuntu 18. Suddenly yesterday (Monday) afternoon, MySQL 5.7 was stopped on those boxes. It is probably some unattended upgrad… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=2) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=4)