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

learn more… | top users | synonyms

3
votes
2answers
2k views

MySQL information_schema doesn't update

I have a database, say abc, in mysql server. It has only one table named test. test uses innodb engine and I've set innodb_file_per_table to true. After I run the query delete from abc.test, I want ...
1
vote
1answer
61 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
1answer
32 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
20 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
444 views

slow writes on percona / mariadb server only when replication is running

Hi I am trying to migrate to percona server from mysql 5.6 on windows. In my development machine for percona is running of centos 6.5 which is installed on vmware 5.5 sphere. Our business ...
0
votes
1answer
117 views

Cannot execute statement: impossible to write to binary log?

When I try to create a user story/issue in my my percona xtradb cluster I am getting below error. How to fix it? Error creating issue: Could not create workflow instance: root cause: while ...
0
votes
1answer
365 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) ...
0
votes
0answers
23 views

Never ending count(*) on a table after upgrading to Percona 5.6.16

I had a 5.5 instance I was upgrading to 5.6.16. That went seemingly with out issue, take a mysqldump from the 5.5 version and source into the 5.6.16. It starts up with out error in the error log. ...