Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [percona-tools]

Percona Tools : 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 Documentation for a more Comprehensive Description of the Toolkit

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

73 questions
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,153
  • 5
  • 36
  • 56
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:…
LeG
  • 81
  • 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

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
  • 6
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
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
  • 7
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
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
  • 205
  • 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,008
  • 4
  • 22
  • 33
3
votes
2 answers

Prometheus High Memory and CPU Usage in PMM

We are running PMM v1.17.0 and prometheus is causing huge cpu and mem usage (200% CPU and 100% RAM), and pmm went down because of this. We are running PMM on a VM with 2vCPUs and 7.5G RAM, and are monitoring about 25 servers. PMM is running with…
user5594148
  • 43
  • 1
  • 7
3
votes
3 answers

Is it possible to pass parameters to pt-table-checksum using an options file?

We're using Percona's pt-table-checksum for MySQL replication integrity check. Is it possible to pass some or all of the options using some sort of configuration file? For instance, can we write the list of tables we want checked in a file? I…
Haluk
  • 599
  • 3
  • 10
  • 22
1
2 3 4 5