Skip to main content
Database Administrators

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
edited tags
Source Link
McNets
McNets
  • 23.9k
  • 11
  • 50
  • 89

I'm using 10.1.25-MariaDB-1~xenial. But, but engine is innodb though. 

I'm performing an alter by default it does ONLINE alter. 

When I add column it takes atleast 50minsat least 50 mins for 50G table in our infrastructure. But, but when I performed removing and adding a composite index of 3columns3 columns it took 8mins8 mins. 

Any idea internals of what it is doing? Also

Also does the duration changes if I'm adding an PK index/UK index.

I'm using 10.1.25-MariaDB-1~xenial. But engine is innodb though. I'm performing an alter by default it does ONLINE alter. When I add column it takes atleast 50mins for 50G table in our infrastructure. But when I performed removing and adding a composite index of 3columns it took 8mins. Any idea internals of what it is doing? Also does the duration changes if I'm adding an PK index/UK index.

I'm using 10.1.25-MariaDB-1~xenial, but engine is innodb though. 

I'm performing an alter by default it does ONLINE alter. 

When I add column it takes at least 50 mins for 50G table in our infrastructure, but when I performed removing and adding a composite index of 3 columns it took 8 mins. 

Any idea internals of what it is doing?

Also does the duration changes if I'm adding an PK index/UK index.

Source Link
Mannoj
Mannoj
  • 1.6k
  • 3
  • 15
  • 36

Time taken to drop/add index is lesser than adding a column. Why is that?

I'm using 10.1.25-MariaDB-1~xenial. But engine is innodb though. I'm performing an alter by default it does ONLINE alter. When I add column it takes atleast 50mins for 50G table in our infrastructure. But when I performed removing and adding a composite index of 3columns it took 8mins. Any idea internals of what it is doing? Also does the duration changes if I'm adding an PK index/UK index.