{"id":99,"date":"2012-03-08T22:19:41","date_gmt":"2012-03-08T21:19:41","guid":{"rendered":"http:\/\/morc.solutions\/hu\/?p=99"},"modified":"2012-03-08T22:19:41","modified_gmt":"2012-03-08T21:19:41","slug":"innodb-oromei","status":"publish","type":"post","link":"https:\/\/morc.solutions\/hu\/innodb-oromei\/","title":{"rendered":"InnoDB \u00f6r\u00f6mei"},"content":{"rendered":"<p style=\"text-align: justify;\">\u00dczemeltetek n\u00e9h\u00e1ny szervert, k\u00f6z\u00f6tt\u00fck van n\u00e9h\u00e1nyon MySQL is. Nyilv\u00e1nval\u00f3an n\u00e9h\u00e1ny t\u00e1bla InnoDB-t haszn\u00e1l, ami alapb\u00f3l nem a legjobban van be\u00e1ll\u00edtva.\u00a0<!--more-->Ha nincs t\u00fal sok helyed, vagy csak nem szereted a helypazarl\u00e1st az InnoDB alapbe\u00e1ll\u00edt\u00e1sa okozhat n\u00e9mi fejf\u00e1j\u00e1st. A fejleszt\u0151k \u00fagy gondolt\u00e1k, hogy minden egyes InnoDB t\u00e1bla adata egy k\u00f6z\u00f6s file-halmazba (alapb\u00f3l egyetlen file) ker\u00fclj\u00f6n. A MyISAM minden t\u00e1bl\u00e1hoz egy saj\u00e1t file-t hoz l\u00e9tre, \u00edgy mikor optimaliz\u00e1ljuk a t\u00e1bl\u00e1t a t\u00f6r\u00f6lt rekordok \u00e9s hasonl\u00f3k \u00e1ltal elfoglalt helyet visszakapjuk, visszaker\u00fcl az OS-hez. Ezzel szemben az InnoDB nem tud ilyet, mert a t\u00e1bl\u00e9k adatai sz\u00e9tsz\u00f3rva vannak a k\u00f6z\u00f6s file(ok)-ban, \u00edgy hi\u00e1ba t\u00f6rl\u00fcnk \u00e9s optimaliz\u00e1lunk, nem szabadul fel hely az OS sz\u00e1m\u00e1ra. Ez egyetlen megold\u00e1s, hogy csin\u00e1lunk egy dump-ot az \u00f6sszes adatb\u00e1zisr\u00f3l, t\u00f6r\u00f6lj\u00fck az adatb\u00e1zisokat, le\u00e1ll\u00edtjuk a MySQL-t, belerakjuk a\u00a0<em>innodb_file_per_table=true<\/em> param\u00e9tert a my.cnf [mysqld] szekci\u00f3j\u00e1ba, let\u00f6r\u00f6lj\u00fck az\u00a0ib_logfilen \u00e9s\u00a0ibdatan file-okat, elind\u00edtjuk a MySQL-t \u00e9s bet\u00f6ltj\u00fck a dump-okat. Ett\u0151l az InnoDB is \u00fagy fog viselkedni, mint a MyISAM, egy k\u00fcl\u00f6n file-t hoz l\u00e9tre minden t\u00e1bl\u00e1hoz. Alternat\u00edvak\u00e9nt el\u00e9g lenne csak az InnoDB t\u00e1bl\u00e1kat dump-olni, drop-olni, \u00e9s \u00fajra bet\u00f6lteni, de ez lehet nem t\u00fal hat\u00e9kony a t\u00e1bl\u00e1k sz\u00e1m\u00e1t\u00f3l f\u00fcgg\u0151en. \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00dczemeltetek n\u00e9h\u00e1ny szervert, k\u00f6z\u00f6tt\u00fck van n\u00e9h\u00e1nyon MySQL is. Nyilv\u00e1nval\u00f3an n\u00e9h\u00e1ny t\u00e1bla InnoDB-t haszn\u00e1l, ami alapb\u00f3l nem a legjobban van be\u00e1ll\u00edtva.\u00a0<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25,19],"tags":[],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-config","category-mysql"],"_links":{"self":[{"href":"https:\/\/morc.solutions\/hu\/wp-json\/wp\/v2\/posts\/99","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/morc.solutions\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/morc.solutions\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/morc.solutions\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/morc.solutions\/hu\/wp-json\/wp\/v2\/comments?post=99"}],"version-history":[{"count":1,"href":"https:\/\/morc.solutions\/hu\/wp-json\/wp\/v2\/posts\/99\/revisions"}],"predecessor-version":[{"id":100,"href":"https:\/\/morc.solutions\/hu\/wp-json\/wp\/v2\/posts\/99\/revisions\/100"}],"wp:attachment":[{"href":"https:\/\/morc.solutions\/hu\/wp-json\/wp\/v2\/media?parent=99"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/morc.solutions\/hu\/wp-json\/wp\/v2\/categories?post=99"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/morc.solutions\/hu\/wp-json\/wp\/v2\/tags?post=99"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}