I am using mariadb and I to investigate some issue I wanted to check the logs. To my surprise, log file is not generated for mariadb.<\/p>\n
I suspect this cannot be the case so I am doubting my search skills.<\/p>\n
\nMariaDB [(none)]> show variables like 'log_error'\n -> ;\n+---------------+-------+\n| Variable_name | Value |\n+---------------+-------+\n| log_error | |\n+---------------+-------+\n1 row in set (0.00 sec)\n<\/pre>\nI have added the entry in my.cnf still above field is coming to be empty.<\/p>\n
\n[root@cslcodev11-oem ~]# cat \/etc\/my.cnf\n[mysqld]\n!includedir \/etc\/mysqld\/conf.d\ndatadir=\/mnt\/mgmt\/var\/lib\/mysql\nsocket=\/var\/lib\/mysql\/mysql.sock\ntmpdir=\/mnt\/mgmt\/var\/lib\/mysql_tmp\nuser=mysql\n# Disabling symbolic-links is recommended to prevent assorted security risks\nsymbolic-links=0\n### TRT-3229 #####\nsync_binlog=1\ninnodb_flush_method=O_DIRECT\ninnodb_support_xa = 1\nmyisam_repair_threads = 2\nmyisam_recover_options = FORCE\n###################\ninnodb_file_per_table=1\ninnodb_log_buffer_size = 8M\ntable_open_cache=256\nmax_heap_table_size=256M\n### TRT-4685 ###\nmax_connections=500\n################\ninnodb_log_file_size = 512M\n\n[mysqld_safe]\nlog-error=\/var\/log\/mariadb\/mysqld.log\npid-file=\/var\/run\/mysqld\/mysqld.pid\n[root@cslcodev11-oem ~]# \n<\/pre>\nSo, I want to know do we have any default location where these logs are getting generated, if the path cannot be read from config files.<\/p>\n
INFO: Reference: https:\/\/mariadb.com\/kb\/en\/mariadb\/error-log\/<\/p>\n
On the MariaDB Knowledge base page for the error-log there is a paragraph that states.<\/p>\n
systemd has its own logging system, and Linux distributions running systemd may log errors there instead. To view the systemd logs, use:<\/p>\n
\n# journalctl -u mariadb.\n<\/pre>\nThis answers the question because –log-error would be an option that could be added to MY_SPECIAL.conf file and journalctl is where mariadb logs errors by default on a systemd system. <\/p>\n","protected":false},"excerpt":{"rendered":"
I am using mariadb and I to investigate some issue I wanted to check the logs. To my surprise, log file is not generated for mariadb. I suspect this cannot be the case so I am doubting my search skills. MariaDB [(none)]> show variables like 'log_error' -> ; +—————+——-+ | Variable_name | Value | +—————+——-+ … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[],"class_list":["post-4923","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/4923","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/comments?post=4923"}],"version-history":[{"count":0,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/4923\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/media?parent=4923"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/categories?post=4923"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/tags?post=4923"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}