{"id":481,"date":"2014-03-06T21:02:09","date_gmt":"2014-03-06T20:02:09","guid":{"rendered":"http:\/\/www.antynet.pl\/?p=481"},"modified":"2014-03-06T21:32:02","modified_gmt":"2014-03-06T20:32:02","slug":"donlinkage-przyspieszenie-bazy-danych-mysql","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2014\/03\/06\/donlinkage-przyspieszenie-bazy-danych-mysql\/","title":{"rendered":"DonLinkage – optymalizacja serwera, przy\u015bpieszenie bazy danych mysql"},"content":{"rendered":"

Skrypt jest super.<\/p>\n

\n

Ale czasami mamy problemy z wydajno\u015bci\u0105.<\/p>\n

\n

Na pocz\u0105tek odszed\u0142em od apache2 i mod_php na rzecz ngix i php5-fpm.<\/p>\n

Ruszy\u0142o z kopyta \ud83d\ude09<\/p>\n

\n

Nast\u0119pnie zauwa\u017cy\u0142em i\u017c m\u0105czy si\u0119 mysql…. w znalezieniu tego pom\u00f3g\u0142 mysqltuner.<\/p>\n

Od razu uruchomi\u0142em:<\/p>\n

\n

mysqlcheck -u root -p –optimize \u2013all-databases ( zak\u0142adaj\u0105c i\u017c masz root i tylko ta lub niewiele baz, w innym razie dostosuj zapytanie )<\/p>\n<\/blockquote>\n

\n

Dalej …
\n\/etc\/mysql\/my.cnf
\ndodajemy:<\/p>\n

tmpdir = \/var\/mysql_tmpfs<\/p><\/blockquote>\n

Potem tworzymy katalog:<\/p>\n

mkdir \/var\/mysql_tmpfs<\/p><\/blockquote>\n

i …. to co najwa\u017cniejsze, tworzymy TMP w ramie:
\ndodajemy do \/etc\/fstab:<\/p>\n

none \/var\/mysql_tmpfs tmpfs defaults,size=3500M 1 2<\/p><\/blockquote>\n

oczywi\u015bcie size wedle potrzeby i mo\u017cliwo\u015bci.<\/p>\n

montujemy nowy zas\u00f3b:<\/p>\n

mount -a<\/p><\/blockquote>\n

teraz:<\/p>\n

chown mysql \/var\/mysql_tmpfs<\/p><\/blockquote>\n

i:<\/p>\n

\/etc\/myslq restart<\/p><\/blockquote>\n

Wygl\u0105da lepiej, jak co\u015b b\u0119d\u0119 aktualizowa\u0107 wpis.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Skrypt jest super. Ale czasami mamy problemy z wydajno\u015bci\u0105. Na pocz\u0105tek odszed\u0142em od apache2 i mod_php na rzecz ngix i php5-fpm. Ruszy\u0142o z kopyta \ud83d\ude09 Nast\u0119pnie zauwa\u017cy\u0142em i\u017c m\u0105czy si\u0119 mysql…. w znalezieniu tego pom\u00f3g\u0142 mysqltuner. Od razu uruchomi\u0142em: mysqlcheck -u root -p –optimize \u2013all-databases ( zak\u0142adaj\u0105c i\u017c masz root i tylko ta lub niewiele […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[4],"tags":[],"class_list":["post-481","post","type-post","status-publish","format-standard","hentry","category-sciaga-admina"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=481"}],"version-history":[{"count":11,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/481\/revisions"}],"predecessor-version":[{"id":492,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/481\/revisions\/492"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}