search

Map-A-Droid / MAD-docs

Documentation for Map-A-Droid
8 stars 28 forks source link

Added steps for mariadb performance optimizations #37

Closed domizei385 closed 4 years ago

domizei385 commented 4 years ago

updated to newer mariadb base image

muckelba commented 4 years ago

Nice suggestions! i think it would be smart to add the commandline options used in the docker-compose file as well to that file. Can you do that?

And are those settings optimized for docker or do they apply for a normal DB host as well?

domizei385 commented 4 years ago

Nice suggestions! i think it would be smart to add the commandline options used in the docker-compose file as well to that file. Can you do that?

And are those settings optimized for docker or do they apply for a normal DB host as well?

I like the separate cnf file, as I can add other options such as slow-query log, recovery mode etc. as well and it will take effect upon restarting the container. As for the commandline you'll have to rebuild the container.

As per general mariadb documentation those settings should be valid for both setups. However in the non-dockerized scenario I dont know whether people use the database for other things that I'd rather not mess with.