Percona : MySQL open source fork with performance improvements

learn more… | top users | synonyms

0
votes
0answers
6 views

how to change wsrep_cluster_size in Percona XtraDB Cluste?

I am trying to setup Percona XtraDB Cluster according to their doc When I run show status like 'wsrep%'; it's show wsrep_cluster_size is 1 in every node(2 node for me). Actually it should be 1 for ...
1
vote
1answer
17 views

Setting sql_slave_skip_counter is not working on Percona 5.6.24

I am currently running a master - slave replication where on my slave there is an sql error due to which my replication was stopped. when I tried to run the following good old solution SHOW SLAVE ...
1
vote
0answers
23 views

New percona xtradb node shuts itself down shortly after launch

We currently have a 3 node percona xtradb cluster running on premises. We are trying to add a 4th, remote node ( Obviously split-brain is a concern in this situation but it is only temporary while we ...
0
votes
1answer
40 views

MySql How to rollback my database to a certain point in time the fastest way?

I'm currently working in a testing database and we are not cleaning up after test because of our current configuration and we probably aren't changing that configuration soon, we are currently using a ...
0
votes
1answer
20 views

MySQL issue - startup

I have Percona Server 5.6 running in linux platform.. recently I faced an issue where mysql instance was continuously restarting for no reason.. mysql logs had this error: [ERROR] InnoDB: File ./...
0
votes
0answers
20 views

InnoDB: Operating system error number 9

I got error when trying to backup with percona. Backup command [xtrabackup --backup --target-dir=/data/backups/mysql/] was worked and When I try to prepare backup [xtrabackup --prepare --target-dir=/...
0
votes
1answer
71 views

Memory(buffer pool) not populating on mysql start on Percona 5.6.28

We are testing Percona 5.6.28 at the moment, during our testing we found out even though the innodb_buffer_pool_populate is set to ON, it doesn't populate the memory(buffer pool) during mysql start. ...
0
votes
1answer
13 views

Failed transaction replicated and thrown errors on remaining Percona XtraDB cluster nodes

I am using Percona XtraDB cluster 5.5.37. I have run one alter command (to add unique constraint) on node1. But due to duplicate keys,alter command failed on it. But that failed statement passed to ...
0
votes
1answer
16 views

How password can be prompted in percona xtrabackup

How password can be prompted while using percona xtrabackup.--ask-pass option is not working with xtrabackup. Thanks in advance.
1
vote
1answer
62 views

Is the SQL syntax for InnoDB gauranteed to be the same between MySQL, MariaDB and Percona?

I develop an application that uses MySQL and explicitly uses InnoDB table engine. In a few cases we have clients using this application with MariaDB or Percona. I understand that MariaDB and Percona ...
2
votes
1answer
28 views

In [Percona] MySQL, is the Adaptive Hash Index included in the Total memory allocated count?

I'm debugging a memory problem with MySQL 5.6 (I'm using the Percona distribution), but I can't figure out, searching around the web, if the Adaptive Hash Index amount is part of the Total memory ...
3
votes
1answer
41 views

Is there a non-blocking operation to back up MyISAM tables using Percona XtraBackup?

I've been reading through the website of Percona XtraBackup and it claims that: Percona XtraBackup can back up the following storage engines by briefly pausing writes at the end of the backup: ...
0
votes
1answer
19 views

Temporary files on RAM on PXC?

I manage a PXC 5.6 cluster and noticed that the tmpdir variable in /etc/my.cnf isn't set. I was thinking to set it to /tmp (which is tmpfs) to explicitly make the cluster store temporary files in RAM....
0
votes
2answers
61 views

Memory leak on MySQL slave?

I have a Percona MySQL master-slave server configuration(5.6.20-68.0). The memory usage by MySQL on the slave server is constantly growing. Now it reached 68G despite on fact that ...
0
votes
0answers
25 views

Boosting select queries during INSERT ON DUPLICATE KEY UPDATE into 150Gb innoDb table

I have a single server with 2 innoDb tables: 35Gb (partitioned, 24M rows), 150Gb (without partitioning, 220M rows). 25% data, 75% index. 99% of select queries are SUM + WHERE + GROUP BY. 100% of ...
0
votes
2answers
43 views

percona-online-schema-change recommendation

I am currently setting up percona-online-schema-change to do a ALTER on a table with 300m+ rows. I've verified that percona-online-schema-change can make the required ALTER. The source table ...
1
vote
2answers
46 views

OOM in mysql-percona, memory leak?

Every second day, I run into an OOM problem. Mar 21 17:31:33 iZ23h7fvujwZ kernel: Out of memory: Kill process 60346 (mysqld) score 943 or sacrifice child Mar 21 17:31:33 iZ23h7fvujwZ kernel: ...
0
votes
1answer
15 views

Allow access to RackSpace database from Vagrant box

we have two developers using Vagrant (which has it's own internal ip like: 10.0.2.0/24). On RackSpace we have a percona database instance. We would like to allow read/write access to that database ...
4
votes
2answers
116 views

Is there a way to create a MySQL/Percona Slave without using a dump?

I haven't been able to find anything so I'm sure the answer is no, what are you, a noob? but I feel the need to ask anyway :) Is there a simple utility that would allow a new slave server to be ...
1
vote
2answers
72 views

Running pt-table-checksum with replicate-do-db option on

I've read the documentation on percona page, but still a bit confused, especially about the --replicate option. My setting is that the slave is only replicating certain databases from master, say db1 ...
2
votes
2answers
118 views

How to make TokuDB engine on Percona delete faster

I've done some reading on the percona website, most notably MySQL Partitioning: A Flow Chart where they recommend TokuDB as a solution to faster(er) deletes over innoDB rather than partitioning. I've ...
0
votes
0answers
44 views

MySql master stopped writing to binlogs when tmp partition full

Percona MySql version is : mysql Ver 14.14 Distrib 5.5.46-37.5, for debian-linux-gnu (x86_64) using readline 5.1 OS Version is : Debian 7.9 MySql master has a separate tmp partition, of ...
1
vote
1answer
88 views

Between optimizing a 1-billion rows table and dump-restoring it, which would be faster?

Have multiple tables which had more than 1 billion rows. Archived and deleted many of them, now want to recover the disk space. Have option to either optimize the table, or dump the table and restore ...
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, ...
1
vote
3answers
69 views

MySQL Slave database size >> Master Database

I have a Percona MySQL Master-Master setup (5.6) with second master as passive master(read-only). Slave: mysql> SELECT table_schema AS "Database", ROUND(SUM(data_length + index_length) / 1024 / ...
1
vote
0answers
32 views

pt-table-sync fails “Turning off AutoCommit”

While trying to use pt-table-sync with the following options for a list of slaves: pt-table-sync --print --replicate schema.checksum_table --sync-to-master slave-001 I receive the following error ...
1
vote
1answer
52 views

Why does Table Definitions Opened differ this much between cluster nodes?

I have a Percona/Galera cluster and see this when i monitor the different cluster nodes. What does this really mean? And is this something erroneous that needs to be taken care of? This is how one of ...
0
votes
0answers
32 views

Master-master asyn replication between two PXC clusters and replicate-ignore-table

We have set up master-master async replication between two 3 node 5.5.41-37.0-55 PXC clusters. we need to exclude one table from the bi-directional replication. However, if we set replicate-ignore-...
0
votes
1answer
27 views

MySQL: 3 servers on-site architecture

I have 3 servers with RHEL 6 OS and Percona server running in one of the servers in the same data centre, while the other 2 servers lie idle. Now I need to implement some kind of on-site redundancy (...
0
votes
2answers
65 views

Optimal database structure for fast inserts

I am using MySQL Percona server. This table needs to do fast bulk inserts using 'INSERT INTO ... VALUES' for smaller requests (about 100k records) and using 'LOAD DATA INFILE' for larger (up to 10kk ...
1
vote
2answers
173 views

Scaling for MariaDB / Percona / Galera Scaling

I ventured into the world of NoSQL database and as great as they are the lack of true ACID compliance has been a nightmare resulting in a lot of bad data so I am looking into relational databases. I ...
1
vote
2answers
62 views

What options in /etc/mysql/my.cnf are applicable to percona-server-client-5.6?

I installed percona-server-client-5.6 on Ubuntu; there is no mysql server installed on that same machine. In /etc/mysql/, the only file is my.cnf. That file contains many sections of options and I am ...
0
votes
1answer
96 views

MySQL how to find top consuming queries

I have the need to find top resource consuming queries in my Percona 5.6 server so that those queries can be fine tuned to improve the performance of the database. Also, is it possible to get the ...
0
votes
1answer
124 views

How to recover performance_schema after restoring from partial innobackupex backup?

I am taking a partial backup from a Master server, which needs to be restored on a to-be slave server. I only need one of the databases, and the mysql database. I am following instructions on https:/...
0
votes
1answer
47 views

Suddenly a massive amount of binlog files

I've seen a sudden increase of binlog files, very large in number and size, in all three nodes of a Percona XtraDB cluster: -rw-rw---- 1 mysql mysql 1,1G 19 oct. 16:11 binlog-32.000001 -rw-rw---- ...
0
votes
0answers
92 views

wrapping point in innodb log file

I ran optimizing tables on a server and at the same time percona xtrabackup script started running on the same server due to a cron job. After some time i got below xtrabackup error. xtrabackup: ...
3
votes
1answer
175 views

How to run OPTIMIZE TABLE on a 3-node cluster?

I've my hands on a 3-node Percona XtraDB Cluster where, according to mysqlcheck, some tables are corrupted (some indexes contain the wrong number of entries): mydb.mytable Warning : InnoDB: Index '...
0
votes
0answers
34 views

Replication of MySQL databases, but only some of the data

I need to set up a system to do basically a partial backup/replication of a couple of MySQL databases (actually Percona XtraDB 5.5, all tables are InnoDB). There are a few hundred tables in one of ...
1
vote
2answers
44 views

Securing MySQL backup process

I'm running my MySQL backups through cron scheduled every night, but the thing is in cron the username and password is given for it run, is there any other way I can securely run the backups? where I ...
0
votes
1answer
838 views

Of the multiple cnf files in /etc/mysql/conf.d/ dir, which would be the last one to be read (and will enventually take precedence)?

For some reasons (and only for some days to come) we are going to have 2 cnf files in /etc/mysql/conf.d directory, apart from the default one /etc/mysql/my.cnf. Now I know this can be disastrous, and ...
1
vote
3answers
73 views

Is it safe to run optimze on mutliple tables in parallel in mysql (percona)

I have a slave on which no query is coming. Lot of data has been archived and deleted from almost all tables. Size of tables vary from 80Gb to few Mbs. And there are around 130 such tables. Mysql (...
2
votes
1answer
48 views

MySQL users not visible after import

I have a Percona MySQL database 5.6 running in a linux machine. I have created new users called test1 and test2. What I did was I imported mysql database from my test setup to this new setup. After ...
2
votes
1answer
63 views

MySQL connection process slow for non-root user

I'm using Percona server 5.6 on Linux. When I connect to MySQL from the command line as the root user, it connects immediately. I have also created a new user in the database, but when I try to ...
0
votes
2answers
843 views

Percona XtraDB - Random deadlock

Randomly my database gets locked completely and queries hang and they pile up until it gets "Too many connections". Below is my mysql log file, I couldn't find anything related to the error system ...
1
vote
0answers
32 views

MySQL/Percona Audit Log Plugin Not Working

I've been looking to implemement the Percona Audit Log plugin. So far I have installed it and configured it, and it seems to be working ok. Except, I have installed it on a slave Database as I don't ...
1
vote
2answers
253 views

Disaster recovery solution for MySQL

I have set a Master-master replication with the second Master running as read-only. This master-master setup is on the same location. Now I will have to setup an DR for this production at a different ...
2
votes
1answer
162 views

How to:: Master-Master replication

I have setup Master-Master replication on two servers. Now, my question is that if I need to have the second master as only read-only, what should I do? I tried doing mysql> flush tables with ...
0
votes
0answers
31 views

Doubt on Master-Master replication

I'm setting up a master-master replication where in the second master is only read only there by reducing the issues of conflicts. My doubt is that to reduce the downtime when my master goes down I ...
0
votes
0answers
111 views

MySQL drops every connection, even locally

Every time I run a MySQL query it has to reconnect mysql> show variables like '%timeout%'; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 60 ...
0
votes
0answers
86 views

Percona: Innobackupex failing when taking incremental backup

I have been trying to take incremental backup as below and its getting error all the time. Innobackupex 2.1.8 Linux x86_64 Mysql 5.5.45 Step1: innobackupex -uxxx --stream=xbstream datadir > file....