{"id":4155,"date":"2020-02-24T10:44:21","date_gmt":"2020-02-24T03:44:21","guid":{"rendered":"https:\/\/tino.vn\/?post_type=ht_kb&#038;p=4155"},"modified":"2020-02-25T08:13:41","modified_gmt":"2020-02-25T01:13:41","slug":"mariadb-advance-cac-yeu-cau-co-ban-de-mariadb-hoat-dong-tot-nhat","status":"publish","type":"ht_kb","link":"https:\/\/tino.vn\/blog\/docs\/mariadb-advance-cac-yeu-cau-co-ban-de-mariadb-hoat-dong-tot-nhat\/","title":{"rendered":"MariaDB Advance: C\u00e1c y\u00eau c\u1ea7u c\u01a1 b\u1ea3n \u0111\u1ec3 MariaDB ho\u1ea1t \u0111\u1ed9ng t\u1ed1t nh\u1ea5t."},"content":{"rendered":"<div><\/div>\n<div><strong><span style=\"font-size: 24pt;\">Hardware Optimization<\/span><\/strong><\/div>\n<div><\/div>\n<div><em><span style=\"font-size: 18pt;\">Memory<\/span><\/em><\/div>\n<div>B\u1ed9 nh\u1edb l\u00e0 y\u1ebfu t\u1ed1 quan tr\u1ecdng nh\u1ea5t v\u00ec n\u00f3 cho ph\u00e9p b\u1ea1n \u0111i\u1ec1u ch\u1ec9nh Bi\u1ebfn h\u1ec7 th\u1ed1ng m\u00e1y ch\u1ee7. Nhi\u1ec1u b\u1ed9 nh\u1edb h\u01a1n c\u00f3 ngh\u0129a l\u00e0 b\u1ed9 nh\u1edb cache v\u00e0 kh\u00f3a b\u1ea3ng l\u1edbn h\u01a1n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong b\u1ed9 nh\u1edb \u0111\u1ec3 truy c\u1eadp \u0111\u0129a, m\u1ed9t th\u1ee9 t\u1ef1 c\u01b0\u1eddng \u0111\u1ed9 ch\u1eadm h\u01a1n, b\u1ecb gi\u1ea3m.<\/div>\n<div>Ch\u1ec9 c\u1ea7n th\u00eam b\u1ed9 nh\u1edb nhi\u1ec1u h\u01a1n c\u00f3 th\u1ec3 kh\u00f4ng d\u1eabn \u0111\u1ebfn c\u1ea3i thi\u1ec7n m\u1ea1nh m\u1ebd n\u1ebfu c\u00e1c bi\u1ebfn m\u00e1y ch\u1ee7 kh\u00f4ng \u0111\u01b0\u1ee3c \u0111\u1eb7t \u0111\u1ec3 s\u1eed d\u1ee5ng th\u00eam b\u1ed9 nh\u1edb kh\u1ea3 d\u1ee5ng.<\/div>\n<div>S\u1eed d\u1ee5ng nhi\u1ec1u khe RAM tr\u00ean bo m\u1ea1ch ch\u1ee7 s\u1ebd l\u00e0m t\u0103ng t\u1ea7n s\u1ed1 bus v\u00e0 s\u1ebd c\u00f3 nhi\u1ec1u \u0111\u1ed9 tr\u1ec5 h\u01a1n gi\u1eefa RAM v\u00e0 CPU. V\u00ec v\u1eady, s\u1eed d\u1ee5ng k\u00edch th\u01b0\u1edbc RAM cao nh\u1ea5t tr\u00ean m\u1ed7i khe c\u1eafm l\u00e0 t\u1ed1t h\u01a1n.<\/div>\n<div><\/div>\n<div><em><span style=\"font-size: 18pt;\">Disks<\/span><\/em><\/div>\n<div>Truy c\u1eadp \u0111\u0129a nhanh l\u00e0 r\u1ea5t quan tr\u1ecdng, v\u00ec cu\u1ed1i c\u00f9ng n\u00f3 l\u00e0 n\u01a1i ch\u1ee9a d\u1eef li\u1ec7u. Con s\u1ed1 ch\u00ednh l\u00e0 th\u1eddi gian t\u00ecm ki\u1ebfm \u0111\u0129a, m\u1ed9t ph\u00e9p \u0111o t\u1ed1c \u0111\u1ed9 c\u1ee7a \u0111\u0129a v\u1eadt l\u00fd c\u00f3 th\u1ec3 di chuy\u1ec3n \u0111\u1ec3 truy c\u1eadp d\u1eef li\u1ec7u, v\u00ec v\u1eady h\u00e3y ch\u1ecdn c\u00e1c \u0111\u0129a c\u00f3 th\u1eddi gian t\u00ecm ki\u1ebfm c\u00e0ng th\u1ea5p c\u00e0ng t\u1ed1t. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u00eam c\u00e1c \u0111\u0129a chuy\u00ean d\u1ee5ng cho c\u00e1c t\u1ec7p t\u1ea1m th\u1eddi v\u00e0 nh\u1eadt k\u00fd giao d\u1ecbch.<\/div>\n<div><\/div>\n<div><em><span style=\"font-size: 18pt;\">CPU<\/span><\/em><\/div>\n<div>d\u00f9 c\u00e1c t\u1eafc ngh\u1ebdn ph\u1ea7n c\u1ee9ng th\u01b0\u1eddng r\u01a1i \u1edf n\u01a1i kh\u00e1c, b\u1ed9 x\u1eed l\u00fd nhanh h\u01a1n cho ph\u00e9p c\u00e1c ph\u00e9p t\u00ednh \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nhanh h\u01a1n v\u00e0 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c g\u1eedi l\u1ea1i cho m\u00e1y kh\u00e1ch nhanh h\u01a1n. B\u00ean c\u1ea1nh t\u1ed1c \u0111\u1ed9 b\u1ed9 x\u1eed l\u00fd, t\u1ed1c \u0111\u1ed9 bus v\u00e0 k\u00edch th\u01b0\u1edbc b\u1ed9 \u0111\u1ec7m c\u1ee7a b\u1ed9 x\u1eed l\u00fd c\u0169ng l\u00e0 nh\u1eefng y\u1ebfu t\u1ed1 quan tr\u1ecdng c\u1ea7n xem x\u00e9t.<\/div>\n<div>M\u1eb7c d\u00f9 c\u00e1c t\u1eafc ngh\u1ebdn ph\u1ea7n c\u1ee9ng th\u01b0\u1eddng r\u01a1i \u1edf n\u01a1i kh\u00e1c, b\u1ed9 x\u1eed l\u00fd nhanh h\u01a1n cho ph\u00e9p c\u00e1c ph\u00e9p t\u00ednh \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nhanh h\u01a1n v\u00e0 k\u1ebft qu\u1ea3 \u0111\u01b0\u1ee3c g\u1eedi l\u1ea1i cho m\u00e1y kh\u00e1ch nhanh h\u01a1n. B\u00ean c\u1ea1nh t\u1ed1c \u0111\u1ed9 b\u1ed9 x\u1eed l\u00fd, t\u1ed1c \u0111\u1ed9 bus v\u00e0 k\u00edch th\u01b0\u1edbc b\u1ed9 \u0111\u1ec7m c\u1ee7a b\u1ed9 x\u1eed l\u00fd c\u0169ng l\u00e0 nh\u1eefng y\u1ebfu t\u1ed1 quan tr\u1ecdng c\u1ea7n xem x\u00e9t.<\/div>\n<div><\/div>\n<div><strong><span style=\"font-size: 24pt;\"><em>Operating System Optimizations<\/em><\/span><\/strong><\/div>\n<div><span style=\"text-decoration: underline;\"><em>Linux kernel settings: <\/em><em>IO scheduler<\/em><\/span><\/div>\n<div>\u0110\u1ec3 c\u1ea3i thi\u1ec7n I\/O th\u00ec Mariadb s\u1eed d\u1ee5ng\u00a0noop scheduler ,\u00a0B\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m tra c\u00e0i \u0111\u1eb7t l\u1ecbch tr\u00ecnh c\u1ee7a m\u00ecnh v\u1edbi:<\/div>\n<div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">cat \/sys\/block\/${DEVICE}\/queue\/scheduler<\/pre>\n<p>V\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<\/div>\n<div>\n<div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">cat \/sys\/block\/sda\/queue\/scheduler\r\n[noop] deadline cfq<\/pre>\n<p>c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam t\u1ea1i \u0111\u00e2y: <a href=\"https:\/\/www.percona.com\/blog\/2009\/01\/30\/linux-schedulers-in-tpcc-like-benchmark\/\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/www.percona.com\/blog\/2009\/01\/30\/linux-schedulers-in-tpcc-like-benchmark\/<\/a><\/p>\n<\/div>\n<\/div>\n<div>Trong \u0111\u00f3 c\u00f3 b\u1ed9 scheduler noop l\u00e0 t\u1ed1t nh\u1ea5t, sau \u0111\u00f3 \u0111\u1ebfn deadline: <a href=\"https:\/\/access.redhat.com\/solutions\/109223\" rel=\"nofollow noopener\" target=\"_blank\">https:\/\/access.redhat.com\/solutions\/109223<\/a><\/div>\n<div><\/div>\n<div><span style=\"text-decoration: underline;\"><em>Open file limits:<\/em><\/span><\/div>\n<div>Open file limits kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e0i \u0111\u1eb7t li\u00ean quan \u0111\u1ebfn hi\u1ec7u su\u1ea5t, nh\u01b0ng ch\u1ea1y \u0111i\u1ec3m chu\u1ea9n v\u1edbi nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng \u0111\u1ed3ng th\u1eddi c\u00f3 th\u1ec3 \u0111\u1ea1t gi\u1edbi h\u1ea1n Open file limits.<\/div>\n<div>Tr\u00ean h\u1ea7u h\u1ebft c\u00e1c h\u1ec7 th\u1ed1ng Linux, gi\u1edbi h\u1ea1n t\u1ec7p m\u1edf l\u00e0 1024, c\u00f3 th\u1ec3 kh\u00f4ng \u0111\u1ee7. \u0110\u1eb7t gi\u1edbi h\u1ea1n t\u1ec7p m\u1edf c\u1ee7a b\u1ea1n cao h\u01a1n b\u1eb1ng c\u00e1ch ch\u1ec9nh s\u1eeda:<\/div>\n<div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">$EDITOR \/etc\/security\/limits.conf<\/pre>\n<p>Th\u00eam v\u00e0o d\u00f2ng d\u1ea1ng nh\u01b0 sau:<\/p>\n<\/div>\n<div>\n<div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">#ftp             hard    nproc           0\r\n#@student        -       maxlogins       4\r\n*                -       nofile          16384\r\n# End of file<\/pre>\n<p>\u0110\u1ea7u ra &#8220;&#8221; ulimit -a &#8220;&#8221; c\u1ee7a b\u1ea1n s\u1ebd tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0y sau \u0111\u00f3:<\/p>\n<\/div>\n<\/div>\n<div>\n<div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">ulimit -a\r\ncore file size          (blocks, -c) 0\r\ndata seg size           (kbytes, -d) unlimited\r\nscheduling priority             (-e) 0\r\nfile size               (blocks, -f) unlimited\r\npending signals                 (-i) 15975\r\nmax locked memory       (kbytes, -l) 64\r\nmax memory size         (kbytes, -m) 1744200\r\nopen files                      (-n) 16384<\/pre>\n<\/div>\n<\/div>\n<div><\/div>\n<div><em><span style=\"text-decoration: underline;\">Configuring Swappiness<\/span><\/em><\/div>\n<div>T\u1ea1i sao ph\u1ea3i tr\u00e1nh\u00a0Swapping : Do t\u1ed1c \u0111\u1ed9 x\u1eed l\u00fd tr\u00ean ram nhanh h\u01a1n nhi\u1ec1u so v\u1edbi tr\u00ean swap\u00a0 n\u00ean h\u1ea1n ch\u1ebf x\u1eed l\u00fd tr\u00ean swap \u0111\u01b0\u1ee3c th\u00ec t\u1ed1t h\u01a1n.<\/div>\n<div>Setting Swappiness on Linux<\/div>\n<div>M\u1eb7c \u0111\u1ecbnh th\u00ec linux s\u1ebd set swappiness l\u00e0 60:<\/div>\n<div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">sysctl vm.swappiness<\/pre>\n<\/div>\n<div>M\u1ed9t c\u00e0i \u0111\u1eb7t swappiness th\u1ea5p \u0111\u01b0\u1ee3c khuy\u1ebfn ngh\u1ecb cho kh\u1ed1i l\u01b0\u1ee3ng c\u00f4ng vi\u1ec7c c\u01a1 s\u1edf d\u1eef li\u1ec7u. \u0110\u1ed1i v\u1edbi c\u01a1 s\u1edf d\u1eef li\u1ec7u MariaDB, n\u00ean \u0111\u1eb7t swappiness th\u00e0nh gi\u00e1 tr\u1ecb 1.<\/div>\n<div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">vm.swappiness = 1<\/pre>\n<\/div>\n<div>sau \u0111\u00f3 reboot \u0111\u1ec3 nh\u1eadn c\u1ea5u h\u00ecnh ho\u1eb7c ch\u1ea1y th\u00eam l\u1ec7nh sau:<\/div>\n<div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">sysctl -w vm.swappiness=1<\/pre>\n<\/div>\n<div>Kh\u00f4ng n\u00ean t\u1eaft swap \u0111\u1ec3 tr\u00e1nh l\u1ed7i h\u1ec7 th\u1ed1ng \u0111\u1eb7c bi\u1ec7t l\u00e0 \u0111\u1ec3 kernel c\u00f3 th\u1ec3 ho\u1ea1t \u0111\u1ed9ng\u00a0gracefully khi c\u00f3 l\u1ed7i x\u1ea3y ra\u00a0 n\u1ebfu nh\u01b0 l\u01b0\u1ee3ng ram kh\u00f4ng d\u01b0 qu\u00e1 nhi\u1ec1u.<\/div>\n<div>\n<div><\/div>\n<div><\/div>\n<div><strong><span style=\"font-size: 24pt;\">File system Optimizations<\/span><\/strong><\/div>\n<div>H\u1ec7 th\u1ed1ng t\u1eadp tin kh\u00f4ng ph\u1ea3i l\u00e0 kh\u00eda c\u1ea1nh quan tr\u1ecdng nh\u1ea5t c\u1ee7a hi\u1ec7u n\u0103ng MariaDB. Quan tr\u1ecdng h\u01a1n nhi\u1ec1u l\u00e0 RAM c\u00f3 s\u1eb5n, t\u1ed1c \u0111\u1ed9 \u1ed5 \u0111\u0129a,\u00a0System Variables<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Hardware Optimization Memory B\u1ed9 nh\u1edb l\u00e0 y\u1ebfu t\u1ed1 quan tr\u1ecdng nh\u1ea5t v\u00ec n\u00f3 cho ph\u00e9p b\u1ea1n \u0111i\u1ec1u ch\u1ec9nh Bi\u1ebfn h\u1ec7 th\u1ed1ng m\u00e1y ch\u1ee7. Nhi\u1ec1u b\u1ed9 nh\u1edb h\u01a1n c\u00f3 ngh\u0129a l\u00e0 b\u1ed9 nh\u1edb cache v\u00e0 kh\u00f3a b\u1ea3ng l\u1edbn h\u01a1n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong b\u1ed9 nh\u1edb \u0111\u1ec3 truy c\u1eadp \u0111\u0129a, m\u1ed9t th\u1ee9 t\u1ef1 c\u01b0\u1eddng \u0111\u1ed9 [&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-4155","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\/4155","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=4155"}],"version-history":[{"count":0,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb\/4155\/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=4155"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/tags?post=4155"},{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/tino.vn\/blog\/wp-json\/wp\/v2\/ht_kb_category?post=4155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}