Mariadb max_allowed_packet

[Niels2570]

Hello,

I've installed OTRS 3.3.5 on a RHEL 7 machine with Mariadb 5.5.37.

After running Support Assessment I got the following warnings

---
Check "max_allowed_packet" setting.
"max_allowed_packet" should be higher than 20 MB (it's 1 MB).

Critical Check "query_cache_size" setting.
The setting "query_cache_size" should be used.
----

The strange thing is that I've added those values in the /etc/my.cnf.d/server.cnf file and of course restarted mariadb.

---
[mysqld]

max_allowed_packet=48M
query_cache_type=1
query_cache_limit=5M
query_cache_size=32M

---

Mariadb starts with the right values :

/usr/libexec/mysqld would have been started with the following arguments:
--innodb_log_file_size=5242880 --query_cache_size=32M --thread_cache_size=4 --innodb_buffer_pool_size=66G --datadir=/var/lib/mysql --socket=/var/lib/mysql/mysql.sock --symbolic-links=0 --max_allowed_packet=48M --query_cache_type=1 --query_cache_limit=5M --query_cache_size=32M --character-set-server=utf8 --collation-server=utf8_general_ci --skip-character-set-client-handshake --init_connect=SET collation_connection = utf8_general_ci --init_connect=SET collation_database = utf8_general_ci --init_connect=SET NAMES utf8 --innodb_file_per_table --innodb_flush_method=O_DIRECT --innodb_buffer_pool_size=4G --thread_cache_size=4 --thread_cache_size=4 --innodb_buffer_pool_size=5G --innodb_log_buffer_size=67G --log_bin=/var/lib/myarch/mariadb-bin --log_bin_index=/var/lib/myarch/mariadb-bin.index --expire_logs_days=2

But when I connect and do a show variables I see the default value again ?

MariaDB [(none)]> show variables like 'max_allowed_packet';
+--------------------+---------+
| Variable_name | Value |
+--------------------+---------+
| max_allowed_packet | 1048576 |
+--------------------+---------+

My /etc/my.cnf is empty as it picks up the files from /etc/my.cnf.d and in there only the server.cnf has the values that I've added.

Any idea what I have to do to fix this ?

Regards,
Niels

[crythias]

This would not (necessarily) be an OTRS issue, but rather a mariadb issue.

[Niels2570]

Yeah, true, I will try to ask the Mariadb guys.

[Giulio Soleni]

Hi,
by the way, what Linux release are you using?
'cos both on CentOS 7 and OpenSuSE 13.1 mounting MariaDB I found present /etc/my.cnf at its place...

Edit: ... sorry for the silly question, since I see right now you have a RHEL 7 ... anyhow did you install MariaDB from source?

[Niels2570]

Hi,
by the way, what Linux release are you using?
'cos both on CentOS 7 and OpenSuSE 13.1 mounting MariaDB I found present /etc/my.cnf at its place...

Edit: ... sorry for the silly question, since I see right now you have a RHEL 7 ... anyhow did you install MariaDB from source?

MariaDB was installed from the repository from RedHat.

Anyways I got it working, but I don't like it, in fact when I do a chmod 644 /etc/my.cnf and restarted OTRS it worked.