Improve performance because of huge cpu load ( > 3)

Here is the result of iotop (that i just discover thanks to you)


Seems to have an issue with jbd2/md1-8 !

For the nextcloud database, it’s 1016.87 MB

you should give large enough caches to the database.

I’m not sure, are you talking about this parameter innodb_buffer_pool_size ?
At the moment, it is set to 256M
Here are all this related parameters

# Read the manual for more InnoDB related options. There are many!
default_storage_engine  = InnoDB
# you can't just change log file size, requires special procedure
#innodb_log_file_size   = 50M
innodb_buffer_pool_size = 256M
innodb_log_buffer_size  = 8M
innodb_file_per_table   = 1
innodb_open_files       = 400
innodb_io_capacity      = 400
innodb_flush_method     = O_DIRECT

Also thanks for sharing this topic, i will check this as soon as possible :pray: