Timeline for Migrate from innodb_file_per_table to off in MySQL ALTER TABLE removing ibd files
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Apr 27, 2016 at 1:39 | comment | added | jozwikjp | I think it was a 'wrong' guess in my case because it never removed the files or moved the table space after a day. | |
| Apr 26, 2016 at 20:47 | comment | added | Rick James | That's a guess. If the .ibd files did not go away in a few minutes, then it is a 'wrong' guess. | |
| Apr 26, 2016 at 11:45 | vote | accept | jozwikjp | ||
| Apr 26, 2016 at 11:44 | comment | added | jozwikjp | @RickJames so you are saying that even though those ibd files are still in place after running the commands that eventually they will be removed? Trying to reduce the amount of open files on the system. | |
| Apr 25, 2016 at 20:39 | comment | added | Rick James | What was the "Warnings: 1"? | |
| Apr 25, 2016 at 20:39 | comment | added | Rick James | Force, old_alter, etc are not needed -- the alter takes time, and it will, of necessity, do the copy. Only after the copy will the DATAFILE be changed. | |
| Apr 22, 2016 at 15:48 | history | edited | jozwikjp | CC BY-SA 3.0 |
added 1 character in body
|
| Apr 22, 2016 at 15:41 | history | edited | jozwikjp | CC BY-SA 3.0 |
added 604 characters in body
|
| Apr 22, 2016 at 15:25 | history | answered | jozwikjp | CC BY-SA 3.0 |