How to edit /etc/my.cnf? [SOLVED]

[phalek]

That's exactly the part where you need to add these variables to:

Code: Select all

# this is only for the mysqld standalone daemon
[mysqld]
...
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10

[Skepticalme]

I did the following:


And when I try to restart mariadb I get the following result.

Code: Select all

admin@nems:~ $ sudo systemctl restart mariadb
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

Code: Select all

admin@nems:~$ systemctl status mariadb.service

Code: Select all

● mariadb.service - MariaDB 10.3.22 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Tue 2023-01-17 00:47:48 AEDT; 56s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 2849 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
  Process: 2850 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 2852 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 2931 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Main PID: 2931 (code=exited, status=1/FAILURE)

Also, there are InnoDB variables, lots of them, do they go into the same [mysql] section?

Thanks again.

[phalek]

What does the other command "journalctl -xe" return ?

[Skepticalme]

What does the other command "journalctl -xe" return ?

[phalek]

you need to restart mysql/mariadb first before executing the command

[Skepticalme]

you need to restart mysql/mariadb first before executing the command

Sorry! This looks different.




I can't seem to restart mysql/mariadb

[phalek]

Ok, doesn't tell here.

Check /var/log for any mysql/mariadb logs, then check what errors are in there

[Skepticalme]

Ok, doesn't tell here.

Check /var/log for any mysql/mariadb logs, then check what errors are in there

Now I'm confused. Sorry for this mess.

Code: Select all

admin@nems:/var/log $ less /var/log/mysql/errorlog.1
/var/log/mysql/errorlog.1: Permission denied

[Skepticalme]

Ok, doesn't tell here.

Check /var/log for any mysql/mariadb logs, then check what errors are in there

Code: Select all

admin@nems:/var/log $ cd /var/log/mysql
bash: cd: /var/log/mysql: Permission denied

[Skepticalme]

Ok, doesn't tell here.

Check /var/log for any mysql/mariadb logs, then check what errors are in there

I put a hash in front of the variables again and MariaDB is working again but of course, I'm back to the original problem.

[phalek]

you should be "root" or do a "sudo cat /var/log/mysql/errorlog" thing.

You can enable the variables one-by-one though, then restartt mariadb and check if it does. Then go back enable the next one until mariadb does not start again.
Then skip/comment that variable again and take the next one until it starts with most variables uncommented except the ones that prevent it from starting

[Skepticalme]

you should be "root" or do a "sudo cat /var/log/mysql/errorlog" thing.

You can enable the variables one-by-one though, then restartt mariadb and check if it does. Then go back enable the next one until mariadb does not start again.
Then skip/comment that variable again and take the next one until it starts with most variables uncommented except the ones that prevent it from starting

The problem was that one of the variables was recommended to be set to 30.3 M, and MariaDB didn't like the ".3" ... so I removed it and input 31M and it solved the issue. Everything is done now. Thank you very much for your help and patience.

Code: Select all

max_heap_table_size	 12 M	>=	30.3 M

[TheWitness]

MySQL is bad about fractional M and G limits. Decimal points not allowed. Silly MySQL/MariaDB.