MySQL ALTER TABLE ADD COLUMN OPTIMIZATION

Asked Nov 03 '17 at 13:01

Active Nov 03 '17 at 13:21

Viewed 148 times

In a MariaDB Database, I'm trying to:

ALTER TABLE `table` 
ADD COLUMN `field1` BIGINT(6) UNSIGNED NOT NULL AFTER `field2`;

It is a great table with millions of registers (records). The DDL command runs for a long time. I don't mind if field1 is placed at the end or not. In performance terms, is better to place it at the end or not?

edited Nov 03 '17 at 13:21

Robert Columbia

6,313
15
32
40

asked Nov 03 '17 at 13:01

framontb

1,817
1
15
33

1

I don't get the downvotes. It is a good question IMO. – juergen d Nov 03 '17 at 13:04
I don't think ordering coloums in mysql matters in terms of performance, it's possible duplicate question of below one: https://stackoverflow.com/questions/2111958/does-column-order-matter-in-your-mysql-tables – Lawakush Kurmi Nov 03 '17 at 13:09
I mean performance executing the ALTER TABLE command – framontb Nov 03 '17 at 13:10

MySQL ALTER TABLE ADD COLUMN OPTIMIZATION

0 Answers0