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?
MySQL conf and path [SOLVED]
- info@eurhosting.net
- KeyHelp Translator
- Posts: 45
- Joined: Tue 24. May 2016, 15:17
- Location: Brno
- Contact:
MySQL conf and path [SOLVED]
Stop stop stop
If hosting is not your main focus, I can be of help to mantain your servers
If hosting is not your main focus, I can be of help to mantain your servers
Re: MySQL conf and 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.
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
**************************************************************
Alexander Mahr
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
- info@eurhosting.net
- KeyHelp Translator
- Posts: 45
- Joined: Tue 24. May 2016, 15:17
- Location: Brno
- Contact:
Re: MySQL conf and path
That's a great piece of information.
And in case if update will be overwritten or we may sleep without worries?
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
If hosting is not your main focus, I can be of help to mantain your servers
Re: MySQL conf and path
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
**************************************************************
Alexander Mahr
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
- info@eurhosting.net
- KeyHelp Translator
- Posts: 45
- Joined: Tue 24. May 2016, 15:17
- Location: Brno
- Contact:
Re: MySQL conf and path
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?
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
If hosting is not your main focus, I can be of help to mantain your servers
Re: MySQL conf and path
Hallo,
maybe you don't have simply no slow queries.
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
**************************************************************
Florian Cheno
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
- info@eurhosting.net
- KeyHelp Translator
- Posts: 45
- Joined: Tue 24. May 2016, 15:17
- Location: Brno
- Contact:
Re: MySQL conf and path
seems u're rught Florian
After 36 hours we had only 1 result, but we had one so it mens that is actually working
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
If hosting is not your main focus, I can be of help to mantain your servers