# Percona Server for MySQL 5.7 **URL:** https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=4 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 5 --- ## [Big latency in Server version: 5.7.24-26-57 Percona XtraDB Cluster (GPL), Release rel26](https://forums.percona.com/t/big-latency-in-server-version-5-7-24-26-57-percona-xtradb-cluster-gpl-release-rel26/11695)
**Author:** [@MAGGI](https://forums.percona.com/u/MAGGI)\ **Replies:** 7\ **Last updated:** [August 27, 2021, 3:05am UTC](https://forums.percona.com/t/big-latency-in-server-version-5-7-24-26-57-percona-xtradb-cluster-gpl-release-rel26/11695 "2021-08-27T03:05:36Z")
We are facing in the database Percona XtraDB Cluster that have 5 nodes, a Big latency, that appear when we execute a commande like SHOW DATABASES; or CREATE … it take for so long to give the result even in PREPRODUCTION … --- ## [Innodb-buffer-pool-size versus performance](https://forums.percona.com/t/innodb-buffer-pool-size-versus-performance/11874)
**Author:** [@artur](https://forums.percona.com/u/artur)\ **Replies:** 2\ **Last updated:** [August 26, 2021, 9:11pm UTC](https://forums.percona.com/t/innodb-buffer-pool-size-versus-performance/11874 "2021-08-26T21:11:16Z")
Hello, this is my first post so please be understanding. I am trying to configure the size of innodb-buffer-pool-size correctly but I don’t see the difference in the benchmark. My hardware: CPU: Intel Xeon E-2236 (6 c… --- ## [Problem in the distrubution of traffic in PXC cluster](https://forums.percona.com/t/problem-in-the-distrubution-of-traffic-in-pxc-cluster/11893)
**Author:** [@MAGGI](https://forums.percona.com/u/MAGGI)\ **Replies:** 5\ **Last updated:** [August 26, 2021, 2:34pm UTC](https://forums.percona.com/t/problem-in-the-distrubution-of-traffic-in-pxc-cluster/11893 "2021-08-26T14:34:06Z")
we have a cluster PXC that have 5 nodes, and those nodes does not share the same traffic only 2 of them that has the traffic, so what could be the problem, is there any algorithme that does this distrubution, is it based… --- ## [Percona Sever - MySQL packages for aarch64 architecture servers](https://forums.percona.com/t/percona-sever-mysql-packages-for-aarch64-architecture-servers/9092)
**Author:** [@Deependra\_Saraswat](https://forums.percona.com/u/Deependra_Saraswat)\ **Replies:** 6\ **Last updated:** [August 10, 2021, 10:12pm UTC](https://forums.percona.com/t/percona-sever-mysql-packages-for-aarch64-architecture-servers/9092 "2021-08-10T22:12:40Z")
Hi, I am trying to setup Percona server for mysql(5.7.25-28) on c6g instance types in aws. The OS is centos 7.9 and the architecture is aarch64. I am unable to find any packages compatible with this architecture on off… --- ## [Database crash with \`mysqld got signal 11\`](https://forums.percona.com/t/database-crash-with-mysqld-got-signal-11/11703)
**Author:** [@krystalcode](https://forums.percona.com/u/krystalcode)\ **Replies:** 6\ **Last updated:** [August 10, 2021, 6:23pm UTC](https://forums.percona.com/t/database-crash-with-mysqld-got-signal-11/11703 "2021-08-10T18:23:50Z")
I have a database that stopped working starting up. I don’t think the server crashed before the error starting happening, but it is possible the application did. Here are some log outputs, I’m not sure where to go from h… --- ## [Optimum thread\_pool\_size](https://forums.percona.com/t/optimum-thread-pool-size/11417)
**Author:** [@elisia](https://forums.percona.com/u/elisia)\ **Replies:** 13\ **Last updated:** [July 29, 2021, 5:53am UTC](https://forums.percona.com/t/optimum-thread-pool-size/11417 "2021-07-29T05:53:34Z")
Hi Folks, I seems to unable to find a good reference to find the best number of thread\_pool\_size. I have a very read heavy db server (barely any write). percona 5.7 on 16 VCPU + 32GB RAM. i was using 80 thread\_pool\_si… --- ## [Rejecting queries when server is overloaded](https://forums.percona.com/t/rejecting-queries-when-server-is-overloaded/11423)
**Author:** [@elisia](https://forums.percona.com/u/elisia)\ **Replies:** 2\ **Last updated:** [July 19, 2021, 4:09pm UTC](https://forums.percona.com/t/rejecting-queries-when-server-is-overloaded/11423 "2021-07-19T16:09:47Z")
Hi folks, Im trying to see if there is a feature within mysql/percona/mariadb in general that does this kind of feature to reject queries when a service is overloaded. Similar to back pressure system. TIA --- ## [Create Slave 5.7 from Master 5.6 with Xtrabackup](https://forums.percona.com/t/create-slave-5-7-from-master-5-6-with-xtrabackup/11064)
**Author:** [@GeertM](https://forums.percona.com/u/GeertM)\ **Replies:** 1\ **Last updated:** [July 2, 2021, 1:13pm UTC](https://forums.percona.com/t/create-slave-5-7-from-master-5-6-with-xtrabackup/11064 "2021-07-02T13:13:40Z")
Hello, I have to create a slave in version Percona 5.7 from a Master Percona 5.6 Is this possible? Geert --- ## [Check If SQL server in Percona cluster is in bootstrap mode](https://forums.percona.com/t/check-if-sql-server-in-percona-cluster-is-in-bootstrap-mode/10710)
**Author:** [@jasonfe33](https://forums.percona.com/u/jasonfe33)\ **Replies:** 3\ **Last updated:** [June 15, 2021, 2:54pm UTC](https://forums.percona.com/t/check-if-sql-server-in-percona-cluster-is-in-bootstrap-mode/10710 "2021-06-15T14:54:46Z")
Hello, Still getting to learn this so I apologize if this is an easy question. How can I make sure none of my SQL nodes are running in bootstrap mode? I ran a service mysql status on all 3 nodes in percona cluster 5.7 a… --- ## [Percona Cluster Functionality](https://forums.percona.com/t/percona-cluster-functionality/10833)
**Author:** [@jasonfe33](https://forums.percona.com/u/jasonfe33)\ **Replies:** 1\ **Last updated:** [June 10, 2021, 9:05pm UTC](https://forums.percona.com/t/percona-cluster-functionality/10833 "2021-06-10T21:05:09Z")
Have existing percona cluster and new percona cluster. Both have a few slight configuration differences. Would like to know functionality wise, what the difference is, if any. Cluster A - 3 nodes , my.cnf file server\_i… --- ## [Innodb bufferpool continuous flush storm](https://forums.percona.com/t/innodb-bufferpool-continuous-flush-storm/10620)
**Author:** [@Petr\_Hrabal](https://forums.percona.com/u/Petr_Hrabal)\ **Replies:** 2\ **Last updated:** [May 28, 2021, 8:26pm UTC](https://forums.percona.com/t/innodb-bufferpool-continuous-flush-storm/10620 "2021-05-28T20:26:41Z")
I am using 5.7.28-31-57-log - Percona XtraDB Cluster (GPL), Release rel31 in production enviroment one of the nodes started for no apparent reason agresively flushing bufferpool … what I see as strange is that only … --- ## [Percona Server for MySQL 5.7.34-37 Released](https://forums.percona.com/t/percona-server-for-mysql-5-7-34-37-released/10622)
**Author:** [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)\ **Replies:** 0\ **Last updated:** [May 28, 2021, 3:15pm UTC](https://forums.percona.com/t/percona-server-for-mysql-5-7-34-37-released/10622 "2021-05-28T15:15:08Z")
May 26, 2021 - Find release notes at Percona Server for MySQL 5.7.34-37 — Percona Server 5.7 Documentation --- ## [Upgrade from MySQL v5.5.59 to Percona 5.6? 5.7? XtraDB?](https://forums.percona.com/t/upgrade-from-mysql-v5-5-59-to-percona-5-6-5-7-xtradb/10146)
**Author:** [@jbiancot](https://forums.percona.com/u/jbiancot)\ **Replies:** 3\ **Last updated:** [April 19, 2021, 5:09pm UTC](https://forums.percona.com/t/upgrade-from-mysql-v5-5-59-to-percona-5-6-5-7-xtradb/10146 "2021-04-19T17:09:33Z")
Hello there, On our QA environments we are running Debian 9, Keycloak 3.4.3 and Percona “MySQL” XtraDB 5.7.33-36. We have a bunch of backends working fine with XtraDB. On Production we were running Debian 8 “don’t ask”… --- ## [PS-6961 Event Scheduler memory leaks](https://forums.percona.com/t/ps-6961-event-scheduler-memory-leaks/9897)
**Author:** [@Eryk\_Michalik](https://forums.percona.com/u/Eryk_Michalik)\ **Replies:** 2\ **Last updated:** [April 8, 2021, 2:12pm UTC](https://forums.percona.com/t/ps-6961-event-scheduler-memory-leaks/9897 "2021-04-08T14:12:12Z")
Hi, We are going to use Events mechanism in our system but we found that there are memory leaks in event scheduler: https://jira.percona.com/browse/PS-6961 We are currently using Percona 5.7.23-23-57 and If i understa… --- ## [Does "CVE-2021-2022" vulnerability exist in Percona XtraDB v5.7.32?](https://forums.percona.com/t/does-cve-2021-2022-vulnerability-exist-in-percona-xtradb-v5-7-32/9534)
**Author:** [@pramodbhaskar](https://forums.percona.com/u/pramodbhaskar)\ **Replies:** 1\ **Last updated:** [March 28, 2021, 11:37pm UTC](https://forums.percona.com/t/does-cve-2021-2022-vulnerability-exist-in-percona-xtradb-v5-7-32/9534 "2021-03-28T23:37:47Z")
Does “CVE-2021-2022” vulnerability exist in Percona XtraDB v5.7.32? If yes, do we have an ETA for the Security Patch release? --- ## [Percona 5.7.32 switch to GTID online](https://forums.percona.com/t/percona-5-7-32-switch-to-gtid-online/9803)
**Author:** [@BoneBunny](https://forums.percona.com/u/BoneBunny)\ **Replies:** 1\ **Last updated:** [March 24, 2021, 2:00pm UTC](https://forums.percona.com/t/percona-5-7-32-switch-to-gtid-online/9803 "2021-03-24T14:00:54Z")
Hi, I would like to switch a running Master-Master-Slave setup to GITD based replication. As for MariaDB this step is quite straight forward and I’ve done this successfully several times. For percona this seems to be … --- ## [Why is the memory on the server high, mostly in the db (mysqld) process, even though DB activity is not high?](https://forums.percona.com/t/why-is-the-memory-on-the-server-high-mostly-in-the-db-mysqld-process-even-though-db-activity-is-not-high/9680)
**Author:** [@Fikri\_Maulana](https://forums.percona.com/u/Fikri_Maulana)\ **Replies:** 3\ **Last updated:** [March 22, 2021, 10:42am UTC](https://forums.percona.com/t/why-is-the-memory-on-the-server-high-mostly-in-the-db-mysqld-process-even-though-db-activity-is-not-high/9680 "2021-03-22T10:42:21Z")
You can see that the server memory is full, It can be seen from CLI monitoring that there are many mysql processes that use up to 10GB of memory (virtually), but in terms of DB activity itself is not heavy, --- ## [\[SOLVED\] Updating the package Percona-Server-client-57 to 5.7.33-36 fails](https://forums.percona.com/t/solved-updating-the-package-percona-server-client-57-to-5-7-33-36-fails/9682)
**Author:** [@coqu](https://forums.percona.com/u/coqu)\ **Replies:** 2\ **Last updated:** [March 17, 2021, 7:12am UTC](https://forums.percona.com/t/solved-updating-the-package-percona-server-client-57-to-5-7-33-36-fails/9682 "2021-03-17T07:12:56Z")
I’m trying to update Percona-Server-client-57 on a CloudLinux 7.9 system, but the update fails as the file can’t be downloaded properly: Percona-Server-client-57-5.7.3 FAILED http://repo.percona.com/percona/yum/release/… --- ## [Percona Server for MySQL 5.7.33-36 Released](https://forums.percona.com/t/percona-server-for-mysql-5-7-33-36-released/9553)
**Author:** [@Tom\_Basil](https://forums.percona.com/u/Tom_Basil)\ **Replies:** 0\ **Last updated:** [March 4, 2021, 2:19pm UTC](https://forums.percona.com/t/percona-server-for-mysql-5-7-33-36-released/9553 "2021-03-04T14:19:31Z")
March 2, 2021 - See release notes at: https://www.percona.com/doc/percona-server/5.7/release-notes/Percona-Server-5.7.33-36.html --- ## [Spatial Index rebuilds](https://forums.percona.com/t/spatial-index-rebuilds/9225)
**Author:** [@mikes](https://forums.percona.com/u/mikes)\ **Replies:** 5\ **Last updated:** [March 3, 2021, 9:31am UTC](https://forums.percona.com/t/spatial-index-rebuilds/9225 "2021-03-03T09:31:16Z")
Hi, Is there any way, other than doing a DROP INDEX followed by an ALER TABLE x ADD SPATIAL INDEX of carrying out SPATIAL INDEX maintanence ? I had hoped that using pt-online-schema-change might do the trick, but it see… --- ## [High InnoDB Log File Usage](https://forums.percona.com/t/high-innodb-log-file-usage/5452)
**Author:** [@leeus](https://forums.percona.com/u/leeus)\ **Replies:** 1\ **Last updated:** [February 3, 2021, 1:30pm UTC](https://forums.percona.com/t/high-innodb-log-file-usage/5452 "2021-02-03T13:30:18Z")
I installed an InnoDB database yesterday on a new database server I am working on. Using the latest Percona 5.7 release from the apt repo. The database contains 2 tables of highly transient data. One table has a high up… --- ## [What's the difference between \`libperconaserverclient20-dev\` and \`libmysqlclient-dev\`?](https://forums.percona.com/t/whats-the-difference-between-libperconaserverclient20-dev-and-libmysqlclient-dev/8968)
**Author:** [@jdstone](https://forums.percona.com/u/jdstone)\ **Replies:** 1\ **Last updated:** [January 28, 2021, 2:09pm UTC](https://forums.percona.com/t/whats-the-difference-between-libperconaserverclient20-dev-and-libmysqlclient-dev/8968 "2021-01-28T14:09:45Z")
My guess is that if I use Percona Server for MySQL, I should install libperconaserverclient20-dev, but if I use MySQL Server or MariaDB Server, I should install libmysqlclient-dev. Is my assumption correct? --- ## [Update to 5.7 fails on Ubuntu 12.04.5 LTS](https://forums.percona.com/t/update-to-5-7-fails-on-ubuntu-12-04-5-lts/4906)
**Author:** [@Lars\_Schwarz](https://forums.percona.com/u/Lars_Schwarz)\ **Replies:** 2\ **Last updated:** [January 20, 2021, 10:57am UTC](https://forums.percona.com/t/update-to-5-7-fails-on-ubuntu-12-04-5-lts/4906 "2021-01-20T10:57:02Z")
Hi guys, i tried to update a running 5.6 to 5.7. Here’s what I did: service mysql stop apt-get install percona-server-server-5.7 Install fails with the following error: dpkg: error processing /var/cache/apt/a… --- ## [Multiple instances](https://forums.percona.com/t/multiple-instances/8754)
**Author:** [@rokj](https://forums.percona.com/u/rokj)\ **Replies:** 4\ **Last updated:** [January 13, 2021, 11:16am UTC](https://forums.percona.com/t/multiple-instances/8754 "2021-01-13T11:16:49Z")
Hi, we are considering to setup multiple instances of percona 5.7 and 8.0 (from binary) little bit different than “recommended” way in tutorials. Is it “ok” to run multiple instances with systemd with separate mysql co… --- ## [Replication on different datadir](https://forums.percona.com/t/replication-on-different-datadir/8392)
**Author:** [@rokj](https://forums.percona.com/u/rokj)\ **Replies:** 5\ **Last updated:** [January 11, 2021, 11:08am UTC](https://forums.percona.com/t/replication-on-different-datadir/8392 "2021-01-11T11:08:29Z")
Hi, I have a running replication, but I tried running replication on different datadir, but I’ve got /opt/percona-5.5.62-38.14-ssl101/bin/mysqld: File ‘/var/lib/mysql/data/mysql-bin.000045’ not found (Errcode: 2) 2012… --- ## [LOAD DATA INFILE loading incorrect field value for string with space](https://forums.percona.com/t/load-data-infile-loading-incorrect-field-value-for-string-with-space/7052)
**Author:** [@prince85](https://forums.percona.com/u/prince85)\ **Replies:** 0\ **Last updated:** [June 7, 2019, 7:56am UTC](https://forums.percona.com/t/load-data-infile-loading-incorrect-field-value-for-string-with-space/7052 "2019-06-07T07:56:05Z")
HI, I’m using Server version: 5.7.24-27 Percona Server (GPL), Release 27, Revision bd42700. I’m migrating data from MSSQL to MySQL by generating CSV files and then importing to MySQL using below command. LOAD DATA LOC… --- ## [Percona Server for MySQL Replication and TRUNCATE statement](https://forums.percona.com/t/percona-server-for-mysql-replication-and-truncate-statement/6941)
**Author:** [@apmakeev](https://forums.percona.com/u/apmakeev)\ **Replies:** 0\ **Last updated:** [April 3, 2019, 2:14am UTC](https://forums.percona.com/t/percona-server-for-mysql-replication-and-truncate-statement/6941 "2019-04-03T02:14:11Z")
Hi All! Percona Server for MySQL 5.7.23-23 with RBR replication (RFR, TokuDB tables). According to Oracle MySQL documentation TRUNCATE TABLE is normally must be regarded as a DML statement in row-based replication. How… --- ## [Data in the Toku DB table are lost](https://forums.percona.com/t/data-in-the-toku-db-table-are-lost/6664)
**Author:** [@apmakeev](https://forums.percona.com/u/apmakeev)\ **Replies:** 0\ **Last updated:** [October 31, 2018, 8:10am UTC](https://forums.percona.com/t/data-in-the-toku-db-table-are-lost/6664 "2018-10-31T08:10:27Z")
Hi dear experts! We got a big and strange problem. Perhaps, someone faced something similar. Ubuntu 18.04.1 LTS deb \[url\]https://repo.percona.com/apt\[/url\] bionic main mysqld Ver 5.7.23-23 for debian-linux-gnu on x86… --- ## [Mysql 5.7 memory usage problem OOM](https://forums.percona.com/t/mysql-5-7-memory-usage-problem-oom/6657)
**Author:** [@zsebacsi](https://forums.percona.com/u/zsebacsi)\ **Replies:** 0\ **Last updated:** [October 30, 2018, 8:05am UTC](https://forums.percona.com/t/mysql-5-7-memory-usage-problem-oom/6657 "2018-10-30T08:05:16Z")
Hi We are using a 3 node galera cluster with Mysql 5.7 5.7.23-23-57-log on ubuntu 16.04 x64, 64G ram + 64g swap my problem is that mysql memory usage is constantly growing and after a few days it runs to an OOM and got… --- ## [Database Memory keep on increase and decrease](https://forums.percona.com/t/database-memory-keep-on-increase-and-decrease/5856)
**Author:** [@spyworld](https://forums.percona.com/u/spyworld)\ **Replies:** 0\ **Last updated:** [September 11, 2017, 11:11pm UTC](https://forums.percona.com/t/database-memory-keep-on-increase-and-decrease/5856 "2017-09-11T23:11:01Z")
Max 250 queries every 5 mins Max 50 connections Max 1 concurrent connection every 5 sec Avg 1.5k Read/Fetch Rows 24GB allocated for Innodb Buffer Pool 32GB Server RAM I attached my memory usage. There is something … [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=3) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=5)