(please read warning in above comment before following instructions below).
If you want to make config file changes:
docker exec -ti mysql /bin/bash
Edit /run/mysql/my.cnf as needed
supervisorctl restart mysql
It is important to note that the changes to config files are not persistent across container restarts and server reboot. In general, we have not envisioned Cloudron as a development environment, but we do have many devs using it as such. So, if there is interest, maybe we need to improve things for such use cases.
@girish I think that might be an improvement worth considering, no? Making the necessary changes would (I think)...
Make it clear to monitoring tools and manual checks by users which processes being run are local to the host and which are from containers, particularly useful when multiple instances of a service are being run both on the host and container.
Follow what appears to be "best practices" when running containers.
Improve security in certain situations.
Admittedly these may be minor and not worth the overhead, but now that I'm aware of the behaviour, I'm a bit irked by it as it currently prevents me from easily identifying which services are container-run and which are local to the host, as well as making it confusing to which user is actually running the process listed.
Generally, I am wary of putting this information for general use (and even in docs) because many things can go wrong . So, please, if you care about the data, don't hesitate to contact us on support@ . We help regardless of the subscription plan.
@drpaneas Just give that redis more memory. The "e1ca318a" is the app id. If you put in the search in the apps view, you will know which app's redis needs a bit more memory. It was reported earlier that pixelfed's redis needs more memory after the update. I guess this is because of update to Redis 5.
@nebulon I thought it was perhaps the Broken Links Checker on one of my WordPress installs, as as @marcusquinn noted it's widely known to sometimes cause such issues, but I've disabled that and I'm still getting these /mysql was restarted (OOM) (although they don't seem to appear in the event log?).
I note that the most recent one happened 5 minutes after my backups are due to start, and the other previous two times it's been 7-9mins before updates are due to run.
I wonder if either of those (backup/ update) processes might have something to do with it?
I guess I could just give mysql more memory and not worry, but be nice to know what's happening and why...
@girish I think the issue with MySQL Workbench is I can't use the latest version as they don't support macOS 10.14 past a certain version, and a colleague on a later macOS can get it working on a later MySQL Workbench version but I can't update my OS at the moment until some other software I use is updated to work with the later OS. Classic catch-22 on that one.
I think the solution to this should just be to use DBeaver, it's free on all platforms, and seems to work on all OS versions. too.
Maybe better to save your time for the odd additional /phpmyadmin/ that might be useful on certain apps.
Certainly appreciate the help and looking, but I don't want to distract you too much given it's a software version compatibility issue and not a Cloudron issue really. Thank you all the same though!!
@girish Thanks for the answer, but I didn't mean the internal server. I would like to install MySQL or another standalone server. I would like to try some things. Try and Error 🙂 I have three instances of Cloudron and I would like to install my own applications and if I can understand all things and requirements ... I do not know what can happen ....
First I have successfull ended a course on udemy.com for Docker.
This is possible but will increase complexity in deploys and maintenance. I have also noticed that MySQL changes things between patch releases a lot. Maybe because their release numbers don't follow semver .