Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [percona-toolkit]

28 questions
12
votes
2 answers

Alter large table without downtime

I have a very large table, lets call it example, and I try to execute a little alter command on that table: ALTER TABLE `example` ADD `example_column` TINYINT(1) NOT NULL DEFAULT 0; Checking the progress of alter command: mysql -e 'show engine…
crashoverbike
  • 221
  • 1
  • 2
  • 4
7
votes
1 answer

How much space is needed to reclaim space from a table in INNODB

I inherited a MySQL InnoDB table that has approximately 200 GB worth of data, as well as several unneeded indices that amount to approximately 500 GB. I've archived approximately 75 percent of the records off site and DELETED the records from my…
Evan Volgas
  • 173
  • 1
  • 5
5
votes
2 answers

pt-table-checksum and row-based replication

The set up I work with is MySQL 5.5 in a master-slave replication configuration, but we have to use "MIXED" replication (statement and row-based) because we use an application that requires it, and it happens to be on our same server. We had…
dmgig
  • 291
  • 1
  • 4
  • 10
4
votes
2 answers

How pt-online-schema-change ensures consistency during data copy

I have read pt-online-schema-change documentation and understood that it works by creating triggers and copying data in chunks with in chunk-time seconds(0.5 seconds in default) Let us consider this below case. We have a table TBL1 of 5 GB and is…
Uday
  • 814
  • 3
  • 13
  • 27
3
votes
2 answers

Is it necessary to run apply-log immediately after innobackupexec has run?

i have been trying to read other questions, but i did not find a answer to suit me. So excuse me if i ask something that has been already asked. I'm trying to organize my self and backup all my mysql servers with innobackupexec (since i only use…
x86fantini
  • 131
  • 1
  • 3
3
votes
2 answers

Skipping chunk X of Y.Z because MySQL chose no index instead of the word_sid_typeindex

My environment: # cat /etc/redhat-release Red Hat Enterprise Linux Server release 6.8 (Santiago) # uname -a Linux A.B.C 2.6.32-642.4.2.el6.x86_64 #1 SMP Mon Aug 15 02:06:41 EDT 2016 x86_64 x86_64 x86_64 GNU/Linux # rpm -q mysql-server…
alexus
  • 625
  • 5
  • 14
  • 28
2
votes
1 answer

What is the Best way to set Disaster recovery setup for percona Xtra DB Cluster?

We do have a Percona XtraDB Cluster(Master-Master-Master) setup in one country. Now we want to setup a disaster recovery setup in some other country. Please provide us the best possible ways to do that. Is it possible to link between PXC(as…
Narasimha T. Juvvigunta
  • 133
  • 7
2
votes
1 answer

pt-heartbeat showing "Host is blocked because of many connection errors"...but connections are well under limit

I'm running MySQL in a master-slave configuration. pt-heartbeat is showing "Host is blocked because of many connection errors"...but connections are well under limit (limit is 600 connections, MySQL workbench shows I'm hovering around 250, and I'm…
dmgig
  • 291
  • 1
  • 4
  • 10
2
votes
1 answer

Is it safe to use pt-online-schema-change in a multimaster environment?

I have 2 MySQL servers with row-based replication between them. Both of them are masters and slaves for each other (active-active master-master setup). If I understand it correctly pt-osc creates triggers to catch any changes while running. But from…
Mrskman
  • 121
  • 2
2
votes
1 answer

Using Pt-online schema change on multi master MYSQL

We are using two MYSQL servers in ring replication where master is also a slave of the other master. Both have slaves connected to each other. We want to run pt-online-schema-change to add couple of columns but we are not sure if it may break the…
Mysql Consultancy
  • 35
  • 5
2
votes
2 answers

Cleanup / Prune Unreferenced Data in Dimension Tables

We have a star schema data warehouse running on MySQL 5.6. We keep a rolling 18 months of data in our fact tables using partitions by month. We have a number of dynamic dimension tables that are referenced by multiple fact tables. However, we have…
Shaun
  • 31
  • 2
2
votes
1 answer

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 message on some of the slaves: DBD::mysql::db STORE…
Ana C.
  • 83
  • 9
1
vote
1 answer

pt-table-checksum - Verify MySQL replication integrity

export/import: $ mysqldump -h6dhdbm01 -p clee2 users > 6dhdbm01-clee2.users.sql Enter password: $ echo $? 0 $ mysql clee2 < 6dhdbm01-clee2.users.sql $ echo $? 0 $ pt-table-checksum: $ pt-table-checksum --databases=clee2 --tables=users Error…
alexus
  • 625
  • 5
  • 14
  • 28
1
vote
1 answer

pt-online-schema-change MySQL Error: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

I've attempted to alter table using pt-online-schema-change in our master-master replication environment (Percona used as a cluster). It seems, that an operation completed successfully, but inspecting MySQL logs I've found the following: 140724…
Vladislav Rastrusny
  • 151
  • 2
  • 7
1
vote
0 answers

pt-archiver and foreign keys?

How does pt-archiver handle foreign keys? Does it archive associated data? (seems not but the documentation is not very clear to me) And if not, how could one perform an archive of a table with all its associated data from other tables also being…
GregOriol
  • 11
  • 2
1
2