{"id":14374,"date":"2020-02-09T12:32:48","date_gmt":"2020-02-09T12:32:48","guid":{"rendered":"https:\/\/kiencang.net\/?p=14374"},"modified":"2023-07-24T03:37:37","modified_gmt":"2023-07-23T20:37:37","slug":"toi-uu-database-wordpress","status":"publish","type":"post","link":"https:\/\/kiencang.net\/toi-uu-database-wordpress\/","title":{"rendered":"C\u00e1ch t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u (database) trong WordPress"},"content":{"rendered":"\n<p>C\u01a1 s\u1edf d\u1eef li\u1ec7u (CSDL) trong website WordPress n\u1eafm gi\u1eef c\u00e1c th\u00f4ng tin ki\u1ec3u nh\u01b0 n\u1ed9i dung b\u00e0i post, ng\u01b0\u1eddi d\u00f9ng, \u0111\u01a1n \u0111\u1eb7t h\u00e0ng, v\u00e0 c\u00e1c c\u00e0i \u0111\u1eb7t (setting) c\u1ee7a giao di\u1ec7n c\u0169ng nh\u01b0 plugin. Trong khi c\u00e1c m\u00e3 PHP cho trang web bi\u1ebft c\u00e1ch th\u1ef1c hi\u1ec7n c\u00e1c h\u00e0m v\u00e0 CSS cho c\u00e1c \u0111o\u1ea1n m\u00e3 h\u00ecnh d\u00e1ng, th\u00ec CSDL n\u1eafm gi\u1eef t\u1ea5t c\u1ea3 th\u00f4ng tin cho n\u1ed9i dung c\u1ee7a trang. \u0110i\u1ec1u quan tr\u1ecdng l\u00e0 CSDL c\u1ea7n nh\u1eb9 nh\u00e0ng (lightweight), khi \u1ea5y n\u00f3 s\u1ebd \u0111\u1ee7 nhanh \u0111\u1ec3 t\u01b0\u01a1ng t\u00e1c v\u1edbi m\u1ecdi trang m\u00e0 kh\u00f4ng \u1ea3nh h\u01b0\u1edfng ti\u00eau c\u1ef1c \u0111\u1ebfn hi\u1ec7u su\u1ea5t (performance).<\/p>\n\n\n\n<p>Ng\u00f4n ng\u1eef SQL \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 vi\u1ebft l\u1ec7nh y\u00eau c\u1ea7u, n\u00f3 c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 &#8220;truy v\u1ea5n\/query&#8221; th\u00f4ng tin t\u1eeb CSDL. \u0110i\u1ec1u quan tr\u1ecdng l\u00e0 c\u0169ng ph\u1ea3i \u0111\u1ea3m b\u1ea3o truy v\u1ea5n SQL nh\u1eb9 nh\u00e0ng \u0111\u1ec3 trang c\u00f3 th\u1ec3 t\u1ea3i hi\u1ec7u qu\u1ea3 h\u01a1n.<\/p>\n\n\n\n<p>\u0110\u1ec3 t\u1ed1i \u01b0u h\u00f3a CSDL c\u1ee7a b\u1ea1n, b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i ch\u1ea1y c\u00e1c truy v\u1ea5n t\u1eeb phpMyAdmin.<\/p>\n\n\n\n<p>B\u1eb1ng c\u00e1ch t\u1ed1i \u01b0u h\u00f3a c\u1ea3 d\u1eef li\u1ec7u trong CSDL v\u00e0 truy v\u1ea5n SQL giao ti\u1ebfp v\u1edbi n\u00f3, b\u1ea1n s\u1ebd <a href=\"https:\/\/kiencang.net\/tang-toc-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">c\u1ea3i thi\u1ec7n th\u1eddi gian t\u1ea3i trang web<\/a>, <a href=\"https:\/\/kiencang.net\/giam-ttfb-trong-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">TTFB<\/a>, v\u00e0 tr\u1ea3i nghi\u1ec7m t\u1ed5ng th\u1ec3 c\u1ee7a ng\u01b0\u1eddi d\u00f9ng cu\u1ed1i (end-user experience).<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_60 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >M\u1ee5c l\u1ee5c<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6577d65a16062\" ><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6577d65a16062\"  type=\"checkbox\" id=\"item-6577d65a16062\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress\/#Toi_uu_hoa_cac_bang\" title=\"T\u1ed1i \u01b0u h\u00f3a c\u00e1c b\u1ea3ng\">T\u1ed1i \u01b0u h\u00f3a c\u00e1c b\u1ea3ng<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress\/#Cac_kieu_bang_Storage_engine_va_bo_nho\" title=\"C\u00e1c ki\u1ec3u b\u1ea3ng Storage engine v\u00e0 b\u1ed9 nh\u1edb\">C\u00e1c ki\u1ec3u b\u1ea3ng Storage engine v\u00e0 b\u1ed9 nh\u1edb<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress\/#Don_dep_CSDL\" title=\"D\u1ecdn d\u1eb9p CSDL\">D\u1ecdn d\u1eb9p CSDL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress\/#Cac_plugin_giup_don_dep_co_so_du_lieu\" title=\"C\u00e1c plugin gi\u00fap d\u1ecdn d\u1eb9p c\u01a1 s\u1edf d\u1eef li\u1ec7u\">C\u00e1c plugin gi\u00fap d\u1ecdn d\u1eb9p c\u01a1 s\u1edf d\u1eef li\u1ec7u<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress\/#Cac_du_lieu_duoc_tai_tu_dong_autoloaded\" title=\"C\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ea3i t\u1ef1 \u0111\u1ed9ng (autoloaded)\">C\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ea3i t\u1ef1 \u0111\u1ed9ng (autoloaded)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress\/#Object_cache\" title=\"Object cache\">Object cache<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress\/#Cac_giai_phap_cho_tim_kiem\" title=\"C\u00e1c gi\u1ea3i ph\u00e1p cho t\u00ecm ki\u1ebfm\">C\u00e1c gi\u1ea3i ph\u00e1p cho t\u00ecm ki\u1ebfm<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Toi_uu_hoa_cac_bang\"><\/span>T\u1ed1i \u01b0u h\u00f3a c\u00e1c b\u1ea3ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>S\u1eed d\u1ee5ng c\u00e1c c\u00e2u l\u1ec7nh <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/optimize-table.html\" target=\"_blank\" rel=\"noreferrer noopener\">T\u1ed1i \u01b0u h\u00f3a b\u1ea3ng (optimize table)<\/a> l\u00e0 th\u1ef1c h\u00e0nh t\u1ed1t \u0111\u1ec3 duy tr\u00ec ch\u1ea5t l\u01b0\u1ee3ng v\u00e0 hi\u1ec7u su\u1ea5t c\u1ee7a CSDL. T\u1ed1i \u01b0u h\u00f3a b\u1ea3ng s\u1ebd t\u1ea1o l\u1ea1i b\u1ea3ng \u0111\u00e3 ch\u1ecdn v\u00e0 lo\u1ea1i b\u1ecf b\u1ea5t k\u1ef3 kh\u00f4ng gian \u0111\u0129a th\u1eeba n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng b\u1edfi b\u1ea3ng \u0111\u00f3. Gi\u1ea3i ph\u00f3ng kh\u00f4ng gian \u0111\u0129a th\u1eeba gi\u00fap c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t b\u1eb1ng c\u00e1ch gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u ph\u1ea3i l\u01b0u gi\u1eef trong b\u1ed9 nh\u1edb khi truy c\u1eadp b\u1ea3ng.<\/p>\n\n\n\n<p>\u0110\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u00e1c b\u1ea3ng CSDL:<\/p>\n\n\n\n<ol>\n<li>\u0110\u0103ng nh\u1eadp v\u00e0o <strong>phpMyAdmin<\/strong><\/li>\n\n\n\n<li>Ch\u1ecdn CSDL (<strong>wp_environmentname<\/strong>)<\/li>\n\n\n\n<li><strong>Tick v\u00e0o h\u1ed9p nh\u1ecf<\/strong> b\u00ean c\u1ea1nh c\u00e1c b\u1ea3ng b\u1ea1n mu\u1ed1n t\u1ed1i \u01b0u h\u00f3a<\/li>\n\n\n\n<li>\u1ede cu\u1ed1i, trong ph\u1ea7n x\u1ed5 xu\u1ed1ng, b\u1ea1n ch\u1ecdn T\u1ed1i \u01b0u h\u00f3a b\u1ea3ng (<strong>Optimize table<\/strong>)<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/toi-uu-hoa-bang.png\" alt=\"t\u1ed1i \u01b0u h\u00f3a b\u1ea3ng\" class=\"wp-image-14375\"\/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cac_kieu_bang_Storage_engine_va_bo_nho\"><\/span>C\u00e1c ki\u1ec3u b\u1ea3ng Storage engine v\u00e0 b\u1ed9 nh\u1edb<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>C\u00f3 hai c\u01a1 ch\u1ebf storage engines ch\u00ednh \u0111\u1ec3 t\u1ea1o b\u1ea3ng: MyISAM v\u00e0 InnoDB. Ki\u1ec3u storage engine trang c\u1ee7a b\u1ea1n s\u1eed d\u1ee5ng s\u1ebd \u1ea3nh h\u01b0\u1edfng l\u1edbn \u0111\u1ebfn hi\u1ec7u su\u1ea5t do c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t trong c\u00e1ch ch\u00fang ghi d\u1eef li\u1ec7u v\u00e0 s\u1eed d\u1ee5ng c\u00e1c ngu\u1ed3n t\u00e0i nguy\u00ean m\u00e1y ch\u1ee7 (server resources). Ch\u00fang t\u00f4i lu\u00f4n <em><strong>khuy\u1ebfn kh\u00edch s\u1eed d\u1ee5ng ki\u1ec3u storage ingine InnoDB<\/strong><\/em> \u0111\u1ec3 t\u1ea1o b\u1ea3ng.<\/p>\n\n\n\n<p>Hi\u1ec7u su\u1ea5t c\u1ee7a MyISAM ch\u1ec9 \u1ed5n \u1edf kh\u00eda c\u1ea1nh \u0111\u1ecdc CSDL, nh\u01b0ng khi n\u00f3i \u0111\u1ebfn vi\u1ec7c vi\u1ebft v\u00e0 c\u1eadp nh\u1eadt CSDL, to\u00e0n b\u1ed9 b\u1ea3ng s\u1ebd b\u1ecb kh\u00f3a (locked) cho \u0111\u1ebfn khi qu\u00e1 tr\u00ecnh x\u1eed l\u00fd ho\u00e0n t\u1ea5t. \u0110i\u1ec1u n\u00e0y s\u1ebd ng\u0103n b\u1ea5t k\u1ef3 ho\u1ea1t \u0111\u1ed9ng \u0111\u1ecdc\/ghi n\u00e0o \u0111\u01b0\u1ee3c ph\u00e9p b\u1eaft \u0111\u1ea7u trong b\u1ea3ng cho \u0111\u1ebfn khi m\u1ed9t qu\u00e1 tr\u00ecnh x\u1eed l\u00fd c\u1ee5 th\u1ec3 \u0111\u01b0\u1ee3c ho\u00e0n t\u1ea5t. InnoDB ch\u1ec9 kh\u00f3a m\u1ed9t h\u00e0ng c\u1ea7n \u0111\u1ec3 ghi, ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a b\u1ea3ng \u0111\u01b0\u1ee3c t\u1ef1 do cho c\u00e1c ho\u1ea1t \u0111\u1ed9ng \u0111\u1ed3ng th\u1eddi kh\u00e1c.<\/p>\n\n\n\n<p>S\u1ef1 kh\u00e1c bi\u1ec7t quan tr\u1ecdng kh\u00e1c l\u00e0 c\u00e1ch c\u00e1c storage engines t\u01b0\u01a1ng t\u00e1c v\u1edbi b\u1ed9 nh\u1edb trong m\u00e1y ch\u1ee7 (server). C\u00f3 m\u1ed9t pool b\u1ed9 nh\u1edb c\u1ee5 th\u1ec3 \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/innodb-buffer-pool.html\" target=\"_blank\" rel=\"noreferrer noopener\">InnoDB Buffer Pool<\/a> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng b\u1edfi c\u00e1c b\u1ea3ng InnoDB. C\u00e1c b\u1ea3ng d\u00f9ng MyISAM kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng pool b\u1ed9 nh\u1edb n\u00e0y, \u0111i\u1ec1u \u0111\u00f3 c\u00f3 ngh\u0129a l\u00e0 h\u1ecd ghi v\u00e0o \u0111\u0129a (disk) thay v\u00ec s\u1eed d\u1ee5ng b\u1ed9 nh\u1edb CSDL.<\/p>\n\n\n\n<p>\u0110\u1ec3 ki\u1ec3m tra storage engine b\u1ea1n \u0111ang d\u00f9ng:<\/p>\n\n\n\n<ol>\n<li>\u0110\u0103ng nh\u1eadp.<\/li>\n\n\n\n<li>Click v\u00e0o <strong>phpMyAdmin<\/strong>.<\/li>\n\n\n\n<li>Ch\u1ecdn CSDL (<strong>wp_environmentname<\/strong>).<\/li>\n\n\n\n<li>Nh\u00ecn v\u00e0o c\u1ed9t &#8220;<strong>Type<\/strong>&#8220;.<\/li>\n<\/ol>\n\n\n\n<p>B\u1ea1n c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp c\u1ed9t n\u00e0y b\u1eb1ng c\u00e1ch click v\u00e0o t\u00ean<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/ten-storage_engines.png\" alt=\"t\u00ean storage engine\" class=\"wp-image-14376\"\/><\/figure><\/div>\n\n\n<p>M\u1ed9t khi b\u1ea1n ph\u00e1t hi\u1ec7n m\u1ed9t b\u1ea3ng n\u00e0o \u0111\u1ea5y \u0111ang s\u1eed d\u1ee5ng MyISAM, h\u00e3y chuy\u1ec3n n\u00f3 sang ki\u1ec3u b\u1ea3ng InnoDB. Thay th\u1ebf <strong>table_name<\/strong> b\u1eb1ng t\u00ean b\u1ea3ng t\u01b0\u01a1ng \u1ee9ng.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ALTER TABLE&nbsp;<b>table_name<\/b>&nbsp;ENGINE=InnoDB;<\/pre>\n\n\n\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng bi\u1ebft c\u00e1ch l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u1ea1y truy v\u1ea5n, h\u00e3y tham kh\u1ea3o c\u00e1c h\u01b0\u1edbng d\u1eabn tr\u00ean m\u1ea1ng.<\/p>\n\n\n\n<p><strong>L\u01b0u \u00fd<\/strong>: B\u1ea1n c\u1ea7n backup CSDL tr\u01b0\u1edbc khi th\u1ef1c hi\u1ec7n thay \u0111\u1ed5i. (Plugin gi\u00fap b\u1ea1n l\u00e0m \u0111i\u1ec1u n\u00e0y d\u1ec5 d\u00e0ng l\u00e0 <a href=\"https:\/\/kiencang.net\/plugin-updraftplus\/\" target=\"_blank\" rel=\"noreferrer noopener\">UpdraftPlus<\/a>. Kh\u00f4ng ch\u1ec9 database, n\u00f3 c\u00f2n c\u00f3 kh\u1ea3 n\u0103ng backup t\u1ea5t c\u1ea3 c\u00e1c th\u00e0nh ph\u1ea7n kh\u00e1c c\u1ee7a website &#8211; \u0111\u00e2y l\u00e0 m\u1ed9t trong c\u00e1c plugin t\u1ed1t nh\u1ea5t v\u1ec1 m\u1ea3ng backup v\u00e0 restore, vui h\u01a1n n\u1eefa l\u00e0 c\u00e1c t\u00ednh n\u0103ng c\u01a1 b\u1ea3n c\u1ee7a n\u00f3 th\u00ec mi\u1ec5n ph\u00ed)<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Don_dep_CSDL\"><\/span>D\u1ecdn d\u1eb9p CSDL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0110i\u1ec1u quan tr\u1ecdng v\u00e0 c\u00f3 \u00edch cho hi\u1ec7u su\u1ea5t CSDL c\u1ee7a b\u1ea1n l\u00e0 lo\u1ea1i b\u1ecf c\u00e1c d\u1eef li\u1ec7u d\u01b0 th\u1eeba c\u0169ng nh\u01b0 gi\u1ea3m nguy c\u01a1 ph\u00ecnh to CSDL qua th\u1eddi gian (theo th\u1eddi gian, b\u1ea1n c\u00f3 nhi\u1ec1u n\u1ed9i dung h\u01a1n, th\u1eed nghi\u1ec7m v\u00f4 s\u1ed1 plugin, giao di\u1ec7n, v\u00e0 v\u00ec v\u1eady CSDL c\u00f3 khuynh h\u01b0\u1edbng ng\u00e0y c\u00e0ng l\u1edbn h\u01a1n).<\/p>\n\n\n\n<p>MySQL l\u00e0 h\u1ec7 th\u1ed1ng CSDL ki\u1ec3u quan h\u1ec7 (relational), c\u00f3 ngh\u0129a l\u00e0 d\u1eef li\u1ec7u trong m\u1ed9t b\u1ea3ng th\u01b0\u1eddng s\u1ebd c\u00f3 m\u1ed1i li\u00ean h\u1ec7 d\u1eef li\u1ec7u \u1edf trong b\u1ea3ng kh\u00e1c. Khi m\u1ed9t gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u, ch\u1eb3ng h\u1ea1n nh\u01b0 m\u1ed9t b\u00e0i \u0111\u0103ng, b\u1ecb lo\u1ea1i b\u1ecf kh\u1ecfi m\u1ed9t b\u1ea3ng, n\u00f3 c\u00f3 th\u1ec3 b\u1ecf l\u1ea1i d\u1eef li\u1ec7u kh\u00f4ng c\u00f2n \u00fd ngh\u0129a trong m\u1ed9t b\u1ea3ng kh\u00e1c (m\u00e0 n\u00f3 t\u1eebng c\u00f3 li\u00ean h\u1ec7 tr\u01b0\u1edbc \u0111\u00e2y).<\/p>\n\n\n\n<p><strong>C\u00e2u l\u1ec7nh d\u00f9ng \u0111\u1ec3 ki\u1ec3m tra xem b\u1ea3ng c\u1ee7a b\u1ea1n c\u00f3 b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u postmeta n\u00e0o v\u00f4 \u00edch hay kh\u00f4ng:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT COUNT(pm.meta_id) as row_count FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;<\/pre>\n\n\n\n<p><strong>Lo\u1ea1i b\u1ecf b\u1ea5t c\u1ee9 postmeta n\u00e0o v\u00f4 \u00edch:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL;<\/pre>\n\n\n\n<p><strong>Ki\u1ec3m tra xem trang c\u1ee7a b\u1ea1n c\u00f3 b\u1ea5t c\u1ee9 commentmata n\u00e0o v\u00f4 \u00edch hay kh\u00f4ng:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT COUNT(*) as row_count FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);<\/pre>\n\n\n\n<p><strong>Lo\u1ea1i b\u1ecf b\u1ea5t c\u1ee9 commentmeta n\u00e0o v\u00f4 \u00edch:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);<\/pre>\n\n\n\n<p>Ngo\u00e0i ra trang c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 <a href=\"https:\/\/kiencang.net\/revision-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">revision t\u1eeb c\u00e1c b\u00e0i \u0111\u0103ng<\/a>. <strong>X\u00f3a b\u1ecf b\u1ea5t c\u1ee9 revisions n\u00e0o b\u1eb1ng c\u00e2u l\u1ec7nh<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM wp_posts WHERE post_type = \"revision\";<\/pre>\n\n\n\n<p><strong>Ki\u1ec3m tra wp_session data:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT * FROM `wp_options` WHERE `option_name` LIKE '_wp_session_%'<\/pre>\n\n\n\n<p><strong>Lo\u1ea1i b\u1ecf wp_session data:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM `wp_options` WHERE `option_name` LIKE '_wp_session_%'<\/pre>\n\n\n\n<p><strong>Lo\u1ea1i b\u1ecf transients qu\u00e1 h\u1ea1n:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM `wp_options` WHERE `option_name` LIKE ('%_transient_%')<\/pre>\n\n\n\n<p><strong>Lo\u1ea1i b\u1ecf c\u00e1c tag kh\u00f4ng c\u00f3 m\u1ed1i li\u00ean h\u1ec7 v\u1edbi b\u1ea5t c\u1ee9 b\u00e0i post n\u00e0o:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM wp_terms WHERE term_id IN (SELECT term_id FROM wp_term_taxonomy WHERE count = 0 );\nDELETE FROM wp_term_taxonomy WHERE term_id not IN (SELECT term_id FROM wp_terms);\nDELETE FROM wp_term_relationships WHERE term_taxonomy_id not IN (SELECT term_taxonomy_id FROM wp_term_taxonomy);<\/pre>\n\n\n\n<p><strong>Lo\u1ea1i b\u1ecf c\u00e1c pingbacks v\u00e0 trackbacks:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM wp_comments WHERE comment_type = 'pingback';\nDELETE FROM wp_comments WHERE comment_type = 'trackback';<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cac_plugin_giup_don_dep_co_so_du_lieu\"><\/span>C\u00e1c plugin gi\u00fap d\u1ecdn d\u1eb9p c\u01a1 s\u1edf d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ho\u00e0n to\u00e0n d\u1ec5 hi\u1ec3u th\u00f4i, vi\u1ec7c th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 l\u01b0\u1ee3ng l\u1edbn truy v\u1ea5n c\u00f3 th\u1ec3 \u0111\u00e1ng s\u1ee3, nh\u1ea5t l\u00e0 khi tr\u01b0\u1edbc \u0111\u00f3 b\u1ea1n ch\u01b0a t\u1eebng thao t\u00e1c v\u1edbi CSDL. C\u00f3 m\u1ed9t s\u1ed1 plugin c\u00f3 th\u1ec3 h\u1ed7 tr\u1ee3 b\u1ea1n, tuy nhi\u00ean c\u00e1c plugin c\u00f3 th\u1ec3 x\u00f3a d\u1eef li\u1ec7u k\u00e9m c\u1ea9n tr\u1ecdng h\u01a1n so v\u1edbi khi ch\u1ea1y t\u1eebng truy v\u1ea5n SQL. H\u00e3y th\u1ef1c hi\u1ec7n backup tr\u01b0\u1edbc khi ti\u1ebfp t\u1ee5c. Ch\u00fang t\u00f4i c\u0169ng khuy\u1ebfn c\u00e1o b\u1ea1n ki\u1ec3m tra b\u1ea5t c\u1ee9 thay \u0111\u1ed5i n\u00e0o trong m\u00f4i tr\u01b0\u1eddng staging (*) tr\u01b0\u1edbc khi l\u00e0m \u0111i\u1ec1u n\u00e0y \u1edf phi\u00ean b\u1ea3n website ch\u00ednh th\u1ee9c.<\/p>\n\n\n\n<p>(*): staging l\u00e0 m\u00f4i tr\u01b0\u1eddng demo cho website c\u1ee7a b\u1ea1n, n\u00f3 gi\u00fap b\u1ea1n ki\u1ec3m tra k\u1ef9 l\u01b0\u1ee1ng c\u00e1c thay \u0111\u1ed5i th\u1eed nghi\u1ec7m, v\u00e0 khi m\u1ecdi th\u1ee9 \u1ed5n th\u1ecfa, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ea9y n\u00f3 l\u00ean website ch\u00ednh th\u1ee9c m\u00e0 hi\u1ebfm khi ph\u1ea3i g\u1eb7p r\u1ee7i ro.<\/p>\n\n\n\n<p>M\u1ed9t s\u1ed1 plugin h\u1ed7 tr\u1ee3 b\u1ea1n l\u00e0:<\/p>\n\n\n\n<ul>\n<li>WP Rocket.<\/li>\n\n\n\n<li><a href=\"https:\/\/kiencang.net\/plugin-wp-optimize\/\" target=\"_blank\" rel=\"noreferrer noopener\">WP Optimize<\/a>.<\/li>\n\n\n\n<li>WP Sweep.<\/li>\n\n\n\n<li><a href=\"https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/\" target=\"_blank\" rel=\"noreferrer noopener\">Advanced Database Cleaner<\/a>.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cac_du_lieu_duoc_tai_tu_dong_autoloaded\"><\/span>C\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c t\u1ea3i t\u1ef1 \u0111\u1ed9ng (autoloaded)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>M\u1ed9t s\u1ed1 th\u00f4ng tin trong CSDL ph\u1ea3i \u0111\u01b0\u1ee3c t\u1ea3i trong m\u1ed7i y\u00eau c\u1ea7u, ch\u1eb3ng h\u1ea1n nh\u01b0 URL c\u1ee7a trang, giao di\u1ec7n v\u00e0 plugin n\u00e0o \u0111ang \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t. Trong WordPress, \u0111i\u1ec1u n\u00e0y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 d\u1eef li\u1ec7u t\u1ea3i t\u1ef1 \u0111\u1ed9ng v\u00e0 n\u00f3 \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong b\u1ea3ng wp_options (c\u00e1c t\u00f9y ch\u1ecdn c\u1ee7a WP).<\/p>\n\n\n\n<p>Trong khi d\u1eef li\u1ec7u t\u1ea3i t\u1ef1 \u0111\u1ed9ng h\u1eefu \u00edch trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, n\u00f3 c\u0169ng th\u01b0\u1eddng ch\u1ee9a nhi\u1ec1u th\u00f4ng tin kh\u00f4ng c\u1ea7n thi\u1ebft. M\u1ed9t l\u1eddi khuy\u00ean l\u00e0 b\u1ea1n n\u00ean <strong>gi\u1eef t\u1ed5ng l\u01b0\u1ee3ng d\u1eef li\u1ec7u t\u1ea3i t\u1ef1 \u0111\u1ed9ng d\u01b0\u1edbi 800 ng\u00e0n byte (kho\u1ea3ng 0,8Mb) <\/strong>\u0111\u1ec3 t\u1ed1i \u01b0u hi\u1ec7u su\u1ea5t.<\/p>\n\n\n\n<p>V\u1edbi t\u1eebng h\u00e0ng trong b\u1ea3ng t\u00f9y ch\u1ecdn, c\u00f3 m\u1ed9t gi\u00e1 tr\u1ecb t\u01b0\u01a1ng \u1ee9ng trong c\u1ed9t &#8220;autoload&#8221; c\u00f3 th\u1ec3 l\u00e0 <strong>yes<\/strong>\/c\u00f3 ho\u1eb7c <strong>no<\/strong>\/kh\u00f4ng. V\u00f4 hi\u1ec7u h\u00f3a t\u1ef1 \u0111\u1ed9ng t\u1ea3i cho m\u1ed9t h\u00e0ng \u0111\u01a1n gi\u1ea3n c\u00f3 ngh\u0129a l\u00e0 thi\u1ebft l\u1eadp gi\u00e1 tr\u1ecb trong c\u1ed9t n\u00e0y l\u00e0 <strong>no<\/strong>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/vi-du-autoload.png\" alt=\"v\u00ed d\u1ee5 v\u1ec1 autoload\" class=\"wp-image-14378\"\/><\/figure><\/div>\n\n\n<p>V\u00f4 hi\u1ec7u h\u00f3a t\u1ef1 \u0111\u1ed9ng t\u1ea3i trong d\u1eef hi\u1ec7u h\u00e0ng <strong>kh\u00f4ng<\/strong> l\u00e0m lo\u1ea1i b\u1ecf n\u00f3 kh\u1ecfi CSDL c\u1ee7a b\u1ea1n, n\u00f3 ch\u1ec9 \u0111\u01a1n gi\u1ea3n c\u00f3 ngh\u0129a l\u00e0 th\u00f4ng tin \u1edf h\u00e0ng \u0111\u00f3 kh\u00f4ng c\u00f2n \u0111\u01b0\u1ee3c g\u1ecdi m\u1ed7i khi trang \u0111\u01b0\u1ee3c t\u1ea3i t\u1ef1 \u0111\u1ed9ng. Khi t\u1ef1 autoload \u0111\u01b0\u1ee3c \u0111\u1eb7t l\u00e0 <strong>no<\/strong>, d\u1eef li\u1ec7u \u1edf h\u00e0ng \u0111\u00f3 ch\u1ec9 \u0111\u01b0\u1ee3c k\u00e9o v\u00e0o trang khi c\u00f3 y\u00eau c\u1ea7u.<\/p>\n\n\n\n<p>Cu\u1ed1i c\u00f9ng, chuy\u1ec7n n\u00e0y l\u00e0 t\u00f9y thu\u1ed9c v\u00e0o b\u1ea1n ho\u1eb7c nh\u00e0 l\u1eadp tr\u00ecnh quy\u1ebft \u0111\u1ecbnh l\u00e0 th\u00f4ng tin n\u00e0o trong website c\u1ea7n \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng t\u1ea3i v\u00e0 c\u00e1i n\u00e0o c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c v\u00f4 hi\u1ec7u h\u00f3a m\u00e0 kh\u00f4ng l\u00e0m h\u1ecfng ch\u1ee9c n\u0103ng c\u1ee7a trang. B\u00ean d\u01b0\u1edbi ch\u00fang t\u00f4i chia s\u1ebb m\u1ed9t s\u1ed1 truy v\u1ea5n h\u1eefu \u00edch \u0111\u1ec3 \u0111i\u1ec1u khi\u1ec3n d\u1eef li\u1ec7u t\u1ea3i t\u1ef1 \u0111\u1ed9ng.<\/p>\n\n\n\n<p>T\u00ednh to\u00e1n t\u1ed5ng l\u01b0\u1ee3ng d\u1eef li\u1ec7u t\u1ea3i t\u1ef1 \u0111\u1ed9ng theo bytes:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT SUM(LENGTH(option_value)) FROM wp_options WHERE autoload = 'yes';<\/pre>\n\n\n\n<p>T\u00ecm v\u00e0 s\u1eafp x\u1ebfp 20 h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb t\u1ea3i t\u1ef1 \u0111\u1ed9ng l\u1edbn nh\u1ea5t:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT LENGTH(option_value),option_name FROM wp_options WHERE autoload='yes' ORDER BY length(option_value) DESC LIMIT 20;<\/pre>\n\n\n\n<p>V\u00f4 hi\u1ec7u h\u00f3a t\u1ea3i t\u1ef1 \u0111\u1ed9ng cho m\u1ed9t t\u00f9y ch\u1ecdn c\u1ee5 th\u1ec3. Thay option_name b\u1eb1ng t\u00ean t\u00f9y ch\u1ecdn th\u1ef1c s\u1ef1 m\u00e0 b\u1ea1n t\u00ecm ra khi s\u1eed d\u1ee5ng \u1edf c\u00e2u l\u1ec7nh tr\u01b0\u1edbc:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">UPDATE wp_options SET autoload='no' WHERE option_name='<b>option_name<\/b>';\n<strong>EX<\/strong>:&nbsp;UPDATE wp_options SET autoload='no' WHERE option_name='<b>really_large_row<\/b>';<\/pre>\n\n\n\n<p>Sau khi b\u1ea1n gi\u1ea3m t\u1ed5ng l\u01b0\u1ee3ng d\u1eef li\u1ec7u t\u1ea3i t\u1ef1 \u0111\u1ed9ng xu\u1ed1ng d\u01b0\u1edbi 800K byte, c\u1ea7n \u0111\u1ea3m b\u1ea3o b\u1ea3ng t\u00f9y ch\u1ecdn \u0111\u01b0\u1ee3c l\u1eadp ch\u1ec9 m\u1ee5c (indexed). \u0110i\u1ec1u n\u00e0y gi\u00fap trang web c\u1ee7a b\u1ea1n ph\u1ee5c v\u1ee5 d\u1eef li\u1ec7u t\u1ea3i t\u1ef1 \u0111\u1ed9ng m\u1edbi \u0111\u00e3 \u0111\u01b0\u1ee3c d\u1ecdn d\u1eb9p nhanh h\u01a1n.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE INDEX autoloadindex ON wp_options(autoload, option_name);<\/pre>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Object_cache\"><\/span>Object cache<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Object cache l\u01b0u tr\u1eef c\u00e1c k\u1ebft qu\u1ea3 \u0111\u1ec3 truy v\u1ea5n \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n nhanh h\u01a1n \u1edf c\u00e1c l\u1ea7n truy c\u1eadp sau. N\u00f3 c\u00f3 th\u1ec3 c\u00f3 b\u1ed9 \u0111\u1ec7m l\u00ean t\u1edbi 1MB v\u00e0 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn t\u1ea5t c\u1ea3 c\u00e1c trang tr\u00ean website c\u1ee7a b\u1ea1n, th\u1eadm ch\u00ed l\u00e0 c\u1ea3 nh\u1eefng trang th\u00f4ng th\u01b0\u1eddng kh\u00f4ng ph\u1ea3i l\u01b0u b\u1ed9 nh\u1edb \u0111\u1ec7m cache ch\u1eb3ng h\u1ea1n nh\u01b0 wp-admin.<\/p>\n\n\n\n<p>C\u00e1c truy v\u1ea5n cache \u0111\u01b0\u1ee3c g\u00f3i v\u00e0o trong c\u00e1c h\u00e0m <a href=\"https:\/\/codex.wordpress.org\/Class_Reference\/WP_Object_Cache\" target=\"_blank\" rel=\"noreferrer noopener\">wp_cache()<\/a> \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1edfi WordPress \u0111\u1ec3 l\u01b0u tr\u1eef, c\u0169ng nh\u01b0 trong c\u00e1c <a href=\"https:\/\/codex.wordpress.org\/Transients_API\" target=\"_blank\" rel=\"noreferrer noopener\">transients<\/a>.<\/p>\n\n\n\n<p>Object cache \u0111\u01b0\u1ee3c v\u00f4 hi\u1ec7u h\u00f3a theo m\u1eb7c \u0111\u1ecbnh, b\u1eadt t\u00ednh n\u0103ng n\u00e0y l\u00ean th\u01b0\u1eddng \u0111\u01b0\u1ee3c khuy\u1ebfn ngh\u1ecb \u0111\u1ec3 c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t.<\/p>\n\n\n\n<p>\u0110\u1ec3 b\u1eadt Object Cache:<\/p>\n\n\n\n<ol>\n<li>\u0110\u0103ng nh\u1eadp.<\/li>\n\n\n\n<li>Click v\u00e0o <strong>Utilities<\/strong>.<\/li>\n\n\n\n<li>Ch\u1ecdn t\u00f9y ch\u1ecdn \u0111\u1ec3 <strong>b\u1eadt<\/strong> Object Cache.<\/li>\n\n\n\n<li><strong>Save<\/strong>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/bat-object-cache.jpg\" alt=\"b\u1eadt Object cache\" class=\"wp-image-14380\"\/><\/figure><\/div>\n\n\n<p><strong>L\u01b0u \u00fd<\/strong>: N\u1ebfu b\u1ea1n c\u00f3 d\u1eef li\u1ec7u t\u1ea3i t\u1ef1 \u0111\u1ed9ng v\u01b0\u1ee3t qu\u00e1 800 ng\u00e0n byte, object cache c\u1ea7n ph\u1ea3i v\u00f4 hi\u1ec7u h\u00f3a. Object cache c\u00f3 b\u1ed9 \u0111\u1ec7m 1MB v\u00e0 d\u1eef li\u1ec7u t\u1ea3i t\u1ef1 \u0111\u1ed9ng l\u1edbn s\u1ebd nhanh ch\u00f3ng v\u01b0\u1ee3t qu\u00e1 gi\u1edbi h\u1ea1n n\u00e0y l\u00e0m xu\u1ea5t hi\u1ec7n l\u1ed7i 502 ngay l\u1eadp t\u1ee9c ho\u1eb7c ng\u1eabu nhi\u00ean.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Cac_giai_phap_cho_tim_kiem\"><\/span>C\u00e1c gi\u1ea3i ph\u00e1p cho t\u00ecm ki\u1ebfm<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>N\u1ebfu trang c\u1ee7a b\u1ea1n c\u00f3 v\u00e0i ng\u00e0n b\u00e0i \u0111\u0103ng, b\u1ea1n c\u00f3 kh\u1ea3 n\u0103ng s\u1ebd nh\u1eadn ra ch\u1ee9c n\u0103ng t\u00ecm ki\u1ebfm c\u00f3 t\u1ed1c \u0111\u1ed9 ch\u1eadm. \u0110i\u1ec1u n\u00e0y l\u00e0 v\u00ec s\u1ed1 l\u01b0\u1ee3ng c\u00e1c m\u1ee5c t\u00ecm ki\u1ebfm v\u00e0 b\u1ea3n th\u00e2n truy v\u1ea5n t\u00ecm ki\u1ebfm kh\u00f4ng m\u1edf r\u1ed9ng ra s\u1ed1 l\u01b0\u1ee3ng l\u1edbn n\u1ed9i dung.<\/p>\n\n\n\n<p>Sau khi trang c\u1ee7a b\u1ea1n ch\u1ea1m \u0111\u1ebfn gi\u1edbi h\u1ea1n v\u00e0i ng\u00e0n b\u00e0i vi\u1ebft, t\u1ed1t nh\u1ea5t h\u00e3y s\u1eed d\u1ee5ng gi\u1ea3i ph\u00e1p t\u00ecm ki\u1ebfm d\u1ea1ng \u1ee9ng d\u1ee5ng c\u1ee7a b\u00ean th\u1ee9 ba (off-site). Ch\u00fang t\u00f4i khuy\u1ebfn ngh\u1ecb:<\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/www.elasticpress.io\/\" target=\"_blank\" rel=\"noreferrer noopener\">ElasticPress<\/a>.<\/li>\n\n\n\n<li><a href=\"https:\/\/www.algolia.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Algolia<\/a> (xem <a href=\"https:\/\/kiencang.net\/cong-cu-tim-kiem-algolia-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">h\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Algolia \u1edf \u0111\u00e2y<\/a>).<\/li>\n<\/ul>\n\n\n\n<p>\u0110i\u1ec1u n\u00e0y gi\u00fap gi\u1ea3m t\u1ea3i cho vi\u1ec7c ph\u1ea3i s\u1eed d\u1ee5ng qu\u00e1 nhi\u1ec1u t\u00e0i nguy\u00ean m\u00e1y ch\u1ee7 c\u1ee7a b\u1ea1n \u0111\u1ec3 t\u00ecm ki\u1ebfm, c\u0169ng nh\u01b0 chuy\u1ec3n vi\u1ec7c t\u00ecm ki\u1ebfm \u0111\u1ebfn h\u1ec7 th\u1ed1ng ri\u00eang \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ed1i \u01b0u h\u00f3a \u0111\u1ec3 x\u1eed l\u00fd n\u00f3 v\u00e0 cho k\u1ebft qu\u1ea3 t\u1ed1t h\u01a1n, nhanh h\u01a1n. Nh\u1edd vi\u1ec7c gi\u1ea3m t\u1ea3i, m\u00e1y ch\u1ee7 c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u t\u00e0i nguy\u00ean h\u01a1n \u0111\u1ec3 x\u1eed l\u00fd nhi\u1ec1u l\u01b0u l\u01b0\u1ee3ng truy c\u1eadp \u0111\u1ed3ng th\u1eddi h\u01a1n v\u00e0 l\u00e0m cho website c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng d\u1ec5 d\u00e0ng.<\/p>\n\n\n\n<p>Cu\u1ed1i c\u00f9ng n\u1ebfu b\u1ea1n \u0111\u00e3 th\u1eed c\u00e1c bi\u1ec7n ph\u00e1p t\u1ed1i \u01b0u h\u00f3a \u1edf tr\u00ean (v\u00e0 c\u00e1c gi\u1ea3i ph\u00e1p kh\u00e1c) nh\u01b0ng website v\u1eabn g\u1eb7p v\u1ea5n \u0111\u1ec1 v\u1ec1 hi\u1ec7u su\u1ea5t v\u00e0 t\u1ed1c \u0111\u1ed9, th\u1ebf th\u00ec c\u00f3 th\u1ec3 \u0111\u00e3 \u0111\u1ebfn th\u1eddi \u0111i\u1ec3m b\u1ea1n n\u00ean n\u00e2ng c\u1ea5p l\u00ean g\u00f3i host l\u01b0u tr\u1eef c\u00f3 nhi\u1ec1u t\u00e0i nguy\u00ean h\u01a1n. Tham kh\u1ea3o b\u00e0i vi\u1ebft <a href=\"https:\/\/kiencang.net\/mua-hosting-cho-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">n\u00ean mua hosting \u1edf \u0111\u00e2u<\/a> \u0111\u1ec3 bi\u1ebft th\u00eam chi ti\u1ebft.<\/p>\n\n\n\n<p><em>(D\u1ecbch t\u1eeb b\u00e0i vi\u1ebft <a href=\"https:\/\/wpengine.com\/support\/database-optimization-best-practices\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">How to optimize a database on WordPress, website: WP Engine<\/a>, ng\u01b0\u1eddi d\u1ecbch: Nguy\u1ec5n \u0110\u1ee9c Anh)<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u01a1 s\u1edf d\u1eef li\u1ec7u (CSDL) trong website WordPress n\u1eafm gi\u1eef c\u00e1c th\u00f4ng tin ki\u1ec3u nh\u01b0 n\u1ed9i dung b\u00e0i post, ng\u01b0\u1eddi d\u00f9ng, \u0111\u01a1n \u0111\u1eb7t h\u00e0ng, v\u00e0 c\u00e1c c\u00e0i \u0111\u1eb7t (setting) c\u1ee7a giao di\u1ec7n c\u0169ng nh\u01b0 plugin. Trong khi c\u00e1c m\u00e3 PHP cho trang web bi\u1ebft c\u00e1ch th\u1ef1c hi\u1ec7n c\u00e1c h\u00e0m v\u00e0 CSS cho c\u00e1c \u0111o\u1ea1n m\u00e3 &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[263],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00e1ch t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u (database) trong WordPress &#8226; Ki\u1ebfn c\u00e0ng<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1ch t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u (database) trong WordPress &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"C\u01a1 s\u1edf d\u1eef li\u1ec7u (CSDL) trong website WordPress n\u1eafm gi\u1eef c\u00e1c th\u00f4ng tin ki\u1ec3u nh\u01b0 n\u1ed9i dung b\u00e0i post, ng\u01b0\u1eddi d\u00f9ng, \u0111\u01a1n \u0111\u1eb7t h\u00e0ng, v\u00e0 c\u00e1c c\u00e0i \u0111\u1eb7t (setting) c\u1ee7a giao di\u1ec7n c\u0169ng nh\u01b0 plugin. Trong khi c\u00e1c m\u00e3 PHP cho trang web bi\u1ebft c\u00e1ch th\u1ef1c hi\u1ec7n c\u00e1c h\u00e0m v\u00e0 CSS cho c\u00e1c \u0111o\u1ea1n m\u00e3 &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/toi-uu-database-wordpress\/\" \/>\n<meta property=\"og:site_name\" content=\"Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anhducnguyen87\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-02-09T12:32:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-23T20:37:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/toi-uu-hoa-bang.png\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00e1ch t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u (database) trong WordPress &#8226; Ki\u1ebfn c\u00e0ng","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kiencang.net\/toi-uu-database-wordpress\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1ch t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u (database) trong WordPress &#8226; Ki\u1ebfn c\u00e0ng","og_description":"C\u01a1 s\u1edf d\u1eef li\u1ec7u (CSDL) trong website WordPress n\u1eafm gi\u1eef c\u00e1c th\u00f4ng tin ki\u1ec3u nh\u01b0 n\u1ed9i dung b\u00e0i post, ng\u01b0\u1eddi d\u00f9ng, \u0111\u01a1n \u0111\u1eb7t h\u00e0ng, v\u00e0 c\u00e1c c\u00e0i \u0111\u1eb7t (setting) c\u1ee7a giao di\u1ec7n c\u0169ng nh\u01b0 plugin. Trong khi c\u00e1c m\u00e3 PHP cho trang web bi\u1ebft c\u00e1ch th\u1ef1c hi\u1ec7n c\u00e1c h\u00e0m v\u00e0 CSS cho c\u00e1c \u0111o\u1ea1n m\u00e3 &hellip;","og_url":"https:\/\/kiencang.net\/toi-uu-database-wordpress\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2020-02-09T12:32:48+00:00","article_modified_time":"2023-07-23T20:37:37+00:00","og_image":[{"url":"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/toi-uu-hoa-bang.png"}],"author":"Nguy\u1ec5n \u0110\u1ee9c Anh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n \u0110\u1ee9c Anh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"11 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/toi-uu-database-wordpress\/","url":"https:\/\/kiencang.net\/toi-uu-database-wordpress\/","name":"C\u00e1ch t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u (database) trong WordPress &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2020-02-09T12:32:48+00:00","dateModified":"2023-07-23T20:37:37+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/toi-uu-database-wordpress\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/toi-uu-database-wordpress\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/toi-uu-database-wordpress\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"C\u00e1ch t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u (database) trong WordPress"}]},{"@type":"WebSite","@id":"https:\/\/kiencang.net\/#website","url":"https:\/\/kiencang.net\/","name":"Ki\u1ebfn c\u00e0ng","description":"\u00d4m l\u00fd thuy\u1ebft, h\u00f4n th\u1ef1c h\u00e0nh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kiencang.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16","name":"Nguy\u1ec5n \u0110\u1ee9c Anh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/kiencang.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","caption":"Nguy\u1ec5n \u0110\u1ee9c Anh"},"description":"Sinh n\u0103m 1987, t\u1ed1t nghi\u1ec7p Cao \u0111\u1eb3ng th\u1ef1c h\u00e0nh FPT qu\u00e3ng 2014, chuy\u00ean ng\u00e0nh Thi\u1ebft k\u1ebf website. T\u00f4i th\u00edch Content, SEO, Ads, T\u0103ng t\u1ed1c website v\u00e0 Th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed. B\u00ean c\u1ea1nh b\u00e0i t\u1ef1 vi\u1ebft, t\u00f4i c\u0169ng d\u1ecbch nhi\u1ec1u n\u1ed9i dung th\u00fa v\u1ecb c\u1ee7a c\u00e1c t\u00e1c gi\u1ea3 kh\u00e1c nhau. FB c\u00e1 nh\u00e2n: facebook.com\/anhducnguyen87. Email li\u00ean h\u1ec7: guiemailchotoi@gmail.com","sameAs":["https:\/\/www.facebook.com\/anhducnguyen87\/"],"url":"https:\/\/kiencang.net\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/14374"}],"collection":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/comments?post=14374"}],"version-history":[{"count":1,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/14374\/revisions"}],"predecessor-version":[{"id":24376,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/14374\/revisions\/24376"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=14374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=14374"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=14374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}