Percona Server is a fork of MySQL Community Edition, focusing on performance improvements.

learn more… | top users | synonyms

1
vote
4answers
44 views

20 mysqld processes using only 1 port?

These are from Aliyun Cloud DB Servers,20 mysqld processes using one 3306 port Has anyone seen this before ? Can anybody explain how to do that ? Are there any advantages to this ?
1
vote
3answers
474 views

Integrity constraint violation in Percona XtraDB Cluster

We have a PHP application that uses AWS Load Balancer that connects to 3 Percona Servers. Before we used a single standard Percona Server and that never happened. The cluster starts throwing Primary ...
0
votes
2answers
1k views

Percona xtradb cluster node2 won't start

I have configured Percona Xtradb cluster 5.6. The first node starts fine when bootstrapped, but the second node seems to have an issue with this variable setting: wsrep_provider=/usr/lib/...
1
vote
1answer
29 views

How to clear gcache pages in Percona PXC

I have a 4 node cluster(percona PXC) and one of the nodes have more than 150 gcache disk files each of size ~128 MB. I would like to purge or flush them so that the server user fresh gcache disk file. ...
1
vote
1answer
54 views

TokuDB table stats row count decreases to 1

I have a few Percona 5.6.30 servers with a TokuDB table that has ~120 million rows. On some of these servers, row count in SHOW TABLE STATUS mysteriously decreases until is hits 1. This is accompanied ...
1
vote
1answer
55 views

Replicating into a Percona XtraDB Cluster

We have a 2 node (plus an arbiter) Percona XtraDB cluster. It is used for data indexing/archiving. It has it's own database called archive but it is also the replication slave for a database called ...
1
vote
1answer
62 views

InnoDB AUTO_INCREMENT resetting itself without MySQL restart

We've recently noticed the following scenario happening in many of our databases: A record is inserted, and receives an AUTO_INCREMENT primary key. The record is deleted. Another record is inserted, ...
0
votes
1answer
8 views

Percona server Master-Slave version query

I have a master with percona server (5.6.25) running in RHEL host and a slave of the same version. I'm facing some corruption issues in replication slave and I'm thinking of rebuilding the slave from ...
0
votes
1answer
47 views

How can I disable xb_doublewrite?

Getting error while service restart. [ERROR] InnoDB: A parallel doublewrite file /test/mysql/xb_doublewrite found on startup.
0
votes
1answer
69 views

Moved database (percona mysql) to larger disk, now everything is missing (though the files exist)

I dont know anything about databases or MySQL beyond the absolute basics so lets start with that. I moved the /var/lib/mysql from the / to a mounted volume which I remounted as /var/lib/mysql after ...
0
votes
1answer
31 views

Automatic slave reconfiguration after updating master

I have development mysql master and slave servers and a prod server. I need to set up regular (once a week) syncronization of dev and prod databases. It would be easy for me to use prod# mysqldump > ...
0
votes
1answer
541 views

Strange Locking issues while playing back logs via percona playback

Problem while replaying logs I am in the process of benchmarking a new DB node (specs at the end) and have run across some strange behavior: As described here i: Created a dump (innobackupex ftw) ...
1
vote
0answers
46 views

MYSQL Extremely slow - Heavy CPU Load

I am having an issue with my Percona MySQL 5.7 node. Since past 3 days, MySQL is processing queries very slowly. When I run top, the % CPU usage of MySQL is always 600. # top | grep mysqld 8409 ...
0
votes
0answers
17 views

Very slow query with percona XtraDB Cluster

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 ...
0
votes
0answers
36 views

MySQL Upgrade query

I have 5.5.44-log MySQL Community Server (GPL) running in one of my RHEL 6.4 server. I need to upgrade the server to Percona Server-5.6.29-76.2. How to go about the upgrade? Should I completely remove ...
0
votes
0answers
60 views

How to start mysql without recovery rollback

I started a delete operation on table "A" in mysql which ran for 12 hours (lots of triggers and cascading deletes) already before I decided to kill this transaction. I waited then for another 12 hours ...
0
votes
0answers
39 views

One node in Percona Cluster isn't coming up with following error

Whenever I try to start the services on this specific node it is failing with this error in log: [ERROR] WSREP: Node IP address not obtained from bind_address, trying alternate methods
0
votes
0answers
250 views

How to troubleshoot, find and fix query Percona 5.6 with error “SQLSTATE[HY000]: General error: 1785 When @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1”

i'm running Magento CMS, and underneath there are 2 physical servers both with Percona Server version: 5.6.23-72.1-log Percona Server (GPL), Release 72.1, Revision 0503478 in Master/Slave ...
0
votes
0answers
94 views

Temporary tables and Fetch times

We've noticed something curious in our office which no one seems to know the answer to. I'll explain: We have some mildly complex queries, one of which executes in under 3 seconds and then has a ...
0
votes
0answers
177 views

Very slow IO on mysql percona server

Our site goes down because the IO on our database servers is too slow. Troubleshooting this we found that mysql is really really slow. It's constantly reading from disk and I think not using enough ...