{"id":506,"date":"2014-09-24T10:00:25","date_gmt":"2014-09-24T08:00:25","guid":{"rendered":"http:\/\/www.antynet.pl\/?p=506"},"modified":"2014-09-24T10:03:50","modified_gmt":"2014-09-24T08:03:50","slug":"mysql-sprawdzanie-naprawa-optymalizacja-o-zadanej-godzinie","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2014\/09\/24\/mysql-sprawdzanie-naprawa-optymalizacja-o-zadanej-godzinie\/","title":{"rendered":"mysql – sprawdzanie naprawa optymalizacja – o zadanej godzinie"},"content":{"rendered":"

Jeden taki niedobry prosi\u0142 o napisanie czego\u015b co o zadanej godzinie zrobi porz\u0105dki w tabelach mysql.
\nZadanie niezwykle trywialne….<\/p>\n

1. Tworzymy plik naprawa.sh
\ntouch \/root\/naprawa.sh
\nchmod +x \/root\/naprawa.sh<\/p>\n

2. W pliku umieszczamy zakl\u0119cia do uporz\u0105dkowania tabelek.
\n##############################
\n#!\/bin\/bash<\/p>\n

PATH=\/bin:\/sbin:\/usr\/bin:\/usr\/sbin:\/usr\/local\/bin:\/usr\/local\/sbin<\/p>\n

mysqlcheck --optimize --all-databases -u root --password=TwojeHasloMysql
\nmysqlcheck --check --all-databases -u root --password=TwojeHasloMysql
\nmysqlcheck --auto-repair --all-databases -u root --password=TwojeHasloMysql<\/code>
\n################################################## <\/p>\n

3.Teraz uruchamianie o zadanej godzinie ( 00:15)<\/p>\n

uruchamiamy:
\ncrontab -e
\ni wpisujemy:<\/p>\n

15 0 * * * \/root\/naprawa.sh >\/dev\/null 2>&1<\/code><\/p>\n

Zapisujemy.<\/p>\n

4. Przynosimy piwo adminowi<\/p>\n","protected":false},"excerpt":{"rendered":"

Jeden taki niedobry prosi\u0142 o napisanie czego\u015b co o zadanej godzinie zrobi porz\u0105dki w tabelach mysql. Zadanie niezwykle trywialne…. 1. Tworzymy plik naprawa.sh touch \/root\/naprawa.sh chmod +x \/root\/naprawa.sh 2. W pliku umieszczamy zakl\u0119cia do uporz\u0105dkowania tabelek. ############################## #!\/bin\/bash PATH=\/bin:\/sbin:\/usr\/bin:\/usr\/sbin:\/usr\/local\/bin:\/usr\/local\/sbin mysqlcheck –optimize –all-databases -u root –password=TwojeHasloMysql mysqlcheck –check –all-databases -u root –password=TwojeHasloMysql mysqlcheck –auto-repair –all-databases -u […]<\/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,3],"tags":[],"class_list":["post-506","post","type-post","status-publish","format-standard","hentry","category-sciaga-admina","category-uslugi"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/506","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=506"}],"version-history":[{"count":3,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/506\/revisions"}],"predecessor-version":[{"id":508,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/506\/revisions\/508"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}