# Percona Server for MySQL 5.7 **URL:** https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=8 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 9 --- ## [Percona Server for MySQL 5.7.25-28 Is Now Available](https://forums.percona.com/t/percona-server-for-mysql-5-7-25-28-is-now-available/6852)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [February 19, 2019, 12:56am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-7-25-28-is-now-available/6852 "2019-02-19T00:56:19Z")
Percona is glad to announce the release of Percona Server 5.7.25-28 on February 18, 2019. Downloads are available here and from the Percona Software Repositories. This release is based on MySQL 5.7.25 and includes all t… --- ## [Sporadic MySQL lag with master-master replication and slave\_parallel\_workers](https://forums.percona.com/t/sporadic-mysql-lag-with-master-master-replication-and-slave-parallel-workers/6825)
**Author:** [@aerialls1](https://forums.percona.com/u/aerialls1)\ **Replies:** 0\ **Last updated:** [January 29, 2019, 9:28am UTC](https://forums.percona.com/t/sporadic-mysql-lag-with-master-master-replication-and-slave-parallel-workers/6825 "2019-01-29T09:28:55Z")
Hello, I’ve two MySQL servers running version 5.7.24-27 in a master-master replication configuration (all the traffic goes to the “primary” server and the “secondary” node is only here for backup). To try to improve th… --- ## [I don't see STRICT\_TRANS\_TABLES errors in logs](https://forums.percona.com/t/i-dont-see-strict-trans-tables-errors-in-logs/6824)
**Author:** [@ynasida](https://forums.percona.com/u/ynasida)\ **Replies:** 0\ **Last updated:** [January 29, 2019, 5:05am UTC](https://forums.percona.com/t/i-dont-see-strict-trans-tables-errors-in-logs/6824 "2019-01-29T05:05:21Z")
Hi guys, That is very weird but I can not get mysql 5.7 percona to send any warn\\errors to log file in case I try to run some INSERT and get error like this in mysql console ERROR 1265 (01000): Data truncated for colum… --- ## [MySQL Won't Start: "Found 1 prepared transaction" --tc-heuristic-recover alternative?](https://forums.percona.com/t/mysql-wont-start-found-1-prepared-transaction-tc-heuristic-recover-alternative/6341)
**Author:** [@michaelpward](https://forums.percona.com/u/michaelpward)\ **Replies:** 2\ **Last updated:** [January 21, 2019, 7:57am UTC](https://forums.percona.com/t/mysql-wont-start-found-1-prepared-transaction-tc-heuristic-recover-alternative/6341 "2019-01-21T07:57:18Z")
The logs (pertinent section pasted below) say that “critical information was manually deleted” – but we did not manually delete anything. Trying "does not work. Any solutions for this? Found 1 prepared transaction(s) i… --- ## [How to get Percona Server 5.7 respect open files limit?](https://forums.percona.com/t/how-to-get-percona-server-5-7-respect-open-files-limit/6798)
**Author:** [@LeonardChallis](https://forums.percona.com/u/LeonardChallis)\ **Replies:** 1\ **Last updated:** [January 16, 2019, 2:02am UTC](https://forums.percona.com/t/how-to-get-percona-server-5-7-respect-open-files-limit/6798 "2019-01-16T02:02:54Z")
My system: Linux x.x.x.x.hostname 3.10.0-862.14.4.el7.x86\_64 #1 SMP Wed Sep 26 15:12:11 UTC 2018 x86\_64 x86\_64 x86\_64 GNU/Linux I am seeing errors like: mysqldump: Got error: 23: Out of resources when opening file './… --- ## [Fixing 'ERROR: Unknown repository: percona' in percona-release](https://forums.percona.com/t/fixing-error-unknown-repository-percona-in-percona-release/6794)
**Author:** [@Sergey\_Bear](https://forums.percona.com/u/Sergey_Bear)\ **Replies:** 0\ **Last updated:** [January 15, 2019, 5:56am UTC](https://forums.percona.com/t/fixing-error-unknown-repository-percona-in-percona-release/6794 "2019-01-15T05:56:18Z")
On RHEL/Centos after updating percona-release to percona-release-1.0-4.noarch you may find that percona repository becomes disabled and suggested command to reenable it throws an error: percona-release setup ps57 Disab… --- ## [TokuDB question about Hot Indexing and Replication Lag](https://forums.percona.com/t/tokudb-question-about-hot-indexing-and-replication-lag/6792)
**Author:** [@Jeff\_Ward](https://forums.percona.com/u/Jeff_Ward)\ **Replies:** 0\ **Last updated:** [January 14, 2019, 3:12pm UTC](https://forums.percona.com/t/tokudb-question-about-hot-indexing-and-replication-lag/6792 "2019-01-14T15:12:46Z")
I am running into an issue with TokuDB and replication lag. I am wondering if this is expected or if there is a setting I am missing somewhere? We have tables with billions of rows, I can successfully create hot indexe… --- ## [Manu Access denied for user in logs](https://forums.percona.com/t/manu-access-denied-for-user-in-logs/6789)
**Author:** [@Akuma](https://forums.percona.com/u/Akuma)\ **Replies:** 4\ **Last updated:** [January 14, 2019, 12:04pm UTC](https://forums.percona.com/t/manu-access-denied-for-user-in-logs/6789 "2019-01-14T12:04:26Z")
Hello, I use a docker image percona:5.7 and today I noticed many “Access denied for user” in logs. Is this normal behavior or someone trying to brutforce my server or something else? Port 3306 is exposed. 2019-01-12T0… --- ## [About the user filtering of mysql percona audit plugin](https://forums.percona.com/t/about-the-user-filtering-of-mysql-percona-audit-plugin/6791)
**Author:** [@spala](https://forums.percona.com/u/spala)\ **Replies:** 0\ **Last updated:** [January 14, 2019, 5:50am UTC](https://forums.percona.com/t/about-the-user-filtering-of-mysql-percona-audit-plugin/6791 "2019-01-14T05:50:35Z")
I have a mysql server. I use Percona and I use the audit log plugin. I have no problem with this. But there are too many active users in the sub-structure using mysql. I just want to keep the audit logs of real users. I… --- ## [Moving partition files to another data directory](https://forums.percona.com/t/moving-partition-files-to-another-data-directory/6778)
**Author:** [@pfr](https://forums.percona.com/u/pfr)\ **Replies:** 0\ **Last updated:** [January 7, 2019, 5:18am UTC](https://forums.percona.com/t/moving-partition-files-to-another-data-directory/6778 "2019-01-07T05:18:33Z")
Hello, We have a partitioned table contain more than 10B records. The problem is that the partition files (e.g. mytable#P#p11.ibd) ended up in the mysql datadir instead of the in the separate filesystem we have for the… --- ## [MySQL 5.7.23 replica failed to execute load data infile](https://forums.percona.com/t/mysql-5-7-23-replica-failed-to-execute-load-data-infile/6728)
**Author:** [@AlexM](https://forums.percona.com/u/AlexM)\ **Replies:** 3\ **Last updated:** [December 11, 2018, 2:15pm UTC](https://forums.percona.com/t/mysql-5-7-23-replica-failed-to-execute-load-data-infile/6728 "2018-12-11T14:15:48Z")
Hello, Server migrated from Percona MySQL 5.7.19 to 5.7.23 failed to apply Load Data infile during replication. Specs: Master-master replication Statement based replication Percona MySQL 5.7.23 (both servers) CentOS … --- ## [Migrating to Percona 5.7 from a Mysql 5.7 InnoDB Cluster](https://forums.percona.com/t/migrating-to-percona-5-7-from-a-mysql-5-7-innodb-cluster/6696)
**Author:** [@RoyBatty](https://forums.percona.com/u/RoyBatty)\ **Replies:** 2\ **Last updated:** [December 10, 2018, 11:33am UTC](https://forums.percona.com/t/migrating-to-percona-5-7-from-a-mysql-5-7-innodb-cluster/6696 "2018-12-10T11:33:27Z")
Can an innodb cluster continue to run while one at a time replacing each server with Percona? I presume being a drop-in replacement that percona is able to do innodb clustering after the migration is completed? What sho… --- ## [Percona failed to set datadir to](https://forums.percona.com/t/percona-failed-to-set-datadir-to/6628)
**Author:** [@VRuler](https://forums.percona.com/u/VRuler)\ **Replies:** 1\ **Last updated:** [December 3, 2018, 7:28pm UTC](https://forums.percona.com/t/percona-failed-to-set-datadir-to/6628 "2018-12-03T19:28:34Z")
Hi, I’ve been using Percona and recently I decided to move the database from the OS ssd to a new nvme one. Set the datadir to the new location, copied the files and set permissions but I get an error when starting mysq… --- ## [innodb\_buffer\_pool\_instances and innodb\_buffer\_pool\_size](https://forums.percona.com/t/innodb-buffer-pool-instances-and-innodb-buffer-pool-size/6684)
**Author:** [@gandalf](https://forums.percona.com/u/gandalf)\ **Replies:** 0\ **Last updated:** [November 15, 2018, 3:01am UTC](https://forums.percona.com/t/innodb-buffer-pool-instances-and-innodb-buffer-pool-size/6684 "2018-11-15T03:01:40Z")
Let’s assume a 1.2GB innodb database. AFAIK, it should fit totally in RAM, thus, at least 1.2GB for innodb\_buffer\_pool\_size. Then, if possible, we should set innodb\_buffer\_pool\_instances to a value that innodb\_buffer\_p… --- ## [Slave replication when using both TokuDB and InnoDB engines - any caveats?](https://forums.percona.com/t/slave-replication-when-using-both-tokudb-and-innodb-engines-any-caveats/6670)
**Author:** [@lkuchars](https://forums.percona.com/u/lkuchars)\ **Replies:** 0\ **Last updated:** [November 7, 2018, 3:23am UTC](https://forums.percona.com/t/slave-replication-when-using-both-tokudb-and-innodb-engines-any-caveats/6670 "2018-11-07T03:23:57Z")
Hi there. For last few days I was experimenting with TokuDB engine. Compression ratios are impressive for some of our tables. I’d like to ask experts if there are any issues when I setup such ‘double engine’ percona serv… --- ## [Migrating from MySQL 5.6 to Percona 5.7](https://forums.percona.com/t/migrating-from-mysql-5-6-to-percona-5-7/6643)
**Author:** [@Orcio76](https://forums.percona.com/u/Orcio76)\ **Replies:** 0\ **Last updated:** [October 19, 2018, 10:03am UTC](https://forums.percona.com/t/migrating-from-mysql-5-6-to-percona-5-7/6643 "2018-10-19T10:03:51Z")
We are planning on migrating from MySQL 5.6 Master and Slave on VM to physical servers at a new data center to Percona 5.7 I’m thinking about installing Percona 5.7 and set it as a new slave. Is it a straightforward pro… --- ## [Connection to server via clients hostname](https://forums.percona.com/t/connection-to-server-via-clients-hostname/6639)
**Author:** [@UncertaintyP](https://forums.percona.com/u/UncertaintyP)\ **Replies:** 0\ **Last updated:** [October 18, 2018, 1:00pm UTC](https://forums.percona.com/t/connection-to-server-via-clients-hostname/6639 "2018-10-18T13:00:09Z")
I am trying to setup a configuration to connect to a mysql server via the clients hostname. On the server I have the following entry in mysql.user (user | host): webadmin | webadmin-1 and the respective entry in /etc/h… --- ## [Compare passwords with sha256](https://forums.percona.com/t/compare-passwords-with-sha256/6616)
**Author:** [@fjbejarano](https://forums.percona.com/u/fjbejarano)\ **Replies:** 0\ **Last updated:** [October 9, 2018, 7:00am UTC](https://forums.percona.com/t/compare-passwords-with-sha256/6616 "2018-10-09T07:00:34Z")
Hi all I have recently migrated to percona mysql to 5.7.23. I had some process to compare a password of a mysql user with a new one. If new password is different I change it for the new one. To do that I use this mysql… --- ## [Query optimization](https://forums.percona.com/t/query-optimization/6582)
**Author:** [@gandalf](https://forums.percona.com/u/gandalf)\ **Replies:** 16\ **Last updated:** [October 7, 2018, 10:43am UTC](https://forums.percona.com/t/query-optimization/6582 "2018-10-07T10:43:32Z")
I don’t know if this is the right forum to use. I’ve moved a Percona 5.7 database from our local premise to a Google Cloud Instance. After the move, queries that where executed in 0.000 seconds on our local server, sta… --- ## [installation of mysql5.7 for centos 7 -using rpm/yum - missing mysql.server script](https://forums.percona.com/t/installation-of-mysql5-7-for-centos-7-using-rpm-yum-missing-mysql-server-script/6611)
**Author:** [@gsbtech](https://forums.percona.com/u/gsbtech)\ **Replies:** 0\ **Last updated:** [October 2, 2018, 1:01pm UTC](https://forums.percona.com/t/installation-of-mysql5-7-for-centos-7-using-rpm-yum-missing-mysql-server-script/6611 "2018-10-02T13:01:50Z")
Upon installation of percona 5.7 for Centos OS 7, I did not see the script /usr/share/percona-server/mysql.start. For the percona 5.6 installation, the script is there. I also see less files in /usr/share for 5.7 than … --- ## [installation of mysql5.7 for centos 7 -using rpm/yum - missing mysql.server script](https://forums.percona.com/t/installation-of-mysql5-7-for-centos-7-using-rpm-yum-missing-mysql-server-script/6610)
**Author:** [@gsbtech](https://forums.percona.com/u/gsbtech)\ **Replies:** 0\ **Last updated:** [October 2, 2018, 12:57pm UTC](https://forums.percona.com/t/installation-of-mysql5-7-for-centos-7-using-rpm-yum-missing-mysql-server-script/6610 "2018-10-02T12:57:16Z")
Upon installation of percona 5.7 for Centos 7, using rpm/yum for docker, the /usr/share/percona-server did not have the script mysql.server. When we installed percona 5.6, the script was there, and I also see many more … --- ## [installation of mysql5.7 for centos 7 -using rpm/yum - missing mysql.server script](https://forums.percona.com/t/installation-of-mysql5-7-for-centos-7-using-rpm-yum-missing-mysql-server-script/6606)
**Author:** [@gsbtech](https://forums.percona.com/u/gsbtech)\ **Replies:** 0\ **Last updated:** [October 1, 2018, 3:19pm UTC](https://forums.percona.com/t/installation-of-mysql5-7-for-centos-7-using-rpm-yum-missing-mysql-server-script/6606 "2018-10-01T15:19:20Z")
I have installed 5.7 for centos. My Dockerfile uses mysql.server to start the database. I could not find this file in the downloaded .rpms --- ## [Multi-Source replication broken](https://forums.percona.com/t/multi-source-replication-broken/6590)
**Author:** [@Gajendra](https://forums.percona.com/u/Gajendra)\ **Replies:** 4\ **Last updated:** [September 25, 2018, 11:40am UTC](https://forums.percona.com/t/multi-source-replication-broken/6590 "2018-09-25T11:40:12Z")
Hello, i have setup multi-source replication where i have 2 master and 1 slave MASTER A MASTER B SLAVE C but when i was trying to create a database on MASTER A and it is reduplicating on SLAVE C then i create a sam… --- ## [Incorrect arguments to st\_distance\_sphere with request](https://forums.percona.com/t/incorrect-arguments-to-st-distance-sphere-with-request/6594)
**Author:** [@evgeniy123](https://forums.percona.com/u/evgeniy123)\ **Replies:** 0\ **Last updated:** [September 25, 2018, 6:20am UTC](https://forums.percona.com/t/incorrect-arguments-to-st-distance-sphere-with-request/6594 "2018-09-25T06:20:22Z")
I get an error when I get this request SELECT patch, x.id, type, geo\_address, place\_name, x(coordinates) as lat, y(coordinates) as lng, x.updated\_at, x.created\_at, x.distance FROM (SELECT \* ,(ST\_Distance\_Sphere(ST\_Geom… --- ## [Need help to troubleshoot RAM usage with Percona MySQL 5.7 after upgrade](https://forums.percona.com/t/need-help-to-troubleshoot-ram-usage-with-percona-mysql-5-7-after-upgrade/6569)
**Author:** [@ebuton](https://forums.percona.com/u/ebuton)\ **Replies:** 7\ **Last updated:** [September 24, 2018, 4:02am UTC](https://forums.percona.com/t/need-help-to-troubleshoot-ram-usage-with-percona-mysql-5-7-after-upgrade/6569 "2018-09-24T04:02:14Z")
Hello, After an upgrade from MySQL 5.5 to Percona MySQL 5.7, I noticed that the usage of the RAM never goes down and MySQL always finished by using all the RAM of the server which crashed. Here some logs before the cras… --- ## [Semaphore locks causing stalls](https://forums.percona.com/t/semaphore-locks-causing-stalls/6570)
**Author:** [@debian.dba](https://forums.percona.com/u/debian.dba)\ **Replies:** 0\ **Last updated:** [September 11, 2018, 3:16am UTC](https://forums.percona.com/t/semaphore-locks-causing-stalls/6570 "2018-09-11T03:16:12Z")
Hi all, I use 5.7.16-10-log Percona Server on Ubuntu 16.04.1 LTS with a m4.2xlarge ec2 instance type on AWS. For the past few months, I’ve been facing an issue with semaphore waits which cause stalls for around a minut… --- ## [Slow replication with TokuDB (open table cache not used during replication)](https://forums.percona.com/t/slow-replication-with-tokudb-open-table-cache-not-used-during-replication/6554)
**Author:** [@sergiu.hlihor](https://forums.percona.com/u/sergiu.hlihor)\ **Replies:** 3\ **Last updated:** [September 4, 2018, 4:06am UTC](https://forums.percona.com/t/slow-replication-with-tokudb-open-table-cache-not-used-during-replication/6554 "2018-09-04T04:06:37Z")
We have a setup where we replicate from MySQL 5.6 master to a MySQL 5.7 slave. Recently we changed all tables from slave server to TokuDB. Before, the server was able to keep up, while now the server falls behind. When e… --- ## [Issue with inserting new entry to table](https://forums.percona.com/t/issue-with-inserting-new-entry-to-table/6552)
**Author:** [@coutti](https://forums.percona.com/u/coutti)\ **Replies:** 0\ **Last updated:** [September 3, 2018, 3:42am UTC](https://forums.percona.com/t/issue-with-inserting-new-entry-to-table/6552 "2018-09-03T03:42:06Z")
Hello, We have issue with inserting new data to table after we moved our database from old MySQL server (version 5.5.37) under service provider to our own DB server witch is now running Percona version of MySQL with rel… --- ## [Ibdata is continuously growing](https://forums.percona.com/t/ibdata-is-continuously-growing/6545)
**Author:** [@Gajendra](https://forums.percona.com/u/Gajendra)\ **Replies:** 4\ **Last updated:** [August 31, 2018, 6:25am UTC](https://forums.percona.com/t/ibdata-is-continuously-growing/6545 "2018-08-31T06:25:21Z")
Hi, ibdata file is continuously growing on standalone mysql server (5.7). i dont know why is growing and eating too much space dbsize : 40 Gb Ibdata size : 130 Gb please advice how can i shrink ibdata file or do i ne… --- ## [Unable to stop XtraDB cluster node](https://forums.percona.com/t/unable-to-stop-xtradb-cluster-node/6546)
**Author:** [@shahidbashir7861](https://forums.percona.com/u/shahidbashir7861)\ **Replies:** 3\ **Last updated:** [August 30, 2018, 5:48am UTC](https://forums.percona.com/t/unable-to-stop-xtradb-cluster-node/6546 "2018-08-30T05:48:08Z")
Hello, I have setup a two node cluster using using MySQL-5.7. Now i am trying to stop one of the nodes using the command “systemctl stop mysql” and it keeps waiting. I can see the following at the end of the logs 2018-… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=7) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=9)