MySQL conf and path [SOLVED]

[info@eurhosting.net]

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?

[Alexander]

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.

[info@eurhosting.net]

That's a great piece of information.

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

[Alexander]

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

[info@eurhosting.net]

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?

[Florian]

Hallo,

maybe you don't have simply no slow queries.

[info@eurhosting.net]

seems u're rught Florian

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