Timeline for How can I determine the size of a dump file prior to dumping?
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 12, 2023 at 6:13 | comment | added | Meow Kim | Great solution :) | |
| Nov 19, 2021 at 16:02 | comment | added | Joe Yahchouchi | Thank you, ok so indexes are already excluded. | |
| Nov 18, 2021 at 23:54 | comment | added | RolandoMySQLDBA |
@JoeYahchouchi Please look carefully at my answer. I did exclude it already. Data pages and index pages are independent pages that coexist inside an .ibd file.
|
|
| Nov 18, 2021 at 19:48 | comment | added | Joe Yahchouchi | Is there any way to exclude the index size from that count? I have rather large indices and they won't be taking room in the dump file. Edit: I guess it would be SUM(DATA_LENGTH)-SUM(INDEX_LENGTH) DATA_BB | |
| Jan 24, 2021 at 17:00 | comment | added | Björn | Thank you for the explanation. | |
| Jan 22, 2021 at 18:03 | comment | added | RolandoMySQLDBA |
@Björn The A is an alias for the subquery.
|
|
| Jan 22, 2021 at 17:45 | comment | added | Björn |
The A in A;is no typo.
|
|
| Mar 20, 2013 at 19:06 | vote | accept | Micah Bolen | ||
| Mar 20, 2013 at 18:59 | history | answered | RolandoMySQLDBA | CC BY-SA 3.0 |