Hi, Peter! On Jan 29, Peter Mclarty wrote:
Hi All Running Mariadb 10.0.16 and need to add a timestamp column to a table with has around 60m rows
Testing on lesser hardware instances suggest around 40 minutes to make this change on the production system.
To reduce the down time I was planning to alter the slave and role swap the slave to become the master
I have added the column to a test slave and notice it alway populates as Unix_epoch 0 ie no current timestamp date | timestamp 2016-01-29 | 0000-00-00 00:00:00
This sounds about right, but to confirm it's not a bug.
Depends on what you want. If you do ALTER TABLE ... ADD COLUMN x TIMESTAMP DEFALT CURRENT_TIMESTAMP you'll get current timestamp; Regards, Sergei Chief Architect MariaDB and security@mariadb.org