Timeline for MySQL any way to import a huge (32 GB) sql dump faster?
Current License: CC BY-SA 3.0
18 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 15, 2021 at 2:47 | comment | added | user1751825 | A 32GB database dump cannot really be considered to be "huge". I'm trying to find information about importing multi-terrabyte databases, and keep finding questions about databases I would consider to be quite small. | |
| Jun 4, 2021 at 16:44 | history | protected | CommunityBot | ||
| Jun 4, 2021 at 16:39 | answer | added | Ahtisham | timeline score: 3 | |
| Aug 16, 2019 at 14:56 | history | edited | RolandoMySQLDBA |
Added backup tag since mysqldump performs backups
|
|
| Nov 21, 2018 at 11:51 | answer | added | pgee70 | timeline score: 6 | |
| May 23, 2017 at 11:33 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Oct 21, 2016 at 18:11 | history | edited | RolandoMySQLDBA | CC BY-SA 3.0 |
Added mysqldump tag since it involves loading mysqldump file
|
| Jul 5, 2016 at 23:04 | history | tweeted | twitter.com/StackDBAs/status/750465332796592129 | ||
| Jul 5, 2016 at 20:29 | answer | added | Bruno J. Araujo | timeline score: 17 | |
| Nov 24, 2014 at 8:29 | vote | accept | SBhojani | ||
| Nov 23, 2014 at 3:19 | history | edited | RolandoMySQLDBA |
edited tags
|
|
| Nov 23, 2014 at 3:04 | answer | added | RolandoMySQLDBA | timeline score: 174 | |
| Nov 20, 2014 at 21:36 | vote | accept | SBhojani | ||
| Nov 20, 2014 at 21:36 | |||||
| Nov 20, 2014 at 17:01 | answer | added | Alex | timeline score: 6 | |
| Nov 20, 2014 at 3:50 | history | migrated | from serverfault.com (revisions) | ||
| Nov 19, 2014 at 21:28 | comment | added | SBhojani | @ChrisS no, the CPU usage is 3 to 4%. I'm not sure what the bottleneck is. I'm thinking it's the indexes. How would one find/confirm the bottleneck? | |
| Nov 19, 2014 at 20:53 | comment | added | SBhojani | @Bert the server has 8 GB of RAM most of which is just unused. Can't add more storage either. How would that help? Is it really the write operations that are so slow? | |
| Nov 19, 2014 at 20:36 | history | asked | SBhojani | CC BY-SA 3.0 |