{"id":3172,"date":"2011-05-02T08:09:11","date_gmt":"2011-05-02T05:09:11","guid":{"rendered":"http:\/\/www.imacandi.net\/sin\/blog\/?p=3172"},"modified":"2011-05-02T08:09:11","modified_gmt":"2011-05-02T05:09:11","slug":"blog-problems","status":"publish","type":"post","link":"https:\/\/www.imacandi.net\/sin\/blog\/2011\/05\/02\/blog-problems.html","title":{"rendered":"blog problems"},"content":{"rendered":"<p>In ultima vreme tot am dat de dude cu blogul si nu stiam ce are. In weekend am descoperit: am ramas fara spatiu pe disc din cauza bazei de date care ajunsese la 16GB, iar discul e mic (20GB).<\/p>\n<p>Asa ca am inceput sa investighez.<\/p>\n<p>Am facut un dump pe un alt disc la toate bazele de date si am ajuns la 9.4GB. Asta a fost momentul de WTF, ca n-am cum pisici sa am atata spatiu ocupat cu blogul. Dar aveam cum sa am atata spatiu ocupat cu wiki-ul. Care in ultimii doi ani a fost spamat in dusmanie. Si m-am apucat sa sap sa vad ce pot face.<\/p>\n<p>Si a devenit interesant, ca initial am vrut sa sterg toate reviziile de la pagini astfel incat sa nu mai am probleme, doar ca dura incredibil de mult. Pana m-am prins ca pot sterge cate o luna, cate o luna pana ajung la zi cu spam-ul. Si uite asa am sters cre&#8217;ca 1.5-2 milioane de spam-uri :( sute de mii de randuri cu cate putin text. Dupa toata aventura asta, am dat din nou dump la baza de date si guess what: doar 66MB.<\/p>\n<p>Sters \/var\/lib\/mysql, pornit MySQL sa-si refaca bazele de date, import si acu sunt iar fericit.<\/p>\n<p>Acu merge blogul bine, merge si wiki-ul cam cum trebuie. Mai am sa ma prind cum draci sterg vreo 1700 de pagini de talk aiurea in mod automat sa nu ma ia plansul manual si cre&#8217;ca o sa fie OK overall.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In ultima vreme tot am dat de dude cu blogul si nu stiam ce are. In weekend am descoperit: am ramas fara spatiu pe disc din cauza bazei de date care ajunsese la 16GB, iar discul e mic (20GB). Asa ca am inceput sa investighez. Am facut un dump pe un alt disc la toate &hellip; <a href=\"https:\/\/www.imacandi.net\/sin\/blog\/2011\/05\/02\/blog-problems.html\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">blog problems<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"ngg_post_thumbnail":0,"footnotes":""},"categories":[2],"tags":[7,22,28],"class_list":["post-3172","post","type-post","status-publish","format-standard","hentry","category-diverse","tag-computers","tag-ma-sa","tag-nervi"],"_links":{"self":[{"href":"https:\/\/www.imacandi.net\/sin\/blog\/wp-json\/wp\/v2\/posts\/3172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.imacandi.net\/sin\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.imacandi.net\/sin\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.imacandi.net\/sin\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.imacandi.net\/sin\/blog\/wp-json\/wp\/v2\/comments?post=3172"}],"version-history":[{"count":0,"href":"https:\/\/www.imacandi.net\/sin\/blog\/wp-json\/wp\/v2\/posts\/3172\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.imacandi.net\/sin\/blog\/wp-json\/wp\/v2\/media?parent=3172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.imacandi.net\/sin\/blog\/wp-json\/wp\/v2\/categories?post=3172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.imacandi.net\/sin\/blog\/wp-json\/wp\/v2\/tags?post=3172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}