Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [percona-tools]

A collection of software designed for advanced MySQL/PerconaServer tasks, maintenance, and monitoring.

Percona Toolkit is a collection of advanced command-line tools created by Percona support staff for the purpose of setting up MySQL and system tasks that are too difficult or complex to perform manually.

See the official percona website for a more comprehensive description of the Toolkit.

It is a very enhanced upgrade from its Predecessor : MAATKIT (also created by Percona)

More external links

79 questions
10
votes
1 answer

How to add index to a big table with 60M records without downtime?

we have been struggling with one issue in the past few days. We want to add an index to a huge table with 60M records. At first we tried adding it with basic mysql syntax. But it clogged our production DB. That table is used very frequently in…
Rohan
  • 53
  • 1
  • 8
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
6
votes
3 answers

Finding differences between a master and slave when pt-table-sync fails

I have a table that's showing some differences on a master and slave according to pt-table-checksum (PTC). I've found some verifying differences beyond that. Certain tables in the mix have composite primary keys which, while work well enough for…
atxdba
  • 5,293
  • 5
  • 41
  • 62
6
votes
2 answers

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 system time, 71.75M rss, 223.13M vsz # Current date:…
Diego T
  • 81
  • 5
5
votes
2 answers

Which hot backup tools for MySQL InnoDB database : Percona XtraBackup, Zmanda Recovery Manager Enterprise or Community or…?

I manage a PHP/MySQL website : max 500 simultaneous users / average of 4000 per hour in update/read 1 MySQL Community Server (5.1) - (Xeon / 16 Go RAM) InnoDB Storage engine on 100 tables for 1.4 Go of data Actually, every 30mn a cronjob make a…
Grey Goda
  • 51
  • 1
  • 2
5
votes
1 answer

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.db It succeeds creating the hot backup. Now I want…
user1623521
  • 159
  • 1
  • 7
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
4
votes
1 answer

pt-query-digest results are empty

I have a slow log generated by MySQL 5.1.71-log, that I've copied onto another machine. It appears I'm not getting any results from pt-query-digest. $> pt-query-digest slow.log # 2.1s user time, 910ms system time, 506.36M rss, 687.04M vsz # Current…
Alan C.
  • 347
  • 1
  • 11
4
votes
3 answers

failed pt-online-schema-change left behind triggers. How to delete?

We had a failed pt-osc - the server ran out of disk space. And now the triggers are left behind SHOW TRIGGERS; pt_osc_xxx_production_orders_ins pt_osc_xxx_production_orders_upd pt_osc_xxx_production_orders_del How can these be deleted? Doing a…
phil
  • 153
  • 6
4
votes
2 answers

pt-table-checksum help required

I am trying to figure out pt-table-checksum, as I am using it for the first time. It look likes the documentation is complex and not easy to understand stuff. I have a complex replication topology setup: I have master-master active topology setup…
user10011
  • 41
  • 1
  • 2
4
votes
2 answers

pt-table-checksum with slaves using non-standard ports

Trying to run pt-table-checksum to detect slave drift in MySQL replication. My slaves are not using the standard TCP listening port however, and so when I run the tool I get an error: Cannot connect to P=3306,h=,p=... It still checksums the…
wjimenez5271
  • 143
  • 1
  • 5
4
votes
2 answers

Is it possible to backup stored routines and functions with Innobackupex?

I am running a few restore tests on my Dev and I've noticed that the stored routines are not being restored with the innobackupx. Is that something achievable ? Am I doing something wrong ? I am only using innodb tables so it will be good to restore…
Haohmaru
  • 145
  • 1
  • 7
3
votes
1 answer

Fixing tables out of sync as reported by pt-table-checksum, pt-table-sync is not working

I have several tables being reported by pt-table-checksum with CRC_DIFF between my master and slave servers using the following commands: $ pt-table-checksum h=master,u=user,p=password --empty-replicate-table --databases db --replicate…
stanleykylee
  • 474
  • 1
  • 6
  • 21
3
votes
2 answers

Is it possible to remove useless GRANTS in MySQL

I'm using pt-show-grants to create all my GRANTS on a new server but there's lots of old GRANTS that refer to tables that doesn't exist anymore so I get errors when I try to apply the SQL file on the new server. Is there a way to remove GRANTS that…
bbigras
  • 215
  • 3
  • 7
3
votes
1 answer

pt-table-sync error: Called not_in_left in state 0

I have setup a Mysql replication between 2 servers, using Percona Xtrabackup: Master is a MySQL 5.0.91 Community Edition (CentOS 4.8) Slave is a MySQL 5.1.68 Community Edition (CentOS 6.4) When starting the slave, some replication queries where…
Nicolas Payart
  • 2,508
  • 5
  • 28
  • 36
1
2 3 4 5 6