Ostatnio jedna z instancji mysql po restarcie zamiast wsta\u0107 sypa\u0142a logami:<\/p>\n
mysqld: \/usr\/sbin\/mysqld: Table ’.\/mysql\/plugin’ is marked as crashed and last (automatic?) repair failed<\/p>\n
mysqld: \/usr\/sbin\/mysqld: Table ’.\/mysql\/host’ is marked as crashed and last (automatic?) repair failed<\/p>\n
Powodem jest zamarkowanie tabeli, jako crashed. Serwer zatrzymany, wi\u0119c pytanie jak naprawi\u0107 tabel\u0119?<\/p>\n
Z pomoc\u0105 przychodzi skrypcik szymana:<\/p>\n
#! \/bin\/bash<\/p>\n
\/etc\/init.d\/mysql stop<\/p>\n
base=”\/var\/lib\/mysql\/”<\/p>\n
cd $base<\/p>\n
lll=`ls`<\/p>\n
for i in $lll.<\/p>\n
do<\/p>\n
if [ -d $i ];<\/p>\n
then<\/p>\n
myisamchk -rf $i\/*.MYI<\/p>\n
fi<\/p>\n
done<\/p>\n
\/etc\/init.d\/mysql restart<\/p><\/blockquote>\n
mysql is marked as crashed and last (automatic?) repair failed – rozwi\u0105zanie problemu<\/p>\n","protected":false},"excerpt":{"rendered":"
Ostatnio jedna z instancji mysql po restarcie zamiast wsta\u0107 sypa\u0142a logami: mysqld: \/usr\/sbin\/mysqld: Table ’.\/mysql\/plugin’ is marked as crashed and last (automatic?) repair failed mysqld: \/usr\/sbin\/mysqld: Table ’.\/mysql\/host’ is marked as crashed and last (automatic?) repair failed Powodem jest zamarkowanie tabeli, jako crashed. Serwer zatrzymany, wi\u0119c pytanie jak naprawi\u0107 tabel\u0119? Z pomoc\u0105 przychodzi skrypcik szymana: […]<\/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-478","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\/478","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=478"}],"version-history":[{"count":2,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/478\/revisions"}],"predecessor-version":[{"id":480,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/478\/revisions\/480"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=478"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=478"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}