SOT: MariaDB 5.5.x-MariaDB Logs Are Not Going To Desired .log File

Home » CentOS » SOT: MariaDB 5.5.x-MariaDB Logs Are Not Going To Desired .log File
CentOS 3 Comments

Hi there, I know this is off-topic or semi off-topic but I really need some help since I am stucked.

I’m trying to redirect MariaDB logs to `/var/log/mysql/*.log` files as shown below on the `/etc/my.cnf.d/server.cnf` file:

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]
#wait_timeout(800
#interactive_timeout = 28800
max_allowed_packetQ2M

#General Query Log
general_log_file = /var/log/mysql/mysql_query.log
general_log = 1

#Error Log
log_error = /var/log/mysql/mysql_error.log

#Slow Query Log
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysql_slow.log
long_query_time = 2
log-queries-not-using-indexes

collation-server = utf8_general_ci
init-connect=’SET NAMES utf8′
character-set-server = utf8

# this is only for embedded server
[embedded]

# This group is only read by MariaDB servers, not by MySQL.
# If you use the same .cnf file for MySQL and MariaDB,
# you can put MariaDB-only options here
[mariadb]

# This group is only read by MariaDB-10.0 servers.
# If you use the same .cnf file for MariaDB of different versions,
# use this group for options that older servers don’t understand
[mariadb-5.5]

`mysql_query.log`, `mysql_error.log` and `mysql_slow.log` should go to
`/var/log/mysql/`, right? For some reason, unknow to me, they are not going. I did run the following query:

MariaDB [(none)]> show variables like ‘%log%’;

And this is the output:

+——————————————-+————————————————————————————————————–+
| Variable_name | Value

|
+——————————————-+————————————————————————————————————–+
| aria_checkpoint_log_activity | 1048576

|
| aria_log_file_size | 1073741824

|
| aria_log_purge_type | immediate

|
| aria_sync_log_dir | NEWFILE

|
| back_log | 50

|
| binlog_annotate_row_events | OFF

|
| binlog_cache_size | 32768

|
| binlog_checksum | NONE

|
| binlog_direct_non_transactional_updates | OFF

|
| binlog_format | STATEMENT

|
| binlog_optimize_thread_scheduling | ON

|
| binlog_stmt_cache_size | 32768

|
| expire_logs_days | 0

|
| general_log | OFF

|
| general_log_file | pdone-prod.log

|
| innodb_flush_log_at_trx_commit | 1

|
| innodb_locks_unsafe_for_binlog | OFF

|
| innodb_log_block_size | 512

|
| innodb_log_buffer_size | 8388608

|
| innodb_log_file_size | 5242880

|
| innodb_log_files_in_group | 2

|
| innodb_log_group_home_dir | ./

|
| innodb_mirrored_log_groups | 1

|
| innodb_recovery_update_relay_log | OFF

|
| innodb_use_global_flush_log_at_trx_commit | ON

|
| log | OFF

|
| log_bin | OFF

|
| log_bin_trust_function_creators | OFF

|
| log_error |
/var/lib/mysql/pdone-prod.pdi-inc.com.err
|
| log_output | FILE

|
| log_queries_not_using_indexes | OFF

|
| log_slave_updates | OFF

|
| log_slow_filter |
admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
|
| log_slow_queries | OFF

|
| log_slow_rate_limit | 1

|
| log_slow_verbosity |

|
| log_warnings | 1

|
| max_binlog_cache_size | 18446744073709547520

|
| max_binlog_size | 1073741824

|
| max_binlog_stmt_cache_size | 18446744073709547520

|
| max_relay_log_size | 0

|
| relay_log |

|
| relay_log_index |

|
| relay_log_info_file | relay-log.info

|
| relay_log_purge | ON

|
| relay_log_recovery | OFF

|
| relay_log_space_limit | 0

|
| slow_query_log | OFF

|
| slow_query_log_file | pdone-prod-slow.log

|
| sql_log_bin | ON

|
| sql_log_off | OFF

|
| sync_binlog | 0

|
| sync_relay_log | 0

|
| sync_relay_log_info | 0

|
+——————————————-+————————————————————————————————————–+
54 rows in set (0.01 sec)

I have tried putting same config at `[mariadb]` and `[mariadb-5.5]` and result is the same.

Why changes are not working? I have restarted MariaDB (mysql) service several times and even I have restarted the whole server. Seems like MariaDB is not reading those values, any advice?

3 thoughts on - SOT: MariaDB 5.5.x-MariaDB Logs Are Not Going To Desired .log File