{"id":911,"date":"2022-04-11T10:30:48","date_gmt":"2022-04-11T03:30:48","guid":{"rendered":"https:\/\/doc.dncloud.net\/?p=911"},"modified":"2023-07-13T16:05:00","modified_gmt":"2023-07-13T09:05:00","slug":"huong-dan-toi-uu-hoa-mysql-tren-aapanel","status":"publish","type":"post","link":"https:\/\/dncloud.net\/blog\/huong-dan-toi-uu-hoa-mysql-tren-aapanel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ed1i \u01b0u mysql tr\u00ean aaPanel"},"content":{"rendered":"

Trong b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n aaPanel c\u00f3 t\u00ednh n\u0103ng r\u1ea5t h\u1eefu \u00edch \u0111\u00f3 l\u00e0 t\u1ed1i \u01b0u h\u00f3a mysql \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi c\u1ea5u h\u00ecnh ram c\u1ee7a VPS, trong b\u00e0i vi\u1ebft n\u00e0y m\u00ecnh s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n s\u1eed d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y.<\/p>\n

\u0110\u1ea7u ti\u00ean b\u1ea1n c\u1ea7n \u0111\u0103ng nh\u1eadp v\u00e0o aaPanel cu\u1ed9n trang xu\u1ed1ng s\u1ebd th\u1ea5y ph\u1ea7n Software<\/strong> t\u1ea1i \u0111\u00e2y \u00a0MySQL (ho\u1eb7c MariaDB)<\/strong>.<\/p>\n

\"\"<\/p>\n

Sau \u0111\u00f3 b\u1ea1n ch\u1ecdn m\u1ee5c Optimization<\/strong>.<\/p>\n

\"\"<\/p>\n

T\u1ea1i m\u1ee5c Optimization<\/strong> b\u1ea1n ch\u1ecdn m\u1ee9c ram t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi VPS c\u1ee7a b\u1ea1n \u0111ang d\u00f9ng. VPS c\u1ee7a m\u00ecnh 1GB ram n\u00ean m\u00ecnh s\u1ebd ch\u1ecdn 1-2GB.<\/p>\n

\"\"<\/p>\n

Sau khi ch\u1ecdn xong b\u1ea1n \u1ea5n n\u00fat Save<\/strong> v\u00e0 Restart mysqld service<\/strong>.<\/p>\n

\"\"<\/p>\n

V\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 t\u1ed1i \u01b0u ho\u00e0n t\u1ea5t mysql \u0111\u1ec3 t\u1eadn d\u1ee5ng to\u00e0n b\u1ed9 s\u1ee9c m\u1ea1nh.<\/p>\n

Ch\u00fac b\u1ea1n th\u00e0nh c\u00f4ng.<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Trong b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n aaPanel c\u00f3 t\u00ednh n\u0103ng r\u1ea5t h\u1eefu \u00edch \u0111\u00f3 l\u00e0 t\u1ed1i \u01b0u h\u00f3a…<\/p>\n","protected":false},"author":1,"featured_media":912,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[135,130],"tags":[139,186],"class_list":["post-911","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aapanel","category-huong-dan-vps","tag-aapanel","tag-mysql"],"_links":{"self":[{"href":"https:\/\/dncloud.net\/blog\/wp-json\/wp\/v2\/posts\/911","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dncloud.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dncloud.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dncloud.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dncloud.net\/blog\/wp-json\/wp\/v2\/comments?post=911"}],"version-history":[{"count":0,"href":"https:\/\/dncloud.net\/blog\/wp-json\/wp\/v2\/posts\/911\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dncloud.net\/blog\/wp-json\/wp\/v2\/media\/912"}],"wp:attachment":[{"href":"https:\/\/dncloud.net\/blog\/wp-json\/wp\/v2\/media?parent=911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dncloud.net\/blog\/wp-json\/wp\/v2\/categories?post=911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dncloud.net\/blog\/wp-json\/wp\/v2\/tags?post=911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}