{"id":100,"date":"2020-05-03T10:31:21","date_gmt":"2020-05-03T10:31:21","guid":{"rendered":"https:\/\/fsc24.org\/?p=100"},"modified":"2020-05-03T10:33:49","modified_gmt":"2020-05-03T10:33:49","slug":"db-update","status":"publish","type":"post","link":"https:\/\/fsc24.org\/?p=100","title":{"rendered":"DB Update"},"content":{"rendered":"\n<p>We had to backup the existing flights stats and reduce DB size afterwards, because our DB server was hitting 100% workload several times during the pasts days and weeks. This was causing freezing and &#8222;hanging&#8220; or even making it impossible to log in. The fastest solution was to backup the existing data and then start with a fresh table (with dramatically smaller DB size).<\/p>\n\n\n\n<p>If you, dear pilots, need your old flightstats in any way, please drop us a line, i.ex. using discord. As most of us fly just for fun I think it is ok to know that your data is still there, even though the stats showing only the fresh data.<\/p>\n\n\n\n<p>Thanks &amp; happy flights!<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/fsc24.org\/wp-content\/uploads\/2020\/05\/DB.png\" alt=\"\" class=\"wp-image-102\" width=\"158\" height=\"158\" srcset=\"https:\/\/fsc24.org\/wp-content\/uploads\/2020\/05\/DB.png 600w, https:\/\/fsc24.org\/wp-content\/uploads\/2020\/05\/DB-300x300.png 300w, https:\/\/fsc24.org\/wp-content\/uploads\/2020\/05\/DB-150x150.png 150w\" sizes=\"auto, (max-width: 158px) 100vw, 158px\" \/><\/figure>\n\n\n\n<p style=\"color:#1f1ce0\" class=\"has-text-color\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We had to backup the existing flights stats and reduce DB size afterwards, because our DB server was hitting 100% workload several times during the pasts days and weeks. This was causing freezing and &#8222;hanging&#8220; or even making it impossible to log in. The fastest solution was to backup the<a class=\"moretag\" href=\"https:\/\/fsc24.org\/?p=100\"> Weiterlesen<\/a><\/p>\n","protected":false},"author":1,"featured_media":102,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[12,13,11],"class_list":["post-100","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-multiplayer","tag-database","tag-statistics","tag-stats"],"_links":{"self":[{"href":"https:\/\/fsc24.org\/index.php?rest_route=\/wp\/v2\/posts\/100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fsc24.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fsc24.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fsc24.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fsc24.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=100"}],"version-history":[{"count":2,"href":"https:\/\/fsc24.org\/index.php?rest_route=\/wp\/v2\/posts\/100\/revisions"}],"predecessor-version":[{"id":103,"href":"https:\/\/fsc24.org\/index.php?rest_route=\/wp\/v2\/posts\/100\/revisions\/103"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fsc24.org\/index.php?rest_route=\/wp\/v2\/media\/102"}],"wp:attachment":[{"href":"https:\/\/fsc24.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fsc24.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fsc24.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}