• 请不要在回答技术问题时复制粘贴 AI 生成的内容
hostigation
V2EX  ›  程序员

mysql 中一个将近 1 亿行的表,要增加一个字段会很慢吗?

  •  
  •   hostigation · Nov 24, 2015 · 3474 views
    This topic created in 4002 days ago, the information mentioned may be changed or developed.
    triffic
    triffic
    Nov 24, 2015
    1
    这个字段是索引的一部分吗
    SoloCompany
    SoloCompany
    Nov 25, 2015
    2
    https://mariadb.com/kb/en/mariadb/alter-table/

    When does ALTER TABLE copy all data?

    Here is a list of the actions that can be performed without having to copy the table: ...
    显然,增加新的列不在这个列表内
    SmiteChow
    SmiteChow
    Nov 25, 2015
    3
    无论慢不慢,请先备份
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1208 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 15:54 · PVG 23:54 · LAX 07:54 · JFK 10:54
    ♥ Do have faith in what you're doing.