# Percona Server for MySQL 5.6 **URL:** https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.md [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) --- ## [About the Percona Server for MySQL 5.6 category](https://forums.percona.com/t/about-the-percona-server-for-mysql-5-6-category/20)
**Author:** [@system](https://forums.percona.com/u/system)\ **Replies:** 0
Percona Server for MySQL® is a free, fully compatible, enhanced and open source drop-in replacement for any MySQL database. It provides superior performance, scalability and instrumentation. --- ## [Percona Server 5.7 orphan #sql-ib\* entry in INNODB\_SYS\_TABLES cannot be removed, blocks MySQL 8 upgrade](https://forums.percona.com/t/percona-server-5-7-orphan-sql-ib-entry-in-innodb-sys-tables-cannot-be-removed-blocks-mysql-8-upgrade/39973)
**Author:** [@aycelen](https://forums.percona.com/u/aycelen)\ **Replies:** 2\ **Last updated:** [January 2, 2026, 12:47pm UTC](https://forums.percona.com/t/percona-server-5-7-orphan-sql-ib-entry-in-innodb-sys-tables-cannot-be-removed-blocks-mysql-8-upgrade/39973 "2026-01-02T12:47:00Z")
Hello, I am running Percona Server 5.7.44-48 on a large dataset (~9 TB). This instance is a replica / test clone, not production. While running util.checkForServerUpgrade() (MySQL Shell) in preparation for an upgrade … --- ## [Innodb\_log\_file\_size Parameter Appropriate Size For Master and Slaves mysql 5.6](https://forums.percona.com/t/innodb-log-file-size-parameter-appropriate-size-for-master-and-slaves-mysql-5-6/24137)
**Author:** [@tamoor\_ali](https://forums.percona.com/u/tamoor_ali)\ **Replies:** 1\ **Last updated:** [August 2, 2023, 3:01pm UTC](https://forums.percona.com/t/innodb-log-file-size-parameter-appropriate-size-for-master-and-slaves-mysql-5-6/24137 "2023-08-02T15:01:21Z")
I have a Scenario to set inndb\_log\_file\_size as some cron jobs and services are running on Master and Slaves(Select relevant Data From Slave and update it on Master) So in That Scenario If We Calculate Innodb\_log\_… --- ## [Performance\_schema not capturing prepared stements](https://forums.percona.com/t/performance-schema-not-capturing-prepared-stements/5197)
**Author:** [@mrunreal121](https://forums.percona.com/u/mrunreal121)\ **Replies:** 1\ **Last updated:** [May 23, 2023, 7:07pm UTC](https://forums.percona.com/t/performance-schema-not-capturing-prepared-stements/5197 "2023-05-23T19:07:50Z")
Hi all, we are trying to get an ideal of all the queries we have running against our databases but we can’t see any of the prepared statements that are coming from a jdbc connection. We have everything that I am aware of… --- ## [Node is not starting 5.6](https://forums.percona.com/t/node-is-not-starting-5-6/21231)
**Author:** [@elkhedewy](https://forums.percona.com/u/elkhedewy)\ **Replies:** 8\ **Last updated:** [April 10, 2023, 1:20pm UTC](https://forums.percona.com/t/node-is-not-starting-5-6/21231 "2023-04-10T13:20:42Z")
Hello, I’ve 2 nodes one running as bootstrap and i need the other node to join the cluster. But i got this errors in mysql error log. The second node LOG: Blockquote Log of wsrep recovery (–wsrep-recover): 2023-04-… --- ## [Pt-online-schema-change fails 99% Out of range value for column](https://forums.percona.com/t/pt-online-schema-change-fails-99-out-of-range-value-for-column/19222)
**Author:** [@Fabien\_Oram](https://forums.percona.com/u/Fabien_Oram)\ **Replies:** 5\ **Last updated:** [December 21, 2022, 5:52pm UTC](https://forums.percona.com/t/pt-online-schema-change-fails-99-out-of-range-value-for-column/19222 "2022-12-21T17:52:18Z")
I am altering some INT(11) to BIGINT(20). Both a PK and a regular column. CHANGE COLUMN id id BIGINT(20) unsigned NOT NULL auto\_increment COMMENT ‘’, CHANGE COLUMN message\_id message\_id BIGINT(20) unsigned NOT NULL COMM… --- ## [Percona 5.6.X on Red Hat 8.x](https://forums.percona.com/t/percona-5-6-x-on-red-hat-8-x/16768)
**Author:** [@wjb2130](https://forums.percona.com/u/wjb2130)\ **Replies:** 1\ **Last updated:** [July 27, 2022, 1:01am UTC](https://forums.percona.com/t/percona-5-6-x-on-red-hat-8-x/16768 "2022-07-27T01:01:22Z")
Greetings. We have Red Hat 8.5 / 8.6 nodes, but are tied to a specific version of Percona (5.6.45) Are the dependencies for this in order? What set of steps is needed to get Percona-Server-client, Percona-Server-server,… --- ## [Source rpm check-rpaths](https://forums.percona.com/t/source-rpm-check-rpaths/15488)
**Author:** [@Jeffrey](https://forums.percona.com/u/Jeffrey)\ **Replies:** 1\ **Last updated:** [May 9, 2022, 4:06pm UTC](https://forums.percona.com/t/source-rpm-check-rpaths/15488 "2022-05-09T16:06:08Z")
Hi, this question is about RPM packaging for RHEL 8 I am aware of your beautiful repository, but I want to package PS for MySQL with a couple of changes for my personal use. I downloaded the PS for MySQL 8.0.27 source … --- ## [Mysql not starting, no wsrep](https://forums.percona.com/t/mysql-not-starting-no-wsrep/12733)
**Author:** [@Aaron1](https://forums.percona.com/u/Aaron1)\ **Replies:** 3\ **Last updated:** [October 27, 2021, 1:28am UTC](https://forums.percona.com/t/mysql-not-starting-no-wsrep/12733 "2021-10-27T01:28:00Z")
Hello! I’m trying to startup percona + mysql + galera on FreeBSD 13. I am using the packages from pkg. I can start my database without any wsrep settings in my my.cnf file. As soon as I add the wsrep settings, mysql … --- ## [Undo size increasing Percona MySql 5.6](https://forums.percona.com/t/undo-size-increasing-percona-mysql-5-6/10397)
**Author:** [@Daljit1](https://forums.percona.com/u/Daljit1)\ **Replies:** 5\ **Last updated:** [September 14, 2021, 2:23pm UTC](https://forums.percona.com/t/undo-size-increasing-percona-mysql-5-6/10397 "2021-09-14T14:23:36Z")
Hi Guys, Please suggest me how i can truncate or drop undo tablespace because its size increasing and below are the parameter setting. innodb\_version | 5.6.34-79.1 (root@)\>show variables like ‘innodb\_undo%’; … --- ## [Question about MySQL 5.6 Post EOL Support](https://forums.percona.com/t/question-about-mysql-5-6-post-eol-support/11638)
**Author:** [@fuzzybase](https://forums.percona.com/u/fuzzybase)\ **Replies:** 9\ **Last updated:** [August 3, 2021, 5:10pm UTC](https://forums.percona.com/t/question-about-mysql-5-6-post-eol-support/11638 "2021-08-03T17:10:19Z")
We have a line of business application on MySQL 5.6 that needs to run for a couple of more years. We are moving it to a new, on-prem setup and are considering setting it up with Percona Server for MySQL 5.6 as it’s a dro… --- ## [Bug found in Percona Server Version: 5.6.34-79.1-1.jessie](https://forums.percona.com/t/bug-found-in-percona-server-version-5-6-34-79-1-1-jessie/6269)
**Author:** [@Jayesh\_Labade](https://forums.percona.com/u/Jayesh_Labade)\ **Replies:** 1\ **Last updated:** [June 17, 2021, 11:12am UTC](https://forums.percona.com/t/bug-found-in-percona-server-version-5-6-34-79-1-1-jessie/6269 "2021-06-17T11:12:51Z")
Hi, Today we encountered bug in Percona Server Version: 5.6.34-79.1-1.jessie server. Mysql service was unavailable for few seconds during bug logging process. Attached mysql-error.log with bug details. Please help. H… --- ## [Percona Server for MySQL 5.6.51-91.0 Released (FINAL)](https://forums.percona.com/t/percona-server-for-mysql-5-6-51-91-0-released-final/9195)
**Author:** [@Tom\_Basil](https://forums.percona.com/u/Tom_Basil)\ **Replies:** 0\ **Last updated:** [February 10, 2021, 2:17am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-6-51-91-0-released-final/9195 "2021-02-10T02:17:42Z")
February 8, 2021 - See release notes at: --- ## [Enabling Numa on mysql 5.6.50](https://forums.percona.com/t/enabling-numa-on-mysql-5-6-50/9177)
**Author:** [@Jayesh\_Labade](https://forums.percona.com/u/Jayesh_Labade)\ **Replies:** 2\ **Last updated:** [February 9, 2021, 3:30pm UTC](https://forums.percona.com/t/enabling-numa-on-mysql-5-6-50/9177 "2021-02-09T15:30:20Z")
Hi, I have 100G of RAM and 70G configured as innodb buffer pool. But after few days of usage swapping started. I wanted to enable NUMA support in percona mysql server 5.6.50-90. As per PerconaLink “Variables innodb\_bu… --- ## [Strange replication stucks "waiting for GTID to be written to binary log"](https://forums.percona.com/t/strange-replication-stucks-waiting-for-gtid-to-be-written-to-binary-log/5229)
**Author:** [@shinkei](https://forums.percona.com/u/shinkei)\ **Replies:** 0\ **Last updated:** [November 23, 2016, 3:05am UTC](https://forums.percona.com/t/strange-replication-stucks-waiting-for-gtid-to-be-written-to-binary-log/5229 "2016-11-23T03:05:11Z")
There is a problem with the replication. The slave between db2 and pxc stucks with the message “waiting for GTID to be written to binary log”. In this case there is no error message. Meters “Seconds\_Behind\_Master” grows… --- ## [Error: Reading from the stream has failed on Percona release 0.1-3](https://forums.percona.com/t/error-reading-from-the-stream-has-failed-on-percona-release-0-1-3/4059)
**Author:** [@fdelelis](https://forums.percona.com/u/fdelelis)\ **Replies:** 0\ **Last updated:** [February 17, 2015, 2:32am UTC](https://forums.percona.com/t/error-reading-from-the-stream-has-failed-on-percona-release-0-1-3/4059 "2015-02-17T02:32:59Z")
Hi, I am using a service .Net that connect to Mysql server 5.6 and move -Mysql server 5.6 (Percona xtraback). -Percona release 0.1-3 -Percona-xtrabackup-2.2.7 --- ## [Moved: MySQL 5.6 End of Life](https://forums.percona.com/t/moved-mysql-5-6-end-of-life/8404)
**Author:** [@Tom\_Basil](https://forums.percona.com/u/Tom_Basil)\ **Replies:** 0\ **Last updated:** [December 16, 2020, 3:25pm UTC](https://forums.percona.com/t/moved-mysql-5-6-end-of-life/8404 "2020-12-16T15:25:34Z")
This discussion has been moved. --- ## [MySQL restarted due to Disk full](https://forums.percona.com/t/mysql-restarted-due-to-disk-full/8345)
**Author:** [@karthik22](https://forums.percona.com/u/karthik22)\ **Replies:** 3\ **Last updated:** [December 8, 2020, 6:21am UTC](https://forums.percona.com/t/mysql-restarted-due-to-disk-full/8345 "2020-12-08T06:21:57Z")
Hi Team, Got mysql restart on one mysql server due to adding the column to existing table. before initiating the alter i have 95 GB disk space free. the table X which is 58GB, am doing alter on X ALTER TABLE X … --- ## [intermittent stored function "does not exist" problem](https://forums.percona.com/t/intermittent-stored-function-does-not-exist-problem/5143)
**Author:** [@peter9370](https://forums.percona.com/u/peter9370)\ **Replies:** 1\ **Last updated:** [December 7, 2020, 8:07am UTC](https://forums.percona.com/t/intermittent-stored-function-does-not-exist-problem/5143 "2020-12-07T08:07:23Z")
We use a database running on percona server 5.6.28 (under ubuntu), which has a large number of stored procedures and functions (around 2000 procedures and 600 functions). A few weeks ago (after the number of stored funct… --- ## [Moved: Percona Server for MySQL 5.6.50-90.0 Released](https://forums.percona.com/t/moved-percona-server-for-mysql-5-6-50-90-0-released/8234)
**Author:** [@Tom\_Basil](https://forums.percona.com/u/Tom_Basil)\ **Replies:** 0\ **Last updated:** [November 3, 2020, 8:29pm UTC](https://forums.percona.com/t/moved-percona-server-for-mysql-5-6-50-90-0-released/8234 "2020-11-03T20:29:36Z")
This discussion has been moved. --- ## [New Percona XtraDB Cluster Ver 5.6 Released](https://forums.percona.com/t/new-percona-xtradb-cluster-ver-5-6-released/8170)
**Author:** [@Tom\_Basil](https://forums.percona.com/u/Tom_Basil)\ **Replies:** 0\ **Last updated:** [October 22, 2020, 8:35pm UTC](https://forums.percona.com/t/new-percona-xtradb-cluster-ver-5-6-released/8170 "2020-10-22T20:35:39Z")
October 22, 2020, this Percona XtraDB Cluster version was released: PXC 5.6.49-28.42.3 Release notes are at: https://www.percona.com/doc/percona-xtradb-cluster/5.6/release-notes/Percona-XtraDB-Cluster-5.6.49-28.42.… --- ## [INFORMATION\_SCHEMA.INNODB\_LOCK\_WAITS empty](https://forums.percona.com/t/information-schema-innodb-lock-waits-empty/8096)
**Author:** [@Jamie\_Downs](https://forums.percona.com/u/Jamie_Downs)\ **Replies:** 2\ **Last updated:** [October 5, 2020, 9:13am UTC](https://forums.percona.com/t/information-schema-innodb-lock-waits-empty/8096 "2020-10-05T09:13:04Z")
MySQL version: 5.6.32-78.1 The following tables exist but are empty. INNODB\_LOCKS INNODB\_LOCK\_WAITS The information\_schema.innodb\_trx table has data in it. Please can someone explain how to expose the data in the loc… --- ## [Percona Server for MySQL ver 5.6.49-89.0 Released](https://forums.percona.com/t/percona-server-for-mysql-ver-5-6-49-89-0-released/7829)
**Author:** [@Tom\_Basil](https://forums.percona.com/u/Tom_Basil)\ **Replies:** 0\ **Last updated:** [July 27, 2020, 8:07pm UTC](https://forums.percona.com/t/percona-server-for-mysql-ver-5-6-49-89-0-released/7829 "2020-07-27T20:07:44Z")
See 2020-07-27 release notes at https://www.percona.com/doc/percona-server/5.6/release-notes/Percona-Server-5.6.49-89.0.html --- ## [Troubleshooting/debugging connection resets](https://forums.percona.com/t/troubleshooting-debugging-connection-resets/7744)
**Author:** [@j4nd3r53n](https://forums.percona.com/u/j4nd3r53n)\ **Replies:** 1\ **Last updated:** [July 24, 2020, 7:48am UTC](https://forums.percona.com/t/troubleshooting-debugging-connection-resets/7744 "2020-07-24T07:48:01Z")
I have an intermittent error on our databases (Percona MySQL 5.6 on Debian 8) which I haven’t been able to find information about online - my colleague runs a python script and it occasionally gets kicked out with: Con… --- ## [Default values for MASTER\_LOG\_POS in CHANGE MASTER TO statement](https://forums.percona.com/t/default-values-for-master-log-pos-in-change-master-to-statement/7721)
**Author:** [@ChrisCard](https://forums.percona.com/u/ChrisCard)\ **Replies:** 5\ **Last updated:** [July 1, 2020, 4:50pm UTC](https://forums.percona.com/t/default-values-for-master-log-pos-in-change-master-to-statement/7721 "2020-07-01T16:50:20Z")
we have a Perl script which we use to perform failover of a slave to become a master, and I am trying to ensure it works with Percona Server 5.6. Part of the processing in the script involves calling “CHANGE MASTER TO …… --- ## [SEMAPHORES - S-lock & X-lock on RW-latch](https://forums.percona.com/t/semaphores-s-lock-x-lock-on-rw-latch/6957)
**Author:** [@pooja.gupta](https://forums.percona.com/u/pooja.gupta)\ **Replies:** 3\ **Last updated:** [July 1, 2020, 4:48pm UTC](https://forums.percona.com/t/semaphores-s-lock-x-lock-on-rw-latch/6957 "2020-07-01T16:48:37Z")
I can see many types of contention in the show engine innodb status\\G Its increasing load on the server , CPU utilization was High and High I/O noticed. Can see below contentions in error logs. SEMAPHORES OS WAIT ARR… --- ## [Recover Accidentally dropped database schema](https://forums.percona.com/t/recover-accidentally-dropped-database-schema/7670)
**Author:** [@Joyexp](https://forums.percona.com/u/Joyexp)\ **Replies:** 1\ **Last updated:** [June 19, 2020, 2:52pm UTC](https://forums.percona.com/t/recover-accidentally-dropped-database-schema/7670 "2020-06-19T14:52:14Z")
While migrating table I accidentally dropped database before migration. I have roughly 250+GB database when du -sh /data/mysql but now showing only 20G. Binlog and innodb\_file\_per\_table ON at my database setting. Can any… --- ## [How to disable bin logging](https://forums.percona.com/t/how-to-disable-bin-logging/6843)
**Author:** [@Cyberflow](https://forums.percona.com/u/Cyberflow)\ **Replies:** 1\ **Last updated:** [June 13, 2020, 4:10pm UTC](https://forums.percona.com/t/how-to-disable-bin-logging/6843 "2020-06-13T16:10:49Z")
Hello, all. I need to disable bin logging on my percona server because I do not use replication. Mysql have option skip-log-bin for this. Have a percona server something? Thank you. --- ## [How to Improve Query Performance of UPDATE and INSERT?](https://forums.percona.com/t/how-to-improve-query-performance-of-update-and-insert/6513)
**Author:** [@dburleson](https://forums.percona.com/u/dburleson)\ **Replies:** 1\ **Last updated:** [June 13, 2020, 4:07pm UTC](https://forums.percona.com/t/how-to-improve-query-performance-of-update-and-insert/6513 "2020-06-13T16:07:00Z")
I’m running a Percona 5.6 cluster (3 nodes) on lxc containers. Each nodes hardware is as follows: 4 x Intel(R) Xeon(R) CPU E5-2630 v3 @ 2.40GHz (2 Sockets) 16GB RAM 130GB HD My database is just under 4GB in size. I’v… --- ## [what is a "normal" connection time?](https://forums.percona.com/t/what-is-a-normal-connection-time/7024)
**Author:** [@Maik80](https://forums.percona.com/u/Maik80)\ **Replies:** 1\ **Last updated:** [June 13, 2020, 3:52pm UTC](https://forums.percona.com/t/what-is-a-normal-connection-time/7024 "2020-06-13T15:52:04Z")
I currently measure an average of 110ms for open the db connection. However, the number varies between 1 ms and 1000ms. The server has a load of about 500-1500 connections/s. Now I’m trying to find out if the connection… [Next page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.md?page=1)