๋ชฉ๋กREDO LOG (1)

DevLog ๐Ÿ˜ถ

[Real MySQL 8.0] InnoDB ์Šคํ† ๋ฆฌ์ง€ ์—”์ง„ ์•Œ์•„๋ณด๊ธฐ - 3ํŽธ (Buffer Pool - on disk structures)

๐ŸŒฑ ๋“ค์–ด๊ฐ€๊ธฐ ์ „์ด๋ฒˆ ํฌ์ŠคํŒ…์—์„œ๋Š” InnoDB์˜ ์ „๋ฐ˜์ ์ธ ์•„ํ‚คํ…์ฒ˜ ์ค‘์—์„œ ๋””์Šคํฌ ์˜์—ญ์— ๋Œ€ํ•ด์„œ ์•Œ์•„๋ณด์ž. ๋งˆ์ฐฌ๊ฐ€์ง€๋กœ ๊ฐ„๋‹จํ•˜๊ฒŒ๋งŒ ์งš๊ณ  ๋„˜์–ด๊ฐ€๊ณ ์ž ํ•œ๋‹ค. ๐ŸŒฑ Tablespaceํ…Œ์ด๋ธ” ์ŠคํŽ˜์ด์Šค๋Š” ๋ฐ์ดํ„ฐ๋ฅผ ์ €์žฅํ•˜๊ธฐ ์œ„ํ•ด ์‚ฌ์šฉ๋˜๋Š” ํฐ ๋…ผ๋ฆฌ์ ์ธ ๋‹จ์œ„์ด๋ฉฐ, Segment -> Extent -> Page -> Row์™€ ๊ฐ™์€ ํ˜•ํƒœ๋กœ ๊ตฌ์„ฑ๋œ๋‹ค. MySQL์—์„œ ํ…Œ์ด๋ธ” ์ŠคํŽ˜์ด์Šค๋Š” ์ €์žฅํ•˜๋Š” ๋ฐ์ดํ„ฐ์˜ ์ข…๋ฅ˜์— ๋”ฐ๋ผ์„œ 5๊ฐ€์ง€๋กœ ๋ถ„๋ฅ˜๊ฐ€ ๊ฐ€๋Šฅํ•œ๋ฐ, ์ด๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™๋‹ค. - System tablespace - File-Per-Table tablespace - General Tablespace - Temporary Tablespace - Undo Tablespace ๐ŸŒฑ System tablespaceSystem tablespace์˜ ๊ฒฝ์šฐ My..
๐Ÿ“–/Real MySQL 8.0 2023. 6. 15. 13:52
์ด์ „ Prev 1 Next ๋‹ค์Œ