Questions tagged [percona-toolkit]
26 questions
10
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
- 201
- 1
- 2
- 4
5
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
- 153
- 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
- 271
- 1
- 4
- 10
3
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
- 726
- 2
- 9
- 27
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
- 535
- 4
- 13
- 27
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
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
- 121
- 3
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
- 271
- 1
- 4
- 10
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
- 4
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
- 535
- 4
- 13
- 27
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
vote
1 answer
pt-query-digest --type binlog (percona-toolkit) gives empty output with MariaDB/Galera 10.1
My installed versions of MariaDB and Percona Toolkit on MacBook:
brew info percona-toolkit
percona-toolkit: stable 3.0.10 (bottled), HEAD
Percona Toolkit for…
Josefine
- 2,158
- 3
- 28
- 55
1
vote
1 answer
Delete _new table from pt-online-schema-change
I used pt-online-schema-change but the process died in the middle.
The script makes a copy of the original table with the name followed by "_new".
Since the process died in the middle, the table "_new" wasn't deleted and when I try to delete it my…
carla
- 553
- 1
- 7
- 14