innodb_buffer_pool_size settings

[LeeW]

Hi,

I am thinking about moving a Laravel site to Cloudron, simply because it's far easier to manage and back up vs Laravel Forge. My issue is that the DB is quite big at 55GB.

I have been trying to figure out if I can set innodb_buffer_pool_size, but it appears I have no control over that.

Can you tell me what the default is? Is it x% of the total system RAM or something else?

Thanks

Lee

[james]

Hello @LeeW

@LeeW said in innodb_buffer_pool_size settings:

have been trying to figure out if I can set innodb_buffer_pool_size, but it appears I have no control over that.

Officially no.
Unsupported yes.

---

When you connect to your Cloudron Server with ssh you can step into the mysql service container with:

docker exec -ti mysql /bin/bash

Inside the mysql service container you can find the file custom.cnf

root@mysql:/app/code# ls -lah
total 264K
drwxr-xr-x  1 root root 4.0K Apr  8  2025 .
drwxr-xr-x  1 root root 4.0K Apr  8  2025 ..
-rw-rw-r--  1 root root  669 Jul 22  2024 custom.cnf
-rw-rw-r--  1 root root 3.5K Jul 22  2024 my.cnf
drwxr-xr-x 98 root root 4.0K Apr  8  2025 node_modules
-rw-rw-r--  1 root root 211K Feb 27  2025 package-lock.json
-rw-rw-r--  1 root root  733 Feb 27  2025 package.json
-rwxrwxr-x  1 root root  17K Apr  8  2025 service.js
-rwxrwxr-x  1 root root 4.1K Apr  2  2025 start.sh

This file states:

# Add custom MySQL configuration here
# WARNING: Use this file at your own risk. It is not covered under Cloudron Support.
# Notes:
# 1. This config file is not part of Cloudron backup. Remember to add this
#    file again if you migrate servers.
# 2. Cloudron manages the update of MySQL. It is possible that a config
#    here breaks future MySQL. It is not possible to pin the mysql version.
#    The only way to do this is by not updating Cloudron.
# 3. Do not change default database configuration (like encoding, timezone). This
#    will most likely break apps and various Cloudron features.
# 4. When doing a major MySQL version upgrade, this file is removed!

You can add your custom configuration under the following path /home/yellowdata/platformdata/mysql/custom.cnf.
If you then restart the mysql service this configuration should be loaded.

I hope this helps.

[LeeW]

James,

Thanks, that's useful, I can use that as a workaround. I will need a 20GB pool size to keep things running the way I want. Thank you.

Lee