How to add column to a table which contain millions of data

问题: 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...

问题:

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?

  • 发表于 2019-03-29 00:17
  • 阅读 ( 172 )
  • 分类:sof

条评论

请先 登录 后评论
不写代码的码农
小编

篇文章

作家榜 »

  1. 小编 文章
返回顶部
部分文章转自于网络,若有侵权请联系我们删除