# Percona Server for MySQL 5.6 **URL:** https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.md?page=2 [Latest](https://forums.percona.com/latest.md) · [Categories](https://forums.percona.com/categories.md) · [Tags](https://forums.percona.com/tags.md) **Page:** 3 --- ## [delete table space](https://forums.percona.com/t/delete-table-space/5882)
**Author:** [@modern\_zoro](https://forums.percona.com/u/modern_zoro)\ **Replies:** 1\ **Last updated:** [July 22, 2018, 11:43pm UTC](https://forums.percona.com/t/delete-table-space/5882 "2018-07-22T23:43:30Z")
Hi All, Kindly advice for the below issue, i have table it’s size more than 1TB and i try to drop it but it didn’t free space in file system. what i should do if i need to freeup this table space ?? i have Percona-Se… --- ## [InnoDB: Error: Tablespace for table "mysql"."innodb\_table\_stats" is missing.](https://forums.percona.com/t/innodb-error-tablespace-for-table-mysql-innodb-table-stats-is-missing/5918)
**Author:** [@soul301](https://forums.percona.com/u/soul301)\ **Replies:** 1\ **Last updated:** [July 22, 2018, 11:38pm UTC](https://forums.percona.com/t/innodb-error-tablespace-for-table-mysql-innodb-table-stats-is-missing/5918 "2018-07-22T23:38:42Z")
Hi, I am continuoulsy getting below error in mysql error log file mysql".“innodb\_table\_stats” is missing. I am using percona mysql server 5.6 can anyone guide me how to resolve above error. I have tried following sol… --- ## [MySQL Server returns only one row of data in rare cases](https://forums.percona.com/t/mysql-server-returns-only-one-row-of-data-in-rare-cases/6448)
**Author:** [@juergen\_thomann](https://forums.percona.com/u/juergen_thomann)\ **Replies:** 0\ **Last updated:** [July 7, 2018, 2:20am UTC](https://forums.percona.com/t/mysql-server-returns-only-one-row-of-data-in-rare-cases/6448 "2018-07-07T02:20:21Z")
Hello, I’ll start first with the context. We have a table that has around 687 Million rows and every night we import this table with Apache Sqoop to Hadoop with a parallelism of 32 tasks. The table looks like the follow… --- ## [Percona Server for MySQL 5.6.40-84.0 Is Now Available](https://forums.percona.com/t/percona-server-for-mysql-5-6-40-84-0-is-now-available/6391)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [May 31, 2018, 4:54am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-6-40-84-0-is-now-available/6391 "2018-05-31T04:54:27Z")
Percona announces the release of Percona Server for MySQL 5.6.40-84.0 on May 30, 2018 (downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.40, including all the bug fixes in it, P… --- ## [Extreme bottleneck on MySQL](https://forums.percona.com/t/extreme-bottleneck-on-mysql/6228)
**Author:** [@pisisler](https://forums.percona.com/u/pisisler)\ **Replies:** 6\ **Last updated:** [March 13, 2018, 12:18am UTC](https://forums.percona.com/t/extreme-bottleneck-on-mysql/6228 "2018-03-13T00:18:38Z")
Hi, I have been searching for solutions to what I have been experiencing for months. Although there is nearly zero load on the server and no active domains, when only a few pages are requested, server slows down to deat… --- ## [Percona Server for MySQL 5.6.39-83.1 Is Now Available](https://forums.percona.com/t/percona-server-for-mysql-5-6-39-83-1-is-now-available/6196)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [February 15, 2018, 4:31am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-6-39-83-1-is-now-available/6196 "2018-02-15T04:31:22Z")
Percona announces the release of Percona Server for MySQL 5.6.39-83.1 on February 13, 2018. Based on MySQL 5.6.39, including all the bug fixes in it, Percona Server for MySQL 5.6.39-83.1 is now the current stable release… --- ## [Mysql Replication Lag is increasing continuously](https://forums.percona.com/t/mysql-replication-lag-is-increasing-continuously/6194)
**Author:** [@farhana](https://forums.percona.com/u/farhana)\ **Replies:** 0\ **Last updated:** [February 13, 2018, 12:31pm UTC](https://forums.percona.com/t/mysql-replication-lag-is-increasing-continuously/6194 "2018-02-13T12:31:35Z")
Hi Team, Could anyone please help me to come out of this situation. When i actually change the pt-online-schema-change -u root --ask-pass --alter “MODIFY COLUMN id BIGINT UNSIGNED NOT NULL AUTO\_INCREMENT” on production… --- ## [missing Percona-server-devel for version 5.6 in debian apt](https://forums.percona.com/t/missing-percona-server-devel-for-version-5-6-in-debian-apt/4317)
**Author:** [@anshusah](https://forums.percona.com/u/anshusah)\ **Replies:** 8\ **Last updated:** [February 11, 2018, 3:35pm UTC](https://forums.percona.com/t/missing-percona-server-devel-for-version-5-6-in-debian-apt/4317 "2018-02-11T15:35:43Z")
Hi I have been struggling to install devel package but no luck. kindly advise. Logs root@instance-5:/usr/lib/x86\_64-linux-gnu# apt-get install Percona-Server-devel\* Reading package lists… Done Building dependency tr… --- ## [Troubleshooting Percona Server for MySQL and How to Report a Bug](https://forums.percona.com/t/troubleshooting-percona-server-for-mysql-and-how-to-report-a-bug/6164)
**Author:** [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\ **Replies:** 0\ **Last updated:** [January 29, 2018, 7:48am UTC](https://forums.percona.com/t/troubleshooting-percona-server-for-mysql-and-how-to-report-a-bug/6164 "2018-01-29T07:48:28Z")
We have a separate system for recording and reporting on bugs, for Percona Server for MySQL and for other Percona software. The forum is oriented towards discussion and advice rather than to bug reporting and fixing. Th… --- ## [sysbench oltp test， the result is not stable after warmup, why?](https://forums.percona.com/t/sysbench-oltp-test-the-result-is-not-stable-after-warmup-why/6093)
**Author:** [@jared](https://forums.percona.com/u/jared)\ **Replies:** 1\ **Last updated:** [January 2, 2018, 11:17am UTC](https://forums.percona.com/t/sysbench-oltp-test-the-result-is-not-stable-after-warmup-why/6093 "2018-01-02T11:17:25Z")
sysbench oltp test， the result is not stable after warmup, why? the percona server version is 5.6.72.0 The web server contain six SAS SSD components rain0 and skylake 6148 cpu. The sysbench and the mysql running on the … --- ## [Percona Server for MySQL 5.6.38-83.0 is Now Available](https://forums.percona.com/t/percona-server-for-mysql-5-6-38-83-0-is-now-available/6066)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [December 8, 2017, 12:47pm UTC](https://forums.percona.com/t/percona-server-for-mysql-5-6-38-83-0-is-now-available/6066 "2017-12-08T12:47:16Z")
Percona announces the release of Percona Server for MySQL 5.6.38-83.0 on December 8, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers fr… --- ## [replace command in binary log not working](https://forums.percona.com/t/replace-command-in-binary-log-not-working/5998)
**Author:** [@chintoo02018](https://forums.percona.com/u/chintoo02018)\ **Replies:** 0\ **Last updated:** [November 13, 2017, 1:21pm UTC](https://forums.percona.com/t/replace-command-in-binary-log-not-working/5998 "2017-11-13T13:21:25Z")
I have binary log edit INSERT to REPLACE to overwrite the data in table but it showing Duplicate key error \[root@etim upload\_new\]# mysql --defaults-extra-file=/usr/bin/.config145 \< BHKR\_mysql-bin.002873\_13-11-17\_20… --- ## [Performance problems in Percona MySQL 5.6 migrating from Ubuntu 14.04LTS to 16.04LTS](https://forums.percona.com/t/performance-problems-in-percona-mysql-5-6-migrating-from-ubuntu-14-04lts-to-16-04lts/5912)
**Author:** [@tuple](https://forums.percona.com/u/tuple)\ **Replies:** 3\ **Last updated:** [October 5, 2017, 5:59am UTC](https://forums.percona.com/t/performance-problems-in-percona-mysql-5-6-migrating-from-ubuntu-14-04lts-to-16-04lts/5912 "2017-10-05T05:59:57Z")
So the big upgrade from 14.04 to 16.04 came up a little unexpectedly 2 weeks ago. many small package changes, and went from Percona 5.6.33-79.0-log (on 14.04) to 5.6.37-82.2-log (on 16.04) - and performance is really not… --- ## [Error after changing datadir](https://forums.percona.com/t/error-after-changing-datadir/5830)
**Author:** [@phiber](https://forums.percona.com/u/phiber)\ **Replies:** 1\ **Last updated:** [September 26, 2017, 1:49pm UTC](https://forums.percona.com/t/error-after-changing-datadir/5830 "2017-09-26T13:49:06Z")
I added 2 SSDs in RAID 1 configuration and mounted them as /ssd. At first, it was very important that two tables from a single database are moved to faster drives so I used the pt-online-schema-change tool to change the… --- ## [5.5 to 5.6 slave upgrade issue](https://forums.percona.com/t/5-5-to-5-6-slave-upgrade-issue/5879)
**Author:** [@mikes](https://forums.percona.com/u/mikes)\ **Replies:** 1\ **Last updated:** [September 25, 2017, 9:01am UTC](https://forums.percona.com/t/5-5-to-5-6-slave-upgrade-issue/5879 "2017-09-25T09:01:37Z")
Hi, We are in the process of a 5.5 to 5.6 upgrade, and after successfully updating the master, I had updated the first slave, and attempted to do the restart with the “–skip-grant-tables” option as per the upgrade guide… --- ## [disconnecting clients](https://forums.percona.com/t/disconnecting-clients/5847)
**Author:** [@lupacexi](https://forums.percona.com/u/lupacexi)\ **Replies:** 1\ **Last updated:** [September 7, 2017, 11:57pm UTC](https://forums.percona.com/t/disconnecting-clients/5847 "2017-09-07T23:57:47Z")
\[Note\] Forcefully disconnecting 5 remaining clients \[Warning\] /usr/sbin/mysqld: Forcing close of thread 1229 user: ‘b\_user’ \[Warning\] /usr/sbin/mysqld: Forcing close of thread 1231 user: ‘b\_user’ \[Warning\] /usr/sbin/m… --- ## [Percona Server for MySQL 5.6.37-82.2 Is Now Available](https://forums.percona.com/t/percona-server-for-mysql-5-6-37-82-2-is-now-available/5835)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [August 31, 2017, 3:49am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-6-37-82-2-is-now-available/5835 "2017-08-31T03:49:24Z")
Percona announces the release of Percona Server for MySQL 5.6.37-82.2 on August 25, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers fro… --- ## [Percona CentOS Repo failing](https://forums.percona.com/t/percona-centos-repo-failing/5812)
**Author:** [@TroyDubs](https://forums.percona.com/u/TroyDubs)\ **Replies:** 1\ **Last updated:** [August 15, 2017, 11:50am UTC](https://forums.percona.com/t/percona-centos-repo-failing/5812 "2017-08-15T11:50:30Z")
As of Aug 14th, the repodata files were updated on the \[url\]http://repo.percona.com/release/7/RPMS/x86\_64/repodata\[/url\] folder and since then all of the servers in my infrastructure are showing YUM errors for the Percon… --- ## [Percona Server for MySQL 5.6.36-82.1 Is Now Available](https://forums.percona.com/t/percona-server-for-mysql-5-6-36-82-1-is-now-available/5782)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [August 1, 2017, 10:00am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-6-36-82-1-is-now-available/5782 "2017-08-01T10:00:24Z")
Percona is glad to announce the release of Percona Server 5.6.36-82.1 on August 1, 2017 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.6.36, including all the bug fixes in it… --- ## [event scheduler in replication master - slave](https://forums.percona.com/t/event-scheduler-in-replication-master-slave/5754)
**Author:** [@nobody](https://forums.percona.com/u/nobody)\ **Replies:** 0\ **Last updated:** [July 20, 2017, 6:38am UTC](https://forums.percona.com/t/event-scheduler-in-replication-master-slave/5754 "2017-07-20T06:38:31Z")
Hi there! I have a problem with percona mysql replication (master-slave) and events. When i create any event on master CREATE EVENT test\_event ON SCHEDULE EVERY 1 MINUTE ON COMPLETION PRESERVE DO insert into test1… --- ## [Percona5.6.35 'commit' is slow](https://forums.percona.com/t/percona5-6-35-commit-is-slow/5719)
**Author:** [@linyue](https://forums.percona.com/u/linyue)\ **Replies:** 0\ **Last updated:** [July 5, 2017, 8:33pm UTC](https://forums.percona.com/t/percona5-6-35-commit-is-slow/5719 "2017-07-05T20:33:48Z")
‘commit’ average total time \> 300ms in the slowlog. Though profile, most time is spent on starting . User@Host: test\[test\] @ \[172.18.16.39\] Id: 318755049 Schema: test Last\_errno: 0 Killed: 0 Query\_time: 0.304581 Lock\_ti… --- ## [Percona replication controlled by Pacemaker](https://forums.percona.com/t/percona-replication-controlled-by-pacemaker/5707)
**Author:** [@DBA](https://forums.percona.com/u/DBA)\ **Replies:** 0\ **Last updated:** [June 29, 2017, 7:11am UTC](https://forums.percona.com/t/percona-replication-controlled-by-pacemaker/5707 "2017-06-29T07:11:49Z")
rpm -qa | grep -i pacemaker percona-pacemaker-agent-1.0.0-1.x86\_64 pacemaker-libs-1.1.15-11.el7.x86\_64 pacemaker-cluster-libs-1.1.15-11.el7.x86\_64 pacemaker-cli-1.1.15-11.el7.x86\_64 pacemaker-1.1.15-11.el7.x86\_64 r… --- ## [percona server performance 5.5 vs 5.6](https://forums.percona.com/t/percona-server-performance-5-5-vs-5-6/5638)
**Author:** [@An\_An](https://forums.percona.com/u/An_An)\ **Replies:** 0\ **Last updated:** [May 25, 2017, 4:29am UTC](https://forums.percona.com/t/percona-server-performance-5-5-vs-5-6/5638 "2017-05-25T04:29:25Z")
Recently we upgraded our percona mysql server from 5.5 to 5.6 version (5.6.34). The problem is that with the same configuration, the same queries started to execute much longer ( comparing to 5.5 ). I have started to e… --- ## [Corrupt frm after upgrade from MySQL 5.5 to MySQL 5.6 (with tokudb)](https://forums.percona.com/t/corrupt-frm-after-upgrade-from-mysql-5-5-to-mysql-5-6-with-tokudb/5611)
**Author:** [@Seunguck\_Lee](https://forums.percona.com/u/Seunguck_Lee)\ **Replies:** 1\ **Last updated:** [May 17, 2017, 10:40am UTC](https://forums.percona.com/t/corrupt-frm-after-upgrade-from-mysql-5-5-to-mysql-5-6-with-tokudb/5611 "2017-05-17T10:40:48Z")
I am going to upgrade “mysql-5.5.41-tokudb-7.5.5-linux-x86\_64” to “Percona-Server-5.6.36-rel82.0-Linux.x86\_64.ssl101”. (Not dump & load , just copy datafiles to Percona server 5.6) But partitioned table’s frm can not b… --- ## [Slow query with IN](https://forums.percona.com/t/slow-query-with-in/5411)
**Author:** [@sixart](https://forums.percona.com/u/sixart)\ **Replies:** 1\ **Last updated:** [May 16, 2017, 3:30am UTC](https://forums.percona.com/t/slow-query-with-in/5411 "2017-05-16T03:30:46Z")
Hi, I have problem with query with IN option, is very slow or I have DEADLOCK. The query is: SELECT \* FROM token WHERE id in (SELECT token\_id FROM tokeninfo WHERE Value = ‘546845’) in this case or is very slow or I … --- ## [Percona Server for MySQL 5.6.36-82.0 is Now Available](https://forums.percona.com/t/percona-server-for-mysql-5-6-36-82-0-is-now-available/5598)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [May 15, 2017, 3:24am UTC](https://forums.percona.com/t/percona-server-for-mysql-5-6-36-82-0-is-now-available/5598 "2017-05-15T03:24:16Z")
Percona announces the release of Percona Server for MySQL 5.6.36-82.0 on May 12, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from t… --- ## [out of memory with plenty of memory](https://forums.percona.com/t/out-of-memory-with-plenty-of-memory/5528)
**Author:** [@tch](https://forums.percona.com/u/tch)\ **Replies:** 0\ **Last updated:** [April 6, 2017, 9:29am UTC](https://forums.percona.com/t/out-of-memory-with-plenty-of-memory/5528 "2017-04-06T09:29:24Z")
I have a busy server running Percona 5.6.34-79.1-1.xenial on Ubuntu 16.04. It works great, however, every few weeks, mysqld is shot by out-of-memory killer and I’m not able to find out why. root@master02:~# grep Out /va… --- ## [Percona database on SSD RAID-0](https://forums.percona.com/t/percona-database-on-ssd-raid-0/5516)
**Author:** [@Korben](https://forums.percona.com/u/Korben)\ **Replies:** 2\ **Last updated:** [April 2, 2017, 9:56am UTC](https://forums.percona.com/t/percona-database-on-ssd-raid-0/5516 "2017-04-02T09:56:00Z")
Hello everybody. I have a very weird behavior of my database which I tried to move to RAID-0 array consisting of two SSD drives. So I have two “Team Group L3 EVO 120Gb” drives in my PowerEdge R710 server which is using… --- ## [Percona Server 5.6.35-81.0 is Now Available](https://forums.percona.com/t/percona-server-5-6-35-81-0-is-now-available/5508)
**Author:** [@hrvojem](https://forums.percona.com/u/hrvojem)\ **Replies:** 0\ **Last updated:** [March 27, 2017, 4:45am UTC](https://forums.percona.com/t/percona-server-5-6-35-81-0-is-now-available/5508 "2017-03-27T04:45:18Z")
Percona announces the release of Percona Server 5.6.35-81.0 on March 24, 2017. Download the latest version from the Percona web site or the Percona Software Repositories. You can also run Docker containers from the image… --- ## [Stored Procedure Using MEDIUMTEXT Variable: Progressively Deteriorating Performance](https://forums.percona.com/t/stored-procedure-using-mediumtext-variable-progressively-deteriorating-performance/5480)
**Author:** [@cnewtonne](https://forums.percona.com/u/cnewtonne)\ **Replies:** 0\ **Last updated:** [March 14, 2017, 8:27am UTC](https://forums.percona.com/t/stored-procedure-using-mediumtext-variable-progressively-deteriorating-performance/5480 "2017-03-14T08:27:40Z")
Hi all … Using MySQL 5.7.5-m15, I have a stored procedure that is pretty simple in its idea … Uses a cursor to read from a table Concatenates column values to produce an XML formatted line per row Concatenates XML for… [Previous page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.md?page=1) [Next page](https://forums.percona.com/c/mysql-mariadb/percona-server-for-mysql-5-6/15.md?page=3)