# Percona Server for MySQL 5.7 **URL:** https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=6 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 7 --- ## [Yocto recipe for percona server for poky 2.7.1](https://forums.percona.com/t/yocto-recipe-for-percona-server-for-poky-2-7-1/7766)
**Author:** [@sathishmls](https://forums.percona.com/u/sathishmls)\ **Replies:** 2\ **Last updated:** [July 16, 2020, 7:01am UTC](https://forums.percona.com/t/yocto-recipe-for-percona-server-for-poky-2-7-1/7766 "2020-07-16T07:01:16Z")
Hi Anyone has any suggestion to add percona server to poky 2.7.1 using recipe ? Thanks --- ## [Is this a Percona Bug - rejects the fieldname "virtual"](https://forums.percona.com/t/is-this-a-percona-bug-rejects-the-fieldname-virtual/7768)
**Author:** [@hder](https://forums.percona.com/u/hder)\ **Replies:** 1\ **Last updated:** [July 11, 2020, 9:33am UTC](https://forums.percona.com/t/is-this-a-percona-bug-rejects-the-fieldname-virtual/7768 "2020-07-11T09:33:57Z")
I have a simple query “SELECT virtual FROM groups”. Works in my Windows/Xampp/PHP7/MySQL (5.6) local setup, but in Percona (5.7) on Bluehost, but it rejects the field word “virtual”. I have to use the “SELECT groups.virt… --- ## [what's root cuase this problem when Percona Mysql auto restart this message error.](https://forums.percona.com/t/whats-root-cuase-this-problem-when-percona-mysql-auto-restart-this-message-error/7717)
**Author:** [@duyduy113](https://forums.percona.com/u/duyduy113)\ **Replies:** 3\ **Last updated:** [July 3, 2020, 7:00pm UTC](https://forums.percona.com/t/whats-root-cuase-this-problem-when-percona-mysql-auto-restart-this-message-error/7717 "2020-07-03T19:00:48Z")
Hi all Pls help me know what’s the root cause of the error with message bellow. At that time, MySQL will automatically restart. How I can do resolve this problem ? 2020-06-13T10:49:22.120854Z 16315919 \[ERROR\] \[MY-010833… --- ## [Using SQL\_CALC\_FOUND\_ROWS vs SELECT COUNT(\*)](https://forums.percona.com/t/using-sql-calc-found-rows-vs-select-count/7707)
**Author:** [@roushenas](https://forums.percona.com/u/roushenas)\ **Replies:** 1\ **Last updated:** [July 1, 2020, 7:31am UTC](https://forums.percona.com/t/using-sql-calc-found-rows-vs-select-count/7707 "2020-07-01T07:31:38Z")
It was in 2006 I heard about SQL\_CALC\_FOUND\_ROWS from @elektronaut, followed by @Peter comment. Since then, a lot of improvement being happened for MySQL. Considering concerns about indices, I am curious if using COUNT(\*… --- ## [Low performance in queries when we get several connections](https://forums.percona.com/t/low-performance-in-queries-when-we-get-several-connections/7303)
**Author:** [@pablo.barrachina](https://forums.percona.com/u/pablo.barrachina)\ **Replies:** 1\ **Last updated:** [June 14, 2020, 7:05am UTC](https://forums.percona.com/t/low-performance-in-queries-when-we-get-several-connections/7303 "2020-06-14T07:05:19Z")
Hi all, We are testing our database performance using JMeter. Our test call to a web service starting with 10 to 600 users on a time range of 15 minutes. The process adds them in a linear increase. At some moment, the … --- ## [Help Troubleshooting a behaivor with max connections and Max treads.](https://forums.percona.com/t/help-troubleshooting-a-behaivor-with-max-connections-and-max-treads/7671)
**Author:** [@albeda1](https://forums.percona.com/u/albeda1)\ **Replies:** 4\ **Last updated:** [June 12, 2020, 6:56am UTC](https://forums.percona.com/t/help-troubleshooting-a-behaivor-with-max-connections-and-max-treads/7671 "2020-06-12T06:56:54Z")
Hi People, It’s my first question here, after looking in a lot of places before. Any help will be welcome! Percona MySQL 5.7.24-27 running over a private on premise vmware vm, with external HP SAS 15k rpm disks, with 3… --- ## [Table full while deleting fast](https://forums.percona.com/t/table-full-while-deleting-fast/7577)
**Author:** [@McA](https://forums.percona.com/u/McA)\ **Replies:** 4\ **Last updated:** [May 25, 2020, 8:13am UTC](https://forums.percona.com/t/table-full-while-deleting-fast/7577 "2020-05-25T08:13:54Z")
Hi all,following situation. Percona Server 5.7.29-32 and a big table. I’m alone on that table so no other transactions are going on on the database. I’m deleting with autocommit in batches which fit into redo and undo lo… --- ## [Installation for Percona xtradb server 57 failed.](https://forums.percona.com/t/installation-for-percona-xtradb-server-57-failed/7639)
**Author:** [@JasonO](https://forums.percona.com/u/JasonO)\ **Replies:** 1\ **Last updated:** [May 18, 2020, 8:33am UTC](https://forums.percona.com/t/installation-for-percona-xtradb-server-57-failed/7639 "2020-05-18T08:33:22Z")
Hi All, I’m trying to get xtradb cluster installed on my new server. At first I notice that the new server which is on RHEL 6 comes with mysql installed. I’ve uninstalled the existing mysql & tried to run the installatio… --- ## [How to solve the problem "Package does not match intended download"](https://forums.percona.com/t/how-to-solve-the-problem-package-does-not-match-intended-download/7629)
**Author:** [@asiagate](https://forums.percona.com/u/asiagate)\ **Replies:** 2\ **Last updated:** [May 15, 2020, 6:09pm UTC](https://forums.percona.com/t/how-to-solve-the-problem-package-does-not-match-intended-download/7629 "2020-05-15T18:09:40Z")
=========================================================================================================================== Package Arch Version Repository … --- ## [segfault Percona Server 5.7.28-31](https://forums.percona.com/t/segfault-percona-server-5-7-28-31/7540)
**Author:** [@dinchu](https://forums.percona.com/u/dinchu)\ **Replies:** 1\ **Last updated:** [May 13, 2020, 7:58am UTC](https://forums.percona.com/t/segfault-percona-server-5-7-28-31/7540 "2020-05-13T07:58:06Z")
We run multiple percona mysql instances and in the last days we had a major failure on 2 of them mysql service stops logging (so nothing useful) and becomes unresponsive (all connections are refused) but while checking s… --- ## [max\_connections setting my my.cnf does not work](https://forums.percona.com/t/max-connections-setting-my-my-cnf-does-not-work/7611)
**Author:** [@roushenas](https://forums.percona.com/u/roushenas)\ **Replies:** 2\ **Last updated:** [May 11, 2020, 12:17am UTC](https://forums.percona.com/t/max-connections-setting-my-my-cnf-does-not-work/7611 "2020-05-11T00:17:37Z")
I am using Percona Server 5.7 on my VPS, and I have an issue with the setting of max\_connections is the config file. The default value is 151, and I wanna increase it to 200. I can do it simply by running this query on t… --- ## [Why Percona-Server-server-57 is not available in the repository?](https://forums.percona.com/t/why-percona-server-server-57-is-not-available-in-the-repository/7607)
**Author:** [@roushenas](https://forums.percona.com/u/roushenas)\ **Replies:** 1\ **Last updated:** [May 8, 2020, 1:05am UTC](https://forums.percona.com/t/why-percona-server-server-57-is-not-available-in-the-repository/7607 "2020-05-08T01:05:00Z")
I wanna install Percona server on my new CentOS 8 VM, I followed instructions on this page, added yum repo and tried to install the server using this command: yum install Percona-Server-server-57 But yum is unable to f… --- ## [Preload error at startup](https://forums.percona.com/t/preload-error-at-startup/7307)
**Author:** [@shade](https://forums.percona.com/u/shade)\ **Replies:** 2\ **Last updated:** [April 30, 2020, 4:24am UTC](https://forums.percona.com/t/preload-error-at-startup/7307 "2020-04-30T04:24:30Z")
Hello, I am using: percona-server-server-5.7 (5.7.28-31-1.bionic) on Ubuntu 18.04 LTS. I started getting these messages in the syslog on startup on the MySQL service: Nov 24 23:08:49 servername mysql-systemd-start\[771… --- ## [Bug: Explicit definer is ignored when I create an event](https://forums.percona.com/t/bug-explicit-definer-is-ignored-when-i-create-an-event/7565)
**Author:** [@andrew\_soloshko](https://forums.percona.com/u/andrew_soloshko)\ **Replies:** 3\ **Last updated:** [April 27, 2020, 10:01am UTC](https://forums.percona.com/t/bug-explicit-definer-is-ignored-when-i-create-an-event/7565 "2020-04-27T10:01:30Z")
Hi,I logged in to Percona MySQL5.7 (version 5.7.24-26-log Percona Server (GPL), Release 26, Revision c8fe767) as user ‘andrew’@‘localhost’. And I need to create an event with DEFINER = ‘root’@‘localhost’, and I am execut… --- ## [I found a broken link in installation document](https://forums.percona.com/t/i-found-a-broken-link-in-installation-document/7502)
**Author:** [@komainu8](https://forums.percona.com/u/komainu8)\ **Replies:** 1\ **Last updated:** [April 23, 2020, 1:01am UTC](https://forums.percona.com/t/i-found-a-broken-link-in-installation-document/7502 "2020-04-23T01:01:41Z")
Installing Percona Server for MySQL 5.7 — Percona Server 5.7 Documentation has a broken link. We execute wget as below in this page. $ wget Percona – The Database Performance Experts However, the above URL is old. Thi… --- ## [pt-online-schema-change: alter not working because of pxc\_strict\_mode = ENFORCING](https://forums.percona.com/t/pt-online-schema-change-alter-not-working-because-of-pxc-strict-mode-enforcing/7513)
**Author:** [@Ronny\_Gorner](https://forums.percona.com/u/Ronny_Gorner)\ **Replies:** 4\ **Last updated:** [April 21, 2020, 8:06am UTC](https://forums.percona.com/t/pt-online-schema-change-alter-not-working-because-of-pxc-strict-mode-enforcing/7513 "2020-04-21T08:06:19Z")
Howdy,first, thanks to all supporting this cool piece of software.However, we have a small issue (maybe not even a small but a major) on changing tables using Alter commands or scheme changes. This would normally result … --- ## [Percona MySQL Index Bug](https://forums.percona.com/t/percona-mysql-index-bug/7553)
**Author:** [@sqlercn](https://forums.percona.com/u/sqlercn)\ **Replies:** 1\ **Last updated:** [April 21, 2020, 4:00am UTC](https://forums.percona.com/t/percona-mysql-index-bug/7553 "2020-04-21T04:00:55Z")
My table schema is CREATE TABLE test ( \`id\` int(11) unsigned NOT NULL AUTO\_INCREMENT , \`class\_id\` int(11) unsigned NOT NULL DEFAULT '0' , \`stu\_id\` int(11) unsigned NOT NULL DEFAULT '0' , \`work\_id\` int(11) unsigned NOT… --- ## [There is not a source package against percona-server-server-5.7\_5.7.29-32-1.](https://forums.percona.com/t/there-is-not-a-source-package-against-percona-server-server-5-7-5-7-29-32-1/7485)
**Author:** [@komainu8](https://forums.percona.com/u/komainu8)\ **Replies:** 2\ **Last updated:** [March 30, 2020, 7:26pm UTC](https://forums.percona.com/t/there-is-not-a-source-package-against-percona-server-server-5-7-5-7-29-32-1/7485 "2020-03-30T19:26:16Z")
Hello, Currently, there is not a source package against percona-server-server-5.7\_5.7.29-32-1. The latest version of percona-server-server-5.7 is 5.7.29-32-1 now. However, if we get a source package of the latest vers… --- ## [mysql:queries and mysql:metrics not work ..](https://forums.percona.com/t/mysql-queries-and-mysql-metrics-not-work/7469)
**Author:** [@umargoury](https://forums.percona.com/u/umargoury)\ **Replies:** 1\ **Last updated:** [March 22, 2020, 5:11pm UTC](https://forums.percona.com/t/mysql-queries-and-mysql-metrics-not-work/7469 "2020-03-22T17:11:03Z")
Hello, we test the functionality pmm. We have only 1 server : - PMM Server (CentOS Linux release 7.7.1908 (Core) : http://89.200.136.175:8081/ PMM Client - 89.200.136.175 For the Slow Query check for QAN PMM on the … --- ## [MySQL options processing order](https://forums.percona.com/t/mysql-options-processing-order/7416)
**Author:** [@zentavr](https://forums.percona.com/u/zentavr)\ **Replies:** 1\ **Last updated:** [March 9, 2020, 6:32am UTC](https://forums.percona.com/t/mysql-options-processing-order/7416 "2020-03-09T06:32:18Z")
Hello, We use Percona MySQL from Percona’s reporitories for our Ubuntu servers. We have own Ansible role which installs the software at our infrastructure. The questions is how and where to specify MySQL options. /etc… --- ## [\[ERROR\] InnoDB: Error number 28 means 'No space left on device' when creating index??](https://forums.percona.com/t/error-innodb-error-number-28-means-no-space-left-on-device-when-creating-index/7358)
**Author:** [@jbiancot](https://forums.percona.com/u/jbiancot)\ **Replies:** 1\ **Last updated:** [December 24, 2019, 3:54am UTC](https://forums.percona.com/t/error-innodb-error-number-28-means-no-space-left-on-device-when-creating-index/7358 "2019-12-24T03:54:07Z")
Hi there, I am running a standalone Percona MySQL Server 5.7.25-28, then I am just trying to add an index on a table, well, the table is kind of big: it has over one billion records, around 92 GB of disk space, here is … --- ## [Pros and cons of changing the root username in MySQL](https://forums.percona.com/t/pros-and-cons-of-changing-the-root-username-in-mysql/7357)
**Author:** [@sawozny](https://forums.percona.com/u/sawozny)\ **Replies:** 0\ **Last updated:** [December 21, 2019, 4:15pm UTC](https://forums.percona.com/t/pros-and-cons-of-changing-the-root-username-in-mysql/7357 "2019-12-21T16:15:53Z")
Well, like it says on the tin, I’m curious if anyone has renamed the root@localhost MySQL user ID in operations and why (or, conversely, if you pushed back against it when requested and, of course, why). I can see there … --- ## [File download is very slow!!!](https://forums.percona.com/t/file-download-is-very-slow/7347)
**Author:** [@hiller](https://forums.percona.com/u/hiller)\ **Replies:** 3\ **Last updated:** [December 12, 2019, 9:09pm UTC](https://forums.percona.com/t/file-download-is-very-slow/7347 "2019-12-12T21:09:34Z")
I am a Chinese user, download \[url\]https://www.percona.com/downloads/Percona-Server-LATEST/Percona-Server-8.0.18-9/binary/tarball/Percona-Server-8.0.18-9-Linux\[/url\]. x86\_64.ssl101.tar.gz is very slow, hope to solve it! --- ## [Тоо many system locks since latest update to 5.7.28-31](https://forums.percona.com/t/many-system-locks-since-latest-update-to-5-7-28-31/7331)
**Author:** [@narodmon](https://forums.percona.com/u/narodmon)\ **Replies:** 0\ **Last updated:** [December 4, 2019, 5:05am UTC](https://forums.percona.com/t/many-system-locks-since-latest-update-to-5-7-28-31/7331 "2019-12-04T05:05:35Z")
Good day. We are using Percona in our non-coomercial IoT Project narodmon (public monitoring project). After the last update (via yum on CentOS 6.9) to 5.7.28-31 we have many sql system lock errors 1205 for simple UPDA… --- ## [Cannot join the cluster](https://forums.percona.com/t/cannot-join-the-cluster/7321)
**Author:** [@eraserx99](https://forums.percona.com/u/eraserx99)\ **Replies:** 0\ **Last updated:** [November 30, 2019, 11:39am UTC](https://forums.percona.com/t/cannot-join-the-cluster/7321 "2019-11-30T11:39:57Z")
Hi, We got a cluster of Percona Xtradb in production (on CentOS 5.7). This is what we have, Percona-XtraDB-Cluster-client-57.x86\_64 5.7.23-31.31.2.el7 @percona-release-x86\_64 Percona-XtraDB-Cluster-devel-57.x86\_64 5.7… --- ## [How to install MyRocks without .rpm - is there an .tar.gz available?](https://forums.percona.com/t/how-to-install-myrocks-without-rpm-is-there-an-tar-gz-available/7181)
**Author:** [@ralfv](https://forums.percona.com/u/ralfv)\ **Replies:** 1\ **Last updated:** [September 24, 2019, 1:39am UTC](https://forums.percona.com/t/how-to-install-myrocks-without-rpm-is-there-an-tar-gz-available/7181 "2019-09-24T01:39:37Z")
Since we install MySQL in user space based on Generic Linux .tar.gz we want (need) to do the same for MyRocks. Is there any way to do so? --- ## [Cant stop/start mysql](https://forums.percona.com/t/cant-stop-start-mysql/7215)
**Author:** [@kivale](https://forums.percona.com/u/kivale)\ **Replies:** 0\ **Last updated:** [September 24, 2019, 1:14am UTC](https://forums.percona.com/t/cant-stop-start-mysql/7215 "2019-09-24T01:14:34Z")
HI, I have an issue after upgrade mysql percona xtradbcluster version 57. i try to re upgrade percona xtradb cluster with remove dir. i do this : 1.stop mysql and remove curent config 2.remove percona \>\> apt-get rem… --- ## [TokuDB Table Size On Disk Question](https://forums.percona.com/t/tokudb-table-size-on-disk-question/7211)
**Author:** [@Jeff\_Ward](https://forums.percona.com/u/Jeff_Ward)\ **Replies:** 0\ **Last updated:** [September 20, 2019, 2:03pm UTC](https://forums.percona.com/t/tokudb-table-size-on-disk-question/7211 "2019-09-20T14:03:21Z")
I have been googling and I have ended up completely unsure how to do this. mysql Ver 14.14 Distrib 5.7.27-30, for debian-linux-gnu (x86\_64) using 7.0 Using TokuDB I have a table with over 2 billion rows. 33GB on disk.… --- ## [5.7.26-29-57-log Percona XtraDB Cluster now tables can not be read](https://forums.percona.com/t/5-7-26-29-57-log-percona-xtradb-cluster-now-tables-can-not-be-read/7201)
**Author:** [@MasterCATZ](https://forums.percona.com/u/MasterCATZ)\ **Replies:** 2\ **Last updated:** [September 14, 2019, 7:46am UTC](https://forums.percona.com/t/5-7-26-29-57-log-percona-xtradb-cluster-now-tables-can-not-be-read/7201 "2019-09-14T07:46:53Z")
Ubuntu did a few updates recently one of them was Server version: 5.7.26-29-57-log Percona XtraDB Cluster (GPL), Release rel29, Revision 03540a3, WSREP version 31.37, wsrep\_31.37 Now nothing seems to be able to access … --- ## [audit\_log logs statements within stored programs](https://forums.percona.com/t/audit-log-logs-statements-within-stored-programs/7171)
**Author:** [@kubanowsky](https://forums.percona.com/u/kubanowsky)\ **Replies:** 0\ **Last updated:** [August 26, 2019, 7:27am UTC](https://forums.percona.com/t/audit-log-logs-statements-within-stored-programs/7171 "2019-08-26T07:27:47Z")
Hi, I’ve came up with problem - I’m using percona-server in 5.7.25-28 version on Debian9 (stretch) with audit\_log plugin and it seem to be logging statemets executed by trigger, which definer is not on audit\_log\_include… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=5) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-7/18.md?page=7)