{"id":4057,"date":"2020-02-20T16:20:19","date_gmt":"2020-02-20T09:20:19","guid":{"rendered":"https:\/\/tino.vn\/?post_type=ht_kb&#038;p=4057"},"modified":"2020-02-20T16:20:19","modified_gmt":"2020-02-20T09:20:19","slug":"mariadb-vi-tri-log_file-va-va-mot-so-loi-thuong-gap","status":"publish","type":"ht_kb","link":"https:\/\/tino.vn\/blog\/docs\/mariadb-vi-tri-log_file-va-va-mot-so-loi-thuong-gap\/","title":{"rendered":"MariaDB &#8211; V\u1ecb tr\u00ed log_file v\u00e0 v\u00e0 m\u1ed9t s\u1ed1 l\u1ed7i th\u01b0\u1eddng g\u1eb7p"},"content":{"rendered":"<p>\u0110\u1ed1i v\u1edbi log tr\u00ean MariaDB c\u00f3 4 lo\u1ea1i l\u00e0 general_log, Binary_Log, slow_query_log, log_error . Ch\u00fang ta ch\u1ec9 n\u00ean quan t\u00e2m \u0111\u1ebfn 2 lo\u1ea1i l\u00e0:<\/p>\n<ul>\n<li>slow_query_log : ghi c\u00e1c truy v\u1ea5n SQL m\u1ea5t nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 th\u1ef1c hi\u1ec7n.<\/li>\n<li>log_error : ghi c\u00e1c l\u1ed7i nghi\u00eam tr\u1ecdng x\u1ea3y ra trong qu\u00e1 tr\u00ecnh ho\u1ea1t \u0111\u1ed9ng c\u1ee7a m\u00e1y ch\u1ee7, h\u1ecfng b\u1ea3ng, th\u00f4ng tin start v\u00e0 stop.<\/li>\n<\/ul>\n<p>\u0110\u1ec3 b\u1eadt slow_query_log b\u1ea1n c\u00f3 th\u1ec3 xem chi ti\u1ebft t\u1ea1i \u0111\u00e2y: <a href=\"https:\/\/tino.vn\/blog\/docs\/bat-slow-query-log-tren-mariadb\/\">https:\/\/tino.vn\/blog\/docs\/bat-slow-query-log-tren-mariadb\/<\/a><\/p>\n<p>\u0110\u1ec3 b\u1eadt log_error b\u1ea1n c\u00f3 th\u1ec3 th\u00eam d\u00f2ng sau v\u00e0o file c\u1ea5u h\u00ecnh my.cnf<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">log_error=\/var\/log\/mariadb.err\r\n<\/pre>\n<p>\u0110\u1ec3 ki\u1ec3m tra v\u1ecb tr\u00ed file log_error m\u00e0 MariaDB \u0111ang s\u1eed d\u1ee5ng ta c\u00f3 th\u1ec3 d\u00f9ng l\u1ec7nh sau<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">MariaDB [(none)]&gt; SHOW VARIABLES LIKE 'log_error';\r\n+---------------+----------------------+\r\n| Variable_name | Value                |\r\n+---------------+----------------------+\r\n| log_error     | \/var\/log\/mariadb.err |\r\n+---------------+----------------------+\r\n1 row in set (0.001 sec)\r\n\r\nMariaDB [(none)]&gt; SHOW VARIABLES LIKE 'slow_query_log_file';\r\n+---------------------+---------------------------+\r\n| Variable_name       | Value                     |\r\n+---------------------+---------------------------+\r\n| slow_query_log_file | \/var\/log\/slow-queries.log |\r\n+---------------------+---------------------------+\r\n1 row in set (0.001 sec)<\/pre>\n<p>&nbsp;<\/p>\n<p>\u0110\u1ed1i v\u1edbi log_error b\u1ea1n c\u00f3 th\u1ec3 b\u1eadt \u0111\u1ec3 gi\u00e1m s\u00e1t, c\u0169ng nh\u01b0\u00a0 \u0111i\u1ec1u tra s\u1ef1 c\u1ed1 trong tr\u01b0\u1eddng h\u1ee3p MariaDB g\u1eb7p l\u1ed7i, c\u00f2n slow_query_log b\u1ea1n ch\u1ec9 n\u00ean b\u1eadt \u0111\u1ec3 t\u1ed1i \u01b0u server ho\u1eb7c debug c\u00e1c query ch\u1eadm. N\u1ebfu kh\u00f4ng c\u1ea7n debug b\u1ea1n n\u00ean t\u1eaft slow_query_log \u0111\u1ec3 gi\u1ea3m t\u1ea3i h\u1ec7 th\u1ed1ng v\u00ec vi\u1ec7c l\u01b0u log s\u1ebd t\u1ed1n t\u00e0i nguy\u00ean nh\u1ea5t \u0111\u1ecbnh.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0110\u1ed1i v\u1edbi log tr\u00ean MariaDB c\u00f3 4 lo\u1ea1i l\u00e0 general_log, Binary_Log, slow_query_log, log_error . Ch\u00fang ta ch\u1ec9 n\u00ean quan t\u00e2m \u0111\u1ebfn 2 lo\u1ea1i l\u00e0: slow_query_log : ghi c\u00e1c truy v\u1ea5n SQL m\u1ea5t nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 th\u1ef1c hi\u1ec7n. log_error : ghi c\u00e1c l\u1ed7i nghi\u00eam tr\u1ecdng x\u1ea3y ra trong qu\u00e1 tr\u00ecnh ho\u1ea1t \u0111\u1ed9ng c\u1ee7a m\u00e1y ch\u1ee7, [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":16424,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"tags":[],"ht_kb_category":[5156],"class_list":["post-4057","ht_kb","type-ht_kb","status-publish","format-standard","has-post-thumbnail","hentry","ht_kb_category-mariadb"],"_links":{"self":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4057","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/comments?post=4057"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4057\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media\/16424"}],"wp:attachment":[{"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/media?parent=4057"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=4057"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=4057"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}