Is it a seamless effort to partition a table with pt-online-schema-change than using the traditional Alter table in mysql client. I have been using pt-online-schema-change for years now and I must say that the result were outstanding. Recently, I’m trying to use this tool to partition my table but I have been getting some errors
( in cleanup ) Error altering new table ‘mydatabse. _mytable_new’: “DBD : : mysql : : db do failed: you have an error in your SQL syntax ; check the manual that corresponds yo your Mariadb server version for the right syntax to use near Jun 7;16:45:10 CEST 2023)
PARTITION BY RANGE (TO_DAYS(wed jun 7 16:46:10 ….::
Note: I’m thinking the partition function using is correct by the date Function (TO_DAYS) might be the issue here .