Performance with large amount of databases is poor.
charrondev opened this issue · 3 comments
While a small performance loss is acceptable for the benefits of using a container, all my sites seemed to crawl to a halt once I imported a ~4GB of data across multiple databases in the datastorage volume (3-6 second response times). This is not an issue with using MySQL outside of Docker on MacOS 10.12.
I'm guessing the slowdown is could be partially alleviated by tuning the MySQL configuration a little bit, but is likely due to the way the datastorage volume is mounts the filesystem. I'm not really sure though.
Possible Solutions:
- Improve the docker setup/tune MySQL.
- Allow using the docker container, but with a native MySQL instance.
This seems to be a High Sierra problem: docker/for-mac#1810 (comment)
I rested with the same dump and I was able to restore it in 28m and I saw absolutely no performance downgrade.
Seems to have improved. Still not perfect though.
Doesn't seem to be an issue for normal development usage.