MySQL conf and path  [SOLVED]

Locked
User avatar
info@eurhosting.net
KeyHelp Translator
Posts: 45
Joined: Tue 24. May 2016, 15:17
Location: Brno
Contact:

MySQL conf and path  [SOLVED]

Post by 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?
Stop stop stop
If hosting is not your main focus, I can be of help to mantain your servers
User avatar
Alexander
Keyweb AG
Posts: 3810
Joined: Wed 20. Jan 2016, 02:23

Re: MySQL conf and path

Post by 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.
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
User avatar
info@eurhosting.net
KeyHelp Translator
Posts: 45
Joined: Tue 24. May 2016, 15:17
Location: Brno
Contact:

Re: MySQL conf and path

Post by info@eurhosting.net »

That's a great piece of information.

And in case if update will be overwritten or we may sleep without worries?
Stop stop stop
If hosting is not your main focus, I can be of help to mantain your servers
User avatar
Alexander
Keyweb AG
Posts: 3810
Joined: Wed 20. Jan 2016, 02:23

Re: MySQL conf and path

Post by Alexander »

This file is created when KeyHelp is installed and remains untouched for the rest of time.
Mit freundlichen Grüßen / Best regards
Alexander Mahr

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
User avatar
info@eurhosting.net
KeyHelp Translator
Posts: 45
Joined: Tue 24. May 2016, 15:17
Location: Brno
Contact:

Re: MySQL conf and path

Post by 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?
Stop stop stop
If hosting is not your main focus, I can be of help to mantain your servers
User avatar
Florian
Keyweb AG
Posts: 1243
Joined: Wed 20. Jan 2016, 02:28

Re: MySQL conf and path

Post by Florian »

Hallo,

maybe you don't have simply no slow queries.
Mit freundlichen Grüßen / Best regards
Florian Cheno

**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
User avatar
info@eurhosting.net
KeyHelp Translator
Posts: 45
Joined: Tue 24. May 2016, 15:17
Location: Brno
Contact:

Re: MySQL conf and path

Post by 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
Stop stop stop
If hosting is not your main focus, I can be of help to mantain your servers
Locked