The DDL efficiency of version 7.0 has improved significantly!

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 7.0的DDL效率提高了不少!

| username: Running

With nearly 100 million records, adding two fields and completing the DDL operation in milliseconds is impressive :call_me_hand:. I hope the speed of bulk data updates can also be improved. Updating millions of records in bulk is very slow :sweat_smile:, so I can only update in small batches!

| username: Billmay表妹 | Original post link

Real-name thumbs up~

| username: Kongdom | Original post link

Real-name thumbs up~

| username: RenlySir | Original post link

With nearly 100 million records, adding two fields and completing the DDL operation in milliseconds, impressive.

| username: Raymond | Original post link

Can you test adding an index?

| username: Running | Original post link

In the online environment, I don’t dare to add it casually.

| username: WalterWj | Original post link

Adding a column has always been just modifying the metadata, theoretically it has always been very fast…

| username: dockerfile | Original post link

Adding a field doesn’t count… Whether it’s milliseconds or seconds doesn’t matter.
The key is adding an index to a large table, have you tested it?

| username: 孤君888 | Original post link

Awesome, awesome, awesome!

| username: yulei7633 | Original post link

DDL is non-blocking.