Stack Overflow
Stack Overflow

Questions tagged [pt-online-schema-change]

pt-online-schema-change is a command-line tool which emulates the way that MySQL alters tables internally, but it works on a copy of the table you wish to alter. This means that the original table is not locked, and clients may continue to read and change data in it.

Pt-online-schema-change is part of Percona Toolkit - a collection of advanced command-line tools for performing a variety of MySQL and system tasks that are too difficult or complex to perform manually.

pt-online-schema-change emulates the way that MySQL alters tables internally, but it works on a copy of the table you wish to alter. This means that the original table is not locked, and clients may continue to read and change data in it.

25 questions
0
votes
1 answer

Pt-online-schema-change - Huge replication lag when renaming tables

We are using ptosc on a Percona MySQL 5.7 database and at the end of the process we encounter a huge 2-3min replication lag on all replicas. We are using the following command and it does pause the copying of data when it encounters a replication…
Laobiz
  • 339
  • 1
  • 5
  • 14
0
votes
2 answers

Flyway upgrade vs. transition to online schema migration, etc

Our main project has been using a now-very-old Flyway version since inception. (v3.2.1) Flyway has made loads of improvements over the years, and v6+ appears to contain many interesting features for our MySQL schema. Attempting the supported…
hagemt
  • 328
  • 5
  • 12
0
votes
0 answers

Using pt-online-schema-change to alter table

pt-online-schema-change is not able to alter table. It is failing at the step where it copies rows from the original table to the new table and is throwing the error: copying rows caused a MySQL error 1048: Level: warning Code: 1048 Message: column…
user5594148
  • 1
  • 4
0
votes
1 answer

mysql innodb table with inconsistent row_format

I have a strange issue with MySQL (5.5.59): I have a logs database (where I store raw data of supplier requests). This table is compressed: CREATE TABLE `logs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `idLogType` tinyint(3) unsigned…
nemenems
  • 1,064
  • 2
  • 9
  • 27
0
votes
1 answer

Ignore warnings with pt-online-schema-change

I'm trying to update a table that was working fine a minute ago, but now I've hit an error that I've got in the past that's extremely inconvenient. 09:32:57 Copying rows caused a MySQL error 1300: Level: Warning Code: 1300 Message:…
Brian Leishman
  • 8,155
  • 11
  • 57
  • 93
0
votes
2 answers

MySQL error 1287 - On insert into table show the partition deprecated error

I am trying to use pt-online-schema-change to alter the schema of some tables on my database. The programs crashs with the MySQL error below. I need to not throws this kind of errors. I already tried to put disable-partition-engine-check on the…
user3806586
  • 53
  • 9
0
votes
1 answer

Percona modify table to allow nulls

how do you modify a table to allow nulls using percona. pt-online-schema-change --modfiy mycolumn default null d=database, t=table I see the --alter but nothing to modify an existing column.
user3525290
  • 1,557
  • 2
  • 20
  • 47
0
votes
0 answers

pt-online-schema-change error with big composite primary key

I've a table with composite primary key with below structure: CREATE TABLE field_name_test ( id_type varchar(128) NOT NULL DEFAULT '', desc varchar(128) NOT NULL DEFAULT '' , deleted tinyint(4) NOT NULL DEFAULT '0' , type_id int(10) unsigned NOT…
user2710412
  • 1
  • 2
0
votes
1 answer

mysql database versioning and pt-online-schema-change

its my first question on stack, than please forgive me if i do something wrong. I look for some tools what i can use for versioning my database. I found nice program for this like Liquibase or Flyway but hear start my problem. Usually to make change…
SilverRAT
  • 37
  • 7
0
votes
1 answer

Would the following primary key change work with `pt-online-schema-change`?

This is a follow-up of Can I use pt-online-schema-change to change a primary key?. Goal: I'd like to ALTER a table's primary key using pt-online-schema-change. Specifically I want migrate from single-column primary key (a) to a composite primary key…
Ztyx
  • 14,100
  • 15
  • 78
  • 114
1
2