{"id":4046,"date":"2020-02-12T15:44:33","date_gmt":"2020-02-12T08:44:33","guid":{"rendered":"https:\/\/tino.vn\/?post_type=ht_kb&#038;p=4046"},"modified":"2020-02-12T15:44:33","modified_gmt":"2020-02-12T08:44:33","slug":"bat-slow-query-log-tren-mariadb","status":"publish","type":"ht_kb","link":"https:\/\/tino.vn\/blog\/docs\/bat-slow-query-log-tren-mariadb\/","title":{"rendered":"B\u1eadt slow query log tr\u00ean MariaDB"},"content":{"rendered":"<div class=\"ddict_div\">\n<div class=\"ddict_div\">\n<p class=\"ddict_sentence\">Slow query log l\u00e0 b\u1ea3n ghi c\u00e1c truy v\u1ea5n SQL m\u1ea5t nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 th\u1ef1c hi\u1ec7n. \u0110\u1ec3 b\u1eadt t\u00ednh n\u0103ng n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 m\u1edf file c\u1ea5u h\u00ecnh MariaDB v\u00e0 th\u00eam c\u00e1c d\u00f2ng sau v\u00e0o file \/etc\/my.cnf:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">slow_query_log\r\nslow_query_log_file=slow-queries.log\r\nlong_query_time=5.0<\/pre>\n<p>Trong \u0111\u00f3<\/p>\n<ul>\n<li>slow_query_log : khi b\u00e1o cho bi\u1ebft b\u1eadt t\u00ednh n\u0103ng ghi log c\u00e1c query ch\u1eadm.<\/li>\n<li>slow_query_log_file=slow-queries.log : c\u1ea5u h\u00ecnh v\u1ecb tr\u00ed file log<\/li>\n<li>long_query_time=5.0 :\u00a0 ghi l\u1ea1i c\u00e1c query t\u1eeb 5s tr\u1edf l\u00ean.<\/li>\n<\/ul>\n<p>Sau khi\u00a0 th\u00eam c\u00e1c c\u1ea5u h\u00ecnh tr\u00ean, b\u1ea1n restart l\u1ea1i MariaDB \u0111\u1ec3 \u00e1p d\u1ee5ng c\u1ea5u h\u00ecnh:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">systemctl restart mariadb<\/pre>\n<p>Nh\u01b0 v\u1eady l\u00e0 \u0111\u00e3 th\u1ef1c hi\u1ec7n c\u1ea5u h\u00ecnh ho\u00e0n t\u1ea5t, \u0111\u1ec3 ki\u1ec3m tra\u00a0 nh\u1eefng query n\u00e0o ch\u1ea1y\u00a0 h\u01a1n ho\u1eb7c b\u1eb1ng 5s b\u1ea1n c\u00f3 th\u1ec3\u00a0 d\u00f9ng l\u1ec7nh sau \u0111\u1ec3 \u0111\u1ecdc file log:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">tailf slow-queries.log<\/pre>\n<p>&nbsp;<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Slow query log l\u00e0 b\u1ea3n ghi c\u00e1c truy v\u1ea5n SQL m\u1ea5t nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 th\u1ef1c hi\u1ec7n. \u0110\u1ec3 b\u1eadt t\u00ednh n\u0103ng n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 m\u1edf file c\u1ea5u h\u00ecnh MariaDB v\u00e0 th\u00eam c\u00e1c d\u00f2ng sau v\u00e0o file \/etc\/my.cnf: slow_query_log slow_query_log_file=slow-queries.log long_query_time=5.0 Trong \u0111\u00f3 slow_query_log : khi b\u00e1o cho bi\u1ebft b\u1eadt t\u00ednh n\u0103ng ghi log c\u00e1c [&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-4046","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\/4046","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=4046"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4046\/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=4046"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=4046"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=4046"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}