maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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@xxxxxxxxxxx