# Percona Server for MySQL 5.6 **URL:** https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.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 --- ## [All of nodes down in cluster](https://forums.percona.com/t/all-of-nodes-down-in-cluster/5041)
**Author:** [@road2me](https://forums.percona.com/u/road2me)\ **Replies:** 1\ **Last updated:** [February 14, 2017, 12:17am UTC](https://forums.percona.com/t/all-of-nodes-down-in-cluster/5041 "2017-02-14T00:17:49Z")
Hello, Today, I had issue with cluster. All of nodes have been shutdown in the same time. I have 3 nodes cluster. In logs I sppotted that wsrep initial shutdown: 2016-08-19 10:01:14 1830 \[Warning\] WSREP: certification… --- ## [Percona Server 5.6.35-80.0 is now available](https://forums.percona.com/t/percona-server-5-6-35-80-0-is-now-available/5404)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [February 8, 2017, 10:27am UTC](https://forums.percona.com/t/percona-server-5-6-35-80-0-is-now-available/5404 "2017-02-08T10:27:20Z")
Percona announces the release of Percona Server 5.6.35-80.0 on February 8, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.35, including all the bug f… --- ## [Cannot start logging of slow queries at run-time](https://forums.percona.com/t/cannot-start-logging-of-slow-queries-at-run-time/5337)
**Author:** [@mskidan](https://forums.percona.com/u/mskidan)\ **Replies:** 1\ **Last updated:** [January 13, 2017, 9:57am UTC](https://forums.percona.com/t/cannot-start-logging-of-slow-queries-at-run-time/5337 "2017-01-13T09:57:48Z")
Hi! I cannot configure my Percona-mysql instance to start logging of slow queries: Server version: 5.6.21-70.1-56-log Percona XtraDB Cluster (GPL), Release rel70.1, Revision 938, WSREP version 25.8, wsrep\_25.8.r4150 I… --- ## [Migrate from 5.6.27-76.0-1 to 5.6.34-79.1-1 results high IOWAIT](https://forums.percona.com/t/migrate-from-5-6-27-76-0-1-to-5-6-34-79-1-1-results-high-iowait/5328)
**Author:** [@Jayesh\_Labade](https://forums.percona.com/u/Jayesh_Labade)\ **Replies:** 0\ **Last updated:** [December 29, 2016, 4:22am UTC](https://forums.percona.com/t/migrate-from-5-6-27-76-0-1-to-5-6-34-79-1-1-results-high-iowait/5328 "2016-12-29T04:22:54Z")
Hi, As my old server has some hardware issue i took full backup from xtrabackup ver. 2.3 and restored in new server. Both old and new server has exactly identical specs. Next Day, when i started my activities on new se… --- ## [Migrate Mysql to Percona](https://forums.percona.com/t/migrate-mysql-to-percona/5327)
**Author:** [@bplegend](https://forums.percona.com/u/bplegend)\ **Replies:** 0\ **Last updated:** [December 28, 2016, 6:31pm UTC](https://forums.percona.com/t/migrate-mysql-to-percona/5327 "2016-12-28T18:31:35Z")
Hi all, We are looking to migrate to Percona server. We are currently running 5.5 MySQL on Solaris (x86) with master and slaves. I was thinking setting a new Linux host with percona 5.6 as a new slave and shutdown one 5… --- ## [MySQL hangs periodically](https://forums.percona.com/t/mysql-hangs-periodically/5305)
**Author:** [@Gadd](https://forums.percona.com/u/Gadd)\ **Replies:** 1\ **Last updated:** [December 19, 2016, 8:36pm UTC](https://forums.percona.com/t/mysql-hangs-periodically/5305 "2016-12-19T20:36:27Z")
Hi I have a few Percona servers 5.6.25-73.1 with workload about 5-6k qps, especially DML workload. All fine, but sometimes servers hangs. For example i am doing simple querys like: “select \* from information\_schema.QUER… --- ## [Compilation of Sphinx 2.2.10 failed with Percona Server 5.6.34](https://forums.percona.com/t/compilation-of-sphinx-2-2-10-failed-with-percona-server-5-6-34/5276)
**Author:** [@Nathalie\_Marsan](https://forums.percona.com/u/Nathalie_Marsan)\ **Replies:** 0\ **Last updated:** [December 9, 2016, 10:31am UTC](https://forums.percona.com/t/compilation-of-sphinx-2-2-10-failed-with-percona-server-5-6-34/5276 "2016-12-09T10:31:50Z")
Hi, I have a problem with the new release of Percona Server. Indeed, since the release of Percona Server 5.6.34-79.1, I’m no longer able to compile Percona with the open-source search server Sphinx 2.2.10. I used a ba… --- ## [innobackupex is not backing up my innodb database and table](https://forums.percona.com/t/innobackupex-is-not-backing-up-my-innodb-database-and-table/5258)
**Author:** [@stephensonk](https://forums.percona.com/u/stephensonk)\ **Replies:** 0\ **Last updated:** [December 5, 2016, 3:20pm UTC](https://forums.percona.com/t/innobackupex-is-not-backing-up-my-innodb-database-and-table/5258 "2016-12-05T15:20:39Z")
I setup xtrabackup and a mysql database to backup. When I run the below command, my database kyle and table che that is innodb does not get backed up. Any ideas on why? innobackupex --host=10.124.164.14 --user=bkpuser -… --- ## [Percona Server 5.6.34-79.1 is now available](https://forums.percona.com/t/percona-server-5-6-34-79-1-is-now-available/5243)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [November 29, 2016, 6:41am UTC](https://forums.percona.com/t/percona-server-5-6-34-79-1-is-now-available/5243 "2016-11-29T06:41:33Z")
Percona announces the release of Percona Server 5.6.34-79.1 on November 23, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.34, including all the bug … --- ## [upgrade cluster from 5.6 to 5.7, problem with index?](https://forums.percona.com/t/upgrade-cluster-from-5-6-to-5-7-problem-with-index/5221)
**Author:** [@road2me](https://forums.percona.com/u/road2me)\ **Replies:** 0\ **Last updated:** [November 21, 2016, 5:14am UTC](https://forums.percona.com/t/upgrade-cluster-from-5-6-to-5-7-problem-with-index/5221 "2016-11-21T05:14:07Z")
Hello, We have 3 nodes cluster (5.6) and recently we’ve tried to upgrade cluster to 5.7 version. It’s been used below manual: \[url\]https://www.percona.com/doc/percona-xtradb-cluster/5.7/install/upgrade\_guide.html\[/url\] … --- ## [Master-Slave Database size difference](https://forums.percona.com/t/master-slave-database-size-difference/5206)
**Author:** [@abreng01](https://forums.percona.com/u/abreng01)\ **Replies:** 0\ **Last updated:** [November 13, 2016, 10:51am UTC](https://forums.percona.com/t/master-slave-database-size-difference/5206 "2016-11-13T10:51:02Z")
I have a Master-Slave replication setup running on Percona Server 5.6.32. Slave is read only and there are no other admin users with super privileges other than the one I hold. What I observed was the database size in Ma… --- ## [Is there a cleaner way to store fractional seconds in update times?](https://forums.percona.com/t/is-there-a-cleaner-way-to-store-fractional-seconds-in-update-times/5195)
**Author:** [@tuple](https://forums.percona.com/u/tuple)\ **Replies:** 0\ **Last updated:** [November 7, 2016, 8:09pm UTC](https://forums.percona.com/t/is-there-a-cleaner-way-to-store-fractional-seconds-in-update-times/5195 "2016-11-07T20:09:06Z")
Percona 5.6.32 : mysql\> create table test0( → id int(2) not null auto\_increment, → modified timestamp not null default current\_timestamp on update current\_timestamp, → primary key (id) → ); Query OK, 0 rows affected (0.… --- ## [Memory leak suspected in 5.6.31-77.0](https://forums.percona.com/t/memory-leak-suspected-in-5-6-31-77-0/5063)
**Author:** [@sureshlaz](https://forums.percona.com/u/sureshlaz)\ **Replies:** 10\ **Last updated:** [November 2, 2016, 12:52am UTC](https://forums.percona.com/t/memory-leak-suspected-in-5-6-31-77-0/5063 "2016-11-02T00:52:35Z")
Hi, On our production master servers, we have noticed that mysql is using more memory than the max calculated memory by mysqltuner.sql. As a result, after three days of activity, oom-killer is restarting mysqld process.… --- ## [Is there a way to actually limit InnoDB data dictionary?](https://forums.percona.com/t/is-there-a-way-to-actually-limit-innodb-data-dictionary/5170)
**Author:** [@HTF1](https://forums.percona.com/u/HTF1)\ **Replies:** 4\ **Last updated:** [October 30, 2016, 4:30pm UTC](https://forums.percona.com/t/is-there-a-way-to-actually-limit-innodb-data-dictionary/5170 "2016-10-30T16:30:52Z")
I would like downgrade AWS instance to save the costs however due to the number of tables and workload (logical backups) InnoDB data dictionary grows extremely large. mysql\> SELECT COUNT(\*) FROM information\_schema.INNOD… --- ## [Percona Server 5.6.33-79.0 is now available](https://forums.percona.com/t/percona-server-5-6-33-79-0-is-now-available/5161)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [October 19, 2016, 10:56am UTC](https://forums.percona.com/t/percona-server-5-6-33-79-0-is-now-available/5161 "2016-10-19T10:56:18Z")
Percona announces the release of Percona Server 5.6.33-79.0 on October 18th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.33, including all the bug… --- ## [Incremental cluster update](https://forums.percona.com/t/incremental-cluster-update/5102)
**Author:** [@chris\_elliott](https://forums.percona.com/u/chris_elliott)\ **Replies:** 1\ **Last updated:** [October 11, 2016, 1:21pm UTC](https://forums.percona.com/t/incremental-cluster-update/5102 "2016-10-11T13:21:58Z")
Hi All We have a percona cluster where 1x of the nodes has crashed multiple times without any obvious reason. I’ve given the server a thorough check over and hardware/filesystems etc all look healthy. It’s running quit… --- ## [Question about Percona XtraDB Cluster Upgrade](https://forums.percona.com/t/question-about-percona-xtradb-cluster-upgrade/5141)
**Author:** [@penguins\_and\_such](https://forums.percona.com/u/penguins_and_such)\ **Replies:** 0\ **Last updated:** [October 11, 2016, 9:28am UTC](https://forums.percona.com/t/question-about-percona-xtradb-cluster-upgrade/5141 "2016-10-11T09:28:23Z")
Howdy, I’m preparing to update an existing (production) Percona XtraDB Cluster (3 nodes). This will be a point release upgrade, going from 5.6.24-72.2 → 5.6.32-25.17. This will be the first time upgrading a production … --- ## [TokuDB -\> Percona Server upgrade path?](https://forums.percona.com/t/tokudb-percona-server-upgrade-path/4348)
**Author:** [@azilber](https://forums.percona.com/u/azilber)\ **Replies:** 4\ **Last updated:** [September 21, 2016, 11:26am UTC](https://forums.percona.com/t/tokudb-percona-server-upgrade-path/4348 "2016-09-21T11:26:08Z")
Hi, Now that Tokutek’s TokuDB builds are no longer available, what is the proper upgrade path? We have servers running some old TokuDB versions, and some newer versions (but none running the latest). Is it a drop-in rep… --- ## [MySQL showing incorrect version?](https://forums.percona.com/t/mysql-showing-incorrect-version/5035)
**Author:** [@akalaj](https://forums.percona.com/u/akalaj)\ **Replies:** 3\ **Last updated:** [September 20, 2016, 5:29pm UTC](https://forums.percona.com/t/mysql-showing-incorrect-version/5035 "2016-09-20T17:29:45Z")
I recently did a fresh install of MySQL 5.6.23 and overwrote my previous 5.6.17 basedir, datadir, and init files with content from the Percona 5.6.23 directory. However, now that everything has been installed, the logs a… --- ## [When will YUM repo be updated with 5.6.32 to patch CVE-2016-06662 ?](https://forums.percona.com/t/when-will-yum-repo-be-updated-with-5-6-32-to-patch-cve-2016-06662/5096)
**Author:** [@peter.morgan](https://forums.percona.com/u/peter.morgan)\ **Replies:** 0\ **Last updated:** [September 20, 2016, 10:09am UTC](https://forums.percona.com/t/when-will-yum-repo-be-updated-with-5-6-32-to-patch-cve-2016-06662/5096 "2016-09-20T10:09:04Z")
Is it usual for the YUM repo to lag behind the latest packages available for manual download? The repo contains 5.6.30 as latest, but the download page has 5.6.32 which includes the patch for CVE-2016-6662. --- ## [auth\_pam\_compat delayed failure?](https://forums.percona.com/t/auth-pam-compat-delayed-failure/5090)
**Author:** [@chawley](https://forums.percona.com/u/chawley)\ **Replies:** 1\ **Last updated:** [September 16, 2016, 2:04pm UTC](https://forums.percona.com/t/auth-pam-compat-delayed-failure/5090 "2016-09-16T14:04:19Z")
account checks fail for ‘@’: user disallowed by .k5login file for ‘’ authentication fails for ‘’ (@): Permission denied (Success) pam\_krb5\[8245\]: pam\_authenticate returning 6 (Permission denied) 2016-9-13 innodb-write… --- ## [Fresh install and: #mysql: unknown option '--CLIENT'](https://forums.percona.com/t/fresh-install-and-mysql-unknown-option-client/3294)
**Author:** [@Seregwethrin](https://forums.percona.com/u/Seregwethrin)\ **Replies:** 1\ **Last updated:** [September 14, 2016, 4:58pm UTC](https://forums.percona.com/t/fresh-install-and-mysql-unknown-option-client/3294 "2016-09-14T16:58:57Z")
Hi, I just installed Percona server 5.6 on Linux 2.6.32-431.1.2.0.1.el6.i686 I think it installed with a default password because: /usr/bin/mysql\_secure\_installation This doesn’t accept empty password. I tried to re… --- ## [TokuDB bulk delete after not decrease disk size?](https://forums.percona.com/t/tokudb-bulk-delete-after-not-decrease-disk-size/5071)
**Author:** [@Sodjamts](https://forums.percona.com/u/Sodjamts)\ **Replies:** 3\ **Last updated:** [September 8, 2016, 8:19pm UTC](https://forums.percona.com/t/tokudb-bulk-delete-after-not-decrease-disk-size/5071 "2016-09-08T20:19:11Z")
I have been using Percona server with TokuDB engine for 2 years. Now I have a one problem. I have used TokuDB row format LZMA by COMPRESSED option on LOGSERVER. This table 200M rows and now our disk 91%. So I need to des… --- ## [Curious apparent index lookup failure. Can anyone explain this unexpected behavior?](https://forums.percona.com/t/curious-apparent-index-lookup-failure-can-anyone-explain-this-unexpected-behavior/5070)
**Author:** [@unixronin](https://forums.percona.com/u/unixronin)\ **Replies:** 0\ **Last updated:** [September 7, 2016, 11:16am UTC](https://forums.percona.com/t/curious-apparent-index-lookup-failure-can-anyone-explain-this-unexpected-behavior/5070 "2016-09-07T11:16:52Z")
I have run across what appears to be a strange indexing failure, and a rather counter-intuitive workaround for it. This is in Percona Server 5.6.29-76.2-log, amd64 platform, running on RHEL6.7. Consider the following ta… --- ## [auto restart on kill](https://forums.percona.com/t/auto-restart-on-kill/5053)
**Author:** [@peter9370](https://forums.percona.com/u/peter9370)\ **Replies:** 1\ **Last updated:** [August 28, 2016, 5:41am UTC](https://forums.percona.com/t/auto-restart-on-kill/5053 "2016-08-28T05:41:02Z")
Sorry if this is a FAQ - I’ve googled high and low for an answer and not found anything specific. I’m running Percona 5.6.29 under ubuntu 14.04. Recently, I had to issue “kill -9” to shut down a mysqld process (I really… --- ## [Very slow database response. I suspect InnoDB .](https://forums.percona.com/t/very-slow-database-response-i-suspect-innodb/5021)
**Author:** [@Abadon](https://forums.percona.com/u/Abadon)\ **Replies:** 0\ **Last updated:** [August 4, 2016, 12:33pm UTC](https://forums.percona.com/t/very-slow-database-response-i-suspect-innodb/5021 "2016-08-04T12:33:03Z")
Hello, I have two database servers with almost the same hardware and software configurations. The load of the servers is almost equal. The problem is that the first server works as snail compared with the second server. … --- ## [Very very slow queries!](https://forums.percona.com/t/very-very-slow-queries/4974)
**Author:** [@Luca\_Leen](https://forums.percona.com/u/Luca_Leen)\ **Replies:** 0\ **Last updated:** [July 17, 2016, 2:03pm UTC](https://forums.percona.com/t/very-very-slow-queries/4974 "2016-07-17T14:03:42Z")
Hi to all, I’m trying a percona xtradb cluster (3 nodes) on a rancher environment (automatically created from rancher catalog). Replication works great, but I’ve lots of problems with slow queries. First of all, for ex… --- ## [Upgrade to Percona 5.6.30,something happened](https://forums.percona.com/t/upgrade-to-percona-5-6-30-something-happened/4953)
**Author:** [@linyue](https://forums.percona.com/u/linyue)\ **Replies:** 0\ **Last updated:** [July 5, 2016, 9:03pm UTC](https://forums.percona.com/t/upgrade-to-percona-5-6-30-something-happened/4953 "2016-07-05T21:03:10Z")
After I upgrade to Percona 5.6.30,my long\_query\_time set 1s, in slow log many “# administrator command: Prepare;” occured , it cost 1-3s . And “SELECT @@session.tx\_isolation;" “SET SESSION TRANSACTION ISOLATION LEVEL REA… --- ## [How to add new column in a big table](https://forums.percona.com/t/how-to-add-new-column-in-a-big-table/4942)
**Author:** [@xsauce](https://forums.percona.com/u/xsauce)\ **Replies:** 0\ **Last updated:** [June 25, 2016, 3:14am UTC](https://forums.percona.com/t/how-to-add-new-column-in-a-big-table/4942 "2016-06-25T03:14:28Z")
Hello, I am working on finding the fastest way to add new column in a big table. The big table has about 30 millions rows and 30 columns, and another three big tables refers to its primary key. Our database is Percona 5… --- ## [PXC to single server](https://forums.percona.com/t/pxc-to-single-server/4919)
**Author:** [@umarzuki](https://forums.percona.com/u/umarzuki)\ **Replies:** 0\ **Last updated:** [June 6, 2016, 10:03pm UTC](https://forums.percona.com/t/pxc-to-single-server/4919 "2016-06-06T22:03:39Z")
Can I just copy /var/lib/mysql from one of PXC node (service stopped) to /var/lib/mysql of a new server, then install percona-server-server-5.6 on that new server ? [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.md?page=2) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.md?page=4)