3 ms·
> I assume this problem was limited to InnoDB because I did not see problems with MyRocks. This would certainly explain why InnoDB is insanely slow at loading
by Izkata 3y ago
> I assume this problem was limited to InnoDB because I did not see problems with MyRocks.
This would certainly explain why InnoDB is insanely slow at loading mysqldumps compared to MyISAM - we hit a wall in some systems and were unable to switch because of it. There's tons of questions online about how to speed this up, people were generally aware of the problem but assumed it was because InnoDB is more reliable with the data (like with foreign keys) or something about how it structures the data on disk that couldn't be changed.