KeyHelp Community

Hello

According to keyhelp documentation the path of mysql conf file is "/etc/mysql/my.cnf" and that file recall a file called "50-server.cnf"

We have modified the max connection to "50-server.cnf" and the change did not reflect in the sql.

So whitch file do we have to modify to have an actual working path?

Hello,

please have a look into "/etc/mysql/mariadb.conf.d/90-tuning.cnf". This file is included after the 50-server.cnf and therefore overwrites your settings in the 50-server.cnf file.

So you should made your changed in the 90-tuning.cnf.

That's a great piece of information.

And in case if update will be overwritten or we may sleep without worries?

This file is created when KeyHelp is installed and remains untouched for the rest of time.

Great

What about slow-query log?
Even if enabled all we got in the logfile is

/usr/sbin/mysqld, Version: 10.3.31-MariaDB-0ubuntu0.20.04.1-log (Ubuntu 20.04). started with:
Tcp port: 0 Unix socket: /run/mysqld/mysqld.sock
Time Id Command Argument


And ten is logging nothing.

Do we have to use a special path or whatever?

Hallo,

maybe you don't have simply no slow queries.

seems u're rught Florian

After 36 hours we had only 1 result, but we had one so it mens that is actually working