We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [percona]

Percona : MySQL open source fork with performance improvements

Filter by
Sorted by
Tagged with
0
votes
1answer
80 views

Routines backup in Percona xtrabackup

I am using Percona xtrabackup for creating backup of mysql server. Does backup file includes all the procedures, functions and triggers ? Does it get restored when i restore it ?
3
votes
1answer
2k views

Percona crash after running for some time [closed]

my mysql db crash after running for some time. MySQL version is *************************** 1. row *************************** Variable_name: innodb_version Value: 5.7.10-3 ******************...
0
votes
1answer
282 views

Insert into table select - Replication lag - Percona Server 5.6

I have two MySQL instances (Percona server 5.6.31) in Master-Slave replication setup. I have set the below configuration: ROW based replication is set. Transaction Isolation is set to read-committed....
0
votes
1answer
79 views

MySQL tuning query - 5.6

I'm using Percona Server 5.6.31 on RHEL 6. 64G RAM/16vCPU - VMware. It's Completely InnoDB and the database size is 300G. I have set Innodb_buffer_pool to 52G, innodb_buffer_pool_instances to default ...
1
vote
0answers
106 views

MySQL Insert from Select and schema alter Busy Production without downtime

Strategy for migration of Huge MySQL (Percona 5.7) Table (InnoDB) in production. The aim is to have minimum downtime (offline schema change would take a week or more...) old has a 100 plus columns ...
0
votes
1answer
47 views

One MySQL table for all data vs Several Different Engines MySQL Tables

I did quite good research and went through some information on this regard. But I am not satisfied yet, so preferred to ask directly about it. I'm designing the schema of an application database, ...
0
votes
1answer
590 views

Database Growth in a table - MySQL

I would like to store the database size for a particular database on daily basis on to a table which would help in understand the growth of the database over a period of time. SELECT table_schema AS "...
3
votes
1answer
1k views

MySQL Replication query - Primary key need

I have few doubts regarding MySQL replication (Master-Slave). Is it mandatory for a table to have primary query for replication to function properly? Referring this Percona link for the above ...
1
vote
0answers
206 views

why pt-table-checksum lock my whole table?

mysql> desc user_donate_request; +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------...
-1
votes
1answer
176 views

Percona pt-deadlock-logger strange results

Running the deadlock detector from Percona Toolkit, I get something like the following (MySQL 5.7 / AWS RDS, reformatted for clarity) server ts thread txn_id txn_time user hostname ip db tbl idx ...
0
votes
2answers
405 views

how to make sure pt-sync-table data is the latest?

the first step is to checksum difference and record into percona.checksum table pt-table-checksum h=xx,P=xx,u=xx,p=xx method=dsn=h=xx,D=xx,t=xx --databases=kobe the second step is to print the ...
6
votes
2answers
664 views

COMMIT on top of the pt-query-digest output

I've been optimizing my MySQL server and after tweaking a few queries, I ended up with the COMMIT item on top of the pt-query-digest output, as shown in the extract below: # 322s user time, 770ms ...
1
vote
0answers
21 views

Innodb file format - Percona Server [duplicate]

I had my innodb file format changed from antelope to barracuda recently. Is it safe to have both antelope and barracuda at the same time? I have my setup running properly now. What issues I would ...
1
vote
2answers
364 views

Delete many rows from a large percona mysql db

I need a fresh opinion on the case. Any thoughts are appreciated. Input: we have a huge percona mysql (5.5) database that takes a couple of Tb (terabytes). Tables on innodb engine. More than a half (...
0
votes
1answer
80 views

MySQL Monitoring Tools

I want to deploy tools to monitor my Production Percona servers (5.6 on Linux). I never used Nagios or any tool before. I did go through this great link but I wanted to clarify few things before ...
0
votes
1answer
451 views

Mysql slave skipping some updates

I have an existing Mysql 5.1.73 Master/Slave/Slave configuration, which is working correctly and all changes are being replicated. I have now set up a PerconaDB (mysql+galera+XtraDB) 5.6.30 3-node ...
1
vote
0answers
946 views

Trying to install Audit_log Plugin on MySQL

I'm trying to install the Percona Audit_log plugin for my instance of MySQL. I ran it previously so I know it works ok with MySQL (I'm sure it says so in the documentation anyway). I have MySQL 5.5....
2
votes
1answer
823 views

Flush Host Connection Blocked, but some connections allowed

We are running Percona MySQL 5.6.30. We've had an issue where a PHP script on a different host was reporting an issue connecting to the database: Database may be down : SQLSTATE[HY000] [1129] Host ...
0
votes
1answer
554 views

Percona Xtrabackup (Partial + incremental)

we have been trying restore Percona (Partial + Incremental) mysql backup, but failing. The process followed is as below: For Backup # Step I: Take Partial-Full Backup innobackupex --user=root -...
1
vote
1answer
1k views

Percona Xtradb Cluster 5.5: node can't join cluster - SST fails with auth problem

I have 3-nodes PXC 5.5 cluster. Settings on node03 in my.cnf [mysqld] section: wsrep_cluster_address=gcomm://<ip_node1>,<ip_node2> wsrep_cluster_name=cluster wsrep_provider_options="...
0
votes
2answers
453 views

Mysqldump failing while restoring database - MySQL 5.6

I have dumped one of my databases of size 5-6GB. I'm trying to restore to another instance but the same is getting failed after sometime with the following error: ERROR 2013 (HY000) at line 12006: ...
0
votes
1answer
446 views

MySQL Backups - Full vs incremental - innobackupex

So I'm implementing a backup strategy for our project and came across some text which I need absolute clarification, false positives are the death nell of IT. I am looking to do your typical backup ...
-1
votes
1answer
222 views

pt-table-checksum show wrong DIFF

I'm try to use pt-table-checksum tool. I have Master/Slave tables, and I add some rows to the slave to check it. pt-table-checksum --ignore-databases mysql S=/tmp/5.6.22_3306_Master/data/mysql.sock --...
4
votes
1answer
3k views

Percona: Backup preparation doesn't work (“cannot open ./xtrabackup_logfile”)

I've created a MySQL backup with PerconaXtrabackup tool via (thanks to this guide): innobackupex --user=backupmysqluser --password=xyz --compress --stream=xbstream ./ > /var/backups/db/firstBackup....
0
votes
1answer
68 views

MySQL - Upgrading from 5.5 to 5.6

I have MySQL community version 5.5.50 running in linux having 4-5 databases on it. Requirement is to upgrade to Percona Server 5.6.31-77.0. What are the pre-requisites that I need to check before ...
0
votes
1answer
602 views

Moving log files & data in MySQL

Is it possible to separate out data files and log files of MySQL from one drive to another? For eg: Data (actual database data and system tablespace ibdata) in one partition, say /data and log files ...
0
votes
1answer
332 views

Doubts on Setting up Master-Master replication (Percona)

I have two 5.6 Percona servers in which I'm planning to setup Active master- Passive master replication. Secondary master will be in read-only mode. Caveat is that the servers in which i'm going to ...
0
votes
1answer
41 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
463 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
2answers
396 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
39 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 ...
2
votes
1answer
719 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
2answers
351 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
3answers
1k 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
26 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
683 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
133 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
400 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 ...
2
votes
1answer
956 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
73 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....
1
vote
0answers
386 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 the fact that ...
0
votes
2answers
70 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
613 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
31 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 ...
5
votes
2answers
599 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
141 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 ...
3
votes
2answers
589 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 ...
2
votes
1answer
589 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
604 views

InnoDB AUTO_INCREMENT resetting itself without MySQL restart [duplicate]

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
829 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 / ...