Results 1 to 2 of 2

Thread: InnodB table

  1. #1
    Join Date
    Sep 2003
    Posts
    5

    Unanswered: InnodB table

    On the manual, the default page in the InnoDB is 64K. Is there any way to change the page size?

    Is there any way we can manage page size, for example, specify pct free and pct used in each page to avoid the row chainning or row migration like oracle?

    Also, when creating table, ss there any way in the CREATE TABLE statement to specify how we want mysql to allocate pages (extent) to each table and how to manage the page (extent) in each table (for example, reserve space in each page for data update)?

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    I think that the default page is 16 k and not 64 k
    You can only change this value (from 8 k to 64 k) by recompiling MySql
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •