# Pt-online-schema-change slow down

**URL:** <https://forums.percona.com/t/pt-online-schema-change-slow-down/12855>\
**Category:** Other MySQL® Questions\
**Created:** [November 3, 2021, 9:01pm UTC](https://forums.percona.com/t/pt-online-schema-change-slow-down/12855 "2021-11-03T21:01:23Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![md.abrarh](https://avatars.discourse-cdn.com/v4/letter/m/b487fb/32.png) [@md.abrarh](https://forums.percona.com/u/md.abrarh)\
**Post date:** [November 3, 2021, 9:01pm UTC](https://forums.percona.com/t/pt-online-schema-change-slow-down/12855/1 "2021-11-03T21:01:23Z")

</div>

Hi,

I started pt-online-schema-change(pt-OSC) for one of my table which is 265Gb in size in Aurora-mysql.Its very critical and highly accessed table.We are converting the column datatype from INT to BIGINT.The pt-OSC ran good for 15 hours and suddenly its performance degraded and started copying rows very slowly…Initially it was copying 80-90 million rows in one hour but suddenly its performance dropped and it now copying 5-6 million per hour…I checked CPU and memory and they look fine.As this is production environment , I had to pause the job for few hours whenever there is a high traffic.Initally when I resumed the job after 1-2 hours few times, it was working fine but later I resumed the job after almost 12 hours and pt-OSC was very slow…It copied only 60 million rows in 11 hours.Here is our pt-OSC command

pt-online-schema-change --recursion-method=none --chunk-size=5000 --max-load Threads\_running=150 --critical-load Threads\_running=300 --alter-foreign-keys-method=auto --alter=“MODIFY BIGINT NOT NULL AUTO\_INCREMENT DEFAULT NULL” h=“${HOST}”,P=3306,u=${USER},p=“${PASSWORD}”,D=,t= --charset=utf8mb4 --print --pause-file /tmp/pause-file --execute

Its still running but very slow…Any help would be greatly appreciated.

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [November 4, 2021, 3:45am UTC](https://forums.percona.com/t/pt-online-schema-change-slow-down/12855/2 "2021-11-04T03:45:27Z")

</div>

Did you check disk usage/iops? Check the history length of InnoDB. Is it growing?