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 [email protected] _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
