I need to add an additional column to live DB table which contain millions of data. I'm using maria 10.0. Is there any tools? or Can anyone suggest a better method for this process.
可以将文章内容翻译成中文,广告屏蔽插件会导致该功能失效:
问题:
回答1:
MariaDB 10.3 has an "instand add column" feature that makes such an operation really fast.
https://mariadb.com/kb/en/library/instant-add-column-for-innodb/
As MariaDB 10.0 reaches its end of life ("EOL") this month, an update to a more recent release should be considered now, anyway?