# Percona Server for MySQL 5.6 **URL:** https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.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 --- ## [Help](https://forums.percona.com/t/help/4860)
**Author:** [@ringostarr](https://forums.percona.com/u/ringostarr)\ **Replies:** 2\ **Last updated:** [May 23, 2016, 3:36am UTC](https://forums.percona.com/t/help/4860 "2016-05-23T03:36:32Z")
Hello! How to enable this innodb\_file\_per\_table = On. default\_storage\_engine = MyISAM What file I need to edit/ Please, most detailed? I’m noob at this. --- ## [Help with rolling Upgrade](https://forums.percona.com/t/help-with-rolling-upgrade/4881)
**Author:** [@OS\_DBA](https://forums.percona.com/u/OS_DBA)\ **Replies:** 1\ **Last updated:** [May 23, 2016, 3:35am UTC](https://forums.percona.com/t/help-with-rolling-upgrade/4881 "2016-05-23T03:35:25Z")
Architecture: MySQL 5.6.24 two node active-passive cluster managed by Pacemaker (with MySQL replication), with DRDB mirrored file system for the Magento application tier. What we need to do: Rolling upgrade to 5.6.29,… --- ## [NUMA CentOS 5.x vs CentOS 6.x differences](https://forums.percona.com/t/numa-centos-5-x-vs-centos-6-x-differences/4894)
**Author:** [@tsolodov](https://forums.percona.com/u/tsolodov)\ **Replies:** 0\ **Last updated:** [May 23, 2016, 3:03am UTC](https://forums.percona.com/t/numa-centos-5-x-vs-centos-6-x-differences/4894 "2016-05-23T03:03:00Z")
Hello All. We are in a process of migration CentOS 5.x → CenstOS 6.x, we are using Percona 5.6.26 release and I found interesting behaviour: CentOS 6.x based systems are swapping even with 4 GB buffer pool size and 32G… --- ## [GTID Migration](https://forums.percona.com/t/gtid-migration/4856)
**Author:** [@andblais123](https://forums.percona.com/u/andblais123)\ **Replies:** 3\ **Last updated:** [April 26, 2016, 9:34am UTC](https://forums.percona.com/t/gtid-migration/4856 "2016-04-26T09:34:05Z")
Little Background: masters running version 5.6.17-65.0-rel65.0-log no GTID enabled replicas running version 5.6.29-76.2-log We are looking to migrate all our servers to GTID. I have setup many of them already (getting… --- ## [Percona 5.5 (sorry to post here, there was no channel for 5.5)](https://forums.percona.com/t/percona-5-5-sorry-to-post-here-there-was-no-channel-for-5-5/4849)
**Author:** [@stevejohnson](https://forums.percona.com/u/stevejohnson)\ **Replies:** 1\ **Last updated:** [April 21, 2016, 7:59pm UTC](https://forums.percona.com/t/percona-5-5-sorry-to-post-here-there-was-no-channel-for-5-5/4849 "2016-04-21T19:59:49Z")
hello, I have a droplet on DigitalOcean, and i was using Mysql 5.5 with my ubuntu 14.04. Recently i switched to Percona (i used 5.5 as my mysql was 5.5). After replacing my mysql, i realized that my server was MyISAM in… --- ## [Percona5.6.10 get error ERROR! The server quit without updating PID file](https://forums.percona.com/t/percona5-6-10-get-error-error-the-server-quit-without-updating-pid-file/2870)
**Author:** [@hellogxp](https://forums.percona.com/u/hellogxp)\ **Replies:** 2\ **Last updated:** [April 2, 2016, 2:18am UTC](https://forums.percona.com/t/percona5-6-10-get-error-error-the-server-quit-without-updating-pid-file/2870 "2016-04-02T02:18:46Z")
hey i have meet the same problem,and i install percona5.6.10 via compile(i download Percona-Server-5.6.10-alpha60.2.tar.gz),when i finished install, all is well,but after a short time when i use /etc/init.d/mysqld restar… --- ## [Clone a DB](https://forums.percona.com/t/clone-a-db/4812)
**Author:** [@EmergeBrandon](https://forums.percona.com/u/EmergeBrandon)\ **Replies:** 1\ **Last updated:** [March 28, 2016, 4:11pm UTC](https://forums.percona.com/t/clone-a-db/4812 "2016-03-28T16:11:40Z")
I have database text\_production and I want to create a database called txt\_development with the same information. I have a 3 node Galera cluster with percona 5.6, I dont want to cause any galera locks. So I dont think I … --- ## [dockerized percona server doesn't start with mounted volume](https://forums.percona.com/t/dockerized-percona-server-doesnt-start-with-mounted-volume/4792)
**Author:** [@lvic4594](https://forums.percona.com/u/lvic4594)\ **Replies:** 0\ **Last updated:** [March 18, 2016, 9:20am UTC](https://forums.percona.com/t/dockerized-percona-server-doesnt-start-with-mounted-volume/4792 "2016-03-18T09:20:41Z")
I am running Percona Server 5.6 inside of docker container and it works until I am trying to mount internal /var/lib/mysql volume to the host directory /home/me/data to provide persistence between container restarts: do… --- ## [Executed\_Gtid\_Set](https://forums.percona.com/t/executed-gtid-set/4781)
**Author:** [@EmergeBrandon](https://forums.percona.com/u/EmergeBrandon)\ **Replies:** 8\ **Last updated:** [March 17, 2016, 7:31am UTC](https://forums.percona.com/t/executed-gtid-set/4781 "2016-03-17T07:31:11Z")
Hello, I have a 3 node galera cluster(multi master) running on: Server version: 5.6.24-72.2-56-log Percona XtraDB Cluster (GPL), Release rel72.2, Revision 1, WSREP version 25.11, wsrep\_25.11 My slave hangs off node1 f… --- ## [Why MySQL only Use ONE THREAD for Query](https://forums.percona.com/t/why-mysql-only-use-one-thread-for-query/4679)
**Author:** [@tonysunxd](https://forums.percona.com/u/tonysunxd)\ **Replies:** 1\ **Last updated:** [March 14, 2016, 10:00am UTC](https://forums.percona.com/t/why-mysql-only-use-one-thread-for-query/4679 "2016-03-14T10:00:48Z")
Hi Gurus, I have a question that puzzled me long time. I was using percona 5.6 as my MySQL database version. From the documents, I know that there are two variables: innodb\_read\_io\_threads and innodb\_write\_io\_threads ca… --- ## [Is INSERT slower in xtradb when compared to innodb?](https://forums.percona.com/t/is-insert-slower-in-xtradb-when-compared-to-innodb/3840)
**Author:** [@acerola](https://forums.percona.com/u/acerola)\ **Replies:** 2\ **Last updated:** [March 14, 2016, 9:42am UTC](https://forums.percona.com/t/is-insert-slower-in-xtradb-when-compared-to-innodb/3840 "2016-03-14T09:42:13Z")
I recently changed hardware for my database. I also changed form MySQL 5.6 to Percona 5.6. I noticed that insertions are much slower, like 10+ times slower. I am using the same database and the same configuration I used… --- ## [Percona 5.6.14-56 very high memory usage.](https://forums.percona.com/t/percona-5-6-14-56-very-high-memory-usage/3030)
**Author:** [@dan2600](https://forums.percona.com/u/dan2600)\ **Replies:** 11\ **Last updated:** [February 15, 2016, 8:40pm UTC](https://forums.percona.com/t/percona-5-6-14-56-very-high-memory-usage/3030 "2016-02-15T20:40:25Z")
I recently, blindly, updated to Percona 5.6 via the repos. I’m not running a very sophisticated database (it’s a small user group (\<10) mostly for displaying timed data that can be inputed via an php interface). I have a… --- ## [random restarts](https://forums.percona.com/t/random-restarts/4681)
**Author:** [@stormdust](https://forums.percona.com/u/stormdust)\ **Replies:** 0\ **Last updated:** [January 25, 2016, 7:09am UTC](https://forums.percona.com/t/random-restarts/4681 "2016-01-25T07:09:40Z")
Hi guys, i keep getting this random restarts with the error below and can´t figure it out wich table is getting this nor nothing. Im using 5.6.28 version of percona and currently im using innodb checksum algoritm. this… --- ## [Percona 5.6 server tcp connection](https://forums.percona.com/t/percona-5-6-server-tcp-connection/4618)
**Author:** [@vlyamtse](https://forums.percona.com/u/vlyamtse)\ **Replies:** 1\ **Last updated:** [December 21, 2015, 10:59am UTC](https://forums.percona.com/t/percona-5-6-server-tcp-connection/4618 "2015-12-21T10:59:37Z")
Hello, I just installed Percona Server 5.6 on Ubuntu 14.04 LTS ( standard binary distribution)… I am trying to connect to the server from different host I am going to grant privileges to ‘root’ accessing db from remote… --- ## [errors in the log file](https://forums.percona.com/t/errors-in-the-log-file/3327)
**Author:** [@manjulaseneviratne](https://forums.percona.com/u/manjulaseneviratne)\ **Replies:** 3\ **Last updated:** [December 21, 2015, 2:54am UTC](https://forums.percona.com/t/errors-in-the-log-file/3327 "2015-12-21T02:54:10Z")
Hi All, I am getting below errors from my Percona 5.6 64bit database. Could you please help me to understand those and take some corrective steps to our come those errors. If you would like have complete error log to an… --- ## [memcached plugin doesn't seem to work](https://forums.percona.com/t/memcached-plugin-doesnt-seem-to-work/4563)
**Author:** [@vadimyer](https://forums.percona.com/u/vadimyer)\ **Replies:** 0\ **Last updated:** [December 3, 2015, 9:51am UTC](https://forums.percona.com/t/memcached-plugin-doesnt-seem-to-work/4563 "2015-12-03T09:51:44Z")
Hi, I’m using Percona v. 5.6.26-74.0 with memcached plugin installed by following the guidelines: \[url\]http://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-installing.html\[/url\] Mysql clearly shows that memcached da… --- ## [Problems with online gtid deployment](https://forums.percona.com/t/problems-with-online-gtid-deployment/4535)
**Author:** [@om\_marcel](https://forums.percona.com/u/om_marcel)\ **Replies:** 0\ **Last updated:** [November 19, 2015, 10:29am UTC](https://forums.percona.com/t/problems-with-online-gtid-deployment/4535 "2015-11-19T10:29:12Z")
Hi All, we are trying to switch from traditional replication to gtid based replication with the online gtid deployment method percona server 5.6 offers. Before I describe the issue in more detail here are some Informat… --- ## [Increase MAX\_INDEX on a table](https://forums.percona.com/t/increase-max-index-on-a-table/4455)
**Author:** [@nhadie](https://forums.percona.com/u/nhadie)\ **Replies:** 2\ **Last updated:** [October 15, 2015, 6:46pm UTC](https://forums.percona.com/t/increase-max-index-on-a-table/4455 "2015-10-15T18:46:05Z")
Hi All, Our devs just reported experiencing adding index on a table, as it hit the maximum number of indexes ( 64 ). Browsing for a solution, found that i need to recompile. Since we used percona’s deb repository, i al… --- ## [Percona TokuDB recovery running over 24 hours](https://forums.percona.com/t/percona-tokudb-recovery-running-over-24-hours/4335)
**Author:** [@lb\_michael](https://forums.percona.com/u/lb_michael)\ **Replies:** 2\ **Last updated:** [September 24, 2015, 11:09am UTC](https://forums.percona.com/t/percona-tokudb-recovery-running-over-24-hours/4335 "2015-09-24T11:09:53Z")
Yesterday, we had a situation that presented (at least to my eyes) like a deadlock. A Truncate table (running against an un-contended) table, had been issued, it’s status was “query completed” but never cleared from the … --- ## [Updating Percona MySQL Server](https://forums.percona.com/t/updating-percona-mysql-server/4406)
**Author:** [@slence](https://forums.percona.com/u/slence)\ **Replies:** 0\ **Last updated:** [September 18, 2015, 6:27am UTC](https://forums.percona.com/t/updating-percona-mysql-server/4406 "2015-09-18T06:27:43Z")
Hi, i’m having some problemas while updating percona mysql server: Installing percona-server-server-5.6 (5.6.26-74.0-1.trusty) … Stopping MySQL (Percona Server) mysqld \[ OK \] Percona Server is distributed with sev… --- ## [MYSQL DB V5.6.21 on server V5.1](https://forums.percona.com/t/mysql-db-v5-6-21-on-server-v5-1/4385)
**Author:** [@narengokal](https://forums.percona.com/u/narengokal)\ **Replies:** 0\ **Last updated:** [September 7, 2015, 1:47pm UTC](https://forums.percona.com/t/mysql-db-v5-6-21-on-server-v5-1/4385 "2015-09-07T13:47:11Z")
Hi, Reading this site, it says, that questions can be asked/discussed. Apologies if I have misunderstood, but anyway, here goes … I have this website which ive developed using MySQL V5.6.21 … However, when I implemente… --- ## [Mysql help](https://forums.percona.com/t/mysql-help/4375)
**Author:** [@searchsupplement](https://forums.percona.com/u/searchsupplement)\ **Replies:** 1\ **Last updated:** [August 31, 2015, 6:14pm UTC](https://forums.percona.com/t/mysql-help/4375 "2015-08-31T18:14:27Z")
How to link a web inquiry form to my sql server --- ## [Same host, cross database transactions possible? Percona/MySQL, Innodb/ExtraDb](https://forums.percona.com/t/same-host-cross-database-transactions-possible-percona-mysql-innodb-extradb/4286)
**Author:** [@perconagw](https://forums.percona.com/u/perconagw)\ **Replies:** 1\ **Last updated:** [July 8, 2015, 10:52am UTC](https://forums.percona.com/t/same-host-cross-database-transactions-possible-percona-mysql-innodb-extradb/4286 "2015-07-08T10:52:14Z")
Hi, Are cross-database transactions supported for Innodb and/or ExtraDB with Percona and/or MySQL? I am not asking about cross-server or cluster, just a simple single host with multiple databases. I would expect transa… --- ## [disconnecting clients](https://forums.percona.com/t/disconnecting-clients/4166)
**Author:** [@kodermax](https://forums.percona.com/u/kodermax)\ **Replies:** 1\ **Last updated:** [April 17, 2015, 10:30am UTC](https://forums.percona.com/t/disconnecting-clients/4166 "2015-04-17T10:30:55Z")
2015-04-17 10:15:15 1226 \[Note\] Forcefully disconnecting 5 remaining clients 2015-04-17 10:15:15 1226 \[Warning\] /usr/sbin/mysqld: Forcing close of thread 1229 user: ‘b\_user’ 2015-04-17 10:15:15 1226 \[Warning\] /usr/sbin… --- ## [MySQL Create Table with Partition Very Slow on server machine](https://forums.percona.com/t/mysql-create-table-with-partition-very-slow-on-server-machine/4056)
**Author:** [@anisar](https://forums.percona.com/u/anisar)\ **Replies:** 0\ **Last updated:** [February 16, 2015, 3:15am UTC](https://forums.percona.com/t/mysql-create-table-with-partition-very-slow-on-server-machine/4056 "2015-02-16T03:15:16Z")
\[TABLE\] \[TR\] \[TD=“class: votecell”\] \[CENTER\]\[COLOR=#707070 !important\]0down votefavorite \[/CENTER\] \[/TD\] \[TD=“class: postcell”\] MySQL version 5.6 InnoDB engine Following create table statement w… --- ## [Is the Memcache extension baked in like Handlersocket was?](https://forums.percona.com/t/is-the-memcache-extension-baked-in-like-handlersocket-was/3926)
**Author:** [@ecommunities](https://forums.percona.com/u/ecommunities)\ **Replies:** 1\ **Last updated:** [December 3, 2014, 9:36am UTC](https://forums.percona.com/t/is-the-memcache-extension-baked-in-like-handlersocket-was/3926 "2014-12-03T09:36:09Z")
We’ve been invested in the Handlersocket capabilities in Percona for a while, but it seems with Oracle deciding to prop up memcache instead, the delayed integration of Handlersocket by Percona in 5.6 until just recently,… --- ## [Replication error 1302 (GTID replication)](https://forums.percona.com/t/replication-error-1302-gtid-replication/3921)
**Author:** [@stephanhuiser](https://forums.percona.com/u/stephanhuiser)\ **Replies:** 5\ **Last updated:** [December 2, 2014, 4:50am UTC](https://forums.percona.com/t/replication-error-1302-gtid-replication/3921 "2014-12-02T04:50:07Z")
Hi, I’m using Percona Server 5.6.21-70.1 on Ubuntu 12.04 LTS, and my replication broke (anonymized): mysql\> show slave status\\G \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 1. row \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* Slave\_IO\_State: Waiting fo… --- ## [Does innodb\_use\_native\_aio = 0 affect XtraDB performance (on a OpenVZ VPS)](https://forums.percona.com/t/does-innodb-use-native-aio-0-affect-xtradb-performance-on-a-openvz-vps/3917)
**Author:** [@ngocnghechvt](https://forums.percona.com/u/ngocnghechvt)\ **Replies:** 0\ **Last updated:** [November 30, 2014, 5:54am UTC](https://forums.percona.com/t/does-innodb-use-native-aio-0-affect-xtradb-performance-on-a-openvz-vps/3917 "2014-11-30T05:54:25Z")
Due to some reasons, I’m going to migrate the application to another OpenVZ VPS. (It as a VMware VPS before) I can’n start the MySQL after installation (both Mysql & Percona). I received the same error about innodb can… --- ## [Yum repository seems to be broken](https://forums.percona.com/t/yum-repository-seems-to-be-broken/3751)
**Author:** [@Rasto\_Stric](https://forums.percona.com/u/Rasto_Stric)\ **Replies:** 14\ **Last updated:** [November 18, 2014, 1:22pm UTC](https://forums.percona.com/t/yum-repository-seems-to-be-broken/3751 "2014-11-18T13:22:32Z")
I am trying to install Percona Server 5.6 on a fresh Amazon Linux AMI. I am following your installation instructions on \[URL\]http://www.percona.com/doc/percona-server/5.6/installation/yum\_repo.html\[/URL\] yum install h… --- ## [InnoDB not using CPU crc32 instructions](https://forums.percona.com/t/innodb-not-using-cpu-crc32-instructions/3854)
**Author:** [@pszajna](https://forums.percona.com/u/pszajna)\ **Replies:** 1\ **Last updated:** [November 13, 2014, 2:00am UTC](https://forums.percona.com/t/innodb-not-using-cpu-crc32-instructions/3854 "2014-11-13T02:00:54Z")
My error.log notes that InnoDB: Not using CPU crc32 instructions, I’ve added innodb-checksum-algorithm = crc32 to my.cnf but didn’t help. Server is running on Debian Wheezy on VirtualBox, can anybody give me an advice wh… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.md?page=3) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.md?page=5)