Questions tagged [percona-tools]
A collection of software designed for advanced MySQL/PerconaServer tasks, maintenance, and monitoring.
77 questions
0 votes
0 answers
50 views
When does xtrabackup take lock exactly and why there's slave lag after backup starts?
MySQL Version -- MySQL Community Server 5.7.44 Percona xtrabackup Version 2.4.29 (x86_64) I want to understand when does xtrabackup exactly take the FLUSH TABLES WITH READ LOCK. Following is the ...
- 216
0 votes
0 answers
75 views
xtrabackup fails with error xb_stream_write_data() failed
I am facing a weird issue while using xtrabackup with xbstream. The weird part is that it was working fine just few days ago and apart from a reboot there were no changes on the machine. I have at ...
- 216
0 votes
1 answer
77 views
Percona xtrabackup and percona toolkit for aarch64 Graviton Amazon Linux 2 machines
In my organisation, it was decided to move all the MySQL infrastructure (Amazon EC2 machines) to Graviton (aarch64) servers from AMD (x86_64). All are MySQL Community Servers. I need percona-...
- 216
10 votes
1 answer
4k views
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 ...
- 53
4 votes
3 answers
889 views
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 ...
- 153
0 votes
1 answer
674 views
pt-online-schema-change drop_swap doesn't work, so what to do?
After waiting 24 hours for a ptosc this: 2023-05-29T11:29:40 Copied rows OK. 2023-05-29T11:29:40 Max rows for the rebuild_constraints method: 2710 Determining the method to update foreign keys... 2023-...
- 153
1 vote
1 answer
1k views
Run pt-online-schema-change with multiple ALTER queries synchronously
I want to run 3 ALTER queries with pt-online-schema-change tool: --alter "ADD INDEX userid_sid_ts_fid (user_id, scorecard_id, timestamp, factor_id), DROP INDEX uidts, RENAME INDEX ...
- 113
0 votes
1 answer
80 views
Can one use a view as a source on pt-table-sync?
Any attempt to fill a table from a view results in an error, as the source-table does not exist: Error getting table structure for TABLE_NAME on SOURCE_DSN_DATA doesnt handle CREATE TABLE without ...
- 223
0 votes
1 answer
440 views
Drop column with percona does not shrink table size
I have a table in Aurora MySQL 5.7. table has few partitions with 800m rows and weights 2tb. Recently I dropped few column using percona. Surprisingly the table size did not change (looking in ...
- 529
-1 votes
1 answer
1k views
InnoDB: Assertion failure on executing select Query - MySQL 5.7.31
I am using pt-archiver for daily archiving of tables, but while selecting data from one tables I am getting following error and it restart mysql instance 2021-07-07 13:21:17 0x7fe0dffdc700 InnoDB: ...
- 149
1 vote
1 answer
269 views
Incremental encrypted per database backup and Partial restore policy for MySQL 5.7 in replication setup
I will run a replication cluster using MySQL 5.7 and I would like to set up for each database a backup policy that has a full once per day + incremental every N hours with data encrypted (based on the ...
0 votes
1 answer
840 views
Stuck pt-archiver query during purge
I am purging a table of size 1.2T using pt-archiver. In the show processlist i can see the query stuck for 650 secs in Sending data state. The query is quick when I execute independely. Any help will ...
- 95
2 votes
3 answers
4k views
Can I disable binlogs to save space temporarily
I am using percona mysql 8. I do not use any type of replication, but I read that binlogs are useful for data recovery. I would like to turn of binlogging and flush them while I run pt-online-schema-...
- 163
0 votes
1 answer
770 views
Downgrade MySQL 8.0.20 to 8.0.19 on Ubuntu for using XtraBackup
With MySQL 8.0.20 currently installed on Ubuntu, I am unable to use Percona XtraBackup 2.3.7 due to breaking changes introduced in MySQL 8.0.20. How can we downgrade MySQL 8.0.20 to 8.0.19 on Ubuntu, ...
- 143
3 votes
2 answers
1k views
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 ...
- 43