{"id":16844,"date":"2022-02-12T21:08:00","date_gmt":"2022-02-12T14:08:00","guid":{"rendered":"https:\/\/kiencang.net\/?p=14420"},"modified":"2023-07-24T03:34:49","modified_gmt":"2023-07-23T20:34:49","slug":"toi-uu-database-wordpress-toan-dien","status":"publish","type":"post","link":"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/","title":{"rendered":"T\u1ed1i \u01b0u database WordPress: H\u01b0\u1edbng d\u1eabn to\u00e0n di\u1ec7n"},"content":{"rendered":"\n<p>Nh\u1eadn x\u00e9t c\u1ee7a ng\u01b0\u1eddi d\u1ecbch: Trong s\u1ed1 c\u00e1c b\u00e0i vi\u1ebft v\u1ec1 database c\u1ee7a WordPress tr\u00ean website n\u00e0y, t\u00f4i \u01b0ng b\u00e0i n\u00e0y nh\u1ea5t, v\u00ec n\u00f3 h\u01b0\u1edbng \u0111\u1ebfn c\u00e1c gi\u1ea3i th\u00edch t\u1ed1i \u01b0u c\u0103n b\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u. B\u1ea1n s\u1ebd v\u1ee1 ra \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1ee9 sau khi \u0111\u1ecdc xong. Tuy nhi\u00ean nh\u01b0 m\u1ecdi b\u00e0i vi\u1ebft kh\u00e1c, n\u00f3 kh\u00f4ng ho\u00e0n h\u1ea3o, v\u00e0 \u0111i\u1ec3m d\u1ec5 nh\u1eadn th\u1ea5y nh\u1ea5t l\u00e0 c\u00e1c plugin m\u00e0 t\u00e1c gi\u1ea3 \u0111\u1ec1 c\u1eadp t\u1edbi. Ngo\u1ea1i tr\u1eeb plugin li\u00ean quan \u0111\u1ebfn transients l\u00e0 v\u1eabn \u0111\u01b0\u1ee3c ng\u01b0\u1eddi ph\u00e1t tri\u1ec3n c\u1eadp nh\u1eadt, c\u00f2n th\u00ec nhi\u1ec1u plugin kh\u00e1c \u0111\u1ec1u \u0111\u00e3 qu\u00e1 c\u0169, trong khi c\u00e1c plugin li\u00ean quan \u0111\u1ebfn CSDL (C\u01a1 s\u1edf d\u1eef li\u1ec7u \/ Database) th\u00ec kh\u00f4ng n\u00ean s\u1eed d\u1ee5ng plugin kh\u00f4ng c\u1eadp nh\u1eadt, v\u00ec sai s\u00f3t x\u1ea3y ra s\u1ebd r\u1ea5t tai h\u1ea1i. N\u1ebfu kh\u00f4ng t\u00ednh v\u1ea5n \u0111\u1ec1 v\u1eeba n\u00f3i th\u00ec b\u00e0i vi\u1ebft r\u1ea5t \u1ed5n, c\u1ef1c k\u1ef3 c\u0103n b\u1ea3n, hy v\u1ecdng s\u1ebd gi\u00fap b\u1ea1n c\u00f3 c\u00e1i nh\u00ecn chi ti\u1ebft h\u01a1n v\u1ec1 t\u1ed1i \u01b0u database WordPress.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<p>L\u1eddi khuy\u00ean cu\u1ed1i c\u00f9ng c\u1ee7a t\u00f4i l\u00e0 b\u1ea1n n\u00ean k\u1ebft h\u1ee3p bi\u1ec7n ph\u00e1p <a href=\"https:\/\/kiencang.net\/toi-uu-hoa-csdl-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">t\u1ed1i \u01b0u h\u00f3a CSDL theo c\u00e1ch th\u1ee7 c\u00f4ng<\/a> + plugin t\u1ed1i \u01b0u database ch\u1ea5t l\u01b0\u1ee3ng nh\u01b0 l\u00e0 <a href=\"https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/\" target=\"_blank\" rel=\"noreferrer noopener\">Advanced Database Cleaner<\/a>.<\/p>\n\n\n\n<p>&#8212;<\/p>\n\n\n\n<p>Database WordPress c\u1ee7a b\u1ea1n l\u01b0u gi\u1eef to\u00e0n b\u1ed9 n\u1ed9i dung c\u1ee7a website. \u0110i\u1ec1u n\u00e0y bao g\u1ed3m b\u00e0i \u0111\u0103ng blog d\u1ea1ng post, d\u1ea1ng page, b\u00ecnh lu\u1eadn, v\u00e0 c\u00e1c \u0111\u1ecbnh d\u1ea1ng post t\u00f9y ch\u1ec9nh nh\u01b0 c\u00e1c li\u00ean k\u1ebft, n\u1ed9i dung nh\u1eadp v\u00e0o form, v\u00e0 c\u00e1c th\u00e0nh ph\u1ea7n portfolio. N\u00f3 c\u0169ng l\u01b0u tr\u1eef c\u00e1c c\u00e0i \u0111\u1eb7t c\u1ee7a website, giao di\u1ec7n v\u00e0 plugin.<\/p>\n\n\n\n<p>N\u1ebfu b\u1ea1n c\u1eadp nh\u1eadt website th\u01b0\u1eddng xuy\u00ean, database c\u1ee7a b\u1ea1n s\u1ebd l\u1edbn d\u1ea7n l\u00ean theo th\u1eddi gian. M\u1ed9t database l\u1edbn c\u00f3 th\u1ec3 \u1ea3nh h\u01b0\u1edfng m\u1ea1nh \u0111\u1ebfn hi\u1ec7u su\u1ea5t (performance) c\u1ee7a website c\u0169ng nh\u01b0 g\u00e2y ra hi\u1ec7n t\u01b0\u1ee3ng m\u00e1y ch\u1ee7 c\u1ee7a b\u1ea1n m\u1ea5t nhi\u1ec1u th\u1eddi gian h\u01a1n \u0111\u1ec3 xu\u1ea5t\/nh\u1eadp th\u00f4ng tin t\u1eeb b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u (database tables). \u0110i\u1ec1u \u0111\u00f3 gi\u1ea3i th\u00edch v\u00ec sao t\u1ed1i \u01b0u h\u00f3a database l\u1ea1i quan tr\u1ecdng \u0111\u1ebfn v\u1eady.<\/p>\n\n\n\n<p>B\u1eb1ng c\u00e1ch <strong>lo\u1ea1i b\u1ecf c\u00e1c d\u1eef li\u1ec7u kh\u00f4ng c\u1ea7n thi\u1ebft<\/strong>, b\u1ea1n c\u00f3 th\u1ec3 c\u1ea3i thi\u1ec7n \u0111\u01b0\u1ee3c t\u00ednh hi\u1ec7u qu\u1ea3 c\u1ee7a database v\u00e0 l\u00e0m cho website c\u1ee7a b\u1ea1n t\u1ea3i nhanh h\u01a1n. Ch\u00fang ta s\u1ebd c\u00f9ng nhau \u0111i t\u1eebng b\u01b0\u1edbc \u0111\u1ec3 \u0111\u1ea1t \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3.<\/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-6577d6337c0ef\" ><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-6577d6337c0ef\"  type=\"checkbox\" id=\"item-6577d6337c0ef\"><\/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-toan-dien\/#Tim_hieu_database_cua_WordPress\" title=\"T\u00ecm hi\u1ec3u database c\u1ee7a WordPress\">T\u00ecm hi\u1ec3u database c\u1ee7a WordPress<\/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-toan-dien\/#Cach_de_toi_uu_hoa_va_sua_chua_database_trong_WordPress\" title=\"C\u00e1ch \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a v\u00e0 s\u1eeda ch\u1eefa database trong WordPress\">C\u00e1ch \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a v\u00e0 s\u1eeda ch\u1eefa database trong WordPress<\/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-toan-dien\/#Lam_the_nao_de_loai_bo_hien_tuong_phinh_to_database_trong_WordPress\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 lo\u1ea1i b\u1ecf hi\u1ec7n t\u01b0\u1ee3ng ph\u00ecnh to database trong WordPress\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 lo\u1ea1i b\u1ecf hi\u1ec7n t\u01b0\u1ee3ng ph\u00ecnh to database trong WordPress<\/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-toan-dien\/#Xoa_bo_cac_items\" title=\"X\u00f3a b\u1ecf c\u00e1c items\">X\u00f3a b\u1ecf c\u00e1c items<\/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-toan-dien\/#WordPress_Transients\" title=\"WordPress Transients\">WordPress Transients<\/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-toan-dien\/#Cac_bang_cua_plugin_va_giao_dien_khong_su_dung\" title=\"C\u00e1c b\u1ea3ng c\u1ee7a plugin v\u00e0 giao di\u1ec7n kh\u00f4ng s\u1eed d\u1ee5ng\">C\u00e1c b\u1ea3ng c\u1ee7a plugin v\u00e0 giao di\u1ec7n kh\u00f4ng s\u1eed d\u1ee5ng<\/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-toan-dien\/#Cac_plugin_gay_cong_kenh\" title=\"C\u00e1c plugin g\u00e2y c\u1ed3ng k\u1ec1nh\">C\u00e1c plugin g\u00e2y c\u1ed3ng k\u1ec1nh<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/#Cach_toi_uu_database_cua_ban_bang_plugin\" title=\"C\u00e1ch t\u1ed1i \u01b0u database c\u1ee7a b\u1ea1n b\u1eb1ng plugin\">C\u00e1ch t\u1ed1i \u01b0u database c\u1ee7a b\u1ea1n b\u1eb1ng plugin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/#Vai_suy_nghi_cuoi_cung\" title=\"V\u00e0i suy ngh\u0129 cu\u1ed1i c\u00f9ng\">V\u00e0i suy ngh\u0129 cu\u1ed1i c\u00f9ng<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/#Bonus_cua_nguoi_dich\" title=\"Bonus c\u1ee7a ng\u01b0\u1eddi d\u1ecbch\">Bonus c\u1ee7a ng\u01b0\u1eddi d\u1ecbch<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"tim-hi\u1ec3u-database-c\u1ee7a-wordpress\"><span class=\"ez-toc-section\" id=\"Tim_hieu_database_cua_WordPress\"><\/span>T\u00ecm hi\u1ec3u database c\u1ee7a WordPress<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>N\u1ebfu b\u1ea1n <a href=\"https:\/\/kiencang.net\/huong-dan-su-dung-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">s\u1eed d\u1ee5ng WordPress<\/a> \u0111\u1ec3 xu\u1ea5t b\u1ea3n n\u1ed9i dung l\u00ean internet, t\u00f4i tin r\u1eb1ng b\u1ea1n s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c nhi\u1ec1u l\u1ee3i \u00edch khi t\u00ecm hi\u1ec3u c\u00e1c b\u1ea3ng database quan tr\u1ecdng trong WordPress; \u0111\u1eb7c bi\u1ec7t l\u00e0 n\u1ebfu b\u1ea1n \u0111ang c\u00f3 \u00fd \u0111\u1ecbnh t\u1ed1i \u01b0u h\u00f3a database trang web c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<p>WordPress hi\u1ec7n c\u00f3 <a href=\"http:\/\/codex.wordpress.org\/Database_Description\" target=\"_blank\" rel=\"noreferrer noopener\">11 b\u1ea3ng l\u00f5i<\/a> (\u0111i\u1ec1u n\u00e0y, d\u0129 nhi\u00ean l\u00e0 s\u1ebd c\u00f3 kh\u1ea3 n\u0103ng thay \u0111\u1ed5i v\u00e0o b\u1ea5t k\u1ef3 l\u00fac n\u00e0o \u1edf c\u00e1c phi\u00ean b\u1ea3n c\u1eadp nh\u1eadt trong t\u01b0\u01a1ng lai c\u1ee7a WordPress). H\u1ea7u h\u1ebft c\u00e1c website WordPress c\u00f3 th\u00eam h\u00e0ng t\u00e1 b\u1ea3ng b\u1edfi v\u00ec c\u00e1c plugin l\u01b0u c\u00e1c c\u00e0i \u0111\u1eb7t v\u00e0 d\u1eef li\u1ec7u kh\u00e1c trong database c\u1ee7a WordPress. C\u00e1c giao di\u1ec7n c\u0169ng c\u00f3 th\u1ec3 l\u01b0u c\u00e1c c\u00e0i \u0111\u1eb7t v\u00e0 d\u1eef li\u1ec7u kh\u00e1c trong database c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<p>N\u1ebfu b\u1ea1n ki\u1ec3m tra database c\u1ee7a b\u1ea1n, b\u1ea1n s\u1ebd th\u1ea5y 11 b\u1ea3ng \u0111\u01b0\u1ee3c li\u1ec7t k\u00ea b\u00ean d\u01b0\u1edbi \u0111\u00e2y. T\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng kh\u00e1c 11 b\u1ea3ng n\u00e0y trong database c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c t\u1ea1o th\u1ee7 c\u00f4ng ho\u1eb7c \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi plugin ho\u1eb7c giao di\u1ec7n WordPress.<\/p>\n\n\n\n<p>H\u00e3y c\u00f9ng xem t\u1eebng b\u1ea3ng trong database l\u01b0u tr\u1eef \u0111i\u1ec1u g\u00ec:<\/p>\n\n\n\n<ul>\n<li><strong>wp_commentmeta<\/strong> &#8211; L\u01b0u tr\u1eef c\u00e1c th\u00f4ng tin meta (si\u00eau d\u1eef li\u1ec7u) v\u1ec1 c\u00e1c b\u00ecnh lu\u1eadn<\/li>\n\n\n\n<li><strong>wp_comments<\/strong> &#8211; L\u01b0u tr\u1eef c\u00e1c b\u00ecnh lu\u1eadn c\u1ee7a b\u1ea1n<\/li>\n\n\n\n<li><strong>wp_links<\/strong> &#8211; L\u01b0u tr\u1eef c\u00e1c li\u00ean k\u1ebft blogroll (t\u00ednh n\u0103ng blogroll hi\u1ec7n kh\u00f4ng c\u00f2n d\u00f9ng n\u1eefa, nh\u01b0ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o b\u1eb1ng <a href=\"https:\/\/wordpress.org\/plugins\/link-manager\/\" target=\"_blank\" rel=\"noreferrer noopener\">plugin Link Manager<\/a>)<\/li>\n\n\n\n<li><strong>wp_options<\/strong> &#8211; L\u01b0u tr\u1eef c\u00e1c t\u00f9y ch\u1ecdn \u0111\u01b0\u1ee3c \u0111\u1ecbnh r\u00f5 trong khu v\u1ef1c c\u00e0i \u0111\u1eb7t c\u1ee7a admin<\/li>\n\n\n\n<li><strong>wp_postmeta<\/strong> &#8211; L\u01b0u tr\u1eef c\u00e1c th\u00f4ng tin post meta<\/li>\n\n\n\n<li><strong>wp_posts<\/strong> &#8211; L\u01b0u tr\u1eef d\u1eef li\u1ec7u c\u00e1c b\u00e0i post, pages, v\u00e0 c\u00e1c \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh post kh\u00e1c<\/li>\n\n\n\n<li><strong>wp_terms<\/strong> &#8211; L\u01b0u tr\u1eef c\u00e1c tag c\u1ee7a post v\u00e0 c\u00e1c th\u01b0 m\u1ee5c cho c\u00e1c post v\u00e0 li\u00ean k\u1ebft<\/li>\n\n\n\n<li><strong>wp_term_relationships<\/strong> &#8211; L\u01b0u tr\u1eef c\u00e1c m\u1ed1i li\u00ean k\u1ebft gi\u1eefa post v\u00e0 c\u00e1c th\u01b0 m\u1ee5c v\u00e0 c\u00e1c tag c\u0169ng nh\u01b0 m\u1ed1i quan h\u1ec7 gi\u1eefa c\u00e1c li\u00ean k\u1ebft v\u00e0 th\u01b0 m\u1ee5c li\u00ean k\u1ebft<\/li>\n\n\n\n<li><strong>wp_term_taxonomy<\/strong> &#8211; L\u01b0u tr\u1eef m\u00f4 t\u1ea3 v\u1ec1 taxonomy (th\u01b0 m\u1ee5c, li\u00ean k\u1ebft, ho\u1eb7c tag) \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong b\u1ea3ng wp_terms_table<\/li>\n\n\n\n<li><strong>wp_usermeta<\/strong> &#8211; L\u01b0u tr\u1eef th\u00f4ng tin meta v\u1ec1 c\u00e1c ng\u01b0\u1eddi d\u00f9ng<\/li>\n\n\n\n<li><strong>wp_users<\/strong> &#8211; L\u01b0u tr\u1eef ng\u01b0\u1eddi d\u00f9ng c\u1ee7a website (v\u00ed d\u1ee5 admin, ng\u01b0\u1eddi \u0111\u0103ng b\u00e0i, duy\u1ec7t b\u00e0i, v\u00e2n v\u00e2n)<\/li>\n<\/ul>\n\n\n\n<p>N\u1ebfu mu\u1ed1n t\u00ecm hi\u1ec3u k\u1ef9 h\u01a1n v\u1ec1 c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a WordPress, b\u1ea1n h\u00e3y <a href=\"http:\/\/codex.wordpress.org\/Database_Description\" target=\"_blank\" rel=\"noreferrer noopener\">truy c\u1eadp th\u00f4ng tin m\u00f4 t\u1ea3 tr\u00ean trang wordpress.org<\/a>.<\/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\/bang-du-lieu-loi-wordpress.png\" alt=\"b\u1ea3ng d\u1eef li\u1ec7u l\u00f5i c\u1ee7a WordPress\" class=\"wp-image-14421\"\/><\/figure><\/div>\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cach-d\u1ec3-t\u1ed1i-\u01b0u-hoa-va-s\u1eeda-ch\u1eefa-database-trong-wordpress\"><span class=\"ez-toc-section\" id=\"Cach_de_toi_uu_hoa_va_sua_chua_database_trong_WordPress\"><\/span>C\u00e1ch \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a v\u00e0 s\u1eeda ch\u1eefa database trong WordPress<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p><a href=\"http:\/\/www.phpmyadmin.net\/\" target=\"_blank\" rel=\"noreferrer noopener\">phpMyAdmin<\/a> l\u00e0 c\u00e1ch ph\u1ed5 bi\u1ebfn nh\u1ea5t \u0111\u1ec3 qu\u1ea3n tr\u1ecb database trong WordPress. N\u1ebfu b\u1ea1n kh\u00f4ng s\u1eed d\u1ee5ng <a href=\"http:\/\/cpanel.net\/\" target=\"_blank\" rel=\"noreferrer noopener\">cPanel<\/a> l\u00e0m c\u00f4ng c\u1ee5 qu\u1ea3n tr\u1ecb hosting, g\u00f3i hosting c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 qu\u1ea3n tr\u1ecb MySQL kh\u00e1c phpMyAdmin. \u0110\u1eebng qu\u00e1 l\u0103n t\u0103n v\u1ec1 \u0111i\u1ec1u n\u00e0y v\u00ec <em>h\u1ea7u h\u1ebft c\u00e1c c\u00f4ng c\u1ee5 qu\u1ea3n tr\u1ecb database c\u00f3 giao di\u1ec7n s\u1eed d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 nhau v\u00e0 l\u00e0m vi\u1ec7c theo c\u00f9ng m\u1ed9t c\u00e1ch<\/em>.<\/p>\n\n\n\n<p>B\u1ea1n c\u00f3 th\u1ec3 \u0111ang qu\u1ea3n tr\u1ecb database WordPress th\u00f4ng qua plugin nh\u01b0 <a href=\"https:\/\/wordpress.org\/plugins\/adminer\/\" target=\"_blank\" rel=\"noreferrer noopener\">Adminer<\/a> (t\u00ean tr\u01b0\u1edbc \u0111\u00e2y c\u1ee7a n\u00f3 l\u00e0 phpMinAdmin). M\u1eb7c d\u00f9 plugin qu\u1ea3n tr\u1ecb database c\u1ee7a WordPress c\u00f3 th\u1ec3 gi\u00fap truy c\u1eadp database theo c\u00e1ch \u0111\u01a1n gi\u1ea3n h\u01a1n, t\u00f4i khuy\u00ean kh\u00f4ng n\u00ean qu\u1ea3n tr\u1ecb database c\u1ee7a b\u1ea1n theo c\u00e1ch n\u00e0y v\u00ec n\u00f3 c\u00f3 nguy c\u01a1 b\u1ea3o m\u1eadt l\u1edbn (security risk). N\u1ebfu b\u1ea1n \u0111\u00e3 c\u00e0i plugin ki\u1ec3u nh\u01b0 Adminer v\u00e0 m\u1ed9t ai \u0111\u00f3 kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p l\u1ea1i truy c\u1eadp \u0111\u01b0\u1ee3c v\u00e0o database c\u1ee7a b\u1ea1n, h\u1ecd c\u00f3 th\u1ec3 l\u00e0m b\u1ea5t c\u1ee9 \u0111i\u1ec1u g\u00ec h\u1ecd mu\u1ed1n tr\u00ean website c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<p>N\u1ebfu b\u1ea1n ki\u1ec3m tra database c\u1ee7a b\u1ea1n, b\u1ea1n s\u1ebd th\u1ea5y hai c\u1ed9t \u1edf cu\u1ed1i: size v\u00e0 overhead. K\u00edch c\u1ee1 c\u1ee7a b\u1ea3ng ph\u1ee5 thu\u1ed9c v\u00e0o s\u1ed1 l\u01b0\u1ee3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong \u0111\u00f3. N\u1ebfu nhi\u1ec1u h\u00e0ng \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong b\u1ea3ng, k\u00edch c\u1ee1 c\u1ee7a b\u1ea3ng s\u1ebd t\u0103ng.<\/p>\n\n\n\n<p>Overhead l\u00e0 kh\u00f4ng gian l\u01b0u tr\u1eef t\u1ea1m th\u1eddi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng b\u1edfi database c\u1ee7a b\u1ea1n \u0111\u1ec3 l\u01b0u tr\u1eef truy v\u1ea5n. Qua th\u1eddi gian, b\u1ea3ng overhead s\u1ebd t\u0103ng k\u00edch c\u1ee1.<\/p>\n\n\n\n<p>Ho\u00e0n to\u00e0n b\u00ecnh th\u01b0\u1eddng th\u00f4i khi c\u00f3 overhead trong database WordPress c\u1ee7a b\u1ea1n v\u00e0 n\u00f3 kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t tr\u1eeb khi overhead qu\u00e1 cao.<\/p>\n\n\n<div class=\"wp-block-image wp-image-14425 size-full\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/overhead.png\" alt=\"Size v\u00e0 Overhead \u1edf b\u00ean cu\u1ed1i\" class=\"wp-image-14425\"\/><figcaption class=\"wp-element-caption\">Size v\u00e0 overhead c\u1ee7a database hi\u1ec3n th\u1ecb ngo\u00e0i c\u00f9ng b\u00ean tay ph\u1ea3i<\/figcaption><\/figure><\/div>\n\n\n<p>L\u01b0u \u00fd r\u1eb1ng h\u00ecnh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean \u0111\u01b0\u1ee3c l\u1ea5y t\u1eeb b\u1ea3n c\u00e0i \u0111\u1eb7t m\u1edbi c\u1ee7a WordPress. \u0110\u00e2y l\u00e0 l\u00fd do t\u1ea1i sao ti\u1ec1n t\u1ed1 c\u1ee7a database v\u1eabn l\u00e0 <em>wp_<\/em>. \u0110\u1ec3 website c\u1ee7a b\u1ea1n b\u1ea3o m\u1eadt h\u01a1n, b\u1ea1n n\u00ean thay \u0111 \u1ed5i ti\u1ec1n t\u1ed1 database c\u1ee7a WordPress th\u00f4ng qua wp-config.php sang t\u00ean kh\u00e1c.<\/p>\n\n\n\n<p>T\u1ed1i \u01b0u h\u00f3a database s\u1ebd lo\u1ea1i b\u1ecf overhead v\u00e0 l\u00e0m gi\u1ea3m k\u00edch c\u1ee1 t\u1ed5ng th\u1ec3 c\u1ee7a database. Nhi\u1ec1u l\u1eadp tr\u00ecnh vi\u00ean l\u01b0u \u00fd r\u1eb1ng t\u1ed1i \u01b0u h\u00f3a database gi\u1ed1ng nh\u01b0 vi\u1ec7c ch\u1ed1ng ph\u00e2n m\u1ea3nh \u1ed5 c\u1ee9ng.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<p>T\u1ea5t c\u1ea3 database, qua th\u1eddi gian y\u00eau c\u1ea7u m\u1ed9t s\u1ed1 b\u1ea3o tr\u00ec nh\u1ea5t \u0111\u1ecbnh \u0111\u1ec3 duy tr\u00ec \u0111\u01b0\u1ee3c hi\u1ec7u su\u1ea5t t\u1ed1i \u01b0u. X\u00f3a b\u1ecf c\u00e1c h\u00e0ng, s\u1eafp x\u1ebfp l\u1ea1i, n\u00e9n, qu\u1ea3n l\u00fd \u0111\u01b0\u1eddng d\u1eabn ch\u1ec9 m\u1ee5c, ch\u1ed1ng ph\u00e2n m\u1ea3nh, v\u00e2n v\u00e2n l\u00e0 nh\u1eefng th\u1ee9 \u0111\u01b0\u1ee3c coi l\u00e0 T\u1ed0I \u01afU H\u00d3A trong mysql. L\u1ea5y v\u00ed d\u1ee5 IBM DB2\/400 g\u1ecdi n\u00f3 l\u00e0 REORGANIZE PHYSICAL FILE MEMBER. \u0110i\u1ec1u n\u00e0y gi\u1ed1ng nh\u01b0 vi\u1ec7c thay d\u1ea7u ho\u1eb7c s\u1eeda ch\u1eefa xe. B\u1ea1n c\u00f3 th\u1ec3 ngh\u0129 r\u1eb1ng b\u1ea1n kh\u00f4ng th\u1ef1c s\u1ef1 c\u1ea7n l\u00e0m v\u1eady, nh\u01b0ng b\u1eb1ng c\u00e1ch s\u1eeda ch\u1eefa b\u1ea1n gi\u00fap xe ch\u1ea1y t\u1ed1t h\u01a1n nhi\u1ec1u, v\u00e0 ti\u1ebft ki\u1ec7m x\u0103ng, v\u00e2n v\u00e2n. Chi\u1ebfc xe c\u00e0ng ch\u1ea1y nhi\u1ec1u b\u1ea1n c\u00e0ng c\u1ea7n b\u1ea3o d\u01b0\u1ee1ng th\u01b0\u1eddng xuy\u00ean h\u01a1n. T\u01b0\u01a1ng t\u1ef1, database c\u0169ng ph\u1ea3i x\u1eed l\u00fd r\u1ea5t nhi\u1ec1u y\u00eau c\u1ea7u. N\u1ebfu b\u1ea1n th\u1ef1c hi\u1ec7n vi\u1ec7c C\u1eacP NH\u1eacT v\u00e0\/ho\u1eb7c X\u00d3A li\u00ean t\u1ee5c, v\u00e0 \u0111\u1eb7c bi\u1ec7t n\u1ebfu c\u00e1c b\u1ea3ng c\u00f3 c\u00e1c c\u1ed9t c\u00f3 \u0111\u1ed9 d\u00e0i bi\u1ebfn \u0111\u1ed5i (VARCHAR, TEXT, v\u00e2n v\u00e2n), b\u1ea1n c\u1ea7n \u0111\u1ec3 \u00fd b\u1ea3o d\u01b0\u1ee1ng ch\u00fang.<\/p>\n<\/blockquote>\n\n\n\n<p>B\u1ea1n c\u00f3 th\u1ec3 t\u1ed1i \u01b0u h\u00f3a b\u1ea3ng b\u1ecb \u1ea3nh h\u01b0\u1edfng b\u1edfi overhead b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00e2u l\u1ec7nh SQL T\u1ed0I \u01afU H\u00d3A B\u1ea2NG (Optimize table). L\u1ea5y v\u00ed d\u1ee5, b\u1ea1n c\u00f3 th\u1ec3 t\u1ed1i \u01b0u b\u1ea3ng wp_posts b\u1eb1ng c\u00e1ch th\u1ef1c thi truy v\u1ea5n sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>OPTIMIZE TABLE 'wp_posts'<\/code><\/pre>\n\n\n\n<p>B\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh SQL v\u00ec phpMyAdmin cho ph\u00e9p b\u1ea1n t\u1ed1i \u01b0u h\u00f3a b\u1ea3ng th\u00f4ng qua menu x\u1ed5 xu\u1ed1ng. T\u1ea5t c\u1ea3 \u0111i\u1ec1u b\u1ea1n c\u1ea7n \u0111\u1ec3 t\u1ed1i \u01b0u database l\u00e0 click v\u00e0o box &#8220;Check All&#8221;, ch\u1ecdn &#8220;Optimize table&#8221; t\u1eeb menu x\u1ed5 xu\u1ed1ng, r\u1ed3i sau \u0111\u00f3 click v\u00e0o n\u00fat &#8220;Go&#8221;.<\/p>\n\n\n\n<p>M\u1ed9t khi b\u1ea1n \u0111\u00e3 t\u1ed1i \u01b0u h\u00f3a database WordPress, phpMyAdmin s\u1ebd x\u00e1c nh\u1eadn r\u1eb1ng c\u00e1c b\u1ea3ng c\u1ee7a b\u1ea1n \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ed1i \u01b0u.<\/p>\n\n\n\n<p>M\u1ed9t t\u00f9y ch\u1ecdn h\u1eefu \u00edch kh\u00e1c b\u1ea1n c\u1ea7n ghi nh\u1edb \u0111\u1ec3 d\u00f9ng trong t\u01b0\u01a1ng lai l\u00e0 &#8220;Repair table \/ S\u1eeda b\u1ea3ng&#8221;. Repair table s\u1ebd gi\u00fap b\u1ea1n s\u1eeda b\u1ea3ng b\u1ecb h\u1ecfng.<\/p>\n\n\n\n<p>WordPress c\u00f3 c\u00f4ng c\u1ee5 cho ph\u00e9p b\u1ea1n s\u1eeda v\u00e0 t\u1ed1i \u01b0u database c\u1ee7a b\u1ea1n. B\u1ea1n c\u00f3 th\u1ec3 t\u00ecm hi\u1ec3u th\u00eam c\u00f4ng c\u1ee5 n\u00e0y \u1edf khu v\u1ef1c h\u01b0\u1edbng d\u1eabn tr\u00ean wordpress.org thu\u1ed9c ph\u1ea7n <a href=\"http:\/\/codex.wordpress.org\/Editing_wp-config.php#Automatic_Database_Optimizing\" target=\"_blank\" rel=\"noreferrer noopener\">T\u1ef1 \u0111\u1ed9ng T\u1ed1i \u01b0u h\u00f3a Database<\/a> th\u00f4ng qua wp-config.php<\/p>\n\n\n\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 t\u1ed1i \u01b0u h\u00f3a, tr\u01b0\u1edbc h\u1ebft b\u1ea1n c\u1ea7n th\u00eam d\u00f2ng d\u01b0\u1edbi \u0111\u00e2y v\u00e0o website c\u1ee7a b\u1ea1n \u1edf file wp-config.php<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>define( 'WP_ALLOW_REPAIR', true );<\/code><\/pre>\n\n\n\n<p>M\u1ed9t khi b\u1ea1n \u0111\u00e3 th\u00eam d\u00f2ng tr\u00ean v\u00e0o wp-config.php v\u00e0 l\u01b0u file, b\u1ea1n c\u00f3 th\u1ec3 truy c\u1eadp c\u00f4ng c\u1ee5 t\u1ed1i \u01b0u h\u00f3a t\u1ea1i \u0111\u01b0\u1eddng d\u1eabn http:\/\/www.ten-mien-cua-ban.com\/wp-admin\/maint\/repair.php<\/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\/sua-lai-database.png\" alt=\"s\u1eeda l\u1ea1i database\" class=\"wp-image-14427\"\/><\/figure><\/div>\n\n\n<p>C\u00f4ng c\u1ee5 t\u1ed1i \u01b0u h\u00f3a s\u1ebd c\u1ed1 g\u1eafng s\u1eeda t\u1eebng b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u. Theo th\u1eddi gian, t\u1ec7p l\u1ec7nh c\u00f3 th\u1ec3 kh\u00f4ng c\u00f3 kh\u1ea3 n\u0103ng s\u1eeda c\u00e1c b\u1ea3ng nh\u1ea5t \u0111\u1ecbnh.<\/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\/sua-bang-thanh-cong.png\" alt=\"s\u1eeda th\u00e0nh c\u00f4ng\" class=\"wp-image-14428\"\/><\/figure><\/div>\n\n\n<p>N\u1ebfu b\u1ea1n kh\u00f4ng s\u1eeda th\u00e0nh c\u00f4ng c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n trong l\u1ea7n th\u1eed \u0111\u1ea7u ti\u00ean, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ea1y c\u00f4ng c\u1ee5 t\u1ed1i \u01b0u h\u00f3a l\u1ea7n n\u1eefa.<\/p>\n\n\n\n<p>N\u1ebfu b\u1ea1n ch\u1ecdn &#8220;Repair and Optimize Database&#8221;, WordPress s\u1ebd t\u1ed1i \u01b0u h\u00f3a t\u1eebng b\u1ea3ng ch\u01b0a \u0111\u01b0\u1ee3c t\u1ed1i \u01b0u h\u00f3a.<\/p>\n\n\n\n<p>B\u1ea1n kh\u00f4ng c\u1ea7n \u0111\u0103ng nh\u1eadp \u0111\u1ec3 kh\u1edfi ch\u1ea1y c\u00f4ng c\u1ee5 t\u1ed1i \u01b0u h\u00f3a WordPress. Nh\u01b0\u1ee3c \u0111i\u1ec3m n\u00e0y khi\u1ebfn b\u1ea5t c\u1ee9 ai c\u0169ng c\u00f3 th\u1ec3 truy c\u1eadp v\u00e0o t\u1ec7p l\u1ec7nh c\u1ee7a b\u1ea1n v\u00e0 th\u1ef1c thi n\u00f3. V\u00ec v\u1eady, <em>b\u1ea1n c\u1ea7n lo\u1ea1i b\u1ecf d\u00f2ng WP_ALLOW_REPAIR kh\u1ecfi file wp-config.php sau khi b\u1ea1n s\u1eed d\u1ee5ng xong c\u00f4ng c\u1ee5 t\u1ed1i \u01b0u h\u00f3a n\u00e0y<\/em>.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"lam-th\u1ebf-nao-d\u1ec3-lo\u1ea1i-b\u1ecf-hi\u1ec7n-t\u01b0\u1ee3ng-phinh-to-database-trong-wordpress\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_loai_bo_hien_tuong_phinh_to_database_trong_WordPress\"><\/span>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 lo\u1ea1i b\u1ecf hi\u1ec7n t\u01b0\u1ee3ng ph\u00ecnh to database trong WordPress<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Database c\u1ee7a WordPress h\u1ea7u nh\u01b0 l\u01b0u tr\u1eef r\u1ea5t nhi\u1ec1u d\u1eef li\u1ec7u kh\u00f4ng c\u1ea7n thi\u1ebft. \u0110i\u1ec1u n\u00e0y l\u00e0m ph\u00ecnh d\u1eef li\u1ec7u v\u00e0 ch\u1eadm website.<\/p>\n\n\n\n<p>C\u00f3 m\u1ed9t s\u1ed1 th\u1ee9 l\u00e0 nguy\u00ean nh\u00e2n g\u00e2y ph\u00ecnh to CSDL c\u1ee7a WordPress. D\u00f9 v\u1eady th\u00ec b\u1eb1ng c\u00e1ch l\u00e0m theo m\u1ed9t s\u1ed1 th\u1ef1c h\u00e0nh ph\u00f9 h\u1ee3p, b\u1ea1n c\u00f3 th\u1ec3 gi\u1ea3m ph\u1ea7n l\u1edbn d\u1eef li\u1ec7u d\u01b0 th\u1eeba n\u00e0y, ho\u1eb7c th\u1eadm ch\u00ed lo\u1ea1i b\u1ecf ho\u00e0n to\u00e0n d\u1eef li\u1ec7u v\u00f4 \u00edch ra kh\u1ecfi website c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<p>N\u00e0o, ch\u00fang ta c\u00f9ng xem c\u00e1c nguy\u00ean nh\u00e2n ch\u00ednh g\u00e2y ph\u00ecnh to CSDL c\u1ee7a WordPress.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"revisions\">Revisions<\/h3>\n\n\n\n<p><a href=\"http:\/\/codex.wordpress.org\/Revisions\" target=\"_blank\" rel=\"noreferrer noopener\">H\u1ec7 th\u1ed1ng revisions c\u1ee7a WordPress<\/a> t\u1ea1o ra nhi\u1ec1u database l\u1edbn kh\u00f4ng c\u1ea7n thi\u1ebft. \u0110\u01b0\u1ee3c gi\u1edbi thi\u1ec7u l\u1ea7n \u0111\u1ea7u trong WordPress 2.6, t\u00ednh n\u0103ng n\u00e0y gi\u00fap l\u01b0u tr\u1eef t\u1eebng b\u1ea3n sao ch\u00e9p c\u1ee7a b\u1ea3n nh\u00e1p v\u00e0 m\u1ecdi c\u1eadp nh\u1eadt cho b\u00e0i post blog. <a href=\"https:\/\/kiencang.net\/revision-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">Revision l\u00e0 t\u00ednh n\u0103ng h\u1eefu \u00edch cho ph\u00e9p b\u1ea1n kh\u00f4i ph\u1ee5c l\u1ea1i c\u00e1c b\u1ea3n sao ch\u00e9p c\u0169 h\u01a1n<\/a> c\u1ee7a b\u00e0i vi\u1ebft v\u00e0 ki\u1ec3m tra c\u00e1c b\u1ea3n nh\u00e1p tr\u01b0\u1edbc \u0111\u00e2y.<\/p>\n\n\n\n<p>Tuy nhi\u00ean c\u00e1i d\u1edf \u1edf \u0111\u00e2y l\u00e0 WordPress <em>kh\u00f4ng gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng revision c\u00f3 th\u1ec3 l\u01b0u<\/em>. N\u1ebfu b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean m\u1ed9t b\u00e0i vi\u1ebft d\u00e0i (c\u1ea7n nhi\u1ec1u th\u1eddi gian \u0111\u1ec3 vi\u1ebft n\u00ean b\u1ea1n s\u1ebd nh\u1ea5n l\u01b0u nh\u00e1p v\u00e0\/ho\u1eb7c xu\u1ea5t b\u1ea3n r\u1ea5t nhi\u1ec1u l\u1ea7n), \u0111i\u1ec1u n\u00e0y g\u00e2y ra h\u1ec7 qu\u1ea3 l\u00e0 c\u00f3 th\u1ec3 <strong>c\u00f3 h\u00e0ng tr\u0103m revision \u0111\u01b0\u1ee3c l\u01b0u gi\u1eef<\/strong>. Th\u1eadm ch\u00ed ngay c\u1ea3 b\u00e0i vi\u1ebft \u0111\u00e3 \u0111\u01b0\u1ee3c xu\u1ea5t b\u1ea3n ch\u1ec9 chi\u1ebfm m\u1ed9t d\u00f2ng trong b\u1ea3ng CSDL, c\u00e1c b\u1ea3n revision t\u01b0\u01a1ng \u1ee9ng c\u1ee7a n\u00f3 c\u00f3 th\u1ec3 c\u00f3 h\u00e0ng t\u00e1, ho\u1eb7c th\u1eadm ch\u00ed l\u00e0 h\u00e0ng tr\u0103m d\u00f2ng trong CSDL c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<p>T\u00f4i l\u00e0 ng\u01b0\u1eddi \u1ee7ng h\u1ed9 h\u1ec7 th\u1ed1ng revision, tuy nhi\u00ean t\u00f4i kh\u00f4ng tin b\u1ea1n c\u00f3 l\u1ee3i \u00edch th\u1ef1c t\u1ebf khi l\u01b0u tr\u1eef kh\u00f4ng gi\u1edbi h\u1ea1n c\u00e1c b\u1ea3n revision c\u1ee7a t\u1eebng b\u00e0i \u0111\u0103ng. R\u1ea5t may l\u00e0 WordPress cho ph\u00e9p b\u1ea1n d\u1ec5 d\u00e0ng gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng revision l\u01b0u tr\u1eef xu\u1ed1ng con s\u1ed1 m\u00e0 b\u1ea1n mu\u1ed1n.<\/p>\n\n\n\n<p>\u0110\u1ec3 gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng revision xu\u1ed1ng, \u0111\u01a1n gi\u1ea3n l\u00e0 b\u1ea1n th\u00eam \u0111o\u1ea1n m\u00e3 sau v\u00e0o file <em>wp-configs.php<\/em> (d\u00f2ng d\u01b0\u1edbi \u0111\u00e2y gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng revision xu\u1ed1ng ch\u1ec9 2 b\u1ea3n):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>define('WP_POST_REVISIONS', 2);<\/code><\/pre>\n\n\n\n<p>C\u00e1c revision c\u1ee7a b\u00e0i post c\u00f3 th\u1ec3 ho\u00e0n to\u00e0n \u0111\u01b0\u1ee3c v\u00f4 hi\u1ec7u h\u00f3a b\u1eb1ng c\u00e1ch th\u00eam \u0111o\u1ea1n m\u00e3 sau v\u00e0o file wp-config.php.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>define('WP_POST_REVISIONS', false);<\/code><\/pre>\n\n\n\n<p>T\u00f4i kh\u00f4ng khuy\u1ebfn kh\u00edch b\u1ea1n v\u00f4 hi\u1ec7u h\u00f3a t\u00ednh n\u0103ng revision ho\u00e0n to\u00e0n. Cho d\u00f9 vi\u1ec7c v\u00f4 hi\u1ec7u h\u00f3a revision ch\u1eafc ch\u1eafn gi\u00fap gi\u1ea3m k\u00edch c\u1ee1 CSDL c\u1ee7a b\u1ea1n, nh\u01b0ng n\u00f3 s\u1ebd lo\u1ea1i b\u1ecf kh\u1ea3 n\u0103ng kh\u00f4i ph\u1ee5c khi x\u1ea3y ra l\u1ed7i. V\u00ed d\u1ee5, trong t\u00ecnh hu\u1ed1ng b\u1ea1n \u0111\u00f3ng c\u1eeda s\u1ed5 tr\u00ecnh duy\u1ec7t v\u00ec l\u1ed7i n\u00e0o \u0111\u00f3 ho\u1eb7c m\u1ea5t k\u1ebft n\u1ed1i internet, b\u1ea1n c\u00f3 th\u1ec3 m\u1ea5t m\u1ecdi th\u1ee9 b\u1ea1n \u0111\u00e3 g\u00f5 xu\u1ed1ng k\u1ec3 t\u1eeb l\u1ea7n l\u01b0u nh\u00e1p cu\u1ed1i c\u00f9ng!<\/p>\n\n\n\n<p>Gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng revision \u0111\u01b0\u1ee3c ph\u00e9p l\u01b0u, ho\u1eb7c v\u00f4 hi\u1ec7u h\u00f3a revision kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn c\u00e1c revision \u0111\u00e3 l\u01b0u tr\u01b0\u1edbc \u0111\u00f3. V\u00ec th\u1ebf, c\u00e1c revision g\u1eafn v\u1edbi c\u00e1c b\u00e0i \u0111\u0103ng c\u0169 s\u1ebd v\u1eabn \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong CSDL c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<p>M\u1ed9t khi b\u00e0i vi\u1ebft \u0111\u01b0\u1ee3c xu\u1ea5t b\u1ea3n, b\u1ea1n h\u1ea7u nh\u01b0 kh\u00f4ng c\u00f2n nhu c\u1ea7u gi\u1eef c\u00e1c post revision c\u0169 l\u00e0m g\u00ec n\u1eefa, do v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 c\u00e2n nh\u1eafc lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c revision t\u1eeb b\u00e0i vi\u1ebft \u0111\u00e3 xu\u1ea5t b\u1ea3n. C\u00f3 m\u1ed9t s\u1ed1 plugin cho ph\u00e9p b\u1ea1n l\u00e0m \u0111i\u1ec1u n\u00e0y (b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf revision b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng MySQL; tuy nhi\u00ean b\u1ea1n ph\u1ea3i \u00fd th\u1ee9c \u0111\u01b0\u1ee3c r\u1eafc r\u1ed1i c\u00f3 th\u1ec3 x\u1ea3y ra n\u1ebfu b\u1ea1n kh\u00f4ng s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c).<\/p>\n\n\n\n<p>V\u00ed d\u1ee5, t\u00f4i \u0111\u00e3 s\u1eed d\u1ee5ng plugin <a href=\"https:\/\/wordpress.org\/plugins\/rvg-optimize-database\/\" target=\"_blank\" rel=\"noreferrer noopener\">Optimize Database after Deleting Revisions<\/a> \u0111\u1ea7u n\u0103m nay \u0111\u1ec3 gi\u1ea3m k\u00edch c\u1ee1 database c\u1ee7a t\u00f4i \u0111\u1ebfn 59%.<\/p>\n\n\n\n<p>Plugin n\u00e0y cho ph\u00e9p b\u1ea1n <em>\u0111\u1ecbnh r\u00f5 s\u1ed1 l\u01b0\u1ee3ng c\u00e1c b\u1ea3n revision \u0111\u01b0\u1ee3c ph\u00e9p l\u01b0u<\/em>. N\u00f3 c\u0169ng cho ph\u00e9p b\u1ea1n x\u00f3a c\u00e1c item trong th\u00f9ng r\u00e1c, item spam, c\u00e1c tag kh\u00f4ng s\u1eed d\u1ee5ng, v\u00e0 c\u00e1c transients qu\u00e1 h\u1ea1n. C\u00e1c b\u1ea3ng database c\u1ee5 th\u1ec3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf t\u1eeb qu\u00e1 tr\u00ecnh t\u1ed1i \u01b0u h\u00f3a.<\/p>\n\n\n\n<p>Optimize Database after Deleting Revisions cho ph\u00e9p l\u00ean l\u1ecbch x\u00f3a \u0111\u1ecbnh k\u1ef3 (scheduler). N\u00f3 c\u00f3 th\u1ec3 t\u1ed1i \u01b0u h\u00f3a website c\u1ee7a b\u1ea1n m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng m\u1ed9t l\u1ea7n m\u1ed7i gi\u1edd, hai l\u1ea7n m\u1ed9t ng\u00e0y, ho\u1eb7c m\u1ed9t l\u1ea7n m\u1ed9t tu\u1ea7n.<\/p>\n\n\n\n<p>M\u1ed9t t\u00f9y ch\u1ecdn kh\u00e1c \u0111\u1ec3 x\u00f3a c\u00e1c post revision l\u00e0 <a href=\"https:\/\/wordpress.org\/plugins\/better-delete-revision\/\" target=\"_blank\" rel=\"noreferrer noopener\">Better Delete Revision<\/a>. N\u00f3 cung c\u1ea5p m\u1ed9t danh s\u00e1ch t\u1ea5t c\u1ea3 c\u00e1c revision \u0111\u00e3 l\u01b0u tr\u00ean website c\u1ee7a b\u1ea1n. \u0110\u00e1ng ti\u1ebfc, kh\u00f4ng c\u00f3 t\u00f9y ch\u1ecdn x\u00f3a revision c\u1ee5 th\u1ec3 t\u1eebng c\u00e1i; ch\u1ec9 c\u00f3 duy nh\u1ea5t t\u00f9y ch\u1ecdn x\u00f3a t\u1ea5t c\u1ea3 revision c\u00f9ng m\u1ed9t l\u00fac. Plugin c\u0169ng c\u00f3 m\u1ed9t t\u00f9y ch\u1ecdn \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a t\u1ea5t c\u1ea3 b\u1ea3ng CSDL c\u1ee7a b\u1ea1n \u0111\u1ec3 gi\u1ea3m overhead.<\/p>\n\n\n\n<p>T\u00f4i c\u0169ng mu\u1ed1n n\u00f3i ng\u1eafn g\u1ecdn v\u1ec1 t\u00ednh n\u0103ng autosaves. T\u00ednh n\u0103ng autosave c\u1ee7a WordPress t\u1ef1 \u0111\u1ed9ng l\u01b0u m\u1ed9t b\u1ea3n l\u01b0u b\u00e0i vi\u1ebft c\u1ee7a b\u1ea1n c\u1ee9 60 gi\u00e2y m\u1ed9t l\u1ea7n. T\u1ea7n s\u1ed1 n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c thay \u0111\u1ed5i b\u1eb1ng c\u00e1ch th\u00eam \u0111o\u1ea1n m\u00e3 sau v\u00e0o file wp-config.php (*)<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>define('AUTOSAVE_INTERVAL', 160); \/\/ Seconds<\/code><\/pre>\n\n\n\n<p>C\u00f3 nhi\u1ec1u blogger \u0111\u01b0a ra l\u1eddi khuy\u00ean v\u00f4 hi\u1ec7u h\u00f3a t\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng l\u01b0u v\u00ec n\u00f3 t\u1ea1o ra nhi\u1ec1u b\u1ea3n sao t\u1ef1 \u0111\u1ed9ng c\u1ee7a b\u00e0i post v\u00e0 page. \u0110i\u1ec1u n\u00e0y \u0111\u01a1n gi\u1ea3n kh\u00f4ng \u0111\u00fang.&nbsp; T\u1ef1 \u0111\u1ed9ng l\u01b0u bao gi\u1edd c\u0169ng ch\u1ec9 t\u1ea1o ra m\u1ed9t b\u1ea3n sao b\u00e0i vi\u1ebft c\u1ee7a b\u1ea1n (kh\u00f4ng gi\u1ed1ng v\u1edbi revision v\u1eabn gi\u1eef nhi\u1ec1u b\u1ea3n sao) v\u00e0 do v\u1eady n\u00f3 s\u1ebd kh\u00f4ng s\u1eed d\u1ee5ng nhi\u1ec1u kh\u00f4ng gian b\u1ed9 nh\u1edb trong database c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<p>T\u00ednh n\u0103ng t\u1ef1 \u0111\u1ed9ng l\u01b0u l\u00e0 ch\u1ee9c n\u0103ng b\u1ea3o v\u1ec7 quan tr\u1ecdng khi chuy\u1ec7n kh\u00f4ng nh\u01b0 \u00fd x\u1ea3y ra, ch\u1eb3ng h\u1ea1n nh\u01b0 vi\u1ec7c b\u1ecb m\u1ea5t k\u1ebft n\u1ed1i internet, ho\u1eb7c \u0111\u00f3ng c\u1eeda s\u1ed5 tr\u00ecnh duy\u1ec7t do nh\u1ea7m l\u1eabn. T\u00ednh n\u0103ng n\u00e0y kh\u00f4ng s\u1eed d\u1ee5ng nhi\u1ec1u kh\u00f4ng gian trong CSDL c\u1ee7a b\u1ea1n; v\u00ec th\u1ebf t\u00f4i khuy\u1ebfn kh\u00edch b\u1ea1n \u0111\u1ec3 n\u00f3 \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t.<\/p>\n\n\n\n<p>(*): C\u00e1 nh\u00e2n ng\u01b0\u1eddi d\u1ecbch kh\u00f4ng th\u1ea5y t\u00e1c d\u1ee5ng g\u00ec \u0111\u00e1ng k\u1ec3 khi b\u1ea1n n\u00e2ng th\u1eddi gian t\u1ef1 \u0111\u1ed9ng l\u01b0u t\u1eeb 60s l\u00ean 160s, v\u00ec th\u1ef1c s\u1ef1 t\u00e1c v\u1ee5 n\u00e0y r\u1ea5t nh\u1eb9 nh\u00e0ng, n\u00f3 ch\u1ec9 t\u1ea1o ra m\u1ed9t b\u1ea3n l\u01b0u, h\u01a1n n\u1eefa, \u0111a s\u1ed1 c\u00e1c website ch\u1ec9 c\u00f3 &#8216;m\u1ed9t ho\u1eb7c v\u00e0i ng\u01b0\u1eddi vi\u1ebft. Do v\u1eady t\u00e1c \u0111\u1ed9ng (n\u1ebfu c\u00f3) l\u00e0 c\u1ef1c k\u1ef3 nh\u1ecf \u0111\u1ebfn hi\u1ec7u su\u1ea5t.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"cac-binh-lu\u1eadn-spam\">C\u00e1c b\u00ecnh lu\u1eadn spam<\/h3>\n\n\n\n<p>N\u1ebfu website c\u1ee7a b\u1ea1n nh\u1eadn r\u1ea5t nhi\u1ec1u spam, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn ra l\u00e0 c\u00e1c b\u00ecnh lu\u1eadn spam l\u1ea5y r\u1ea5t nhi\u1ec1u kh\u00f4ng gian trong CSDL. Theo m\u1eb7c \u0111\u1ecbnh, c\u00e1c b\u00ecnh lu\u1eadn spam s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng x\u00f3a sau 30 ng\u00e0y; tuy nhi\u00ean trong su\u1ed1t th\u1eddi gian n\u00e0y ch\u00fang c\u00f3 th\u1ec3 t\u0103ng s\u1ed1 l\u01b0\u1ee3ng l\u00ean \u0111\u1ebfn h\u00e0ng ng\u00e0n th\u1eadm ch\u00ed ch\u1ee5c ng\u00e0n d\u00f2ng trong b\u1ea3ng wp_comments c\u1ee7a b\u1ea1n.<\/p>\n\n\n\n<p>M\u1ed9t plugin ch\u1ed1ng spam t\u1ed1t c\u00f3 th\u1ec3 ng\u0103n ch\u1eb7n nhi\u1ec1u spammer b\u1eb1ng c\u00e1ch l\u01b0u gi\u1eef h\u00e0nh vi m\u1eabu c\u1ee7a h\u1ecd, do v\u1eady s\u1ed1 l\u01b0\u1ee3ng c\u00e1c b\u00ecnh lu\u1eadn spam b\u1ea1n b\u1ecb nh\u1eadn s\u1ebd gi\u1ea3m xu\u1ed1ng.<\/p>\n\n\n\n<p><a rel=\"noreferrer noopener\" href=\"https:\/\/wordpress.org\/plugins\/akismet\/\" target=\"_blank\">Akismet<\/a> (xem th\u00eam <a href=\"https:\/\/kiencang.net\/comment-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">qu\u1ea3n l\u00fd b\u00ecnh lu\u1eadn trong WordPress<\/a>) l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1t v\u00ec n\u00f3 cho ph\u00e9p b\u1ea1n lo\u1ea1i b\u1ecf c\u00e1c spam r\u00f5 r\u00e0ng v\u00ec th\u1ebf b\u00ecnh lu\u1eadn \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf kh\u1ecfi CSDL c\u1ee7a b\u1ea1n ngay l\u1eadp t\u1ee9c (m\u1eb7c d\u00f9 b\u1ea1n c\u0169ng c\u00f3 r\u1ee7i ro l\u00e0 c\u00e1c b\u00ecnh lu\u1eadn kh\u00f4ng ph\u1ea3i spam c\u0169ng c\u00f3 th\u1ec3 b\u1ecb x\u00f3a t\u1ef1 \u0111\u1ed9ng do h\u1ec7 th\u1ed1ng nh\u1eadn di\u1ec7n nh\u1ea7m, tuy nhi\u00ean thi\u1ec7t h\u1ea1i n\u00e0y th\u01b0\u1eddng r\u1ea5t nh\u1ecf so v\u1edbi l\u1ee3i \u00edch ch\u1ed1ng spam m\u00e0 plugin cung c\u1ea5p).<\/p>\n\n\n\n<p>C\u00e1c tay spammer c\u00f3 xu h\u01b0\u1edbng nh\u1eafm \u0111\u1ebfn c\u00e1c b\u00e0i vi\u1ebft c\u0169 c\u00f3 th\u1ee9 h\u1ea1ng t\u1ed1t tr\u00ean m\u00e1y t\u00ecm ki\u1ebfm. Do \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng spam tr\u00ean website c\u1ee7a b\u1ea1n b\u1eb1ng vi\u1ec7c c\u00e2n nh\u1eafc v\u00f4 hi\u1ec7u h\u00f3a b\u00ecnh lu\u1eadn tr\u00ean c\u00e1c b\u00e0i vi\u1ebft c\u0169 sau khi n\u00f3 \u0111\u1ea1t tu\u1ed5i ng\u00e0y nh\u1ea5t \u0111\u1ecbnh (v\u00ed d\u1ee5 100 ng\u00e0y). Hi\u1ec7n t\u00ednh n\u0103ng n\u00e0y c\u00f3 s\u1eb5n trong ph\u1ea7n <em>discussion setting<\/em> thu\u1ed9c khu v\u1ef1c qu\u1ea3n tr\u1ecb c\u1ee7a WordPress.<\/p>\n\n\n\n<p>C\u00e1c b\u00ecnh lu\u1eadn spam c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c x\u00f3a b\u1ecf b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng truy v\u1ea5n SQL sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM wp_comments WHERE comment_approved = 'spam'<\/code><\/pre>\n\n\n\n<p>T\u1ea5t c\u1ea3 c\u00e1c b\u00ecnh lu\u1eadn ch\u1edd ph\u00ea duy\u1ec7t c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c x\u00f3a b\u1ecf b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng truy v\u1ea5n SQL sau:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>DELETE FROM wp_comments WHERE comment_approved = '0'<\/code><\/pre>\n\n\n\n<p>Tuy nhi\u00ean hi\u1ec7n t\u1ea1i b\u1ea1n c\u00f3 th\u1ec3 x\u00f3a b\u1ecf t\u1ea5t c\u1ea3 b\u00ecnh lu\u1eadn spam b\u1eb1ng n\u00fat Empty Spam trong trang qu\u1ea3n tr\u1ecb n\u00ean s\u1ebd kh\u00f4ng th\u1ef1c t\u1ebf n\u1ebfu b\u1ea1n l\u1ea1i s\u1eed d\u1ee5ng truy v\u1ea5n SQL \u0111\u1ec3 x\u00f3a spam kh\u1ecfi database.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"xoa-b\u1ecf-cac-items\"><span class=\"ez-toc-section\" id=\"Xoa_bo_cac_items\"><\/span>X\u00f3a b\u1ecf c\u00e1c items<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>B\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n x\u00f3a m\u1ed9t item trong WordPress, ch\u1eb3ng h\u1ea1n nh\u01b0 m\u1ed9t b\u00e0i \u0111\u0103ng blog, trang, \u1ea3nh, b\u00ecnh lu\u1eadn, ho\u1eb7c li\u00ean k\u1ebft, n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c g\u1eedi sang th\u01b0 m\u1ee5c r\u00e1c (trash). \u0110\u00e2y l\u00e0 m\u1ed9t h\u1ec7 th\u1ed1ng d\u1ef1 ph\u00f2ng kh\u00e1c c\u1ee7a WordPress ng\u0103n b\u1ea1n x\u00f3a nh\u1ea7m m\u1ed9t th\u00e0nh ph\u1ea7n n\u00e0o \u0111\u00f3 do s\u01a1 \u00fd. N\u1ebfu b\u1ea1n mu\u1ed1n, h\u1ec7 th\u1ed1ng cho ph\u00e9p b\u1ea1n kh\u00f4i ph\u1ee5c l\u1ea1i item hi\u1ec7n \u0111ang n\u1eb1m trong th\u00f9ng r\u00e1c (v\u1ec1 m\u1eb7t ch\u1ee9c n\u0103ng n\u00f3 kh\u00f4ng kh\u00e1c g\u00ec th\u00f9ng r\u00e1c c\u1ee7a h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows quen thu\u1ed9c).<\/p>\n\n\n\n<p>Tr\u1eeb khi b\u1ea1n x\u00f3a nhi\u1ec1u item m\u1ed9t c\u00e1ch th\u01b0\u1eddng xuy\u00ean, b\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i lo l\u1eafng v\u1ec1 kh\u00f4ng gian c\u1ee7a c\u00e1c item \u0111\u00e3 b\u1ecb x\u00f3a nh\u01b0ng v\u1eabn chi\u1ebfm ch\u1ed7 trong database. D\u00f9 v\u1eady, s\u1ebd c\u00f3 \u00edch khi hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1ch h\u1ec7 th\u1ed1ng th\u00f9ng r\u00e1c l\u00e0m vi\u1ec7c, \u0111\u1eb7c bi\u1ec7t n\u1ebfu b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n vi\u1ec7c x\u00f3a h\u00e0ng tr\u0103m ho\u1eb7c h\u00e0ng ng\u00e0n item t\u1eeb trang WordPress (b\u1ea5t k\u1ec3 n\u00f3 c\u00f3 l\u00e0 b\u00e0i post, b\u00ecnh lu\u1eadn, \u1ea3nh ho\u1eb7c g\u00ec \u0111i ch\u0103ng n\u1eefa).<\/p>\n\n\n\n<p>Item \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00f3a s\u1ebd ti\u1ebfp t\u1ee5c n\u1eb1m trong database c\u1ee7a b\u1ea1n cho \u0111\u1ebfn khi th\u00f9ng r\u00e1c \u0111\u01b0\u1ee3c l\u00e0m tr\u1ed1ng ho\u00e0n to\u00e0n. Theo m\u1eb7c \u0111\u1ecbnh, c\u00e1c item trong th\u00f9ng r\u00e1c s\u1ebd \u0111\u01b0\u1ee3c x\u00f3a ho\u00e0n to\u00e0n sau 30 ng\u00e0y.<\/p>\n\n\n\n<p>S\u1ed1 ng\u00e0y m\u1eb7c \u0111\u1ecbnh tr\u01b0\u1edbc khi x\u00f3a h\u1eb3n n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c thay \u0111\u1ed5i b\u1eb1ng c\u00e1ch th\u00eam \u0111o\u1ea1n m\u00e3 sau v\u00e0o file wp-config.php<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>define( 'EMPTY_TRASH_DAYS', 5 ); \/\/ 5 days<\/code><\/pre>\n\n\n\n<p>H\u1ec7 th\u1ed1ng th\u00f9ng r\u00e1c c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c v\u00f4 hi\u1ec7u h\u00f3a ho\u00e0n to\u00e0n b\u1eb1ng c\u00e1ch th\u00eam \u0111o\u1ea1n m\u00e3 sau v\u00e0o file wp-config.php &#8211; b\u1ea1n \u0111\u1ec3 s\u1ed1 ng\u00e0y v\u1ec1 0<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>define( 'EMPTY_TRASH_DAYS', 0 ); \/\/ Zero days<\/code><\/pre>\n\n\n\n<p>T\u00f4i kh\u00f4ng tin r\u1eb1ng v\u00f4 hi\u1ec7u h\u00f3a ho\u00e0n to\u00e0n h\u1ec7 th\u1ed1ng th\u00f9ng r\u00e1c l\u00e0 c\u00e1ch t\u1ed1t v\u00ec l\u00e0m nh\u01b0 th\u1ebf b\u1ea1n s\u1ebd kh\u00f4ng c\u00f3 kh\u1ea3 n\u0103ng kh\u00f4i ph\u1ee5c l\u1ea1i b\u1ea5t k\u1ef3 item n\u00e0o b\u1ecb x\u00f3a do s\u01a1 xu\u1ea5t.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"wordpress-transients\"><span class=\"ez-toc-section\" id=\"WordPress_Transients\"><\/span>WordPress Transients<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ch\u00fa th\u00edch t\u1eeb ng\u01b0\u1eddi d\u1ecbch: \u0110\u00e2y l\u00e0 ph\u1ea7n duy nh\u1ea5t m\u00e0 c\u00e1c plugin t\u00e1c gi\u1ea3 \u0111\u1ec1 c\u1eadp l\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i c\u1eadp nh\u1eadt, c\u00e1c plugin \u0111\u01b0\u1ee3c n\u00f3i trong c\u00e1c ph\u1ea7n kh\u00e1c \u0111\u1ec1u r\u1ea5t c\u0169.<\/p>\n\n\n\n<p><a href=\"http:\/\/codex.wordpress.org\/Transients_API\" target=\"_blank\" rel=\"noreferrer noopener\">WordPress Transients<\/a> cung c\u1ea5p cho l\u1eadp tr\u00ecnh vi\u00ean c\u00e1ch \u0111\u1ec3 l\u01b0u tr\u1eef d\u1eef li\u1ec7u t\u1ea1m th\u1eddi trong database c\u1ee7a WordPress. C\u00e1c b\u1ea3n ghi transient \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong c\u00e1c b\u1ea3ng options c\u1ee7a WordPress.<\/p>\n\n\n\n<p>C\u00e1c b\u1ea3n ghi transient qu\u00e1 h\u1ea1n c\u00f3 th\u1ec3 l\u00e0m \u0111\u1ea7y database c\u1ee7a b\u1ea1n v\u00e0 l\u00e0m website c\u1ee7a b\u1ea1n ch\u1ea1y ch\u1eadm l\u1ea1i. C\u00f3 m\u1ed9t s\u1ed1 plugin c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n qu\u1ea3n tr\u1ecb c\u00e1c transients v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c b\u1ea3n ghi transient kh\u00f4ng c\u00f2n d\u00f9ng \u0111\u1ebfn n\u1eefa.<\/p>\n\n\n\n<p>Plugin WordPress c\u00f3 t\u00ean <a href=\"https:\/\/wordpress.org\/plugins\/artiss-transient-cleaner\/\" target=\"_blank\" rel=\"noreferrer noopener\">Trasient Cleaner<\/a> cung c\u1ea5p t\u00f9y ch\u1ecdn cho ph\u00e9p b\u1ea1n lo\u1ea1i b\u1ecf c\u00e1c transients qu\u00e1 h\u1ea1n v\u00e0 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c transients. <a href=\"https:\/\/wordpress.org\/plugins\/delete-expired-transients\/\" target=\"_blank\" rel=\"noreferrer noopener\">Plugin Delete Expired Transients<\/a> c\u0169ng cung c\u1ea5p ch\u1ee9c n\u0103ng n\u00e0y v\u00e0 cho ph\u00e9p b\u1ea1n c\u00e0i \u0111\u1eb7t t\u00e1c v\u1ee5 th\u1ef1c hi\u1ec7n l\u1eb7p l\u1ea1i h\u00e0ng ng\u00e0y \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c transients qu\u00e1 h\u1ea1n.<\/p>\n\n\n\n<p><a href=\"https:\/\/wordpress.org\/plugins\/transients-manager\/\" target=\"_blank\" rel=\"noreferrer noopener\">Transients Manager<\/a> l\u00e0 m\u1ed9t trong c\u00e1c gi\u1ea3i ph\u00e1p t\u1ed1t nh\u1ea5t \u0111\u1ec3 xem c\u00e1c transients c\u1ee7a b\u1ea1n. N\u00f3 cho ph\u00e9p b\u1ea1n xem, ch\u1ec9nh s\u1eeda v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c transients. Tuy nhi\u00ean, plugin n\u00e0y kh\u00f4ng c\u00f3 b\u1ea5t k\u1ef3 t\u00f9y ch\u1ecdn n\u00e0o \u0111\u1ec3 x\u00f3a s\u1ed1 l\u01b0\u1ee3ng l\u1edbn c\u00e1c transients qu\u00e1 h\u1ea1n.<\/p>\n\n\n\n<p>Transients kh\u00f4ng ph\u1ea3i l\u00e0 c\u00e1i g\u00ec \u0111\u00f3 m\u00e0 b\u1ea1n c\u1ea7n lo l\u1eafng th\u01b0\u1eddng xuy\u00ean, d\u00f9 v\u1eady n\u00f3 x\u1ee9ng \u0111\u00e1ng \u0111\u01b0\u1ee3c ki\u1ec3m tra \u0111\u1ecbnh k\u1ef3 \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c r\u1eb1ng ch\u00fang kh\u00f4ng l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cac-b\u1ea3ng-c\u1ee7a-plugin-va-giao-di\u1ec7n-khong-s\u1eed-d\u1ee5ng\"><span class=\"ez-toc-section\" id=\"Cac_bang_cua_plugin_va_giao_dien_khong_su_dung\"><\/span>C\u00e1c b\u1ea3ng c\u1ee7a plugin v\u00e0 giao di\u1ec7n kh\u00f4ng s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>99% t\u1ea5t c\u1ea3 plugin WordPress l\u01b0u tr\u1eef c\u00e1c c\u00e0i \u0111\u1eb7t (setting)* v\u00e0 d\u1eef li\u1ec7u c\u1ee7a n\u00f3 trong database c\u1ee7a WordPress. Th\u1eadt kh\u00f4ng may, khi b\u1ea1n g\u1ee1 b\u1ea3n c\u00e0i m\u1ed9t plugin WordPress n\u00e0o \u0111\u00f3, th\u00f4ng tin n\u00e0y kh\u00f4ng b\u1ecb lo\u1ea1i b\u1ecf \u0111\u00e2u!<\/p>\n\n\n\n<p>(*): <em>setting<\/em> \u0111\u01b0\u1ee3c d\u1ecbch l\u00e0 <em>c\u00e0i \u0111\u1eb7t<\/em> nh\u01b0ng b\u1ea1n \u0111\u1eebng nh\u1ea7m v\u1edbi <em>install<\/em>, c\u0169ng hay \u0111\u01b0\u1ee3c d\u1ecbch l\u00e0 <em>c\u00e0i \u0111\u1eb7t<\/em>. \u0110\u1ec3 d\u1ec5 hi\u1ec3u th\u00ec install gi\u1ed1ng nh\u01b0 b\u1ea1n l\u1eafp m\u00e1y \u0111i\u1ec1u h\u00f2a, b\u1ea1n \u0111\u1ee5c t\u01b0\u1eddng, \u0111o d\u00e2y, l\u1eafp c\u1ee5c n\u00f3ng, c\u1ee5c l\u1ea1nh; c\u00f2n setting gi\u1ed1ng v\u1edbi c\u00e1ch b\u1ea1n s\u1eed d\u1ee5ng, nh\u01b0 b\u1ea1n c\u00e0i nhi\u1ec7t \u0111\u1ed9 bao nhi\u00eau, c\u00f3 b\u1eadt ch\u1ebf \u0111\u1ed9 im l\u1eb7ng kh\u00f4ng, c\u00f3 b\u1eadt h\u1eb9n gi\u1edd, l\u1ecdc kh\u00f4ng kh\u00ed kh\u00f4ng, v\u00e2n v\u00e2n.<\/p>\n\n\n\n<p>\u0110i\u1ec1u n\u00e0y l\u00e0 do thi\u1ebft k\u1ebf. N\u1ebfu d\u1eef li\u1ec7u b\u1ecb lo\u1ea1i b\u1ecf m\u1ed7i l\u1ea7n b\u1ea1n v\u00f4 hi\u1ec7u h\u00f3a\/x\u00f3a m\u1ed9t plugin, b\u1ea1n s\u1ebd ph\u1ea3i c\u1ea5u h\u00ecnh l\u1ea1i plugin khi b\u1ea1n k\u00edch ho\u1ea1t l\u1ea1i n\u00f3 \/ reactivate ** (nhi\u1ec1u plugin c\u00f3 c\u1ea5u h\u00ecnh r\u1ea5t ph\u1ee9c t\u1ea1p). B\u1ea1n s\u1ebd m\u1ea5t b\u1ea5t k\u1ef3 b\u00e1o c\u00e1o ho\u1eb7c n\u1ed9i dung n\u00e0o m\u00e0 plugin \u0111\u00e3 t\u1ea1o ra (v\u00ed d\u1ee5 c\u00e1c b\u1ea3ng kh\u1ea3o s\u00e1t, c\u00e1c th\u00f4ng tin m\u00e0 ng\u01b0\u1eddi d\u00f9ng \u0111i\u1ec1n v\u00e0o form).<\/p>\n\n\n\n<p>(**) v\u00e0 (***): khi b\u1ea1n kh\u00f4ng d\u00f9ng plugin n\u00e0o \u0111\u00f3 b\u1ea1n c\u00f3 hai l\u1ef1a ch\u1ecdn: (1) b\u1ea1n h\u1ee7y k\u00edch ho\u1ea1t n\u00f3 c\u00f2n g\u1ecdi l\u00e0 deactivate ho\u1eb7c (2) b\u1ea1n g\u1ee1 h\u1eb3n n\u00f3 ra c\u00f2n g\u1ecdi l\u00e0 uninstall. \u0110\u1ec3 uninstall b\u1ea1n bu\u1ed9c ph\u1ea3i deactive n\u00f3 tr\u01b0\u1edbc.<\/p>\n\n\n\n<p>Tuy v\u1eady, n\u1ebfu b\u1ea1n quy\u1ebft \u0111\u1ecbnh ng\u1eebng s\u1eed d\u1ee5ng plugin, ho\u1eb7c n\u1ebfu b\u1ea1n ch\u1ec9 \u0111\u01a1n gi\u1ea3n \u0111ang test th\u1eed plugin, b\u1ea1n s\u1ebd mu\u1ed1n lo\u1ea1i b\u1ecf ho\u00e0n to\u00e0n t\u1ea5t c\u1ea3 d\u1eef li\u1ec7u khi b\u1ea1n g\u1ee1 c\u00e0i \u0111\u1eb7t (uninstall) *** plugin. Ch\u1ec9 c\u00f3 m\u1ed9t l\u01b0\u1ee3ng nh\u1ecf plugin WordPress bao g\u1ed3m t\u00f9y ch\u1ecdn trong c\u00e0i \u0111\u1eb7t c\u1ee7a h\u1ecd cho ph\u00e9p b\u1ea1n lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 d\u1eef li\u1ec7u, trong khi ph\u1ea7n l\u1edbn plugin kh\u00f4ng c\u00f3 t\u00f9y ch\u1ecdn n\u00e0y.<\/p>\n\n\n\n<p>(***): unistall m\u1ea1nh h\u01a1n deactive. V\u1edbi deactive, plugin ch\u1ec9 nh\u01b0 ng\u1ee7 \u0111\u00f4ng th\u00f4i, c\u00f2n unistall l\u00e0 b\u1ea1n <em>g\u1ea7n nh\u01b0<\/em> lo\u1ea1i b\u1ecf n\u00f3 kh\u1ecfi website.<\/p>\n\n\n\n<p>V\u00ec l\u00fd do \u0111\u00f3, database c\u1ee7a WordPress c\u00f3 th\u1ec3 t\u00edch l\u0169y r\u1ea5t nhi\u1ec1u d\u1eef li\u1ec7u d\u01b0 th\u1eeba theo th\u1eddi gian. Kh\u00f4ng c\u00f3 g\u00ec l\u1ea1 khi database c\u1ee7a WordPress bao g\u1ed3m h\u00e0ng t\u00e1 b\u1ea3ng c\u1ee7a plugin m\u00e0 \u0111\u00e3 b\u1ecb lo\u1ea1i b\u1ecf nhi\u1ec1u th\u00e1ng tr\u01b0\u1edbc \u0111\u00e2y, ho\u1eb7c th\u1eadm ch\u00ed l\u00e0 nhi\u1ec1u n\u0103m tr\u01b0\u1edbc.<\/p>\n\n\n\n<p>Giao di\u1ec7n c\u1ee7a WordPress c\u0169ng l\u01b0u tr\u1eef c\u00e1c c\u00e0i \u0111\u1eb7t trong database WordPress v\u00e0 c\u00e1c c\u00e0i \u0111\u1eb7t n\u00e0y s\u1ebd v\u1eabn c\u00f2n trong database c\u1ee7a b\u1ea1n khi b\u1ea1n chuy\u1ec3n sang d\u00f9ng giao di\u1ec7n kh\u00e1c.<\/p>\n\n\n\n<p>C\u00e1c b\u1ea3ng kh\u00f4ng s\u1eed d\u1ee5ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c lo\u1ea1i b\u1ecf kh\u1ecfi database c\u1ee7a b\u1ea1n theo c\u00e1ch th\u1ee7 c\u00f4ng th\u00f4ng qua c\u00f4ng c\u1ee5 qu\u1ea3n tr\u1ecb database nh\u01b0 phpMyAdmin. D\u00f9 v\u1eady, ngay c\u1ea3 khi b\u1ea1n c\u00f3 hi\u1ec3u bi\u1ebft t\u1ed1t v\u1ec1 11 b\u1ea3ng l\u00f5i trong WordPress, b\u1ea1n s\u1ebd th\u1ea5y l\u00e0 kh\u00f3 c\u00f3 th\u1ec3 ph\u00e2n bi\u1ec7t \u0111\u01b0\u1ee3c b\u1ea3ng n\u00e0o l\u00e0 c\u1ee7a plugin \u0111ang \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t, c\u00f2n b\u1ea3ng n\u00e0o l\u00e0 c\u1ee7a plugin \u0111\u00e3 g\u1ee1 c\u00e0i \u0111\u1eb7t r\u1ed3i.<\/p>\n\n\n\n<p>Ch\u00fa th\u00edch c\u1ee7a ng\u01b0\u1eddi d\u1ecbch: th\u1ef1c ra c\u00e1c b\u1ea3ng trong database l\u00e0 th\u1ee9 d\u1ec5 ki\u1ec3m tra nh\u1ea5t \u0111\u1ec3 bi\u1ebft n\u00f3 thu\u1ed9c v\u1ec1 plugin n\u00e0o, c\u00e1c trang nh\u01b0 <a href=\"https:\/\/plugintests.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">Plugintests<\/a> cung c\u1ea5p c\u00e1c th\u00f4ng tin ki\u1ec3u nh\u01b0 v\u1eady. V\u1ec1 sau b\u1ea1n s\u1ebd th\u1ea5y Cron Jobs v\u00e0 Options m\u1edbi l\u00e0 th\u1ee9 kh\u00f3 bi\u1ebft. C\u00e1c b\u1ea3ng d\u00f9 sao c\u0169ng kh\u00f4ng nhi\u1ec1u, ch\u1ec9 v\u00e0i ch\u1ee5c c\u00e1i, m\u1ea5t v\u00e0i ti\u1ebfng c\u1ea7n c\u00f9 search tr\u00ean m\u1ea1ng l\u00e0 s\u1ebd ra th\u00f4i. T\u1ea5t nhi\u00ean m\u1ed9t s\u1ed1 plugin kh\u00f4ng ph\u1ed5 bi\u1ebfn ho\u1eb7c trong qu\u00e1 tr\u00ecnh ph\u00e1t tri\u1ec3n n\u00f3 thay \u0111\u1ed5i t\u00ean b\u1ea3ng CSDL th\u00ec s\u1ebd kh\u00f3 t\u00ecm h\u01a1n. Trong tr\u01b0\u1eddng h\u1ee3p nh\u01b0 v\u1eady v\u1eabn c\u00f3 gi\u1ea3i ph\u00e1p, d\u00f9 kh\u00e1 m\u1ea5t c\u00f4ng. \u0110\u00f3 l\u00e0 b\u1ea1n t\u1ea1o m\u1ed9t trang WordPress tr\u1eafng demo, sau \u0111\u00f3 c\u00e0i l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c plugin hi\u1ec7n b\u1ea1n \u0111ang k\u00edch ho\u1ea1t tr\u00ean trang, r\u1ed3i sau \u0111\u00f3 b\u1ea1n so s\u00e1nh c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u \u1edf hai trang, trang web ch\u00ednh th\u1ee9c v\u00e0 trang demo, b\u1ea1n s\u1ebd nhanh ch\u00f3ng ph\u00e1t hi\u1ec7n ra c\u00e1c b\u1ea3ng n\u00e0o thu\u1ed9c trang ch\u00ednh th\u1ee9c l\u00e0 t\u00e0n d\u01b0 c\u1ee7a (c\u00e1c) plugin v\u00e0\/ho\u1eb7c theme c\u0169 k\u1ef9 \u0111\u00e3 kh\u00f4ng c\u00f2n d\u00f9ng \u0111\u1ebfn t\u1eeb l\u00e2u.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cac-plugin-gay-c\u1ed3ng-k\u1ec1nh\"><span class=\"ez-toc-section\" id=\"Cac_plugin_gay_cong_kenh\"><\/span>C\u00e1c plugin g\u00e2y c\u1ed3ng k\u1ec1nh<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Ch\u00fa th\u00edch c\u1ee7a ng\u01b0\u1eddi d\u1ecbch: T\u00f4i cho r\u1eb1ng \u0111\u00e2y l\u00e0 m\u1ed9t trong c\u00e1c ph\u1ea7n b\u1ea1n c\u1ea7n \u0111\u1ec3 \u00fd nh\u1ea5t! C\u00f3 r\u1ea5t nhi\u1ec1u plugin thu th\u1eadp d\u1eef li\u1ec7u, v\u00e0 s\u1ebd tr\u1edf th\u00e0nh v\u1ea5n \u0111\u1ec1 v\u1ec1 k\u00edch c\u1ee1 tr\u00ean website trung b\u00ecnh ho\u1eb7c l\u1edbn. Theo th\u1eddi gian n\u00f3 c\u00f3 th\u1ec3 t\u00edch tr\u1eef m\u1ed9t l\u01b0\u1ee3ng d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3 m\u00e0 ph\u1ea7n nhi\u1ec1u trong s\u1ed1 \u0111\u00f3 kh\u00f4ng c\u00f2n h\u1eefu \u00edch n\u1eefa v\u00ec sau khi \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ed5ng h\u1ee3p ph\u00e2n t\u00edch, h\u1ea7u h\u1ebft d\u1eef li\u1ec7u qu\u00e1 kh\u1ee9 c\u00f3 th\u1ec3 lo\u1ea1i b\u1ecf \u0111i \u0111\u01b0\u1ee3c.<\/p>\n\n\n\n<p>&#8212;<\/p>\n\n\n\n<p>M\u1ed7i plugin b\u1ea1n c\u00e0i tr\u00ean website \u0111\u1ec1u l\u00e0m gia t\u0103ng k\u00edch c\u1ee1 c\u1ee7a database. Kh\u00f4ng gian l\u01b0u tr\u1eef m\u00e0 m\u1ed9t s\u1ed1 plugin s\u1eed d\u1ee5ng trong database c\u00f3 th\u1ec3 kh\u00f4ng \u0111\u00e1ng k\u1ec3; nh\u01b0ng m\u1ed9t s\u1ed1 plugin kh\u00e1c l\u1ea1i c\u00f3 th\u1ec3 b\u1ed5 sung th\u00eam r\u1ea5t nhi\u1ec1u v\u00e0o database.<\/p>\n\n\n\n<p>B\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n c\u00e0i m\u1ed9t plugin WordPress m\u1edbi, b\u1ea1n ph\u1ea3i l\u01b0u t\u00e2m ki\u1ec3m tra n\u00f3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn CPU c\u1ee7a m\u00e1y ch\u1ee7 th\u1ebf n\u00e0o, v\u00e0 kh\u00f4ng gian l\u01b0u tr\u1eef m\u00e0 n\u00f3 chi\u1ebfm d\u1eef trong c\u01a1 s\u1edf d\u1eef li\u1ec7u l\u00e0 bao nhi\u00eau.<\/p>\n\n\n\n<p>C\u00e1c ki\u1ec3u plugin WordPress sau \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn l\u00e0 l\u01b0u tr\u1eef r\u1ea5t nhi\u1ec1u d\u1eef li\u1ec7u trong database.<\/p>\n\n\n\n<ul>\n<li><strong>C\u00e1c plugin ch\u1ed1ng spam<\/strong> &#8211; \u0110\u1ec3 b\u1ea3o v\u1ec7 website c\u1ee7a b\u1ea1n, nhi\u1ec1u plugin ch\u1ed1ng spam l\u01b0u tr\u1eef th\u00f4ng tin nh\u01b0 \u0111\u1ecba ch\u1ec9 IP v\u00e0 \u0111\u1ecba ch\u1ec9 email. L\u1ea5y v\u00ed d\u1ee5, Akismet l\u01b0u tr\u1eef r\u1ea5t nhi\u1ec1u d\u1eef li\u1ec7u trong b\u1ea3ng WP_CommentMeta.<\/li>\n\n\n\n<li><strong>C\u00e1c plugin b\u1ea3o m\u1eadt<\/strong> &#8211; C\u0169ng gi\u1ed1ng nh\u01b0 c\u00e1c plugin ch\u1ed1ng spam, c\u00e1c plugin b\u1ea3o m\u1eadt l\u01b0u gi\u1eef v\u00e0 theo d\u00f5i nhi\u1ec1u th\u00f4ng tin v\u1ec1 spammer v\u00e0 hacker (v\u00ed d\u1ee5 <a href=\"https:\/\/wordpress.org\/plugins\/wordfence\/\" target=\"_blank\" rel=\"noreferrer noopener\">plugin wordfence<\/a> c\u00f3 th\u1ec3 t\u1ea1o ra nhi\u1ec1u b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 k\u00edch c\u1ee1 l\u1edbn).<\/li>\n\n\n\n<li><strong>C\u00e1c plugin th\u1ed1ng k\u00ea<\/strong> &#8211; C\u00e1c plugin WordPress cung c\u1ea5p c\u00e1c b\u00e1o c\u00e1o v\u1ec1 l\u01b0u l\u01b0\u1ee3ng truy c\u1eadp v\u00e0 ph\u00e2n t\u00edch c\u1ea7n l\u01b0u tr\u1eef m\u1ed9t l\u01b0\u1ee3ng l\u1edbn d\u1eef li\u1ec7u trong database website c\u1ee7a b\u1ea1n. \u0110i\u1ec1u n\u00e0y bao g\u1ed3m th\u00f4ng tin l\u01b0\u1ee3t xem, l\u01b0\u1ee3t gh\u00e9 th\u0103m, qu\u1ed1c gia, tr\u00ecnh duy\u1ec7t, h\u1ec7 \u0111i\u1ec1u h\u00e0nh, trang gi\u1edbi thi\u1ec7u, t\u1eeb kh\u00f3a, v\u00e0 nhi\u1ec1u th\u00f4ng tin kh\u00e1c n\u1eefa.<\/li>\n\n\n\n<li><strong>Plugin b\u00e0i vi\u1ebft li\u00ean quan v\u00e0 b\u00e0i vi\u1ebft ph\u1ed5 bi\u1ebfn<\/strong> &#8211; C\u00e1c plugin WordPress cho m\u1ee5c \u0111\u00edch n\u00e0y r\u00f5 r\u00e0ng s\u1eed d\u1ee5ng r\u1ea5t nhi\u1ec1u CPU v\u00e0 kh\u00f4ng gian l\u01b0u tr\u1eef c\u1ee7a database. C\u00e1c ki\u1ec3u plugin n\u00e0y c\u1ea7n l\u01b0u tr\u1eef nhi\u1ec1u d\u1eef li\u1ec7u trong database; ch\u1eb3ng h\u1ea1n nh\u01b0 s\u1ed1 l\u01b0\u1ee3t th\u00edch (like), chia s\u1ebb (share), v\u00e0 l\u01b0\u1ee3t xem (views) m\u00e0 t\u1eebng trang tr\u00ean website c\u1ee7a b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c.<\/li>\n\n\n\n<li><strong>C\u00e1c plugin ph\u00e2n t\u00edch li\u00ean k\u1ebft (tracking link)<\/strong> &#8211; H\u1ea7u h\u1ebft c\u00e1c gi\u1ea3i ph\u00e1p theo d\u00f5i li\u00ean k\u1ebft cho b\u1ea1n t\u00f9y ch\u1ecdn l\u01b0u gi\u1eef th\u00f4ng tin s\u1ed1 l\u01b0\u1ee3ng click v\u00e0o li\u00ean k\u1ebft. \u0110i\u1ec1u n\u00e0y c\u00f3 \u00edch khi b\u1ea1n mu\u1ed1n hi\u1ec3u th\u00f3i quen c\u1ee7a ng\u01b0\u1eddi \u0111\u1ecdc v\u00e0 n\u01a1i n\u00e0o l\u01b0u l\u01b0\u1ee3ng truy c\u1eadp b\u1ecb h\u01b0\u1edbng ra ngo\u00e0i nhi\u1ec1u nh\u1ea5t. Tuy nhi\u00ean, theo d\u00f5i c\u00e1c click nh\u01b0 v\u1eady c\u00f3 th\u1ec3 t\u1ed1n r\u1ea5t nhi\u1ec1u kh\u00f4ng gian l\u01b0u tr\u1eef c\u1ee7a database (th\u01b0\u1eddng kh\u00f4ng ch\u1ec9 s\u1ed1 l\u01b0\u1ee3t click, n\u00f3 c\u00f2n l\u01b0u th\u00f4ng tin tr\u00ecnh duy\u1ec7t, th\u1eddi gian, h\u1ec7 \u0111i\u1ec1u h\u00e0nh, IP, v\u00e2n v\u00e2n).<\/li>\n<\/ul>\n\n\n\n<p>M\u1ed9t s\u1ed1 nh\u00e0 l\u1eadp tr\u00ecnh quan t\u00e2m \u0111\u1ebfn th\u1ef1c t\u1ebf l\u00e0 plugin c\u1ee7a h\u1ecd s\u1eed d\u1ee5ng r\u1ea5t nhi\u1ec1u kh\u00f4ng gian l\u01b0u tr\u1eef. \u0110i\u1ec1u \u0111\u00f3 gi\u1ea3i th\u00edch t\u1ea1i sao nh\u1eefng nh\u00e0 l\u1eadp tr\u00ecnh \u0111\u00f3 \u0111\u01b0a ra t\u00f9y ch\u1ecdn x\u00f3a d\u1eef li\u1ec7u trong plugin c\u1ee7a h\u1ecd.<\/p>\n\n\n\n<p>L\u1ea5y v\u00ed d\u1ee5, t\u00f4i theo d\u00f5i li\u00ean k\u1ebft b\u1eb1ng <a href=\"https:\/\/wordpress.org\/plugins\/pretty-link\/\" target=\"_blank\" rel=\"noreferrer noopener\">plugin Pretty Link<\/a>. Plugin cho ph\u00e9p b\u1ea1n v\u00f4 hi\u1ec7u h\u00f3a h\u1ec7 th\u1ed1ng theo d\u00f5i \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng b\u00ean trong. C\u00f3 ba c\u00e0i \u0111\u1eb7t theo d\u00f5i \u0111\u1ec3 b\u1ea1n ch\u1ecdn l\u1ef1a, bao g\u1ed3m: (1) Theo d\u00f5i th\u00f4ng th\u01b0\u1eddng, (2) C\u1ea5u h\u00ecnh theo d\u00f5i m\u1edf r\u1ed9ng cung c\u1ea5p nhi\u1ec1u th\u1ed1ng k\u00ea h\u01a1n nh\u01b0ng l\u00e0m \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t\/t\u1ed1c \u0111\u1ed9, v\u00e0 (3) T\u00f9y ch\u1ecdn theo d\u00f5i click \u0111\u01a1n gi\u1ea3n cung c\u1ea5p \u00edt d\u1eef li\u1ec7u h\u01a1n nh\u01b0ng l\u1ea1i gi\u00fap b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c hi\u1ec7u su\u1ea5t t\u1ed1t nh\u1ea5t.<\/p>\n\n\n\n<p>C\u00e1c con s\u1ed1 th\u1ed1ng k\u00ea c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c x\u00f3a trong khu v\u1ef1c t\u00f9y ch\u1ec9nh. Plugin cho ph\u00e9p b\u1ea1n x\u00f3a t\u1ea5t c\u1ea3 c\u00e1c th\u00f4ng tin l\u01b0u tr\u1eef trong 30 ng\u00e0y ho\u1eb7c 90 ng\u00e0y \u0111\u00e3 qua.<\/p>\n\n\n\n<p>M\u1ed9t s\u1ed1 plugin WordPress kh\u00e1c cho ph\u00e9p b\u1ea1n reset l\u1ea1i d\u1eef li\u1ec7u v\u00e0 lo\u1ea1i b\u1ecf c\u00e1c b\u1ea3ng m\u00e0 plugin \u0111\u00e3 th\u00eam v\u00e0o. D\u00f9 v\u1eady, n\u00f3i chung, h\u1ea7u h\u1ebft plugin kh\u00f4ng c\u00f3 t\u00ednh n\u0103ng cho ph\u00e9p lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 d\u1eef li\u1ec7u.<\/p>\n\n\n<div class=\"wp-block-image wp-image-14434 size-full\">\n<figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/kiencang.net\/wp-content\/uploads\/2020\/02\/plugin-P3.png\" alt=\"c\u00f4ng c\u1ee5 ki\u1ec3m tra \u1ea3nh h\u01b0\u1edfng hi\u1ec7u su\u1ea5t c\u1ee7a plugin\" class=\"wp-image-14434\"\/><figcaption class=\"wp-element-caption\">P3 plugin c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n \u0111\u00e1nh d\u1ea5u nh\u1eefng plugin l\u00e0m ch\u1eadm website c\u1ee7a b\u1ea1n<\/figcaption><\/figure><\/div>\n\n\n<p>M\u1ed9t c\u00f4ng c\u1ee5 t\u1ed1t \u0111\u1ec3 ki\u1ec3m tra c\u00e1c plugin c\u00e0i tr\u00ean trang WordPress c\u1ee7a b\u1ea1n c\u00f3 l\u00e0m ch\u1eadm website c\u1ee7a b\u1ea1n hay kh\u00f4ng l\u00e0 <a href=\"https:\/\/wordpress.org\/plugins\/p3-profiler\/\" target=\"_blank\" rel=\"noreferrer noopener\">P3 (Plugin Performance Profiler)<\/a>. Plugin s\u1ebd highlight \u1ea3nh h\u01b0\u1edfng c\u1ee7a t\u1eebng plugin l\u00ean th\u1eddi gian t\u1ea3i trang.<\/p>\n\n\n\n<p>N\u1ebfu m\u1ed9t plugin s\u1eed d\u1ee5ng nhi\u1ec1u kh\u00f4ng gian l\u01b0u tr\u1eef trong database, ho\u1eb7c l\u00e0m ch\u1eadm website c\u1ee7a b\u1ea1n \u0111\u00e1ng k\u1ec3, h\u00e3y lo\u1ea1i b\u1ecf n\u00f3. T\u00f4i ch\u1ec9 khuy\u00ean gi\u1eef l\u1ea1i plugin l\u00e0m ch\u1eadm website n\u1ebfu n\u00f3 n\u1eafm vai tr\u00f2 r\u1ea5t quan tr\u1ecdng v\u1edbi m\u1ee5c ti\u00eau c\u1ee7a website. D\u00f9 v\u1eady, t\u00f4i tin r\u1eb1ng lu\u00f4n lu\u00f4n c\u00f3 c\u00e1c gi\u1ea3i ph\u00e1p thay th\u1ebf nh\u1eb9 nh\u00e0ng h\u01a1n \u0111\u1ec3 b\u1ea1n kh\u00f4ng c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng plugin n\u1eb7ng n\u1ec1 n\u1eefa.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"cach-t\u1ed1i-\u01b0u-database-c\u1ee7a-b\u1ea1n-b\u1eb1ng-plugin\"><span class=\"ez-toc-section\" id=\"Cach_toi_uu_database_cua_ban_bang_plugin\"><\/span>C\u00e1ch t\u1ed1i \u01b0u database c\u1ee7a b\u1ea1n b\u1eb1ng plugin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Th\u00f4ng qua b\u00e0i vi\u1ebft n\u00e0y t\u00f4i \u0111\u00e3 \u0111\u01b0a ra l\u1eddi khuy\u00ean v\u1ec1 c\u00e1ch t\u1ed1i \u01b0u h\u00f3a database s\u1eed d\u1ee5ng <em>phpMyAdmin<\/em> v\u00e0 <em>wp-config.php<\/em>. N\u1ebfu vi\u1ec7c s\u1eed d\u1ee5ng phpMyAdmin l\u00e0m b\u1ea1n lo l\u1eafng, b\u1ea1n c\u00f3 th\u1ec3 th\u00edch s\u1eed d\u1ee5ng c\u00e1c plugin WordPress \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a c\u01a1 s\u1edf d\u1eef li\u1ec7u. Ch\u00fang ta c\u00f3 m\u1ed9t s\u1ed1 plugin t\u1ed1t \u0111\u1ea3m nhi\u1ec7m \u0111\u01b0\u1ee3c t\u1ed1t vai tr\u00f2 n\u00e0y.<\/p>\n\n\n\n<p><a href=\"https:\/\/wordpress.org\/plugins\/wp-clean-up\/\" target=\"_blank\" rel=\"noreferrer noopener\">WP Clean UP<\/a> l\u00e0 c\u00e1ch t\u1ed1t \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c d\u1eef li\u1ec7u v\u00f4 d\u1ee5ng. N\u00f3 cho ph\u00e9p b\u1ea1n lo\u1ea1i b\u1ecf c\u00e1c revision, b\u1ea3n nh\u00e1p, b\u00ecnh lu\u1eadn, v\u00e0 nhi\u1ec1u th\u1ee9 kh\u00e1c &#8211; t\u1ea5t c\u1ea3 ch\u1ec9 th\u00f4ng qua m\u1ed9t n\u00fat b\u1ea5m.<\/p>\n\n\n\n<p><a href=\"https:\/\/wordpress.org\/plugins\/wp-optimize\/\" target=\"_blank\" rel=\"noreferrer noopener\">WP-Optimize<\/a> c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c revision c\u0169 c\u1ee7a b\u00e0i vi\u1ebft, c\u00e1c b\u1ea3n nh\u00e1p, c\u00e1c b\u00ecnh lu\u1eadn spam, c\u00e1c b\u00ecnh lu\u1eadn ch\u01b0a \u0111\u01b0\u1ee3c ph\u00ea duy\u1ec7t, c\u00e1c b\u00ecnh lu\u1eadn trong th\u00f9ng r\u00e1c, c\u00e1c t\u00f9y ch\u1ecdn transient, pingback, v\u00e0 trackback. N\u00f3 c\u0169ng bao g\u1ed3m m\u1ed9t trang hi\u1ec3n th\u1ecb k\u00edch c\u1ee1 d\u1eef li\u1ec7u, k\u00edch c\u1ee1 index, v\u00e0 overhead, c\u1ee7a t\u1eebng b\u1ea3ng database.<\/p>\n\n\n\n<p>M\u1ed9t plugin t\u1ed1i \u01b0u h\u00f3a ph\u1ed5 bi\u1ebfn kh\u00e1c l\u00e0 <a href=\"https:\/\/wordpress.org\/plugins\/wp-dbmanager\/\" target=\"_blank\" rel=\"noreferrer noopener\">WP-DBManager<\/a>. N\u00f3 l\u00e0 plugin \u0111a t\u00ednh n\u0103ng cho ph\u00e9p b\u1ea1n t\u1ed1i \u01b0u h\u00f3a v\u00e0 s\u1eeda ch\u1eefa database. Backup t\u1ef1 \u0111\u1ed9ng website c\u1ee7a b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c t\u00f9y ch\u1ec9nh.<\/p>\n\n\n\n<p>WP-DBManager l\u00e0 m\u1ed9t plugin ch\u1ea5t l\u01b0\u1ee3ng, nh\u01b0ng t\u1eeb quan \u0111i\u1ec3m b\u1ea3o m\u1eadt t\u00f4i cho r\u1eb1ng c\u1ea7n s\u1eed d\u1ee5ng n\u00f3 m\u1ed9t c\u00e1ch c\u1ea9n th\u1ea9n, b\u1edfi v\u00ec plugin n\u00e0y c\u0169ng cho ph\u00e9p b\u1ea1n x\u00f3a n\u1ed9i dung b\u1ea3ng (empty), lo\u1ea1i b\u1ecf b\u1ea3ng (drop) ho\u00e0n to\u00e0n v\u00e0 ch\u1ea1y c\u00e1c truy v\u1ea5n MySQL. V\u00ec l\u00fd do \u0111\u00f3, b\u1ea5t k\u1ef3 ai c\u00f3 kh\u1ea3 n\u0103ng truy c\u1eadp v\u00e0o website c\u1ee7a b\u1ea1n s\u1eed d\u1ee5ng c\u00e1c ph\u01b0\u01a1ng th\u1ee9c \u0111\u1ed9c h\u1ea1i c\u00f3 th\u1ec3 tr\u1edf n\u00ean r\u1ea5t nguy hi\u1ec3m.<\/p>\n\n\n\n<p>V\u1edbi nh\u1eefng ai s\u1eed d\u1ee5ng <a href=\"https:\/\/managewp.com\/\" target=\"_blank\" rel=\"noreferrer noopener\">ManageWP<\/a> \u0111\u1ec3 qu\u1ea3n tr\u1ecb website d\u1ea1ng multiple c\u00f3 th\u1ec3 t\u1ed1i \u01b0u h\u00f3a database th\u00f4ng qua giao di\u1ec7n qu\u1ea3n tr\u1ecb ManageWP.<\/p>\n\n\n\n<p>Ch\u00fa th\u00edch c\u1ee7a ng\u01b0\u1eddi d\u1ecbch: \u1ede th\u1eddi \u0111i\u1ec3m hi\u1ec7n t\u1ea1i t\u00f4i th\u1ea5y <a href=\"https:\/\/sigmaplugin.com\/downloads\/wordpress-advanced-database-cleaner\" target=\"_blank\" rel=\"noreferrer noopener\">phi\u00ean b\u1ea3n pro<\/a> c\u1ee7a <a href=\"https:\/\/kiencang.net\/plugin-advanced-database-cleaner\/\" target=\"_blank\" rel=\"noreferrer noopener\">plugin Advanced Database Cleaner<\/a> c\u00f3 kh\u1ea3 n\u0103ng t\u1ed1t nh\u1ea5t \u0111\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c t\u1ed1i \u01b0u h\u00f3a c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch chuy\u00ean s\u00e2u. M\u1ed9t plugin kh\u00e1c r\u1ea5t n\u1ed5i ti\u1ebfng l\u00e0 <a href=\"https:\/\/wordpress.org\/plugins\/wp-optimize\/\" target=\"_blank\" rel=\"noreferrer noopener\">WP-Optimize<\/a>, nh\u01b0ng d\u01b0\u1eddng nh\u01b0 n\u00f3 b\u1ecb m\u1ea5t t\u1eadp trung v\u00e0o v\u1ea5n \u0111\u1ec1 t\u1ed1i \u01b0u database, v\u00ec lan man sang c\u1ea3 nh\u1eefng ph\u1ea7n nh\u01b0 t\u1ed1i \u01b0u h\u00f3a \u1ea3nh v\u00e0 t\u1ea1o cache, th\u00e0nh ra t\u00f4i kh\u00f4ng th\u00edch d\u00f9ng. N\u1ebfu b\u1ea1n th\u00edch s\u1ef1 ti\u1ec7n l\u1ee3i, t\u00ednh n\u0103ng t\u1ed1i \u01b0u h\u00f3a csdl c\u1ee7a plugin cache n\u1ed5i ti\u1ebfng LiteSpeed cache c\u0169ng r\u1ea5t t\u1ed1t.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"vai-suy-nghi-cu\u1ed1i-cung\"><span class=\"ez-toc-section\" id=\"Vai_suy_nghi_cuoi_cung\"><\/span>V\u00e0i suy ngh\u0129 cu\u1ed1i c\u00f9ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>T\u00f4i \u0111\u00e3 gi\u00fap nhi\u1ec1u ch\u1ee7 website nhi\u1ec1u n\u0103m qua- v\u1edbi \u0111a d\u1ea1ng c\u00e1c v\u1ea5n \u0111\u1ec1 li\u00ean quan \u0111\u1ebfn WordPress. Bu\u1ed3n thay, c\u00f3 r\u1ea5t \u00edt ng\u01b0\u1eddi ti\u1ebfn h\u00e0nh th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc \u0111\u1ec3 gi\u1eef database website c\u1ee7a h\u1ecd ch\u1ea1y hi\u1ec7u qu\u1ea3. Th\u1ef1c s\u1ef1 th\u1eadt kh\u00f3 tha th\u1ee9 cho \u0111i\u1ec1u n\u00e0y v\u00ec n\u00f3 ch\u1ec9 m\u1ea5t c\u00f3 v\u00e0i ph\u00fat \u0111\u1ec3 tinh ch\u1ec9nh website WordPress c\u1ee7a b\u1ea1n th\u1eadt ch\u00ednh x\u00e1c.<\/p>\n\n\n\n<p>\u0110\u00e2y l\u00e0 \u0111i\u1ec1u m\u00e0 t\u00f4i l\u00e0m tr\u00ean c\u00e1c trang web WordPress c\u1ee7a m\u00ecnh \u0111\u1ec3 gi\u1eef database c\u1ee7a n\u00f3 \u0111\u01b0\u1ee3c t\u1ed1i \u01b0u:<\/p>\n\n\n\n<ul>\n<li>T\u00f4i gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng c\u00e1c post revisions xu\u1ed1ng hai b\u1eb1ng c\u00e1ch th\u00eam <em>define( \u2018WP_POST_REVISIONS\u2019, 2 ); <\/em>v\u00e0o <em>wp-config.php<\/em>;<\/li>\n\n\n\n<li>T\u00f4i tri\u1ec3n khai c\u00e1c bi\u1ec7n ph\u00e1p ki\u1ec3m k\u00ea ch\u1ed1ng spam m\u1ea1nh \u0111\u1ec3 gi\u1ea3m l\u01b0\u1ee3ng l\u1edbn n\u1ed9i dung spam th\u00eam v\u00e0o database c\u1ee7a t\u00f4i;<\/li>\n\n\n\n<li>T\u00f4i \u0111\u00e1nh gi\u00e1 k\u1ef9 c\u00e0ng b\u1ea5t k\u1ef3 item n\u00e0o t\u00f4i mu\u1ed1n x\u00f3a v\u00e0 sau \u0111\u00f3 x\u00f3a ch\u00fang v\u0129nh vi\u1ec5n (thay v\u00ec \u0111\u1ec3 ch\u00fang trong th\u00f9ng r\u00e1c).<\/li>\n<\/ul>\n\n\n\n<p>T\u00f4i c\u0169ng th\u1ef1c hi\u1ec7n ki\u1ec3m tra database c\u1ee7a t\u00f4i \u0111\u1ecbnh k\u1ef3 th\u00f4ng qua phpMyAdmin. \u0110i\u1ec1u n\u00e0y cho ph\u00e9p t\u00f4i c\u01a1 h\u1ed9i ph\u00e1t hi\u1ec7n ra v\u1ea5n \u0111\u1ec1 \u0111\u1ec3 t\u1ed1i \u01b0u h\u00f3a b\u1ea3ng database v\u00e0 lo\u1ea1i b\u1ecf b\u1ea5t c\u1ee9 b\u1ea3ng database n\u00e0o kh\u00f4ng s\u1eed d\u1ee5ng m\u1ed9t c\u00e1ch k\u1ecbp th\u1eddi. <\/p>\n\n\n\n<p>Theo th\u1eddi gian t\u00f4i c\u0169ng s\u1eed d\u1ee5ng c\u00e1c plugin t\u1ed1i \u01b0u h\u00f3a, ch\u1eb3ng h\u1ea1n nh\u01b0 <a href=\"https:\/\/wordpress.org\/plugins\/wp-clean-up\/\" target=\"_blank\" rel=\"noreferrer noopener\">WP Clean Up<\/a>. \u0110i\u1ec1u n\u00e0y cho ph\u00e9p t\u00f4i lo\u1ea1i b\u1ecf c\u00e1c transients v\u00e0 b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u n\u00e0o kh\u00e1c \u0111\u00e3 kh\u00f4ng c\u00f2n gi\u00e1 tr\u1ecb t\u00edch l\u0169y t\u1eeb qu\u00e1 kh\u1ee9.<\/p>\n\n\n\n<p>V\u1edbi m\u1ed9t s\u1ed1 trang WordPress, t\u00f4i th\u1ef1c hi\u1ec7n gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng ng\u00e0y c\u00e1c d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c ph\u00e9p l\u01b0u tr\u1eef trong th\u00f9ng r\u00e1c t\u1eeb m\u1eb7c \u0111\u1ecbnh l\u00e0 30 xu\u1ed1ng ch\u1ec9 c\u00f2n 5. D\u00f9 v\u1eady, t\u00f4i th\u01b0\u1eddng kh\u00f4ng ph\u1ea3i th\u1ef1c hi\u1ec7n b\u01b0\u1edbc n\u00e0y v\u00ec t\u00f4i c\u00f3 th\u00f3i quen x\u00f3a m\u1ed9t th\u00e0nh ph\u1ea7n kh\u00f4ng s\u1eed d\u1ee5ng ho\u00e0n to\u00e0n.<\/p>\n\n\n\n<p>\u0110\u1ec3 gi\u1ea3m s\u1ed1 l\u01b0\u1ee3ng c\u00e1c l\u1eddi g\u1ecdi \u0111\u1ebfn database, t\u00f4i c\u00e0i plugin cache cho WordPress (<a href=\"https:\/\/kiencang.net\/hd-plugin-litespeed-cache-p1\/\" target=\"_blank\" rel=\"noreferrer noopener\">LiteSpeed cache<\/a>, WP-Rocket, <a href=\"https:\/\/kiencang.net\/cach-dung-plugin-swift-performance\/\" target=\"_blank\" rel=\"noreferrer noopener\">Swift Performance<\/a>). \u0110i\u1ec1u n\u00e0y kh\u00f4ng l\u00e0m gi\u1ea3m k\u00edch c\u1ee1 database c\u1ee7a t\u00f4i, nh\u01b0ng n\u00f3 l\u00e0m gi\u1ea3m s\u1ee9c \u00e9p l\u00ean m\u00e1y ch\u1ee7 MySQL v\u00e0 \u0111\u1ea3m b\u1ea3o c\u00e1c trang c\u1ee7a t\u00f4i \u0111\u01b0\u1ee3c t\u1ea3i nhanh ch\u00f3ng.<\/p>\n\n\n\n<p><em>(D\u1ecbch t\u1eeb b\u00e0i vi\u1ebft <a href=\"https:\/\/wpmudev.com\/blog\/optimizing-your-wordpress-database-a-complete-guide\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Optimizing Your WordPress Database \u2013 A Complete Guide c\u1ee7a WPMUdev<\/a>, t\u00e1c gi\u1ea3 Kevin Muldoon)<\/em><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"bonus-c\u1ee7a-ng\u01b0\u1eddi-d\u1ecbch\"><span class=\"ez-toc-section\" id=\"Bonus_cua_nguoi_dich\"><\/span>Bonus c\u1ee7a ng\u01b0\u1eddi d\u1ecbch<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>N\u1ebfu b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf to\u00e0n b\u1ed9 r\u1eafc r\u1ed1i li\u00ean quan \u0111\u1ebfn database, b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng s\u1eed d\u1ee5ng database n\u1eefa! C\u00f3 c\u00e1ch \u0111\u1ec3 l\u00e0m nh\u01b0 v\u1eady \u0111\u00f3 l\u00e0 s\u1eed d\u1ee5ng trang t\u0129nh ho\u00e3n to\u00e0n. Plugin c\u00f3 th\u1ec3 l\u00e0m \u0111i\u1ec1u \u0111\u00f3 c\u00f3 t\u00ean <a href=\"https:\/\/kiencang.net\/gioi-thieu-plugin-wp2static\/\" target=\"_blank\" rel=\"noreferrer noopener\">WP2Static<\/a> ho\u1eb7c <a href=\"https:\/\/kiencang.net\/website-wp-tinh-plugin-simply-static\/\" target=\"_blank\" rel=\"noreferrer noopener\">Simply Static<\/a>, n\u00f3 chuy\u1ec3n to\u00e0n b\u1ed9 trang WordPress \u0111\u1ed9ng c\u1ee7a b\u1ea1n th\u00e0nh HTML v\u00e0 c\u00e1c n\u1ed9i dung t\u0129nh \u0111i k\u00e8m nh\u01b0 CSS, JS v\u00e0 \u1ea3nh. Sau \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 up n\u00f3 l\u00ean <a href=\"https:\/\/kiencang.net\/cdn-wordpress\/\" target=\"_blank\" rel=\"noreferrer noopener\">d\u1ecbch v\u1ee5 CDN ch\u1ea5t l\u01b0\u1ee3ng cao<\/a> n\u00e0o \u0111\u00f3, ch\u1eb3ng h\u1ea1n nh\u01b0 <a href=\"https:\/\/kiencang.net\/gioi-thieu-bunnycdn\/\" target=\"_blank\" rel=\"noreferrer noopener\">BunnyCDN<\/a>. <\/p>\n\n\n\n<p>T\u1ea5t nhi\u00ean c\u00e1i g\u00ec c\u0169ng c\u00f3 c\u00e1i gi\u00e1 c\u1ee7a n\u00f3, trang t\u0129nh ho\u00e0n to\u00e0n kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi t\u1ea5t c\u1ea3 ki\u1ec3u trang, v\u00e0 b\u1ea5t c\u1ee9 y\u1ebfu t\u1ed1 \u0111\u1ed9ng n\u00e0o tr\u00ean trang s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng d\u1ecbch v\u1ee5 c\u1ee7a b\u00ean th\u1ee9 ba. B\u1ea1n h\u00e3y tham kh\u1ea3o link v\u1eeba d\u1eabn b\u00ean tr\u00ean \u0111\u1ec3 bi\u1ebft chi ti\u1ebft.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Nh\u1eadn x\u00e9t c\u1ee7a ng\u01b0\u1eddi d\u1ecbch: Trong s\u1ed1 c\u00e1c b\u00e0i vi\u1ebft v\u1ec1 database c\u1ee7a WordPress tr\u00ean website n\u00e0y, t\u00f4i \u01b0ng b\u00e0i n\u00e0y nh\u1ea5t, v\u00ec n\u00f3 h\u01b0\u1edbng \u0111\u1ebfn c\u00e1c gi\u1ea3i th\u00edch t\u1ed1i \u01b0u c\u0103n b\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u. B\u1ea1n s\u1ebd v\u1ee1 ra \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1ee9 sau khi \u0111\u1ecdc xong. Tuy nhi\u00ean nh\u01b0 m\u1ecdi b\u00e0i vi\u1ebft kh\u00e1c, &hellip;<\/p>\n","protected":false},"author":1,"featured_media":21384,"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>T\u1ed1i \u01b0u database WordPress: H\u01b0\u1edbng d\u1eabn to\u00e0n di\u1ec7n &#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-toan-dien\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u1ed1i \u01b0u database WordPress: H\u01b0\u1edbng d\u1eabn to\u00e0n di\u1ec7n &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"Nh\u1eadn x\u00e9t c\u1ee7a ng\u01b0\u1eddi d\u1ecbch: Trong s\u1ed1 c\u00e1c b\u00e0i vi\u1ebft v\u1ec1 database c\u1ee7a WordPress tr\u00ean website n\u00e0y, t\u00f4i \u01b0ng b\u00e0i n\u00e0y nh\u1ea5t, v\u00ec n\u00f3 h\u01b0\u1edbng \u0111\u1ebfn c\u00e1c gi\u1ea3i th\u00edch t\u1ed1i \u01b0u c\u0103n b\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u. B\u1ea1n s\u1ebd v\u1ee1 ra \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1ee9 sau khi \u0111\u1ecdc xong. Tuy nhi\u00ean nh\u01b0 m\u1ecdi b\u00e0i vi\u1ebft kh\u00e1c, &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/\" \/>\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=\"2022-02-12T14:08:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-23T20:34:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kiencang.net\/wp-content\/uploads\/2022\/02\/co-so-du-lieu.png\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"559\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"28 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T\u1ed1i \u01b0u database WordPress: H\u01b0\u1edbng d\u1eabn to\u00e0n di\u1ec7n &#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-toan-dien\/","og_locale":"vi_VN","og_type":"article","og_title":"T\u1ed1i \u01b0u database WordPress: H\u01b0\u1edbng d\u1eabn to\u00e0n di\u1ec7n &#8226; Ki\u1ebfn c\u00e0ng","og_description":"Nh\u1eadn x\u00e9t c\u1ee7a ng\u01b0\u1eddi d\u1ecbch: Trong s\u1ed1 c\u00e1c b\u00e0i vi\u1ebft v\u1ec1 database c\u1ee7a WordPress tr\u00ean website n\u00e0y, t\u00f4i \u01b0ng b\u00e0i n\u00e0y nh\u1ea5t, v\u00ec n\u00f3 h\u01b0\u1edbng \u0111\u1ebfn c\u00e1c gi\u1ea3i th\u00edch t\u1ed1i \u01b0u c\u0103n b\u1ea3n v\u00e0 d\u1ec5 hi\u1ec3u. B\u1ea1n s\u1ebd v\u1ee1 ra \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1ee9 sau khi \u0111\u1ecdc xong. Tuy nhi\u00ean nh\u01b0 m\u1ecdi b\u00e0i vi\u1ebft kh\u00e1c, &hellip;","og_url":"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2022-02-12T14:08:00+00:00","article_modified_time":"2023-07-23T20:34:49+00:00","og_image":[{"width":640,"height":559,"url":"https:\/\/kiencang.net\/wp-content\/uploads\/2022\/02\/co-so-du-lieu.png","type":"image\/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":"28 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/","url":"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/","name":"T\u1ed1i \u01b0u database WordPress: H\u01b0\u1edbng d\u1eabn to\u00e0n di\u1ec7n &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2022-02-12T14:08:00+00:00","dateModified":"2023-07-23T20:34:49+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/toi-uu-database-wordpress-toan-dien\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"T\u1ed1i \u01b0u database WordPress: H\u01b0\u1edbng d\u1eabn to\u00e0n di\u1ec7n"}]},{"@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\/16844"}],"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=16844"}],"version-history":[{"count":1,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/16844\/revisions"}],"predecessor-version":[{"id":24375,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/16844\/revisions\/24375"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media\/21384"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=16844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=16844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=16844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}