# Percona Server for MySQL 5.7 **URL:** https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=7 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 8 --- ## [InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace](https://forums.percona.com/t/innodb-your-database-may-be-corrupt-or-you-may-have-copied-the-innodb-tablespace/6404)
**Author:** [@shrenikp7](https://forums.percona.com/u/shrenikp7)\ **Replies:** 3\ **Last updated:** [July 31, 2019, 2:39am UTC](https://forums.percona.com/t/innodb-your-database-may-be-corrupt-or-you-may-have-copied-the-innodb-tablespace/6404 "2019-07-31T02:39:22Z")
Why every time getting following message during --prepare? Is there any way to fix it and get clean prepare? InnoDB: Starting crash recovery. InnoDB: Page \[page id: space=0, page number=2\] log sequence number 2615513 i… --- ## [Help for tuning Percona 5.7](https://forums.percona.com/t/help-for-tuning-percona-5-7/7138)
**Author:** [@giannisgz](https://forums.percona.com/u/giannisgz)\ **Replies:** 0\ **Last updated:** [July 29, 2019, 2:26am UTC](https://forums.percona.com/t/help-for-tuning-percona-5-7/7138 "2019-07-29T02:26:47Z")
Hello. I am using a 4 core ubuntu cloud server with 8gb and ssds. There I have only one database for a Magento store which is about 2GB size. Last month after some changes I made it seems that database performing as it … --- ## [Debian buster packages](https://forums.percona.com/t/debian-buster-packages/7094)
**Author:** [@Kode](https://forums.percona.com/u/Kode)\ **Replies:** 4\ **Last updated:** [July 26, 2019, 2:15pm UTC](https://forums.percona.com/t/debian-buster-packages/7094 "2019-07-26T14:15:51Z")
Hello, Debian buster is to be released in 3 days. The percona-release for debian buster does not exist. The generic installs fine though. I’ve noticed there are some packages in the repository, but the normal percona-se… --- ## [What is the maximum number of cores?](https://forums.percona.com/t/what-is-the-maximum-number-of-cores/7137)
**Author:** [@mauricioit](https://forums.percona.com/u/mauricioit)\ **Replies:** 1\ **Last updated:** [July 26, 2019, 3:52am UTC](https://forums.percona.com/t/what-is-the-maximum-number-of-cores/7137 "2019-07-26T03:52:00Z")
Hello, I am doing a stress test using a 96 cores cpu, but Percona 5.7 only uses 48 cores which have a 100% consumption. Are there any settings to change this behavior? Does any version of mysql support more than 48 core… --- ## [replication filter for multi master](https://forums.percona.com/t/replication-filter-for-multi-master/7079)
**Author:** [@Alexander\_Titaev](https://forums.percona.com/u/Alexander_Titaev)\ **Replies:** 1\ **Last updated:** [July 15, 2019, 5:59am UTC](https://forums.percona.com/t/replication-filter-for-multi-master/7079 "2019-07-15T05:59:17Z")
centos 7 Percona-Server-server-57-5.7.26-29.1.el7.x86\_64 mysql\> CHANGE REPLICATION FILTER replicate\_do\_db=(invisible\_coffee) FOR CHANNEL ‘master2’; ERROR 1064 (42000): You have an error in your SQL syntax; check the m… --- ## [Comments in Sql query with Audit Plugin](https://forums.percona.com/t/comments-in-sql-query-with-audit-plugin/7104)
**Author:** [@woodygsd](https://forums.percona.com/u/woodygsd)\ **Replies:** 0\ **Last updated:** [July 8, 2019, 3:53pm UTC](https://forums.percona.com/t/comments-in-sql-query-with-audit-plugin/7104 "2019-07-08T15:53:23Z")
We would like to be able to add a comment to the sql query, and getthe audit plugin to export that to the log file. Something like: /\* Some text here \*/ Insert into Sometable values (…) Tried all versions of ‘comments’… --- ## [Percona MySQL 5.7.19 Performance Decline When Running for a Week.](https://forums.percona.com/t/percona-mysql-5-7-19-performance-decline-when-running-for-a-week/6731)
**Author:** [@AlexM](https://forums.percona.com/u/AlexM)\ **Replies:** 7\ **Last updated:** [June 28, 2019, 1:12pm UTC](https://forums.percona.com/t/percona-mysql-5-7-19-performance-decline-when-running-for-a-week/6731 "2019-06-28T13:12:45Z")
We recently migrated our MySQL 5.5 community edition servers to Percona MySQ. 5.7.19. Migration went smooth. New serves have the following specification: 54 core CPUs 256 GB memory Mirroring (RAID 1+0) - 894GB of usabl… --- ## [Deadlock after upgrading to 5.7 from 5.6](https://forums.percona.com/t/deadlock-after-upgrading-to-5-7-from-5-6/7068)
**Author:** [@pooja.gupta](https://forums.percona.com/u/pooja.gupta)\ **Replies:** 0\ **Last updated:** [June 19, 2019, 7:45pm UTC](https://forums.percona.com/t/deadlock-after-upgrading-to-5-7-from-5-6/7068 "2019-06-19T19:45:02Z")
Hi, We are started facing deadlock issue very frequently after upgrading to 5.7 There are no changes in application and application was running fine before upgrade. Version: | 5.7.25-28-log | Latest Deadlock from inn… --- ## [Cannot detect slave](https://forums.percona.com/t/cannot-detect-slave/7065)
**Author:** [@ammu](https://forums.percona.com/u/ammu)\ **Replies:** 0\ **Last updated:** [June 18, 2019, 6:16am UTC](https://forums.percona.com/t/cannot-detect-slave/7065 "2019-06-18T06:16:26Z")
Hello all, I got stuck with the error “Diffs cannot be detected because no slaves were found. Please read the --recursion-method documentation for information”. Master port: 3307 Slave port: 3306 I would like to run … --- ## [Group Replication with tuned performance Schema settings](https://forums.percona.com/t/group-replication-with-tuned-performance-schema-settings/7063)
**Author:** [@manish.chourasiya](https://forums.percona.com/u/manish.chourasiya)\ **Replies:** 0\ **Last updated:** [June 17, 2019, 2:13am UTC](https://forums.percona.com/t/group-replication-with-tuned-performance-schema-settings/7063 "2019-06-17T02:13:49Z")
Hi, We are using Percona MySql Version 5.7.20-18. We are setting MySql Group Replication for that we need to set Performance Schema on. We want to enable performance schema only for Group Replication related things rest … --- ## [Communications link failure in Percona MySQL 5.7.24](https://forums.percona.com/t/communications-link-failure-in-percona-mysql-5-7-24/7060)
**Author:** [@L4ty4k](https://forums.percona.com/u/L4ty4k)\ **Replies:** 0\ **Last updated:** [June 14, 2019, 5:25am UTC](https://forums.percona.com/t/communications-link-failure-in-percona-mysql-5-7-24/7060 "2019-06-14T05:25:04Z")
Hello We are randomly getting errors in our Percona mysql db and the connecting application when running a “select \* from Table” query on a table that has ~ 19 000 000 rows and 26 columns. In the mysql\_error log we get… --- ## [Install from scratch percona-XtraDB-Cluster](https://forums.percona.com/t/install-from-scratch-percona-xtradb-cluster/7054)
**Author:** [@aldi\_0804](https://forums.percona.com/u/aldi_0804)\ **Replies:** 0\ **Last updated:** [June 10, 2019, 1:56am UTC](https://forums.percona.com/t/install-from-scratch-percona-xtradb-cluster/7054 "2019-06-10T01:56:19Z")
Hi All, I tried to install Xtradb cluster on Centos 6 We are getting following error Could you please help me with some insights. Regard Aldi \[root@master ~\]# yum install epel-release Loaded plugins: fastestmirror,… --- ## [Failed to enable RocksDB, and err log shows nothing](https://forums.percona.com/t/failed-to-enable-rocksdb-and-err-log-shows-nothing/7028)
**Author:** [@geminijun](https://forums.percona.com/u/geminijun)\ **Replies:** 0\ **Last updated:** [May 22, 2019, 4:23pm UTC](https://forums.percona.com/t/failed-to-enable-rocksdb-and-err-log-shows-nothing/7028 "2019-05-22T16:23:32Z")
I build Percona-server from scratch, started mysql by: /bin/mysqld --defaults-file=my.cnf --user=root & But when I tried t enable RocksDB by: ./bin/ps-admin --enable-rocksdb -u root -p -S mysql.sock I got following e… --- ## [How to configure vault server to encrypt data on percona for mysql](https://forums.percona.com/t/how-to-configure-vault-server-to-encrypt-data-on-percona-for-mysql/7025)
**Author:** [@Tecnual](https://forums.percona.com/u/Tecnual)\ **Replies:** 0\ **Last updated:** [May 21, 2019, 6:08am UTC](https://forums.percona.com/t/how-to-configure-vault-server-to-encrypt-data-on-percona-for-mysql/7025 "2019-05-21T06:08:47Z")
I am trying to configure a Percona server for mysql to encrypt the data using keyring \_vault\_plugin. I followed the instructions of this link: \[URL=“https://www.percona.com/doc/percona-server/LATEST/management/data\_at\_… --- ## [Packages missing from Percona Server for MySQL apt repository (Debian Stretch)](https://forums.percona.com/t/packages-missing-from-percona-server-for-mysql-apt-repository-debian-stretch/7009)
**Author:** [@MattDrachemann](https://forums.percona.com/u/MattDrachemann)\ **Replies:** 1\ **Last updated:** [May 13, 2019, 3:50am UTC](https://forums.percona.com/t/packages-missing-from-percona-server-for-mysql-apt-repository-debian-stretch/7009 "2019-05-13T03:50:03Z")
It appears that the various packages for Percona Server for MySQL (percona-server-\*-5.7 and libperconaserverclient20) are missing from the Debian Stretch APT repositories. I’ve followed the instructions in the install d… --- ## [Release Date for 5.7.26 ?](https://forums.percona.com/t/release-date-for-5-7-26/6994)
**Author:** [@gjsmith66](https://forums.percona.com/u/gjsmith66)\ **Replies:** 0\ **Last updated:** [May 1, 2019, 9:40am UTC](https://forums.percona.com/t/release-date-for-5-7-26/6994 "2019-05-01T09:40:48Z")
We have run into the following issue with 5.7.25 and was wondering when you might have the new version released? Thanks as always for your help! InnoDB: Two sessions concurrently executing an INSERT … ON DUPLICATE KEY UP… --- ## [Query has drastic slowdown following upgrade from MySQL 5.6 to 5.7](https://forums.percona.com/t/query-has-drastic-slowdown-following-upgrade-from-mysql-5-6-to-5-7/6985)
**Author:** [@kflavin](https://forums.percona.com/u/kflavin)\ **Replies:** 0\ **Last updated:** [April 25, 2019, 7:02pm UTC](https://forums.percona.com/t/query-has-drastic-slowdown-following-upgrade-from-mysql-5-6-to-5-7/6985 "2019-04-25T19:02:09Z")
Following an upgrade from MySQL 5.6 to 5.7, the following query went from running in \<2 minutes to taking over 30 minutes. SELECT DISTINCT Name,d.id,deviceType,issuedBy, description,avNum,CompanyName, BrandName,dwNumber… --- ## [building rpms from source / cent7](https://forums.percona.com/t/building-rpms-from-source-cent7/6984)
**Author:** [@emilys](https://forums.percona.com/u/emilys)\ **Replies:** 0\ **Last updated:** [April 25, 2019, 3:39pm UTC](https://forums.percona.com/t/building-rpms-from-source-cent7/6984 "2019-04-25T15:39:11Z")
Hello, I am coming up across errors, which appear to be library / compiler incompatibilities. I am trying to build a github checkout of PS 5.7, following \[URL\]https://www.percona.com/blog/2017/01/20/how-to-manually-build… --- ## [auth\_pam\_compat crashing mysqld](https://forums.percona.com/t/auth-pam-compat-crashing-mysqld/6980)
**Author:** [@shadowgun1102](https://forums.percona.com/u/shadowgun1102)\ **Replies:** 1\ **Last updated:** [April 24, 2019, 3:21am UTC](https://forums.percona.com/t/auth-pam-compat-crashing-mysqld/6980 "2019-04-24T03:21:52Z")
I have been running an XtraDB cluster for a bit now without any major issues. My config is: 3x CentOS 7 Servers 2x CPU 4 GB Memory 50 GB OS 50 GB Data PBIS-Open for PAM AD Authentication /etc/pam.d/mysql config fi… --- ## [Process stack on closing tables under Kielled command](https://forums.percona.com/t/process-stack-on-closing-tables-under-kielled-command/6979)
**Author:** [@hvardan71](https://forums.percona.com/u/hvardan71)\ **Replies:** 0\ **Last updated:** [April 23, 2019, 9:31am UTC](https://forums.percona.com/t/process-stack-on-closing-tables-under-kielled-command/6979 "2019-04-23T09:31:21Z")
Hello We have some issues with our MySQL server There is process that stuck on following: \[INDENT\] Id User Host db Command Time State Info Rows\_sent Rows\_examined \[/INDENT\] \[INDENT\]5065231 cyang1 %:28510 servicing Kil… --- ## [Getting error in starting mysql while changing the path](https://forums.percona.com/t/getting-error-in-starting-mysql-while-changing-the-path/6978)
**Author:** [@prince85](https://forums.percona.com/u/prince85)\ **Replies:** 0\ **Last updated:** [April 23, 2019, 9:13am UTC](https://forums.percona.com/t/getting-error-in-starting-mysql-while-changing-the-path/6978 "2019-04-23T09:13:41Z")
I’m getting below error in log. 2019-04-23T14:15:39.420216Z 0 \[ERROR\] Can’t find error-message file ‘/data/share/errmsg.sys’. Check error-message file location and ‘lc-messages-dir’ configuration directive. I’ve specif… --- ## [Query rewrite on VERSION() function](https://forums.percona.com/t/query-rewrite-on-version-function/6968)
**Author:** [@stofa.kenida](https://forums.percona.com/u/stofa.kenida)\ **Replies:** 1\ **Last updated:** [April 17, 2019, 7:46am UTC](https://forums.percona.com/t/query-rewrite-on-version-function/6968 "2019-04-17T07:46:41Z")
Hi There, By using the query rewrite plugin in 5.7.25-28-log Percona Server (GPL), Release 28, Revision c335905 version, i saw tha following strange behaviour. Below are the steps excuted : Load and enable the plugin… --- ## [MySQL failed to handshake due to LOCK\_thread\_cache not released](https://forums.percona.com/t/mysql-failed-to-handshake-due-to-lock-thread-cache-not-released/6965)
**Author:** [@windy.jian](https://forums.percona.com/u/windy.jian)\ **Replies:** 5\ **Last updated:** [April 17, 2019, 4:17am UTC](https://forums.percona.com/t/mysql-failed-to-handshake-due-to-lock-thread-cache-not-released/6965 "2019-04-17T04:17:39Z")
I’m not sure whether it’s ok or not, if I post my help wanted here. It seems that i encounter a bug-like issue. Percona-server 5.7.24-27 \[url\]MySQL failed to handshake due to LOCK\_thread\_cache not released? - Database A… --- ## [Percona Server for MySQL 5.7 testing 'drop in replacement' claim](https://forums.percona.com/t/percona-server-for-mysql-5-7-testing-drop-in-replacement-claim/6646)
**Author:** [@Joe\_GIbbs](https://forums.percona.com/u/Joe_GIbbs)\ **Replies:** 6\ **Last updated:** [March 13, 2019, 4:01pm UTC](https://forums.percona.com/t/percona-server-for-mysql-5-7-testing-drop-in-replacement-claim/6646 "2019-03-13T16:01:46Z")
Good morning, Please read the following post and then answer. How is this a drop in replacement for MySQL 5.7 community version if I can’t get a test db instance up and running? We run multiple MySQL db instances (sta… --- ## [DB Server/Cluster Sizing](https://forums.percona.com/t/db-server-cluster-sizing/6904)
**Author:** [@akajla](https://forums.percona.com/u/akajla)\ **Replies:** 0\ **Last updated:** [March 13, 2019, 3:20am UTC](https://forums.percona.com/t/db-server-cluster-sizing/6904 "2019-03-13T03:20:24Z")
Hi, What would be the perfect server specs for a DB instance/cluster to handle 100k concurrent user requests for a public facing PHP application ? Thanks, Akajla --- ## [Migrating from mysql community 5.7 to Percona mysql 5.7](https://forums.percona.com/t/migrating-from-mysql-community-5-7-to-percona-mysql-5-7/6893)
**Author:** [@Klassey](https://forums.percona.com/u/Klassey)\ **Replies:** 4\ **Last updated:** [March 11, 2019, 12:00pm UTC](https://forums.percona.com/t/migrating-from-mysql-community-5-7-to-percona-mysql-5-7/6893 "2019-03-11T12:00:38Z")
Greetings and Salutations! I am having some difficulties, and was hoping someone from the community might be able to offer some insights or assistance. I will offer thanks in advance as it might get lost below. Thank yo… --- ## [/etc/percona-server.conf.d/mysqld.cnf is empty](https://forums.percona.com/t/etc-percona-server-conf-d-mysqld-cnf-is-empty/6880)
**Author:** [@galago](https://forums.percona.com/u/galago)\ **Replies:** 0\ **Last updated:** [March 3, 2019, 2:16am UTC](https://forums.percona.com/t/etc-percona-server-conf-d-mysqld-cnf-is-empty/6880 "2019-03-03T02:16:16Z")
Hi. I installed the server Percona Server as follows: \[url\]https://www.percona.com/doc/percona-server/LATEST/installation/yum\_repo.html\[/url\] percona-release setup ps80 yum install percona-server-server I started th… --- ## [Reference manual for syntax](https://forums.percona.com/t/reference-manual-for-syntax/6876)
**Author:** [@Egan](https://forums.percona.com/u/Egan)\ **Replies:** 0\ **Last updated:** [February 28, 2019, 9:09am UTC](https://forums.percona.com/t/reference-manual-for-syntax/6876 "2019-02-28T09:09:08Z")
My company uses Percona for our production MySQL environment. I recently found out about a Percona addon to the MySQL syntax to eliminate locking while creating indexes. Is there a reference manual with all of the syntac… --- ## [Installing TokuDB engine on Percona MySQL 5.7.24-27](https://forums.percona.com/t/installing-tokudb-engine-on-percona-mysql-5-7-24-27/6871)
**Author:** [@CAI\_Adam](https://forums.percona.com/u/CAI_Adam)\ **Replies:** 0\ **Last updated:** [February 27, 2019, 8:45am UTC](https://forums.percona.com/t/installing-tokudb-engine-on-percona-mysql-5-7-24-27/6871 "2019-02-27T08:45:05Z")
Greetings, I’ve installed Percona MySQL using the yum repository and now I’m running into trouble with trying to get the TokuDB engine installed. Documentation states that Percona Server 5.7 comes with TokuDB storage en… --- ## [Create foreign key with minimal locking](https://forums.percona.com/t/create-foreign-key-with-minimal-locking/6870)
**Author:** [@Egan](https://forums.percona.com/u/Egan)\ **Replies:** 0\ **Last updated:** [February 26, 2019, 12:13pm UTC](https://forums.percona.com/t/create-foreign-key-with-minimal-locking/6870 "2019-02-26T12:13:49Z")
I’m new to this forum. My company uses Percona in a MySQL 5.7 environment. Is there a way to create a foreign key without locking the underlying tables for a long time? Alternatively, is there a way to disable an fk, dro… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=6) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=8)