Page versus quantity versus segment or table space

Question

Mysql Innodb has the concepts of page, degree, segment, table space, but I don’t know how they interact with each other. How are they connected? What does it mean that a table space has 16 thousand pages? How does this relate to physical strings and are there "pages" in memory?

I would suggest that Oracle might have the same concept, but I'm not sure where to look for it. Is there a good reference / book that talks about this in detail?

Answer 1

Specifically for innodb:

, . , innodb ibdata. - , . mysql , .

:

• 1 .

• 64 . , 64.

• 16k, . , .

. . 11 pdf.

Answer 2

:

http://www.markleith.co.uk/?p=25

 File system              -> InnoDB
 ----------------------------------------------
 disk partition           -> tablespace
 file                     -> segment
 inode                    -> fsp0fsp.c 'inode'
 fs space allocation unit -> extent
 disk block               -> page (16 kB)

, :

http://forge.mysql.com/wiki/MySQL_Internals_InnoDB

Answer 3

Oracle , , . , , .

, . , , , .. , - , , , .

, . , , .

, , , Oracle DB2, , , . , - www.oracle.com www.ibm.com , Google, , .

Answer 4

Oracle . Oracle , .

Google " Oracle" . , , . Oracle Oracle.

, - Oracle.

Answer 5

: http://download.oracle.com/docs/cd/E11882_01/server.112/e10713/logical.htm#CNCPT304

, . , Oracle . 8kb .

, , .. . , . . .

, . .