# File lib/innodb/space.rb, line 144 def pages_per_extent # Note that uncompressed tables and compressed tables using the same page # size will have a different number of pages per "extent" because InnoDB # compression uses the FSP_EXTENT_SIZE define (which is then based on the # UNIV_PAGE_SIZE define, which may be based on the innodb_page_size system # variable) for compressed tables rather than something based on the actual # compressed page size. # # For this reason, an "extent" differs in size as follows (the maximum page # size supported for compressed tables is the innodb_page_size): # # innodb_page_size | innodb compression | # page size | extent size | pages | page size | extent size | pages | # 16384 | 1 MiB | 64 | 16384 | 1 MiB | 64 | # | 8192 | 512 KiB | 64 | # | 4096 | 256 KiB | 64 | # | 2048 | 128 KiB | 64 | # | 1024 | 64 KiB | 64 | # 8192 | 1 MiB | 128 | 8192 | 1 MiB | 128 | # | 4096 | 512 KiB | 128 | # | 2048 | 256 KiB | 128 | # | 1024 | 128 KiB | 128 | # 4096 | 1 MiB | 256 | 4096 | 1 MiB | 256 | # | 2048 | 512 KiB | 256 | # | 1024 | 256 KiB | 256 | # 1048576 / system_page_size end