{"id":14351,"date":"2020-02-07T12:02:33","date_gmt":"2020-02-07T12:02:33","guid":{"rendered":"https:\/\/kiencang.net\/?p=14351"},"modified":"2020-02-07T12:02:33","modified_gmt":"2020-02-07T12:02:33","slug":"plugin-advanced-database-cleaner","status":"publish","type":"post","link":"https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/","title":{"rendered":"Gi\u1edbi thi\u1ec7u plugin Advanced Database Cleaner gi\u00fap t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress"},"content":{"rendered":"\n<p><a href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/\" target=\"_blank\" rel=\"noreferrer noopener\">L\u00e0m s\u1ea1ch database (C\u01a1 s\u1edf d\u1eef li\u1ec7u \/ CSDL) b\u1eb1ng c\u00e1ch lo\u1ea1i b\u1ecf c\u00e1c th\u00e0nh ph\u1ea7n kh\u00f4ng h\u1eefu \u00edch<\/a> (*) nh\u01b0 &#8220;c\u00e1c phi\u00ean b\u1ea3n c\u0169 c\u1ee7a b\u00e0i vi\u1ebft \/ old revisions (**)&#8221;, &#8220;<a href=\"https:\/\/kiencang.net\/comment-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">c\u00e1c b\u00ecnh lu\u1eadt spam<\/a>&#8220;, th\u1ef1c hi\u1ec7n t\u1ed1i \u01b0u h\u00f3a CSDL (c\u01a1 s\u1edf d\u1eef li\u1ec7u), v\u00e2n v\u00e2n.<\/p>\n\n\n<p>(*): T\u1eeb g\u1ed1c ti\u1ebfng Anh l\u00e0 orphaned &#8211; ngh\u0129a \u0111en l\u00e0 tr\u1ebb m\u1ed3 c\u00f4i, \u1edf \u0111\u00e2y n\u00f3 \u00e1m ch\u1ec9 r\u1eb1ng c\u00f3 m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u kh\u00f4ng c\u00f2n c\u00f3 m\u1ed1i li\u00ean quan n\u00e0o \u0111\u1ebfn c\u00e1c d\u1eef li\u1ec7u kh\u00e1c, v\u00ec v\u1eady tr\u1edf n\u00ean v\u00f4 \u00edch. V\u00ed d\u1ee5 m\u1ed9t plugin b\u1ea1n kh\u00f4ng d\u00f9ng n\u1eefa- \u0111\u00e3 xo\u00e1 kh\u1ecfi website, nh\u01b0ng database c\u1ee7a n\u00f3 v\u1eabn c\u00f2n, \u0111\u00f3 l\u00e0 orphaned, v\u00ec n\u00f3 kh\u00f4ng c\u00f2n m\u1ed1i li\u00ean h\u1ec7 v\u1edbi c\u00e1c database c\u00f2n l\u1ea1i.<\/p>\n\n\n<p>(**): C\u00e1c phi\u00ean b\u1ea3n c\u0169 c\u1ee7a b\u00e0i vi\u1ebft kh\u00f4ng h\u1eb3n l\u00e0 t\u00ednh n\u0103ng v\u00f4 d\u1ee5ng, n\u00f3 <a href=\"https:\/\/kiencang.net\/revision-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">gi\u00fap b\u1ea1n kh\u00f4i ph\u1ee5c l\u1ea1i b\u00e0i vi\u1ebft n\u00e0o \u0111\u1ea5y n\u1ebfu l\u1ee1 tay theo t\u00e1c nh\u1ea7m<\/a> (ch\u1eb3ng h\u1ea1n b\u1ea1n x\u00f3a nh\u1ea7m m\u1ed9t \u0111o\u1ea1n). N\u00f3 gi\u1ed1ng nh\u01b0 m\u1ed9t d\u1ea1ng backup n\u1ed9i b\u1ed9 c\u1ee7a b\u00e0i vi\u1ebft v\u1eady. Tuy nhi\u00ean khi s\u1ed1 l\u01b0\u1ee3ng c\u00e1c phi\u00ean b\u1ea3n c\u0169 qu\u00e1 nhi\u1ec1u, n\u00f3 tr\u1edf th\u00e0nh ngu\u1ed3n t\u00e0i nguy\u00ean chi\u1ebfm ch\u1ed7 g\u1ea7n nh\u01b0 v\u00f4 \u00edch, v\u00ec trong \u0111a s\u1ed1 tr\u01b0\u1eddng h\u1ee3p s\u1ebd kh\u00f4ng c\u1ea7n thi\u1ebft. \u0110\u1ec3 t\u1ed1i \u01b0u ch\u00fang ta s\u1ebd <em>c\u00e2n b\u1eb1ng s\u1ed1 l\u01b0\u1ee3ng phi\u00ean b\u1ea3n c\u0169, c\u0169ng nh\u01b0 th\u1eddi gian l\u01b0u<\/em>.<\/p>\n\n\n<p>&#8212;<\/p>\n\n\n<p>N\u1ebfu b\u1ea1n \u0111\u00e3 <a href=\"https:\/\/kiencang.net\/huong-dan-su-dung-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">s\u1eed d\u1ee5ng WordPress<\/a> m\u1ed9t th\u1eddi gian d\u00e0i th\u00ec b\u1ea1n ch\u1eafc ch\u1eafn c\u1ea7n suy ngh\u0129 v\u1ec1 chuy\u1ec7n l\u00e0m s\u1ea1ch CSDL. Th\u1eadt v\u1eady, CSDL c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 ch\u1ee9a \u0111\u1ea7y r\u00e1c l\u00e0m cho website c\u1ed3ng k\u1ec1nh (bloated), ch\u1eadm ch\u1ea1p. R\u00e1c c\u00f3 th\u1ec3 l\u00e0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 c\u1ee7a b\u00e0i vi\u1ebft, c\u00e1c meta post v\u00f4 \u00edch, c\u00e1c b\u00ecnh lu\u1eadn spam, v\u00e2n v\u00e2n. B\u1ea1n c\u1ea7n ph\u1ea3i x\u00f3a s\u1ea1ch c\u00e1c d\u1eef li\u1ec7u kh\u00f4ng c\u1ea7n thi\u1ebft n\u00e0y \u0111\u1ec3 gi\u1ea3m k\u00edch c\u1ee1 CSDL v\u00e0 c\u1ea3i thi\u1ec7n t\u1ed1c \u0111\u1ed9 c\u0169ng nh\u01b0 hi\u1ec7u su\u1ea5t c\u1ee7a trang (P\/S: m\u1ed9t \u0111i\u1ec1u n\u1eefa m\u00e0 c\u00f3 th\u1ec3 m\u1ecdi ng\u01b0\u1eddi qu\u00ean, t\u1ed1i \u01b0u database, \u0111\u1eb7c bi\u1ec7t l\u00e0 tr\u00ean c\u00e1c trang l\u1edbn c\u00f2n l\u00e0 bi\u1ec7n ph\u00e1p gi\u00fap h\u1ea1n ch\u1ebf downtime (***), nh\u1edd th\u1ebf <a href=\"https:\/\/kiencang.net\/website-uptime\/\" target=\"_blank\" rel=\"noreferrer noopener\">duy tr\u00ec \u0111\u01b0\u1ee3c t\u00ednh li\u1ec1n m\u1ea1ch v\u00e0 \u1ed5n \u0111\u1ecbnh c\u1ee7a website<\/a>). Ngo\u00e0i ra, b\u1ea1n c\u00f2n \u0111\u01b0\u1ee3c h\u01b0\u1edfng l\u1ee3i \u00edch t\u1eeb vi\u1ec7c backup CSDL nhanh h\u01a1n v\u00ec <a href=\"https:\/\/kiencang.net\/plugin-updraftplus\/\" target=\"_blank\" rel=\"noreferrer noopener\">file backup c\u1ee7a b\u1ea1n<\/a> gi\u1edd \u0111\u00e3 nh\u1ecf g\u1ecdn h\u01a1n r\u1ed3i.<\/p>\n\n\n<p>(***): B\u1ea1n c\u00f3 th\u1ec3 <a href=\"https:\/\/kiencang.net\/theo-doi-up-time-website\/\" target=\"_blank\" rel=\"noreferrer noopener\">theo d\u00f5i uptime c\u1ee7a website th\u00f4ng c\u00e1c nhi\u1ec1u d\u1ecbch v\u1ee5 mi\u1ec5n ph\u00ed ch\u1ea5t l\u01b0\u1ee3ng<\/a>.<\/p>\n\n\n<p><a href=\"https:\/\/wordpress.org\/plugins\/advanced-database-cleaner\/\" target=\"_blank\" rel=\"noreferrer noopener\">Advanced Database Cleaner<\/a> l\u00e0 plugin m\u00e0 b\u1ea1n ph\u1ea3i c\u00f3, gi\u00fap b\u1ea1n d\u1ecdn d\u1eb9p CSDL, t\u1ed1i \u01b0u h\u00f3a n\u00f3 v\u00e0 nhi\u1ec1u b\u1ed5 sung h\u1eefu \u00edch kh\u00e1c n\u1eefa.<\/p>\n\n\n<hr class=\"wp-block-separator\"\/>\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-6577d65a473a1\" ><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-6577d65a473a1\"  type=\"checkbox\" id=\"item-6577d65a473a1\"><\/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\/plugin-advanced-database-cleaner\/#Cac_tinh_nang_chinh\" title=\"C\u00e1c t\u00ednh n\u0103ng ch\u00ednh\">C\u00e1c t\u00ednh n\u0103ng ch\u00ednh<\/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\/plugin-advanced-database-cleaner\/#Cac_tinh_nang_nang_caopro_cua_goi_tra_phi\" title=\"C\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao\/pro c\u1ee7a g\u00f3i tr\u1ea3 ph\u00ed\">C\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao\/pro c\u1ee7a g\u00f3i tr\u1ea3 ph\u00ed<\/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\/plugin-advanced-database-cleaner\/#Hoi_dap\" title=\"H\u1ecfi \u0111\u00e1p\">H\u1ecfi \u0111\u00e1p<\/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\/plugin-advanced-database-cleaner\/#Kinh_nghiem_su_dung_thuc_te\" title=\"Kinh nghi\u1ec7m s\u1eed d\u1ee5ng th\u1ef1c t\u1ebf\">Kinh nghi\u1ec7m s\u1eed d\u1ee5ng th\u1ef1c t\u1ebf<\/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\/plugin-advanced-database-cleaner\/#Ban_pro_cua_plugin_nay_co_dang_mua_khong\" title=\"B\u1ea3n pro c\u1ee7a plugin n\u00e0y c\u00f3 \u0111\u00e1ng mua kh\u00f4ng?\">B\u1ea3n pro c\u1ee7a plugin n\u00e0y c\u00f3 \u0111\u00e1ng mua kh\u00f4ng?<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"cac-tinh-nang-chinh\"><span class=\"ez-toc-section\" id=\"Cac_tinh_nang_chinh\"><\/span>C\u00e1c t\u00ednh n\u0103ng ch\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<ul><li>X\u00f3a c\u00e1c phi\u00ean b\u1ea3n c\u0169 c\u1ee7a b\u00e0i post v\u00e0 page;<\/li><li>X\u00f3a c\u00e1c phi\u00ean b\u1ea3n c\u0169 l\u01b0u nh\u00e1p t\u1ef1 \u0111\u1ed9ng (auto draft);<\/li><li>X\u00f3a c\u00e1c b\u00e0i post l\u01b0u trong th\u00f9ng r\u00e1c (trash);<\/li><li>X\u00f3a b\u00ecnh lu\u1eadn \u0111ang ch\u1edd x\u1eed l\u00fd (pending);<\/li><li>X\u00f3a b\u00ecnh lu\u1eadn spam;<\/li><li>X\u00f3a b\u00ecnh lu\u1eadn trong th\u00f9ng r\u00e1c;<\/li><li>X\u00f3a c\u00e1c pingback;<\/li><li>X\u00f3a c\u00e1c trackback;<\/li><li>X\u00f3a c\u00e1c post metadata v\u00f4 \u00edch;<\/li><li>X\u00f3a c\u00e1c b\u00ecnh lu\u1eadn metadata v\u00f4 \u00edch;<\/li><li>X\u00f3a user metadata v\u00f4 \u00edch;<\/li><li>X\u00f3a term metadata v\u00f4 \u00edch;<\/li><li>X\u00f3a c\u00e1c m\u1ed1i quan h\u1ec7 v\u00f4 \u00edch;<\/li><li>X\u00f3a c\u00e1c transients qu\u00e1 h\u1ea1n;<\/li><li>Hi\u1ec3n th\u1ecb c\u00e1c th\u00f4ng tin v\u1ec1 d\u1eef li\u1ec7u v\u00f4 \u00edch tr\u01b0\u1edbc khi d\u1ecdn d\u1eb9p CSDL, gi\u00fap b\u1ea1n \u0111\u1ea3m b\u1ea3o v\u1ec1 nh\u1eefng d\u1eef li\u1ec7u n\u00e0o b\u1ea1n mu\u1ed1n d\u1ecdn d\u1eb9p;<\/li><li>T\u00ecm ki\u1ebfm v\u00e0 l\u1ecdc t\u1ea5t c\u1ea3 c\u00e1c item d\u1ef1a tr\u00ean t\u00ean ho\u1eb7c gi\u00e1 tr\u1ecb c\u1ee7a ch\u00fang;<\/li><li>L\u01b0u tr\u1eef d\u1eef li\u1ec7u x ng\u00e0y kh\u00f4ng b\u1ecb x\u00f3a: ch\u1ec9 x\u00f3a d\u1eef li\u1ec7u n\u00e0o c\u0169 h\u01a1n so v\u1edbi s\u1ed1 ng\u00e0y c\u1ee5 th\u1ec3 m\u00e0 b\u1ea1n \u0111\u00e3 ch\u1ecdn;<\/li><li>L\u00ean l\u1ecbch (schedule) d\u1ecdn d\u1eb9p CSDL \u0111\u1ec3 n\u00f3 ch\u1ea1y t\u1ef1 \u0111\u1ed9ng;<\/li><li>L\u00ean l\u1ecbch nhi\u1ec1u t\u00e1c v\u1ee5 d\u1ecdn d\u1eb9p theo y\u00eau c\u1ea7u c\u1ee7a b\u1ea1n v\u00e0 c\u1ee5 th\u1ec3 h\u00f3a m\u1ee5c m\u00e0 b\u1ea1n mu\u1ed1n d\u1ecdn d\u1eb9p th\u00f4ng qua vi\u1ec7c l\u00ean l\u1ecbch;<\/li><li>T\u00e1c v\u1ee5 l\u00ean l\u1ecbch c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c thi d\u1ef1a tr\u00ean c\u00e1c t\u1ea7n su\u1ea5t kh\u00e1c nhau: M\u1ed9t l\u1ea7n, theo gi\u1edd, hai ng\u00e0y m\u1ed9t l\u1ea7n, h\u00e0ng ng\u00e0y, h\u00e0ng tu\u1ea7n ho\u1eb7c h\u00e0ng th\u00e1ng (c\u00e1 nh\u00e2n t\u00f4i th\u01b0\u1eddng b\u1eadt m\u1ed9t l\u1ea7n r\u1ed3i t\u1eaft plugin \u0111i, v\u00ec sau khi can thi\u1ec7p CSDL, ch\u00fang ta c\u1ea7n ki\u1ec3m tra l\u1ea1i website c\u00f9ng c\u00e1c t\u00ednh n\u0103ng c\u01a1 b\u1ea3n c\u1ee7a n\u00f3 xem c\u00f3 b\u1ecb \u1ea3nh h\u01b0\u1edfng g\u00ec kh\u00f4ng. Tr\u01b0\u1eddng h\u1ee3p b\u1ecb \u1ea3nh h\u01b0\u1edfng r\u1ea5t hi\u1ebfm khi x\u1ea3y ra nh\u01b0ng kh\u00f4ng ph\u1ea3i kh\u00f4ng c\u00f3 n\u00ean ph\u00f2ng v\u1eabn t\u1ed1t h\u01a1n. C\u00f2n n\u1ebfu b\u1ea1n \u0111\u1ecbnh l\u00ean l\u1ecbch l\u00e0m t\u1ef1 \u0111\u1ed9ng, t\u00f4i ngh\u0129 r\u1eb1ng t\u1ea7n su\u1ea5t h\u00e0ng tu\u1ea7n ho\u1eb7c h\u00e0ng th\u00e1ng l\u00e0 ph\u00f9 h\u1ee3p &#8211; t\u00f4i nghi\u00eang v\u1ec1 h\u00e0ng th\u00e1ng h\u01a1n);<\/li><li>Hi\u1ec3n th\u1ecb th\u00f4ng tin b\u1ea3ng CSDL, ch\u1eb3ng h\u1ea1n nh\u01b0 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c h\u00e0ng, k\u00edch c\u1ee1 b\u1ea3ng, v\u00e2n v\u00e2n;<\/li><li>T\u1ed1i \u01b0u h\u00f3a b\u1ea3ng CSDL (plugin s\u1ebd nh\u1eafc b\u1ea1n n\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 b\u1ea3ng n\u00e0o c\u1ea7n t\u1ed1i \u01b0u)<\/li><li>S\u1eeda ch\u1eefa c\u00e1c b\u1ea3ng CSDL b\u1ecb h\u1ecfng (plugin s\u1ebd nh\u1eafc b\u1ea1n n\u1ebfu c\u00f3 b\u1ea5t k\u1ef3 b\u1ea3ng n\u00e0o b\u1ecb h\u1ecfng);<\/li><li>L\u00ean l\u1ecbch t\u1ed1i \u01b0u h\u00f3a CSDL v\u00e0\/ho\u1eb7c s\u1eeda ch\u1eefa \u0111\u1ec3 ch\u1ea1y ho\u00e0n to\u00e0n t\u1ef1 \u0111\u1ed9ng v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c t\u00e1c v\u1ee5 n\u00e0y tr\u00ean m\u1ed9t b\u1ea3ng c\u1ee5 th\u1ec3 m\u00e0 b\u1ea1n mu\u1ed1n;<\/li><li>X\u00f3a c\u00e1c h\u00e0ng trong b\u1ea3ng CSDL;<\/li><li>D\u1ecdn d\u1eb9p v\u00e0 x\u00f3a c\u00e1c b\u1ea3ng CSDL;<\/li><li>Hi\u1ec3n th\u1ecb danh s\u00e1ch t\u00f9y ch\u1ecdn (options list);<\/li><li>Hi\u1ec3n th\u1ecb th\u00f4ng tin t\u00f9y ch\u1ecdn nh\u01b0 t\u00ean t\u00f9y ch\u1ecdn, gi\u00e1 tr\u1ecb t\u00f9y ch\u1ecdn, k\u00edch th\u01b0\u1edbc t\u00f9y ch\u1ecdn, t\u1ef1 \u0111\u1ed9ng t\u1ea3i t\u00f9y ch\u1ecdn (option autoload);<\/li><li>C\u00e1c t\u00f9y ch\u1ecdn d\u1ecdn d\u1eb9p v\u00e0 x\u00f3a;<\/li><li>Thi\u1ebft l\u1eadp c\u00e1c t\u00f9y ch\u1ecdn t\u1ea3i t\u1ef1 \u0111\u1ed9ng l\u00e0 no \/ yes;<\/li><li>Hi\u1ec3n th\u1ecb danh s\u00e1ch c\u00e1c t\u00e1c v\u1ee5 cron \u0111ang k\u00edch ho\u1ea1t (c\u00e1c t\u00e1c v\u1ee5 \u0111\u00e3 l\u00ean l\u1ecbch) v\u1edbi c\u00e1c th\u00f4ng tin c\u1ee7a ch\u00fang nh\u01b0 \u0111\u1ed1i s\u1ed1, l\u1ea7n ch\u1ea1y ti\u1ebfp theo, v\u00e2n v\u00e2n;<\/li><li>L\u00e0m s\u1ea1ch v\u00e0 x\u00f3a c\u00e1c t\u00e1c v\u1ee5 \u0111\u01b0\u1ee3c l\u00ean l\u1ecbch t\u1ef1 \u0111\u1ed9ng (sacheduled tasks);<\/li><li>Th\u00e2n thi\u1ec7n v\u00e0 d\u1ec5 s\u1eed d\u1ee5ng.<\/li><\/ul>\n\n\n<p>Th\u00f4ng qua vi\u1ec7c s\u1eed d\u1ee5ng plugin Advanced Database Cleaner b\u1ea1n s\u1ebd:<\/p>\n\n\n<ul><li><strong>C\u00f3 c\u00e1i nh\u00ecn t\u1ed5ng quan<\/strong>: Plugin s\u1ebd gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c c\u00e1i nh\u00ecn t\u1ed5ng quan v\u1ec1 chuy\u1ec7n g\u00ec \u0111ang di\u1ec5n ra trong CSDL c\u1ee7a b\u1ea1n. N\u00f3 s\u1ebd b\u00e1o c\u00e1o t\u1ea5t c\u1ea3 c\u00e1c th\u00e0nh ph\u1ea7n kh\u00f4ng s\u1eed d\u1ee5ng\/v\u00f4 \u00edch m\u00e0 b\u1ea1n c\u1ea7n d\u1ecdn d\u1eb9p, n\u00f3 c\u0169ng cung c\u1ea5p cho b\u1ea1n s\u1ed1 b\u1ea3ng\/t\u00f9y ch\u1ecdn\/t\u00e1c v\u1ee5 b\u1ea1n \u0111ang c\u00f3, v\u00e2n v\u00e2n. B\u1eb1ng c\u00e1ch n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 ki\u1ec3m so\u00e1t CSDL c\u1ee7a b\u1ea1n n\u1ebfu c\u00f3 b\u1ea5t c\u1ee9 \u0111i\u1ec1u g\u00ec b\u1ea5t th\u01b0\u1eddng x\u1ea3y ra.<\/li><li><strong>Ti\u1ebft ki\u1ec7m th\u1eddi gian<\/strong>: B\u1ea1n c\u00f3 th\u1ec3 l\u00e0m s\u1ea1ch\/t\u1ed1i \u01b0u h\u00f3a\/s\u1eeda ch\u1eefa th\u00e0nh ph\u1ea7n c\u1ee5 th\u1ec3 m\u00e0 b\u1ea1n mu\u1ed1n, s\u1ed1 ng\u00e0y d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n gi\u1eef l\u1ea1i v\u00e0 t\u1ea7n s\u1ed1 l\u00e0m s\u1ea1ch\/t\u1ed1i \u01b0u h\u00f3a\/s\u1eeda ch\u1eefa. Plugin s\u1ebd t\u1ef1 \u0111\u1ed9ng x\u1eed l\u00fd qu\u00e1 tr\u00ecnh n\u00e0y d\u1ef1a tr\u00ean c\u00e1c c\u00e0i \u0111\u1eb7t c\u1ee7a b\u1ea1n.<\/li><li><strong>Ti\u1ebft ki\u1ec7m kh\u00f4ng gian \u1ed5 c\u1ee9ng<\/strong>: B\u1eb1ng c\u00e1ch x\u00f3a c\u00e1c th\u00e0nh ph\u1ea7n kh\u00f4ng s\u1eed d\u1ee5ng\/v\u00f4 \u00edch, b\u1ea1n s\u1ebd ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c kh\u00f4ng gian d\u1eef li\u1ec7u c\u1ee7a CSDL v\u00e0 l\u00e0m qu\u00e1 tr\u00ecnh backup di\u1ec5n ra nhanh h\u01a1n so v\u1edbi tr\u01b0\u1edbc \u0111\u00e2y.<\/li><\/ul>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n<h2 class=\"wp-block-heading\" id=\"cac-tinh-nang-nang-cao-pro-c\u1ee7a-goi-tr\u1ea3-phi\"><span class=\"ez-toc-section\" id=\"Cac_tinh_nang_nang_caopro_cua_goi_tra_phi\"><\/span>C\u00e1c t\u00ednh n\u0103ng n\u00e2ng cao\/pro c\u1ee7a g\u00f3i tr\u1ea3 ph\u00ed<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>B\u1ea1n c\u00f3 bi\u1ebft l\u00e0 ngay c\u1ea3 khi b\u1ea1n \u0111\u00e3 x\u00f3a plugin\/theme trong WordPress, m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u d\u01b0 th\u1eeba (leftovers) v\u1eabn c\u00f2n \u1edf l\u1ea1i trong CSDL c\u1ee7a b\u1ea1n? Ch\u1eb3ng h\u1ea1n c\u00e1c t\u00f9y ch\u1ecdn v\u00f4 \u00edch, c\u00e1c b\u1ea3ng v\u00f4 \u00edch ho\u1eb7c c\u00e1c t\u00e1c v\u1ee5 cron v\u00f4 \u00edch. Kh\u00f4ng ph\u1ea3i plugin\/theme n\u00e0o c\u0169ng \u0111\u01b0\u1ee3c nh\u00e0 l\u1eadp tr\u00ecnh ph\u00e1t tri\u1ec3n \u0111\u1ec3 c\u00f3 kh\u1ea3 n\u0103ng \u0111\u1ec3 \u00fd \u0111\u1ebfn vi\u1ec7c d\u1ecdn d\u1eb9p CSDL c\u1ee7a b\u1ea1n \u0111\u00e2u. Do v\u1eady vi\u1ec7c x\u00f3a b\u1ecf plugin\/theme theo th\u1eddi gian s\u1ebd t\u00edch l\u0169y d\u1eef li\u1ec7u d\u01b0 th\u1eeba trong CSDL v\u00e0 l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t c\u1ee7a website. Phi\u00ean b\u1ea3n n\u00e2ng cao c\u1ee7a plugin Advanced Database Cleaner s\u1ebd gi\u00fap b\u1ea1n lo\u1ea1i b\u1ecf t\u1ea5t c\u00e1c c\u00e1c th\u00e0nh ph\u1ea7n d\u01b0 th\u1eeba \u0111\u00f3 v\u00e0 th\u1ef1c hi\u1ec7n vi\u1ec7c d\u1ecdn d\u1eb9p s\u00e2u CSDL. Trong <a href=\"https:\/\/sigmaplugin.com\/downloads\/wordpress-advanced-database-cleaner\" target=\"_blank\" rel=\"noreferrer noopener\">phi\u00ean b\u1ea3n pro<\/a> b\u1ea1n c\u00f3 th\u1ec3:<\/p>\n\n\n<ul><li>Ph\u00e2n lo\u1ea1i (classify) c\u00e1c t\u00f9y ch\u1ecdn d\u1ef1a v\u00e0o ng\u01b0\u1eddi t\u1ea1o (creator). Ch\u00fang c\u00f3 th\u1ec3 l\u00e0: c\u00e1c t\u00f9y ch\u1ecdn c\u1ee7a plugin, c\u00e1c t\u00f9y ch\u1ecdn c\u1ee7a theme (giao di\u1ec7n) ho\u1eb7c c\u00e1c t\u00f9y ch\u1ecdn c\u1ee7a WP core (l\u00f5i c\u1ee7a WordPress)<\/li><li>Nh\u1eadn bi\u1ebft (detect) v\u00e0 lo\u1ea1i b\u1ecf (delete) c\u00e1c t\u00f9y ch\u1ecdn v\u00f4 \u00edch. B\u1ea3ng &#8220;wp_options&#8221; c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 ch\u1ee9a \u0111\u1ea7y c\u00e1c t\u00f9y ch\u1ecdn v\u00f4 \u00edch v\u00e0 v\u00ec th\u1ebf c\u00f3 th\u1ec3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t t\u1ea3i d\u1eef li\u1ec7u t\u1eeb \u0111\u00f3, c\u00e1i c\u00f3 kh\u1ea3 n\u0103ng l\u00e0m ch\u1eadm website. D\u1ecdn d\u1eb9p c\u00e1c t\u00f9y ch\u1ecdn v\u00f4 \u00edch do v\u1eady r\u1ea5t quan tr\u1ecdng<\/li><li>Ph\u00e2n lo\u1ea1i c\u00e1c b\u1ea3ng d\u1ef1a tr\u00ean ng\u01b0\u1eddi t\u1ea1o. Ch\u00fang c\u00f3 th\u1ec3 l\u00e0: c\u00e1c b\u1ea3ng c\u1ee7a plugin, c\u00e1c b\u1ea3ng c\u1ee7a theme, ho\u1eb7c c\u00e1c b\u1ea3ng c\u1ee7a WP core<\/li><li>Nh\u1eadn bi\u1ebft v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c b\u1ea3ng v\u00f4 \u00edch. \u0110\u1ed1i v\u1edbi c\u00e1c t\u00f9y ch\u1ecdn, b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 c\u00f3 m\u1ed9t s\u1ed1 b\u1ea3ng v\u00f4 \u00edch \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi plugin\/theme b\u1ea1n kh\u00f4ng c\u00f2n s\u1eed d\u1ee5ng n\u1eefa. L\u00e0m s\u1ea1ch c\u00e1c b\u1ea3ng v\u00f4 \u00edch s\u1ebd l\u00e0m gi\u1ea3m dung l\u01b0\u1ee3ng CSDL c\u1ee7a b\u1ea1n<\/li><li>Ph\u00e2n lo\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c t\u00e1c v\u1ee5 cron (cron jobs) theo ng\u01b0\u1eddi t\u1ea1o. Ch\u00fang c\u00f3 th\u1ec3 l\u00e0: t\u00e1c v\u1ee5 cron c\u1ee7a plugin, t\u00e1c v\u1ee5 cron c\u1ee7a theme ho\u1eb7c t\u00e1c v\u1ee5 cron c\u1ee7a WP core<\/li><li>Nh\u1eadn bi\u1ebft v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c t\u00e1c v\u1ee5 cron v\u00f4 \u00edch. Sau khi b\u1ea1n g\u1ee1 b\u1ecf plugin\/theme, m\u1ed9t s\u1ed1 t\u00e1c v\u1ee5 cron c\u00f3 th\u1ec3 v\u1eabn k\u00edch ho\u1ea1t l\u00e0m cho WordPress g\u1ecdi nh\u1eefng h\u00e0m kh\u00f4ng c\u1ea7n thi\u1ebft. Khi s\u1eed d\u1ee5ng phi\u00ean b\u1ea3n pro, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn bi\u1ebft v\u00e0 l\u00e0m s\u1ea1ch c\u00e1c t\u00e1c v\u1ee5 v\u00f4 \u00edch \u0111\u00f3<\/li><li>C\u00e1c t\u00f9y ch\u1ecdn t\u00ecm ki\u1ebfm v\u00e0 l\u1ecdc, l\u1ecdc c\u00e1c b\u1ea3ng v\u00e0 l\u1ecdc c\u00e1c t\u00e1c v\u1ee5 cron d\u1ef1a tr\u00ean m\u1ed9t s\u1ed1 \u0111\u1eb7c \u0111i\u1ec3m nh\u01b0 &#8220;name\/t\u00ean&#8221;, &#8220;creator\/ng\u01b0\u1eddi t\u1ea1o&#8221;, &#8220;value\/gi\u00e1 tr\u1ecb&#8221;, v\u00e2n v\u00e2n<\/li><li>Nh\u1eadn h\u1ed7 tr\u1ee3: nh\u00f3m t\u00e1c gi\u1ea3 s\u1ebd h\u1ed7 tr\u1ee3 nhanh nh\u1ea5t c\u00f3 th\u1ec3 c\u0169ng nh\u01b0 tr\u1ea3 l\u1eddi b\u1ea5t c\u1ee9 v\u1ea5n \u0111\u1ec1 k\u1ef9 thu\u1eadt n\u00e0o \u0111\u1ec3 gi\u00fap b\u1ea1n d\u1ecdn d\u1eb9p CSDL m\u1ed9t c\u00e1ch c\u00f3 hi\u1ec7u qu\u1ea3<\/li><\/ul>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n<h2 class=\"wp-block-heading\" id=\"h\u1ecfi-dap\"><span class=\"ez-toc-section\" id=\"Hoi_dap\"><\/span>H\u1ecfi \u0111\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p><strong>1. &#8220;L\u00e0m s\u1ea1ch CSDL&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec?<\/strong><\/p>\n\n\n<p>Khi b\u1ea1n s\u1eed d\u1ee5ng WordPress, CSDL c\u1ee7a b\u1ea1n s\u1ebd t\u00edch l\u0169y r\u1ea5t nhi\u1ec1u d\u1eef li\u1ec7u d\u01b0 th\u1eeba nh\u01b0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 c\u1ee7a b\u00e0i vi\u1ebft, c\u00e1c b\u00ecnh lu\u1eadn spam, c\u00e1c b\u00ecnh lu\u1eadn trong th\u00f9ng r\u00e1c, v\u00e2n v\u00e2n. Lo\u1ea1i b\u1ecf c\u00e1c d\u1eef li\u1ec7u kh\u00f4ng c\u1ea7n thi\u1ebft n\u00e0y s\u1ebd gi\u00fap gi\u1ea3m k\u00edch c\u1ee1 CSDL, t\u0103ng t\u1ed1c qu\u00e1 tr\u00ecnh x\u1eed l\u00fd backup v\u00e0 c\u0169ng gi\u00fap <a href=\"https:\/\/kiencang.net\/tang-toc-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u0111\u1ea9y nhanh t\u1ed1c \u0111\u1ed9 trang web<\/a>.<\/p>\n\n\n<p><strong>2. Li\u1ec7u c\u00f3 an to\u00e0n kh\u00f4ng khi l\u00e0m s\u1ea1ch CSDL<\/strong><\/p>\n\n\n<p>C\u00f3, n\u00f3 an to\u00e0n. Ch\u00fang t\u00f4i kh\u00f4ng ch\u1ea1y b\u1ea5t c\u1ee9 \u0111o\u1ea1n m\u00e3 n\u00e0o c\u00f3 nguy c\u01a1 l\u00e0m gi\u00e1n \u0111o\u1ea1n\/ph\u00e1 h\u1ecfng website c\u1ee7a b\u1ea1n ho\u1eb7c x\u00f3a b\u1ecf c\u00e1c b\u00e0i post, page, b\u00ecnh lu\u1eadn (\u0111\u00e3 duy\u1ec7t). D\u00f9 v\u1eady, \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o an to\u00e0n b\u1ea1n n\u00ean lu\u00f4n lu\u00f4n c\u00f3 b\u1ea3n back up CSDL c\u1ee7a b\u1ea1n tr\u01b0\u1edbc khi d\u1ecdn d\u1eb9p. \u0110\u00e2y kh\u00f4ng ph\u1ea3i l\u00e0 m\u1ed9t t\u00f9y ch\u1ecdn; n\u00f3 l\u00e0 b\u1eaft bu\u1ed9c \u0111\u1ea5y \u1ea1! An to\u00e0n l\u00fac n\u00e0o c\u0169ng t\u1ed1t h\u01a1n l\u00e0 ph\u1ea3i n\u00f3i l\u1eddi xin l\u1ed7i! (l\u1eddi xin l\u1ed7i kh\u00f4ng gi\u00fap b\u1ea1n kh\u00f4i ph\u1ee5c l\u1ea1i database, d\u00f9 n\u00f3 ch\u00e2n th\u00e0nh \u0111\u1ebfn m\u1ee9c n\u00e0o)<\/p>\n\n\n<p><strong>3. &#8220;T\u1ed1i \u01b0u h\u00f3a CSDL&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec?<\/strong><\/p>\n\n\n<p>T\u1ed1i \u01b0u h\u00f3a CSDL s\u1ebd l\u1ea5y l\u1ea1i kh\u00f4ng gian kh\u00f4ng s\u1eed d\u1ee5ng (reclaim unused space) trong b\u1ea3ng c\u1ee7a b\u1ea1n, c\u00e1i s\u1ebd gi\u00fap l\u00e0m gi\u1ea3m kh\u00f4ng gian l\u01b0u tr\u1eef v\u00e0 c\u1ea3i thi\u1ec7n hi\u1ec7u qu\u1ea3 trong vi\u1ec7c truy c\u1eadp b\u1ea3ng. T\u1ed1i \u01b0u h\u00f3a CSDL \u0111\u00f4i khi c\u00f3 th\u1ec3 c\u1ea3i thi\u1ec7n \u0111\u00e1ng k\u1ec3 hi\u1ec7u su\u1ea5t, \u0111\u1eb7c bi\u1ec7t khi trang web c\u1ee7a b\u1ea1n c\u00f3 nhi\u1ec1u ng\u01b0\u1eddi truy c\u1eadp ho\u1eb7c c\u00f3 l\u01b0\u1ee3ng l\u1edbn n\u1ed9i dung. T\u1ed1i \u01b0u h\u00f3a CSDL r\u1ea5t an to\u00e0n.<\/p>\n\n\n<p><strong>4. C\u00f3 an to\u00e0n kh\u00f4ng khi t\u00f4i d\u1ecdn d\u1eb9p cron (t\u00e1c v\u1ee5 theo l\u1ecbch tr\u00ecnh)?<\/strong><\/p>\n\n\n<p>M\u1ed9t t\u00e1c v\u1ee5 theo l\u1ecbch tr\u00ecnh (scheduled task\/cron jobs), cho ph\u00e9p plugin th\u1ef1c thi m\u1ed9t s\u1ed1 h\u00e0nh \u0111\u1ed9ng t\u1ea1i m\u1ed9t th\u1eddi \u0111i\u1ec3m c\u1ee5 th\u1ec3, m\u00e0 kh\u00f4ng c\u1ea7n thao t\u00e1c th\u1ee7 c\u00f4ng \u0111\u1ec3 th\u1ef1c thi m\u00e3 v\u00e0o th\u1eddi \u0111i\u1ec3m \u0111\u00f3. B\u1ea3n th\u00e2n WordPress s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 t\u00e1c v\u1ee5 theo l\u1ecbch tr\u00ecnh \u0111\u1ec3 th\u1ef1c thi v\u00e0i h\u00e0nh \u0111\u1ed9ng l\u1eb7p l\u1ea1i th\u01b0\u1eddng xuy\u00ean. Tuy v\u1eady, m\u1ed9t s\u1ed1 t\u00e1c v\u1ee5 theo l\u1ecbch tr\u00ecnh c\u00f3 th\u1ec3 kh\u00f4ng b\u1ecb lo\u1ea1i b\u1ecf cho d\u00f9 plugin s\u1eed d\u1ee5ng n\u00f3 \u0111\u00e3 b\u1ecb x\u00f3a kh\u1ecfi b\u1ea3n c\u00e0i \u0111\u1eb7t WordPress. Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 plugin \u0111\u1ec1u quan t\u00e2m \u0111\u1ebfn vi\u1ec7c d\u1ecdn d\u1eb9p d\u1eef li\u1ec7u trong WordPress. V\u00ec th\u1ebf, lo\u1ea1i b\u1ecf c\u00e1c t\u00e1c v\u1ee5 kh\u00f4ng c\u1ea7n thi\u1ebft n\u00e0y c\u00f3 th\u1ec3 gi\u00fap l\u00e0m s\u1ea1ch trang web c\u1ee7a b\u1ea1n. \u0110i\u1ec1u c\u1ea7n ph\u1ea3i l\u01b0u \u00fd l\u00e0 d\u1ecdn d\u1eb9p c\u00e1c t\u00e1c v\u1ee5 theo l\u1ecbch tr\u00ecnh l\u00e0 an to\u00e0n mi\u1ec5n l\u00e0 b\u1ea1n b\u1ea1n bi\u1ebft c\u00e1c t\u00e1c v\u1ee5 n\u00e0o \u0111ang \u0111\u01b0\u1ee3c d\u1ecdn d\u1eb9p (c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n bi\u1ebft nhi\u1ec7m v\u1ee5 c\u1ee7a cron jobs \u0111\u00f3 l\u00e0 g\u00ec). N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1eafc ch\u1eafn, t\u1ed1t h\u01a1n l\u00e0 kh\u00f4ng d\u1ecdn d\u1eb9p\/lo\u1ea1i b\u1ecf b\u1ea5t c\u1ee9 t\u00e1c v\u1ee5 n\u00e0o.<\/p>\n\n\n<p><strong>5. &#8220;Revison&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec? \u0110o\u1ea1n m\u00e3 SQL \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p><a href=\"https:\/\/kiencang.net\/revision-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">WordPress l\u01b0u tr\u1eef m\u1ed9t b\u1ea3n ghi (\u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 &#8220;revision&#8221;)<\/a> cho m\u1ed7i l\u1ea7n l\u01b0u nh\u00e1p ho\u1eb7c m\u1ed7i l\u1ea7n c\u1eadp nh\u1eadt \u0111\u01b0\u1ee3c xu\u1ea5t b\u1ea3n. H\u1ec7 th\u1ed1ng n\u00e0y cho ph\u00e9p b\u1ea1n xem nh\u1eefng thay \u0111\u1ed5i \u0111\u00e3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n trong m\u1ed7i b\u00e0i post v\u00e0 page qua th\u1eddi gian. Tuy nhi\u00ean, \u0111i\u1ec1u n\u00e0y c\u00f3 th\u1ec3 t\u1ea1o ra nhi\u1ec1u d\u1eef li\u1ec7u ch\u00ecm\/\u1ea9n kh\u00f4ng c\u1ea7n thi\u1ebft (unnecessary overhead) trong CSDL c\u1ee7a b\u1ea1n, v\u00ec n\u00f3 t\u1ed3n nhi\u1ec1u kh\u00f4ng gian l\u01b0u gi\u1eef. Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c d\u00f9ng b\u1edfi plugin \u0111\u1ec3 x\u00f3a b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c revision l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM posts WHERE post_type = \u2018revision\u2019<\/pre>\n\n\n<p><strong>6. &#8220;L\u01b0u nh\u00e1p l\u01b0u t\u1ef1 \u0111\u1ed9ng&#8221; (Auto-draft) c\u00f3 ngh\u0129a l\u00e0 g\u00ec? \u0110o\u1ea1n m\u00e3 SQL \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00f3a b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>WordPress t\u1ef1 \u0111\u1ed9ng l\u01b0u gi\u1eef c\u00e1c b\u00e0i post\/page c\u1ee7a b\u1ea1n khi b\u1ea1n ch\u1ec9nh s\u1eeda n\u00f3. \u0110i\u1ec1u n\u00e0y \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 l\u01b0u nh\u00e1p l\u01b0u t\u1ef1 \u0111\u1ed9ng. N\u1ebfu b\u1ea1n kh\u00f4ng nh\u1ea5n n\u00fat publish\/update (xu\u1ea5t b\u1ea3n\/c\u1eadp nh\u1eadt), th\u00ec post\/page s\u1ebd l\u01b0u n\u00f3 d\u01b0\u1edbi d\u1ea1ng b\u1ea3n nh\u00e1p t\u1ef1 \u0111\u1ed9ng v\u00e0 b\u1ea5t k\u1ef3 ch\u1ec9nh s\u1eeda n\u00e0o tr\u00ean b\u00e0i post\/page c\u1ee7a b\u1ea1n s\u1ebd kh\u00f4ng hi\u1ec3n th\u1ecb tr\u00ean website \u0111\u00e3 xu\u1ea5t b\u1ea3n. Theo th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u b\u1ea3n nh\u00e1p l\u01b0u t\u1ef1 \u0111\u1ed9ng m\u00e0 b\u1ea1n s\u1ebd kh\u00f4ng bao gi\u1edd xu\u1ea5t b\u1ea3n v\u00e0 v\u00ec th\u1ebf b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a ch\u00fang \u0111i. Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c plugin s\u1eed d\u1ee5ng \u0111\u1ec3 x\u00f3a b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n l\u01b0u nh\u00e1p t\u1ef1 \u0111\u1ed9ng l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM posts WHERE post_status = \u2018auto-draft\u2019<\/pre>\n\n\n<p><strong>7. &#8220;B\u00ecnh lu\u1eadn ch\u1edd duy\u1ec7t&#8221; c\u00f3 ngh\u0129a l\u00e0? \u0110o\u1ea1n m\u00e3 SQL \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00f3a b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>B\u00ecnh lu\u1eadn ch\u1edd duy\u1ec7t l\u00e0 c\u00e1c b\u00ecnh lu\u1eadn \u0111\u01b0\u1ee3c t\u1ea1o ra b\u1edfi ng\u01b0\u1eddi d\u00f9ng v\u00e0 \u0111ang ch\u1edf b\u1ea1n ph\u00ea duy\u1ec7t tr\u01b0\u1edbc khi n\u00f3 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb c\u00f4ng khai tr\u00ean website c\u1ee7a b\u1ea1n. Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, b\u1ea1n s\u1ebd ph\u1ea3i x\u00f3a to\u00e0n b\u1ed9 c\u00e1c b\u00ecnh lu\u1eadn n\u00e0y. Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng b\u1edfi plugin \u0111\u1ec3 x\u00f3a b\u1ecf to\u00e0n b\u1ed9 c\u00e1c b\u00ecnh lu\u1eadn ch\u1edd duy\u1ec7t l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM comments WHERE comment_approved = \u20180\u2019<\/pre>\n\n\n<p><strong>8. &#8220;B\u00ecnh lu\u1eadn spam&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec? \u0110o\u1ea1n m\u00e3 SQL \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 x\u00f3a b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>N\u00f3 l\u00e0 c\u00e1c b\u00ecnh lu\u1eadn m\u00e0 b\u1ea1n (ho\u1eb7c plugin n\u00e0o \u0111\u00f3) \u0111\u00e1nh gi\u00e1 l\u00e0 spam. Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c plugin s\u1eed d\u1ee5ng \u0111\u1ec3 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 b\u00ecnh lu\u1eadn spam l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM comments WHERE comment_approved = \u2018spam\u2019<\/pre>\n\n\n<p><strong>9. &#8220;B\u00ecnh lu\u1eadn r\u00e1c&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec? Truy v\u1ea5n SQL n\u00e0o \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>B\u00ecnh lu\u1eadn r\u00e1c l\u00e0 b\u00ecnh lu\u1eadn m\u00e0 b\u1ea1n \u0111\u00e3 x\u00f3a kh\u1ecfi WordPress v\u00e0 \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ebfn th\u00f9ng r\u00e1c (trash). B\u00ecnh lu\u1eadn r\u00e1c kh\u00f4ng hi\u1ec3n th\u1ecb tr\u00ean website v\u00e0 c\u1ea7n ph\u1ea3i x\u00f3a v\u0129nh vi\u1ec5n. Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c d\u00f9ng b\u1edfi plugin \u0111\u1ec3 x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c b\u00ecnh lu\u1eadn r\u00e1c l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM comments WHERE comment_approved = \u2018trash\u2019<\/pre>\n\n\n<p><strong>10. &#8220;Trackback&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec? Truy v\u1ea5n SQL n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 lo\u1ea1i b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>Trackbacks cho ph\u00e9p b\u1ea1n g\u1eedi th\u00f4ng b\u00e1o (notify) \u0111\u1ebfn c\u00e1c ch\u1ee7 website kh\u00e1c r\u1eb1ng b\u1ea1n \u0111\u00e3 li\u00ean k\u1ebft \u0111\u1ebfn b\u00e0i vi\u1ebft c\u1ee7a h\u1ecd tr\u00ean website c\u1ee7a b\u1ea1n. C\u00e1c trackbacks n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 g\u1eedi m\u1ed9t l\u01b0\u1ee3ng l\u1edbn spam. C\u00e1c spammer s\u1eed d\u1ee5ng ch\u00fang \u0111\u1ec3 c\u00e1c li\u00ean k\u1ebft c\u1ee7a h\u1ecd \u0111\u01b0\u1ee3c \u0111\u0103ng tr\u00ean c\u00e0ng nhi\u1ec1u website c\u00e0ng t\u1ed1t. \u0110\u00f3 l\u00e0 l\u00fd do v\u00ec sao ch\u00fang n\u00ean \u0111\u01b0\u1ee3c h\u1ee7y k\u00edch ho\u1ea1t\/x\u00f3a b\u1ecf n\u1ebfu b\u1ea1n kh\u00f4ng s\u1eed d\u1ee5ng ch\u00fang.&nbsp; Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c plugin s\u1eed d\u1ee5ng \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c trackback l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM comments WHERE comment_type = \u2018trackback\u2019<\/pre>\n\n\n<p><strong>11. &#8220;Pingback&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec? Truy v\u1ea5n SQL n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 lo\u1ea1i b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>Pingbacks cho ph\u00e9p b\u1ea1n th\u00f4ng b\u00e1o v\u1edbi c\u00e1c ch\u1ee7 website kh\u00e1c bi\u1ebft r\u1eb1ng b\u1ea1n \u0111\u00e3 li\u00ean k\u1ebft \u0111\u1ebfn b\u00e0i vi\u1ebft c\u1ee7a h\u1ecd tr\u00ean website c\u1ee7a b\u1ea1n. Pingbacks \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1ec3 gi\u1ea3i quy\u1ebft m\u1ed9t s\u1ed1 v\u1ea5n \u0111\u1ec1 m\u00e0 m\u1ecdi ng\u01b0\u1eddi \u0111\u00e3 quan s\u00e1t th\u1ea5y khi d\u00f9ng trackbacks. M\u1eb7c d\u00f9 c\u00f3 m\u1ed9t s\u1ed1 kh\u00e1c bi\u1ec7t k\u1ef9 thu\u1eadt nh\u1ecf, v\u1ec1 c\u01a1 b\u1ea3n th\u00ec trackback v\u00e0 pingback gi\u1ed1ng nhau. Pingbacks c\u00f3 th\u1ebf \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 g\u1eedi m\u1ed9t l\u01b0\u1ee3ng l\u1edbn spam. \u0110\u00f3 l\u00e0 l\u00fd do v\u00ec sao ch\u00fang n\u00ean \u0111\u01b0\u1ee3c h\u1ee7y k\u00edch ho\u1ea1t\/x\u00f3a b\u1ecf n\u1ebfu b\u1ea1n kh\u00f4ng s\u1eed d\u1ee5ng ch\u00fang.&nbsp; Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c plugin s\u1eed d\u1ee5ng \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c pingback l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM comments WHERE comment_type = \u2018pingback\u2019<\/pre>\n\n\n<p><strong>12. &#8220;Post meta v\u00f4 \u00edch&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec? Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>D\u1eef li\u1ec7u post meta l\u00e0 th\u00f4ng tin b\u1ea1n cung c\u1ea5p cho ng\u01b0\u1eddi \u0111\u1ecdc v\u1ec1 m\u1ed7i b\u00e0i post. Th\u00f4ng tin n\u00e0y th\u01b0\u1eddng bao g\u1ed3m t\u00e1c gi\u1ea3 b\u00e0i \u0111\u0103ng, th\u1eddi \u0111i\u1ec3m n\u00f3 \u0111\u01b0\u1ee3c vi\u1ebft (ho\u1eb7c \u0111\u01b0\u1ee3c \u0111\u0103ng), v\u00e0 c\u00e1ch t\u00e1c gi\u1ea3 ph\u00e2n lo\u1ea1i b\u00e0i post c\u1ee5 th\u1ec3 \u0111\u00f3 (v\u00e0o th\u01b0 m\u1ee5c n\u00e0o). Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u post meta tr\u1edf n\u00ean v\u00f4 \u00edch v\u00e0 kh\u00f4ng thu\u1ed9c v\u1ec1 b\u1ea5t c\u1ee9 b\u00e0i post c\u1ee5 th\u1ec3 n\u00e0o. Ch\u00fang \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 &#8220;orphan postmeta \/ postmeta v\u00f4 \u00edch&#8221; v\u00e0 c\u1ea7n ph\u1ea3i lo\u1ea1i b\u1ecf. Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng b\u1edfi plugin \u0111\u1ec3 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 postmeta v\u00f4 \u00edch l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE pm FROM postmeta pm LEFT JOIN posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL<\/pre>\n\n\n<p><strong>13. &#8220;Meta b\u00ecnh lu\u1eadn v\u00f4 \u00edch&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec? Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>Gi\u1ed1ng nh\u01b0 &#8220;Post meta v\u00f4 \u00edch&#8221;, ngo\u1ea1i tr\u1eeb vi\u1ec7c &#8220;meta b\u00ecnh lu\u1eadn v\u00f4 \u00edch&#8221; li\u00ean quan \u0111\u1ebfn b\u00ecnh lu\u1eadn ch\u1ee9 kh\u00f4ng ph\u1ea3i b\u00e0i post. Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng b\u1edfi plugin \u0111\u1ec3 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 meta b\u00ecnh lu\u1eadn v\u00f4 \u00edch l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM comments)<\/pre>\n\n\n<p><strong>14. &#8220;User meta v\u00f4 \u00edch&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec? Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>D\u1eef li\u1ec7u user meta l\u00e0 th\u00f4ng tin b\u1ea1n cung c\u1ea5p cho ng\u01b0\u1eddi \u0111\u1ecdc v\u1ec1 t\u1eebng user. Th\u00f4ng tin n\u00e0y th\u01b0\u1eddng bao g\u1ed3m d\u1eef li\u1ec7u b\u1ed5 sung m\u00e0 kh\u00f4ng \u0111\u01b0\u1ee3c l\u01b0u gi\u1eef trong b\u1ea3ng ng\u01b0\u1eddi d\u00f9ng c\u1ee7a WordPress. Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, m\u1ed9t s\u1ed1 d\u1eef li\u1ec7u user meta tr\u1edf n\u00ean v\u00f4 \u00edch v\u00e0 kh\u00f4ng thu\u1ed9c v\u1ec1 b\u1ea5t c\u1ee9 user n\u00e0o. Ch\u00fang \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 &#8220;usermeta v\u00f4 \u00edch&#8221; v\u00e0 c\u1ea7n ph\u1ea3i lo\u1ea1i b\u1ecf do t\u00ednh v\u00f4 d\u1ee5ng c\u1ee7a ch\u00fang.&nbsp;Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng b\u1edfi plugin \u0111\u1ec3 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 usermeta v\u00f4 \u00edch l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM usermeta WHERE user_id NOT IN (SELECT ID FROM users)<\/pre>\n\n\n<p><strong>15. &#8220;Term meta v\u00f4 \u00edch&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec? \u0110o\u1ea1n m\u00e3 SQL \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 lo\u1ea1i b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>D\u1eef li\u1ec7u meta data l\u00e0 th\u00f4ng tin \u0111\u01b0\u1ee3c cung c\u1ea5p cho t\u1eebng term taxonomy. Th\u00f4ng tin n\u00e0y th\u01b0\u1eddng bao g\u1ed3m d\u1eef li\u1ec7u b\u1ed5 sung m\u00e0 kh\u00f4ng \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong b\u1ea3ng term c\u1ee7a WordPress. Trong m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, m\u1ed9t s\u1ed1 th\u00f4ng tin d\u1eef li\u1ec7u term meta tr\u1edf n\u00ean v\u00f4 \u00edch v\u00e0 kh\u00f4ng thu\u1ed9c v\u1ec1 b\u1ea5t c\u1ee9 term taxonomy n\u00e0o. N\u1ebfu r\u01a1i v\u00e0o tr\u01b0\u1eddng h\u1ee3p \u0111\u00f3 ch\u00fang \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 &#8220;termmeta v\u00f4 \u00edch&#8221; v\u00e0 n\u00ean \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf do t\u00ednh v\u00f4 d\u1ee5ng c\u1ee7a ch\u00fang. Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c d\u00f9ng b\u1edfi plugin \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c termmeta v\u00f4 \u00edch l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM termmeta WHERE term_id NOT IN (SELECT term_id FROM terms)<\/pre>\n\n\n<p><strong>16. &#8220;C\u00e1c m\u1ed1i quan h\u1ec7 v\u00f4 \u00edch&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec? M\u00e3 SQL \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 lo\u1ea1i b\u1ecf n\u00f3?<\/strong><\/p>\n\n\n<p>\u0110\u00f4i khi b\u1ea3ng wp_term_relationships tr\u1edf n\u00ean c\u1ed3ng k\u1ec1nh v\u1edbi nhi\u1ec1u m\u1ed1i quan h\u1ec7 v\u00f4 \u00edch. \u0110i\u1ec1u n\u00e0y \u0111\u1eb7c bi\u1ec7t hay x\u1ea3y ra trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n s\u1eed d\u1ee5ng trang web kh\u00f4ng ph\u1ea3i cho m\u1ee5c \u0111\u00edch blog m\u00e0 l\u00e0 m\u1ed9t d\u1ea1ng n\u1ed9i dung kh\u00e1c, \u1edf \u0111\u00f3 c\u00e1c b\u00e0i post \u0111\u01b0\u1ee3c x\u00f3a \u0111\u1ecbnh k\u1ef3. Qua th\u1eddi gian, b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 h\u00e0ng ng\u00e0n m\u1ed1i quan h\u1ec7 k\u1ef3 h\u1ea1n cho b\u00e0i post kh\u00f4ng c\u00f2n t\u1ed3n t\u1ea1i n\u1eefa, ti\u00eau t\u1ed1n nhi\u1ec1u kh\u00f4ng gian CSDL. Truy v\u1ea5n SQL \u0111\u01b0\u1ee3c d\u00f9ng b\u1edfi plugin \u0111\u1ec3 x\u00f3a b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c m\u1ed1i quan h\u1ec7 v\u00f4 \u00edch l\u00e0:<\/p>\n\n\n<pre class=\"wp-block-preformatted\">DELETE FROM term_relationships WHERE term_taxonomy_id=1 AND object_id NOT IN (SELECT id FROM posts)<\/pre>\n\n\n<p><strong>17. &#8220;Transient h\u1ebft h\u1ea1n&#8221; c\u00f3 ngh\u0129a l\u00e0 g\u00ec?<\/strong><\/p>\n\n\n<p>Transients l\u00e0 c\u00e1ch l\u01b0u tr\u1eef d\u1eef li\u1ec7u cache t\u1ea1m th\u1eddi trong WordPress DB b\u1eb1ng c\u00e1ch \u0111\u1eb7t cho n\u00f3 m\u1ed9t c\u00e1i t\u00ean v\u00e0 khung th\u1eddi gian sau \u0111\u00f3 n\u00f3 s\u1ebd h\u1ebft h\u1ea1n v\u00e0 b\u1ecb x\u00f3a. \u0110i\u1ec1u n\u00e0y gi\u00fap c\u1ea3i thi\u1ec7n hi\u1ec7u su\u1ea5t WordPress v\u00e0 t\u0103ng t\u1ed1c website trong khi l\u00e0m gi\u1ea3m t\u1ea3i cho m\u00e1y ch\u1ee7 tr\u00ean t\u1ed5ng th\u1ec3. Transients h\u1ebft h\u1ea1n l\u00e0 transients tuy \u0111\u00e3 h\u1ebft th\u1eddi gian t\u1ed3n t\u1ea1i tr\u00ean l\u00fd thuy\u1ebft nh\u01b0ng v\u1eabn t\u1ed3n t\u1ea1i trong CSDL. \u0110\u00e2y l\u00e0 nh\u1eefng d\u1eef li\u1ec7u c\u00f3 th\u1ec3 x\u00f3a m\u1ed9t c\u00e1ch an to\u00e0n. D\u1ecdn d\u1eb9p Transients gi\u1edd \u0111\u00e3 l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a WordPress core, k\u1ec3 t\u1eeb phi\u00ean b\u1ea3n 4.9, v\u00ec th\u1ebf b\u1ea1n kh\u00f4ng c\u1ea7n d\u1ecdn d\u1eb9p ch\u00fang th\u1ee7 c\u00f4ng n\u1eefa, tr\u1eeb khi b\u1ea1n c\u00f3 m\u1ed9t nhu c\u1ea7u \u0111\u1eb7c bi\u1ec7t n\u00e0o \u0111\u00f3.<\/p>\n\n\n<p><strong>18. Plugin n\u00e0y c\u00f3 t\u01b0\u01a1ng th\u00edch v\u1edbi trang multisite?<\/strong><\/p>\n\n\n<p>C\u00f3, n\u00f3 c\u00f3 t\u01b0\u01a1ng th\u00edch v\u1edbi trang multisite. C\u1ea7n ph\u1ea3i l\u01b0u \u00fd l\u00e0 ch\u1ec9 trang ch\u00ednh trong m\u1ea1ng l\u00e0 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c d\u1ecdn d\u1eb9p CSDL v\u00e0 c\u00e1c th\u00e0nh ph\u1ea7n v\u00f4 \u00edch c\u1ee7a t\u1ea5t c\u1ea3 m\u1ea1ng. Ch\u00fang t\u00f4i ng\u0103n kh\u00f4ng cho c\u00e1c trang kh\u00e1c (trang kh\u00f4ng ph\u1ea3i trang ch\u00ednh) d\u1ecdn d\u1eb9p CSDL c\u1ee7a b\u1ea1n v\u00ec ch\u00fang t\u00f4i tin r\u1eb1ng ch\u1ec9 ng\u01b0\u1eddi qu\u1ea3n tr\u1ecb c\u1ea5p cao nh\u1ea5t (super administrator &#8211; tham kh\u1ea3o th\u00eam <a href=\"https:\/\/kiencang.net\/thanh-vien-trong-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">ph\u00e2n quy\u1ec1n trong WordPress<\/a>) m\u1edbi c\u00f3 quy\u1ec1n th\u1ef1c hi\u1ec7n ch\u1ee9c n\u0103ng n\u00e0y. CSDL c\u1ee7a b\u1ea1n th\u1ef1c s\u1ef1 qu\u00fd gi\u00e1!<\/p>\n\n\n<p><strong>19. Plugin n\u00e0y c\u00f3 t\u01b0\u01a1ng th\u00edch v\u1edbi SharDB, HyperDB ho\u1eb7c Multi-DB kh\u00f4ng?<\/strong><\/p>\n\n\n<p>Tr\u00ean th\u1ef1c t\u1ebf plugin n\u00e0y kh\u00f4ng t\u01b0\u01a1ng th\u00edch v\u1edbi SharDB, HyperDB ho\u1eb7c Multi-DB. Ch\u00fang t\u00f4i s\u1ebd c\u1ed1 g\u1eafng l\u00e0m n\u00f3 t\u01b0\u01a1ng th\u00edch trong c\u00e1c phi\u00ean b\u1ea3n s\u1eafp t\u1edbi.<\/p>\n\n\n<p><strong>20. Plugin n\u00e0y c\u00f3 t\u1ef1 d\u1ecdn d\u1eb9p b\u1ea3n th\u00e2n n\u00f3 sau khi g\u1ee1 b\u1ecf kh\u00f4ng?<\/strong><\/p>\n\n\n<p>Ch\u00fang t\u00f4i l\u00e0m c\u00f4ng vi\u1ec7c d\u1ecdn d\u1eb9p trang WordPress c\u1ee7a b\u1ea1n, n\u00ean s\u1ebd th\u1eadt x\u1ea5u h\u1ed5 n\u1ebfu plugin n\u00e0y kh\u00f4ng d\u1ecdn d\u1eb9p ch\u00ednh b\u1ea3n th\u00e2n n\u00f3 sau khi \u0111\u01b0\u1ee3c g\u1ee1 b\u1ecf! V\u00e2ng, t\u1ea5t nhi\u00ean r\u1ed3i, plugin n\u00e0y s\u1ebd t\u1ef1 d\u1ecdn d\u1eb9p ch\u00ednh n\u00f3 v\u00e0 lo\u1ea1i b\u1ecf b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u n\u00e0o \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 l\u01b0u tr\u1eef c\u00e1c c\u00e0i \u0111\u1eb7t c\u1ee7a plugin m\u1ed9t khi n\u00f3 b\u1ecb g\u1ee1 b\u1ecf.<\/p>\n\n\n<p><em>(D\u1ecbch t\u1eeb b\u00e0i gi\u1edbi thi\u1ec7u plugin tr\u00ean trang WordPress.Org)<\/em><\/p>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n<h2 class=\"wp-block-heading\" id=\"kinh-nghi\u1ec7m-s\u1eed-d\u1ee5ng-th\u1ef1c-t\u1ebf\"><span class=\"ez-toc-section\" id=\"Kinh_nghiem_su_dung_thuc_te\"><\/span>Kinh nghi\u1ec7m s\u1eed d\u1ee5ng th\u1ef1c t\u1ebf<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p><a href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">T\u1ed1i \u01b0u h\u00f3a c\u01a1 s\u1edf d\u1eef li\u1ec7u trong WordPress<\/a> \u0111\u00fang l\u00e0 ph\u1ea7n m\u00e0 ngay c\u1ea3 nh\u1eefng ng\u01b0\u1eddi c\u00f3 kinh nghi\u1ec7m th\u01b0\u1eddng b\u1ecf qua. <a href=\"https:\/\/kiencang.net\/plugin-nen-anh-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">T\u00f4i bi\u1ebft c\u00e1ch t\u1ed1i \u01b0u h\u00f3a h\u00ecnh \u1ea3nh c\u00e1ch \u0111\u00e2y 2 n\u0103m<\/a>, plugin cache c\u00e1ch \u0111\u00e2y 3 n\u0103m, <a href=\"https:\/\/kiencang.net\/critical-css-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">t\u1ed1i \u01b0u CSS<\/a>, JS c\u0169ng qu\u00e3ng th\u1eddi gian \u0111\u00f3, nh\u01b0ng gi\u1edd m\u1edbi th\u1ef1c s\u1ef1 ti\u1ebfn h\u00e0nh t\u1ed1i \u01b0u h\u00f3a CSDL!<\/p>\n\n\n<p>C\u0169ng ch\u1eb3ng ph\u1ea3i ng\u1eabu nhi\u00ean m\u00e0 c\u00e2u chuy\u1ec7n l\u1ea1i th\u00e0nh ra nh\u01b0 v\u1eady, theo t\u00f4i ng\u01b0\u1eddi ta \u00edt ch\u00fa \u00fd \u0111\u1ebfn n\u00f3 l\u00e0 v\u00ec:<\/p>\n\n\n<ul><li><strong>N\u00f3 kh\u00f4ng tr\u1ef1c quan, d\u1ec5 th\u1ea5y<\/strong>. CSDL gi\u1ed1ng nh\u01b0 n\u1ed9i t\u1ea1ng c\u1ee7a website, n\u00f3 n\u1eb1m s\u00e2u b\u00ean trong. Trong khi nh\u1eefng th\u1ee9 nh\u01b0 h\u00ecnh \u1ea3nh ho\u1eb7c ngay c\u1ea3 CSS hay JS b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y d\u1ec5 d\u00e0ng.<\/li><li><strong>T\u1ed1i \u01b0u CSDL kh\u00f4ng th\u1ef1c s\u1ef1 quan tr\u1ecdng n\u1ebfu website nh\u1ecf ho\u1eb7c\/v\u00e0 m\u1edbi th\u00e0nh l\u1eadp<\/strong>. B\u1edfi v\u00ec l\u00fac n\u00e0y CSDL c\u00f2n nh\u1eb9 nh\u00e0ng, n\u00f3 v\u1eabn ch\u01b0a b\u1ecb \u1ea3nh h\u01b0\u1edfng b\u1edfi s\u1ed1 l\u01b0\u1ee3ng l\u1edbn n\u1ed9i dung ho\u1eb7c vi\u1ec7c th\u1eed nghi\u1ec7m r\u1ea5t nhi\u1ec1u plugin theo th\u1eddi gian.<\/li><li><strong>Can thi\u1ec7p v\u00e0o CSDL c\u00f3 th\u1ec3 g\u00e2y h\u1eadu qu\u1ea3 nghi\u00eam tr\u1ecdng n\u1ebfu kh\u00f4ng l\u00e0m \u0111\u00fang<\/strong>. Nh\u1eb9 th\u00ec m\u1ea5t d\u1eef li\u1ec7u, m\u00e0 n\u1eb7ng th\u00ec website kh\u00f4ng truy c\u1eadp \u0111\u01b0\u1ee3c. \u0110i\u1ec1u n\u00e0y d\u1eabn \u0111\u1ebfn h\u1ec7 qu\u1ea3 xo\u00e1y v\u00f2ng l\u00e0 nh\u1eefng b\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn v\u1ec1 t\u1ed1i \u01b0u h\u00f3a t\u1ed1c \u0111\u1ed9 cho WordPress (nh\u1ea5t l\u00e0 v\u1edbi nh\u1eefng ng\u01b0\u1eddi m\u1edbi) th\u01b0\u1eddng kh\u00f4ng \u0111\u1ec1 c\u1eadp nhi\u1ec1u \u0111\u1ebfn CSDL, h\u1ecd ch\u1ee7 y\u1ebfu ch\u1ec9 n\u00f3i \u1edf ph\u1ea7n r\u1ea5t n\u00f4ng l\u00e0 lo\u1ea1i b\u1ecf revision. C\u00e1c bi\u1ec7n ph\u00e1p kh\u00e1c nh\u01b0 t\u1ed1i \u01b0u h\u00f3a \u1ea3nh, cache, t\u1ed1i \u01b0u CSS, JS \u00edt r\u1ee7i ro h\u01a1n nhi\u1ec1u.<\/li><\/ul>\n\n\n<p>Ngay ch\u00ednh b\u1ea3n th\u00e2n t\u00f4i khi ngh\u0129 v\u1ec1 t\u1ed1i \u01b0u h\u00f3a CSDL l\u00fac \u0111\u1ea7u c\u0169ng ch\u1ec9 bi\u1ebft \u0111\u1ebfn revision! V\u1ec1 sau m\u1edbi bi\u1ebft c\u00f3 h\u00e0ng t\u00e1 v\u1ea5n \u0111\u1ec1 li\u00ean quan \u0111\u1ebfn b\u1ea3ng d\u1eef li\u1ec7u d\u01b0 th\u1eeba, c\u00e1c options v\u00e0 cron job th\u1eeba th\u00e3i.<\/p>\n\n\n<p>Nguy\u00ean nh\u00e2n h\u00e0ng \u0111\u1ea7u cho r\u1eafc r\u1ed1i n\u00e0y l\u00e0 <strong>qua th\u1eddi gian, r\u1ea5t nhi\u1ec1u giao di\u1ec7n, plugin \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i v\u00e0 g\u1ee1 tr\u00ean website c\u1ee7a ch\u00fang ta<\/strong>.<\/p>\n\n\n<p>B\u1ea1n s\u1ebd ph\u00e1t hi\u1ec7n ra l\u00e0 kh\u00f4ng ch\u1ec9 nh\u1eefng plugin b\u00ecnh th\u01b0\u1eddng, m\u00e0 ngay c\u1ea3 nh\u1eefng plugin n\u1ed5i ti\u1ebfng, \u0111\u01b0\u1ee3c \u0111\u00e1nh gi\u00e1 cao v\u1eabn th\u01b0\u1eddng \u0111\u1ec3 l\u1ea1i d\u1eef li\u1ec7u d\u01b0 th\u1eeba ch\u1ee9 kh\u00f4ng d\u1ecdn d\u1eb9p n\u00f3 ho\u00e0n to\u00e0n s\u1ea1ch s\u1ebd trong CSDL.<\/p>\n\n\n<p>C\u00f2n d\u01b0\u1edbi \u0111\u00e2y l\u00e0 h\u01b0\u1edbng d\u1eabn ng\u1eafn g\u1ecdn v\u00e0 nh\u1eefng ph\u00e1t hi\u1ec7n kh\u00e1c khi t\u00f4i d\u1ecdn d\u1eb9p 2 website (t\u1ed5ng hai trang c\u00f3 h\u01a1n 1000 b\u00e0i, v\u00e0 c\u00f3 tu\u1ed5i \u0111\u1eddi m\u1ed7i trang tr\u00ean 5 n\u0103m):<\/p>\n\n\n<ul><li><strong>C\u00f3 nh\u1eefng trang c\u00f3 th\u1ec3 c\u00f3 r\u1ea5t nhi\u1ec1u revisons c\u0169<\/strong>: M\u1ed9t trang c\u1ee7a t\u00f4i ch\u1ec9 c\u00f3 h\u01a1n 250 b\u00e0i vi\u1ebft nh\u01b0ng c\u00f3 \u0111\u1ebfn h\u01a1n 2000 revision! Tuy h\u01a1i ng\u1ea1c nhi\u00ean nh\u01b0ng c\u0169ng d\u1ec5 hi\u1ec3u, v\u00ec trang n\u00e0y \u0111\u01b0\u1ee3c ch\u0103m ch\u00fat n\u1ed9i dung r\u1ea5t nhi\u1ec1u. M\u1ed9t trang c\u00e0ng \u0111\u01b0\u1ee3c \u0111\u1ec3 \u00fd v\u1ec1 n\u1ed9i dung, n\u00f3 c\u00e0ng c\u00f3 xu h\u01b0\u1edbng \u0111\u01b0\u1ee3c ch\u1ec9nh s\u1eeda nhi\u1ec1u, v\u00e0 do v\u1eady l\u00e0m t\u0103ng revison&#8230; X\u00f3a revision c\u0169 l\u00e0 t\u00ednh n\u0103ng c\u00f3 c\u1ea3 \u1edf phi\u00ean b\u1ea3n tr\u1ea3 ph\u00ed l\u1eabn mi\u1ec5n ph\u00ed (thu\u1ed9c tab General clean up).<\/li><li><strong>\u0110\u1ec3 th\u1ef1c hi\u1ec7n ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u, h\u00e3y nh\u1ea5n v\u00e0o ph\u1ea7n Scan<\/strong>: \u1ede b\u1ea3ng c\u00f3 <em>Scan tables;<\/em>\u00a0\u1edf t\u00f9y ch\u1ecdn c\u00f3<em> Scan options<\/em>, \u1edf Cron jobs c\u00f3 <em>Scan tasks.\u00a0<\/em>V\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u1ee7a b\u1ea3ng:<img loading=\"lazy\" decoding=\"async\" width=\"869\" height=\"121\" class=\"size-full wp-image-14395 aligncenter\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/scan-tables.png\" alt=\"qu\u00e9t b\u1ea3ng\"><\/li><li><strong>C\u00f3 5 ph\u00e2n lo\u1ea1i d\u1eef li\u1ec7u v\u1ec1 ngu\u1ed3n g\u1ed1c c\u1ee7a n\u00f3, bao g\u1ed3m<\/strong>: WP, ngh\u0129a l\u00e0 c\u1ee7a WordPress. Themes ngh\u0129a l\u00e0 c\u1ee7a giao di\u1ec7n. Plugins ngh\u0129a l\u00e0 c\u1ee7a c\u00e1c plugin. Orphans, ngh\u0129a l\u00e0 d\u1eef li\u1ec7u d\u01b0 th\u1eeba. Cu\u1ed1i c\u00f9ng Uncategorized ngh\u0129a l\u00e0 v\u1eabn Ch\u01b0a ph\u00e2n lo\u1ea1i. V\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y c\u00e1c b\u1ea3ng CSDL \u0111\u01b0\u1ee3c Advanced Database Cleaner ph\u00e2n lo\u1ea1i nh\u01b0 th\u1ebf n\u00e0o trong m\u1ed9t website:<img loading=\"lazy\" decoding=\"async\" width=\"868\" height=\"158\" class=\"size-full wp-image-14390 aligncenter\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/phan-loai-bang.png\" alt=\"ph\u00e2n lo\u1ea1i b\u1ea3ng\"><\/li><li><strong>C\u00f3 nh\u1eefng b\u1ea3ng d\u01b0 th\u1eeba c\u00f3 th\u1ec3 c\u00f3 dung l\u01b0\u1ee3ng r\u1ea5t l\u1edbn<\/strong>: Ch\u1eb3ng h\u1ea1n <a href=\"https:\/\/kiencang.net\/plugin-ewww-image-optimizer\/\" target=\"_blank\" rel=\"noreferrer noopener\">plugin EWWW<\/a> t\u1ea1o ra m\u1ed9t b\u1ea3ng l\u00ean \u0111\u1ebfn h\u01a1n 11 MB, chi\u1ebfm kho\u1ea3ng 10% dung l\u01b0\u1ee3ng CSDL c\u1ee7a c\u1ea3 website. M\u1ed9t v\u00ed d\u1ee5 kh\u00e1c, <a href=\"https:\/\/wordpress.org\/plugins\/wordfence\/\" target=\"_blank\" rel=\"noreferrer noopener\">plugin Wordfence Security<\/a> c\u0169ng t\u1ea1o ra nhi\u1ec1u b\u1ea3ng d\u1eef li\u1ec7u kho\u1ea3ng 4 &#8211; 5 MB. V\u1ea5n \u0111\u1ec1 l\u00e0 khi b\u1ea1n \u0111ang c\u1ea7n d\u00f9ng c\u00e1c plugin n\u00e0y th\u00ec d\u1eef li\u1ec7u trong MySQL nh\u01b0 v\u1eady kh\u00f4ng ph\u1ea3i vi\u1ec7c g\u00ec t\u1ec7 h\u1ea1i, nh\u01b0ng n\u1ebfu \u0111\u00e3 g\u1ee1 b\u1ecf \u0111i r\u1ed3i m\u00e0 n\u00f3 v\u1eabn b\u1ecf l\u1ea1i l\u01b0\u1ee3ng d\u1eef li\u1ec7u l\u1edbn nh\u01b0 th\u1ebf th\u00ec kh\u00f4ng \u1ed5n ch\u00fat n\u00e0o. C\u1ea3 2 plugin t\u00f4i v\u1eeba n\u00f3i \u0111\u1ec1u n\u1ed5i ti\u1ebfng trong c\u1ed9ng \u0111\u1ed3ng, \u0111\u1eb7c bi\u1ec7t l\u00e0 Wordfence Security v\u1edbi h\u01a1n 3 tri\u1ec7u l\u01b0\u1ee3t c\u00e0i v\u00e0 h\u01a1n 3000 \u0111\u00e1nh gi\u00e1 5 sao.<\/li><li><strong>Tr\u01b0\u1edbc khi x\u00f3a lu\u00f4n d\u1eef li\u1ec7u lu\u00f4n ph\u1ea3i ki\u1ec3m tra xem n\u00f3 thu\u1ed9c v\u1ec1 plugin\/theme n\u00e0o<\/strong>: L\u00fd do l\u00e0 c\u00f4ng c\u1ee5 ph\u00e2n lo\u1ea1i m\u1eb7c \u0111\u1ecbnh c\u1ee7a plugin Advanced Database Cleaner kh\u00f4ng ho\u00e0n h\u1ea3o, do \u0111\u00f3 n\u1ebfu b\u1ea1n th\u1ea5y n\u00f3 ph\u00e2n lo\u1ea1i l\u00e0 Orphans r\u1ed3i b\u1ea1n c\u1ee9 th\u1ebf x\u00f3a th\u00ec r\u1ea5t nguy hi\u1ec3m. Ph\u00e2n lo\u1ea1i c\u1ee7a n\u00f3 ch\u1ec9 l\u00e0 b\u01b0\u1edbc \u0111\u1ea7u \u0111\u1ec3 b\u1ea1n \u0111\u1ee1 t\u1ed1n th\u1eddi gian th\u00f4i. Ki\u1ec3m tra c\u0169ng \u0111\u01a1n gi\u1ea3n, b\u1ea1n copy v\u00e0 \u0111\u01b0a n\u00f3 l\u00ean m\u00e1y t\u00ecm ki\u1ebfm \u0111\u1ec3 soi (s\u1eed d\u1ee5ng d\u1ea5u nh\u00e1y k\u00e9p trong t\u00ecm ki\u1ebfm n\u1ebfu c\u1ea7n), h\u1ea7u h\u1ebft tr\u01b0\u1eddng h\u1ee3p (v\u1edbi t\u00f4i l\u00e0 h\u01a1n 70%) b\u1ea1n s\u1ebd c\u00f3 \u0111\u01b0\u1ee3c c\u00e2u tr\u1ea3 l\u1eddi ch\u00ednh x\u00e1c.<\/li><li><strong>V\u00ed d\u1ee5 v\u1ec1 tr\u01b0\u1eddng h\u1ee3p \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh l\u00e0 Orphans nh\u01b0ng th\u1ef1c ra kh\u00f4ng ph\u1ea3i<\/strong>: H\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y Advanced Database Cleaner x\u00e1c \u0111\u1ecbnh puc_cron_check_updates-ad-inserter-pro l\u00e0 orphans, nh\u01b0ng \u0111i\u1ec1u n\u00e0y kh\u00f4ng \u0111\u00fang, v\u00ec cron jobs n\u00e0y thu\u1ed9c v\u1ec1 plugin \u0111ang \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t tr\u00ean website c\u1ee7a t\u00f4i l\u00e0 <a href=\"https:\/\/kiencang.net\/ad-inserter-ma-tuy-chinh-trong-wordpress\/\">Ad Inserter<\/a>.<img loading=\"lazy\" decoding=\"async\" width=\"857\" height=\"209\" class=\"size-full wp-image-14391 aligncenter\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/xac-dinh-orphans-nham.png\" alt=\"x\u00e1c \u0111\u1ecbnh orphans nh\u1ea7m\"><\/li><li><strong>N\u1ebfu Orphans ch\u01b0a ch\u1eafc \u0111\u00e3 l\u00e0 Orphans th\u1ef1c th\u00ec tr\u01b0\u1eddng h\u1ee3p ng\u01b0\u1ee3c l\u1ea1i c\u0169ng \u0111\u00fang<\/strong>: \u0110i\u1ec1u \u1ea5y c\u00f3 ngh\u0129a l\u00e0 m\u1ed9t d\u1eef li\u1ec7u n\u00e0o \u0111\u1ea5y \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh l\u00e0 thu\u1ed9c plugin \u0111ang \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t nh\u01b0ng th\u1ef1c ra l\u1ea1i l\u00e0 d\u1eef li\u1ec7u d\u01b0 th\u1eeba. Tuy nhi\u00ean \u0111i\u1ec1u n\u00e0y ph\u1ea3i ki\u1ec3m tra th\u1eadt k\u1ef9, b\u1edfi n\u1ebfu b\u1ea1n nh\u1ea7m, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m h\u1ecfng ch\u1ee9c n\u0103ng c\u1ee7a plugin.<\/li><li><strong>R\u1eafc r\u1ed1i th\u01b0\u1eddng n\u1eb1m \u1edf m\u1ee5c Options<\/strong>: \u00cdt nh\u1ea5t \u0111\u1ed1i v\u1edbi t\u00f4i, v\u00ec m\u1eabu website \u0111\u01b0a v\u00e0o th\u1eed nghi\u1ec7m kh\u00f4ng nhi\u1ec1u \u0111\u1ec3 d\u00e1m kh\u1eb3ng \u0111\u1ecbnh t\u1ed5ng qu\u00e1t. Tr\u00ean c\u1ea3 hai trang c\u1ee7a t\u00f4i, b\u1ea3ng (table) v\u00e0 cron jobs d\u01b0 th\u1eeba kh\u00f4ng qu\u00e1 nhi\u1ec1u, do v\u1eady kh\u00f4ng t\u1ed1n th\u1eddi gian \u0111\u1ec3 ki\u1ec3m tra. Trong khi b\u1ea3ng options c\u00f3 \u0111\u1ebfn h\u00e0ng ngh\u00ecn d\u00f2ng (s\u1ef1 th\u1eadt l\u00e0 m\u1ed9t trong hai website c\u1ee7a t\u00f4i c\u00f3 \u0111\u1ebfn h\u01a1n 70 ng\u00e0n d\u00f2ng \u1edf ph\u1ea7n options! May m\u1eafn l\u00e0 97% trong s\u1ed1 \u0111\u00f3 \u0111\u1ebfn t\u1eeb c\u00f9ng m\u1ed9t ngu\u1ed3n n\u00ean t\u00f4i d\u1ec5 d\u00e0ng x\u00f3a b\u1ecf, ch\u1ec9 \u0111\u1ec3 l\u1ea1i kho\u1ea3ng 1000 d\u00f2ng \u0111\u1ec3 ki\u1ec3m tra).<img loading=\"lazy\" decoding=\"async\" width=\"873\" height=\"162\" class=\"size-full wp-image-14389 aligncenter\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/options-orphans.png\" alt=\"options th\u01b0\u1eddng nhi\u1ec1u r\u1eafc r\u1ed1i nh\u1ea5t\"><\/li><li><strong>T\u1eadn d\u1ee5ng ch\u1ee9c n\u0103ng t\u00ecm ki\u1ebfm, l\u1ecdc (filter)<\/strong>: Gi\u00fap b\u1ea1n r\u00fat g\u1ecdn d\u1eef li\u1ec7u \u0111\u1ec3 d\u1ec5 quan s\u00e1t v\u00e0 ki\u1ec3m tra h\u01a1n.<img loading=\"lazy\" decoding=\"async\" width=\"471\" height=\"64\" class=\"size-full wp-image-14396 aligncenter\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/loc-jetpack.png\" alt=\"v\u00ed d\u1ee5 v\u1ec1 t\u00ednh n\u0103ng l\u1ecdc\"><\/li><li><strong>T\u1eadn d\u1ee5ng ch\u1ee9c n\u0103ng Option name<\/strong>: Ch\u1ee9c n\u0103ng s\u1eafp x\u1ebfp theo t\u00ean n\u00e0y c\u00f3 \u00edch l\u00e0 v\u00ec c\u00e1c ngu\u1ed3n d\u1eef li\u1ec7u \u0111\u1ebfn t\u1eeb c\u00f9ng plugin ho\u1eb7c theme hay c\u00f3 ph\u1ea7n <em>ti\u1ec1n t\u1ed1<\/em> gi\u1ed1ng nhau, v\u00ed d\u1ee5: <em>fontResizer<\/em>_cookieTime, <em>fontResizer<\/em>_maxFontsize, <em>fontResizer<\/em>_minFontsize. B\u1ea1n c\u00f3 \u0111\u1ec3 \u00fd \u0111\u1ebfn ti\u1ec1n t\u1ed1 <em>fontResizer<\/em> xu\u1ea5t hi\u1ec7n \u1edf c\u1ea3 3 kh\u00f4ng?<img loading=\"lazy\" decoding=\"async\" width=\"847\" height=\"559\" class=\"size-full wp-image-14397 aligncenter\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/sap-xep-the-ten.png\" alt=\"s\u1eafp x\u1ebfp theo t\u00ean, ph\u00e2n nh\u00f3m theo ki\u1ec3u d\u1eef li\u1ec7u\"><\/li><li><strong>N\u1ebfu do d\u1ef1 th\u00ec \u0111\u1eebng x\u00f3a!<\/strong>: CSDL gi\u1ed1ng nh\u01b0 n\u1ed9i t\u1ea1ng c\u1ee7a website, \u1ea3nh th\u00ec gi\u1ed1ng nh\u01b0 ki\u1ec3u t\u00f3c. N\u1ebfu ch\u1eb3ng may b\u1ea1n c\u1eaft t\u00f3c x\u1ea5u b\u1ea1n v\u1eabn s\u1ed1ng b\u00ecnh th\u01b0\u1eddng \u0111\u01b0\u1ee3c (b\u1eb1ng c\u00e1ch \u0111\u1ed9i m\u0169). Nh\u01b0ng s\u1ebd kh\u00f4ng ai b\u00ecnh th\u01b0\u1eddng \u0111\u01b0\u1ee3c c\u1ea3 n\u1ebfu khi ph\u1eabu thu\u1eadt b\u1ecb ng\u01b0\u1eddi n\u00e0o \u0111\u00f3 c\u1eaft nh\u1ea7m d\u1ea1 d\u00e0y. So s\u00e1nh \u0111\u1ec3 b\u1ea1n th\u1ea5y <em>\u0111\u1eebng li\u1ec1u v\u1edbi CSDL<\/em>. N\u1ebfu do d\u1ef1, \u0111\u1eebng l\u00e0m g\u00ec c\u1ea3.<\/li><li><strong>T\u1ed1i \u01b0u h\u00f3a xong th\u00ec n\u00ean t\u1eaft plugin \u0111i<\/strong>: Tr\u1eeb khi web c\u1ee7a b\u1ea1n r\u1ea5t l\u1edbn v\u00e0 s\u00f4i \u0111\u1ed9ng (nhi\u1ec1u ng\u01b0\u1eddi gh\u00e9 th\u0103m, c\u00f3 n\u1ed9i dung m\u1edbi th\u01b0\u1eddng xuy\u00ean, ho\u1eb7c nhi\u1ec1u b\u00ecnh lu\u1eadn, v\u00e2n v\u00e2n) c\u00f2n kh\u00f4ng th\u00ec n\u00ean t\u1eaft plugin n\u00e0y \u0111i sau khi t\u1ed1i \u01b0u, v\u00e0i th\u00e1ng d\u00f9ng m\u1ed9t l\u1ea7n l\u00e0 \u1ed5n. N\u00f3 gi\u1ed1ng nh\u01b0 thi\u1ebft b\u1ecb quan tr\u1ecdng nh\u01b0ng \u00edt khi ph\u1ea3i d\u00f9ng, khi \u1ea5y d\u00f9ng xong ch\u00fang ta th\u01b0\u1eddng c\u1ea5t n\u00f3 k\u1ef9 \u0111\u1ec3 \u0111\u1ee1 chi\u1ebfm kh\u00f4ng gian.<\/li><li><strong>T\u1ed1i \u01b0u h\u00f3a CSDL c\u00f3 \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ed1t nh\u1ea5t khi ph\u1ed1i h\u1ee3p c\u00f4ng c\u1ee5 t\u1ef1 \u0111\u1ed9ng v\u00e0 vi\u1ec7c t\u1ed1i \u01b0u h\u00f3a th\u1ee7 c\u00f4ng<\/strong>: B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft n\u00e0y v\u1ec1 c\u00e1c <a href=\"https:\/\/kiencang.net\/toi-uu-hoa-csdl-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">kinh nghi\u1ec7m t\u1ed1i \u01b0u CSDL WordPress theo c\u00e1ch th\u1ee7 c\u00f4ng<\/a>.<\/li><\/ul>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n<h2 class=\"wp-block-heading\" id=\"b\u1ea3n-pro-c\u1ee7a-plugin-nay-co-dang-mua-khong\"><span class=\"ez-toc-section\" id=\"Ban_pro_cua_plugin_nay_co_dang_mua_khong\"><\/span>B\u1ea3n pro c\u1ee7a plugin n\u00e0y c\u00f3 \u0111\u00e1ng mua kh\u00f4ng?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>T\u00f4i ngh\u0129 l\u00e0 c\u00f3, \u0111\u1eb7c bi\u1ec7t n\u1ebfu website c\u1ee7a b\u1ea1n l\u00e0 trang th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed v\u00e0 v\u00e0i n\u0103m r\u1ed3i b\u1ea1n ch\u01b0a th\u1ef1c hi\u1ec7n t\u1ed1i \u01b0u h\u00f3a CSDL.<\/p>\n\n\n<p>L\u00fd do?<\/p>\n\n\n<p>B\u1ea3n mi\u1ec5n ph\u00ed c\u1ee7a plugin n\u00e0y, c\u0169ng nh\u01b0 c\u00e1c phi\u00ean b\u1ea3n mi\u1ec5n ph\u00ed c\u1ee7a plugin t\u01b0\u01a1ng t\u1ef1 kh\u00e1c ch\u1ec9 gi\u1edbi h\u1ea1n \u1edf t\u00ednh n\u0103ng d\u1ecdn d\u1eb9p c\u01a1 b\u1ea3n nh\u01b0 x\u00f3a revisons, b\u00ecnh lu\u1eadn spam, commentmeta, postmeta, usermeta, v\u00e2n v\u00e2n (v\u00e0i c\u00e1i trong s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 l\u00e0m th\u1ee7 c\u00f4ng, kh\u00f4ng c\u1ea7n plugin). C\u00f2n c\u00e1c t\u00ednh n\u0103ng quan tr\u1ecdng h\u01a1n (v\u00e0 c\u0169ng kh\u00f3 h\u01a1n) nh\u01b0 ph\u00e2n lo\u1ea1i v\u00e0 t\u00ecm orphans \u1edf table, options v\u00e0 cron jobs ch\u1ec9 c\u00f3 \u1edf phi\u00ean b\u1ea3n c\u00f3 ph\u00ed m\u00e0 th\u00f4i.<\/p>\n\n\n<p>\u01afu \u0111i\u1ec3m c\u1ee7a plugin tr\u1ea3 ph\u00ed n\u00e0y l\u00e0 c\u1eadp nh\u1eadt tr\u1ecdn \u0111\u1eddi, n\u00f3 t\u00ednh ti\u1ec1n d\u1ef1a tr\u00ean s\u1ed1 l\u01b0\u1ee3ng website b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng. N\u1ebfu mu\u1ed1n mua m\u1ed9t b\u1ea3n, h\u00e3y truy c\u1eadp website n\u00e0y: <a href=\"https:\/\/sigmaplugin.com\/downloads\/wordpress-advanced-database-cleaner\" target=\"_blank\" rel=\"noreferrer noopener\">sigmaplugin.com\/downloads\/wordpress-advanced-database-cleaner<\/a><\/p>\n\n\n<p>Ch\u1ed1t h\u1ea1: qua ph\u1ea7n n\u00e0y ch\u00fang ta th\u1ea5y r\u1eb1ng l\u1ef1a ch\u1ecdn theme v\u00e0 \u0111\u1eb7c bi\u1ec7t l\u00e0 plugin \u0111\u1ec3 c\u00e0i tr\u00ean website r\u1ea5t quan tr\u1ecdng. Plugin ch\u1ea5t l\u01b0\u1ee3ng k\u00e9m s\u1ebd t\u1ea1o ra nhi\u1ec1u r\u1eafc r\u1ed1i ti\u1ec1m \u1ea9n. T\u1ea5t nhi\u00ean t\u00f4i kh\u00f4ng th\u1ec3 b\u1ea3o b\u1ea1n ng\u1eebng th\u1eed nghi\u1ec7m plugin \u0111\u01b0\u1ee3c &#8211; \u0111\u00f3 l\u00e0 l\u1eddi khuy\u00ean ng\u1edb ng\u1ea9n, nh\u01b0ng b\u1ea1n c\u1ea7n c\u1ea9n tr\u1ecdng h\u01a1n b\u1eb1ng c\u00e1ch x\u00e1c \u0111\u1ecbnh th\u1eadt r\u00f5 r\u00e0ng nhu c\u1ea7u c\u1ee7a website, l\u1ef1a ch\u1ecdn t\u00e1c gi\u1ea3 uy t\u00edn v\u00e0 ki\u00ean quy\u1ebft lo\u1ea1i b\u1ecf c\u00e1c t\u00ednh n\u0103ng kh\u00f4ng c\u1ea7n thi\u1ebft.<\/p>\n\n\n<p>P\/S: N\u1ebfu b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf ho\u00e0n to\u00e0n lo l\u1eafng v\u1ec1 CSDL h\u00e3y th\u1eed <a href=\"https:\/\/kiencang.net\/gioi-thieu-plugin-wp2static\/\" target=\"_blank\" rel=\"noreferrer noopener\">plugin WP2Static<\/a>, n\u00f3 s\u1ebd chuy\u1ec3n trang WordPress \u0111\u1ed9ng c\u1ee7a b\u1ea1n th\u00e0nh t\u0129nh ho\u00e0n to\u00e0n, kh\u00f4ng PHP, kh\u00f4ng MySQL. Tuy r\u1eb1ng kh\u00f4ng ph\u1ea3i website n\u00e0o c\u0169ng ph\u00f9 h\u1ee3p nh\u01b0ng khi \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng \u0111\u00fang n\u00f3 \u0111em l\u1ea1i c\u1ea3i thi\u1ec7n tr\u00ean nhi\u1ec1u ph\u01b0\u01a1ng di\u1ec7n: t\u1ed1c \u0111\u1ed9, uptime, b\u1ea3o m\u1eadt v\u00e0 chi ph\u00ed.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>L\u00e0m s\u1ea1ch database (C\u01a1 s\u1edf d\u1eef li\u1ec7u \/ CSDL) b\u1eb1ng c\u00e1ch lo\u1ea1i b\u1ecf c\u00e1c th\u00e0nh ph\u1ea7n kh\u00f4ng h\u1eefu \u00edch (*) nh\u01b0 &#8220;c\u00e1c phi\u00ean b\u1ea3n c\u0169 c\u1ee7a b\u00e0i vi\u1ebft \/ old revisions (**)&#8221;, &#8220;c\u00e1c b\u00ecnh lu\u1eadt spam&#8220;, th\u1ef1c hi\u1ec7n t\u1ed1i \u01b0u h\u00f3a CSDL (c\u01a1 s\u1edf d\u1eef li\u1ec7u), v\u00e2n v\u00e2n. (*): T\u1eeb g\u1ed1c ti\u1ebfng Anh l\u00e0 orphaned &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>Gi\u1edbi thi\u1ec7u plugin Advanced Database Cleaner gi\u00fap t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u 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\/plugin-advanced-database-cleaner\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gi\u1edbi thi\u1ec7u plugin Advanced Database Cleaner gi\u00fap t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"L\u00e0m s\u1ea1ch database (C\u01a1 s\u1edf d\u1eef li\u1ec7u \/ CSDL) b\u1eb1ng c\u00e1ch lo\u1ea1i b\u1ecf c\u00e1c th\u00e0nh ph\u1ea7n kh\u00f4ng h\u1eefu \u00edch (*) nh\u01b0 &#8220;c\u00e1c phi\u00ean b\u1ea3n c\u0169 c\u1ee7a b\u00e0i vi\u1ebft \/ old revisions (**)&#8221;, &#8220;c\u00e1c b\u00ecnh lu\u1eadt spam&#8220;, th\u1ef1c hi\u1ec7n t\u1ed1i \u01b0u h\u00f3a CSDL (c\u01a1 s\u1edf d\u1eef li\u1ec7u), v\u00e2n v\u00e2n. (*): T\u1eeb g\u1ed1c ti\u1ebfng Anh l\u00e0 orphaned &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/\" \/>\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-07T12:02:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/scan-tables.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=\"25 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Gi\u1edbi thi\u1ec7u plugin Advanced Database Cleaner gi\u00fap t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u 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\/plugin-advanced-database-cleaner\/","og_locale":"vi_VN","og_type":"article","og_title":"Gi\u1edbi thi\u1ec7u plugin Advanced Database Cleaner gi\u00fap t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress &#8226; Ki\u1ebfn c\u00e0ng","og_description":"L\u00e0m s\u1ea1ch database (C\u01a1 s\u1edf d\u1eef li\u1ec7u \/ CSDL) b\u1eb1ng c\u00e1ch lo\u1ea1i b\u1ecf c\u00e1c th\u00e0nh ph\u1ea7n kh\u00f4ng h\u1eefu \u00edch (*) nh\u01b0 &#8220;c\u00e1c phi\u00ean b\u1ea3n c\u0169 c\u1ee7a b\u00e0i vi\u1ebft \/ old revisions (**)&#8221;, &#8220;c\u00e1c b\u00ecnh lu\u1eadt spam&#8220;, th\u1ef1c hi\u1ec7n t\u1ed1i \u01b0u h\u00f3a CSDL (c\u01a1 s\u1edf d\u1eef li\u1ec7u), v\u00e2n v\u00e2n. (*): T\u1eeb g\u1ed1c ti\u1ebfng Anh l\u00e0 orphaned &hellip;","og_url":"https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2020-02-07T12:02:33+00:00","og_image":[{"url":"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/scan-tables.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":"25 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/","url":"https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/","name":"Gi\u1edbi thi\u1ec7u plugin Advanced Database Cleaner gi\u00fap t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u WordPress &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2020-02-07T12:02:33+00:00","dateModified":"2020-02-07T12:02:33+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"Gi\u1edbi thi\u1ec7u plugin Advanced Database Cleaner gi\u00fap t\u1ed1i \u01b0u c\u01a1 s\u1edf d\u1eef li\u1ec7u 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\/14351"}],"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=14351"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/14351\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=14351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=14351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=14351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}