Register and ask your own question!
pt-online-schema-change causes MariaDB/MySQL database to crash for very large tables
I am currently trying to run pt-online-schema-change on a MariaDB (v 10.2.36) database, in an attempt to "shrink" InnoDB tables. The table itself is very large -- weighing in at 450Gb.
I am running pt-online-schema-change (version 3.2.1) to attempt this, as follows:
nohup pt-online-schema-change D=my_database,t=very_large_table,h=127.0.0.1,u=root --alter="ENGINE=InnoDB" --alter-foreign-keys-method="auto" --execute &
So basically it spends a long parsing and creating a new version of the table, but then it eventually CRASHES the mySql database, with the following error.log message:
[ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.
I have tried the above command on a smaller table (40Gb) and there are no problems at all, but in the case of the large table, I have not had a lot of luck..
Does anyone have any suggestions, perhaps some 'magic' command-line options to use?
Thanks a lot for your help,