Timeline for mysql innodb dump restore slows down after upgrade mysql 5.7 to 8.0
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 19, 2018 at 12:52 | comment | added | mehltreter | i checked several configurations and finally created the following bug report: bugs.mysql.com/93684 | |
| Dec 13, 2018 at 22:00 | comment | added | Wilson Hauck | @mehltreter Your innodb_log_buffer_size and innodb_log_file_size are BACKWARDS. buffer_size should always be smaller than file_size. | |
| Dec 10, 2018 at 16:31 | comment | added | Rick James | @mehltreter - please add a link to the bug, so others can follow its progress. | |
| Dec 10, 2018 at 8:14 | comment | added | mehltreter | thanks for reply. i adjuted the values in my.cnf without any better performance. the database i used for testing has only two tables "authors" and "posts" and is generated with random data. only a single foreign key exists between this both tables. no stored programs or any other fancy stuff. i will create a bug report. | |
| Dec 7, 2018 at 20:38 | history | answered | Rick James | CC BY-SA 4.0 |