Hi,
I have tried to do some test with pt-online-schema-change while adding partion in the below way, I am getting error,
root@Raja/mysqlbackup/percona-toolkit-2.2.4/bin# pt-online-schema-change --execute --user=root --password=mysqlpass --host=localhost --alter “partition by range(id) (partition po values less than (945268782),partition p1 values less than (945368782),partition p2 values less than (945468782),partition p3 values less than (945568782),partition p4 values less than (MAXVALUE))” D=Client,t=user
Operation, tries, wait:
copy_rows, 10, 0.25
create_triggers, 10, 1
drop_triggers, 10, 1
swap_tables, 10, 1
update_foreign_keys, 10, 1
Altering Client
.user
…
Creating new table…
Created new table Client._user_new OK.
Altering new table…
Altered Client
._user_new
OK.
2013-09-27T06:09:44 Creating triggers…
2013-09-27T06:09:45 Created triggers OK.
2013-09-27T06:09:46 Copying approximately 368760 rows…
2013-09-27T06:09:47 Dropping triggers…
2013-09-27T06:09:51 Dropped triggers OK.
2013-09-27T06:09:51 Dropping new table…
2013-09-27T06:10:05 Dropped new table OK.
Client
.user
was not altered.
(in cleanup) 2013-09-27T06:09:47 Error copying rows from Client
.user
to Client
._user_new
: Threads_running=51 exceeds its critical threshold 50
2013-09-27T06:10:05 Dropping triggers…
2013-09-27T06:10:05 Dropped triggers OK.
Client
.user
was not altered.
How to fix this issue?
why it is showing this error ?
Server : Percona MySQL 5.5.30
Percona Tool kit version : percona-toolkit-2.2.4