Re: [Maria-discuss] Adding timestamp column to a system

2016-02-02 Thread Sergei Golubchik
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

[Maria-discuss] Adding timestamp column to a system

2016-01-28 Thread Peter Mclarty
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 b