Author: paul
Date: 2009-11-24 20:47:59 +0100 (Tue, 24 Nov 2009)
New Revision: 17792
Log:
r46836@frost: paul | 2009-11-24 13:45:12 -0500
Not a great idea to change the InnoDB page size
Modified:
trunk/dynamic-docs/changelog/mysqld-1.xml
trunk/refman-4.1/se-innodb-core.xml
trunk/refman-5.0/se-innodb-core.xml
trunk/refman-5.1/se-innodb-core.xml
trunk/refman-5.4/se-innodb-core.xml
trunk/refman-5.5/se-innodb-core.xml
trunk/refman-6.0.sav/se-innodb-core.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:28120
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:25547
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:46834
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
+ 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:28120
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:25547
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:46836
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
Modified: trunk/dynamic-docs/changelog/mysqld-1.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld-1.xml 2009-11-24 19:24:23 UTC (rev 17791)
+++ trunk/dynamic-docs/changelog/mysqld-1.xml 2009-11-24 19:47:59 UTC (rev 17792)
Changed blocks: 1, Lines Added: 17, Lines Deleted: 0; 1137 bytes
@@ -77563,6 +77563,23 @@
size, some error messages became inaccurate.
</para>
+ <note>
+ <para>
+ Changing the page size is not a supported operation and there
+ is no guarantee that <literal role="se">InnoDB</literal> will
+ function normally with a page size other than 16KB. Problems
+ compiling or running InnoDB may occur. In particular,
+ <literal>ROW_FORMAT=COMPRESSED</literal> in the
+ <literal>InnoDB Plugin</literal> assumes that the page size is
+ at most 16KB and uses 14-bit pointers.
+ </para>
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for one
+ page size cannot use data files or log files from a version
+ built for a different page size.
+ </para>
+ </note>
+
</message>
</logentry>
Modified: trunk/refman-4.1/se-innodb-core.xml
===================================================================
--- trunk/refman-4.1/se-innodb-core.xml 2009-11-24 19:24:23 UTC (rev 17791)
+++ trunk/refman-4.1/se-innodb-core.xml 2009-11-24 19:47:59 UTC (rev 17792)
Changed blocks: 4, Lines Added: 51, Lines Deleted: 0; 2660 bytes
@@ -6037,6 +6037,16 @@
<title>Physical Structure of an Index</title>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
<para>
All <literal>InnoDB</literal> indexes are B-trees where the
index records are stored in the leaf pages of the tree. The
@@ -6055,6 +6065,21 @@
tree to free the page.
</para>
+ <note>
+ <para>
+ Changing the page size is not a supported operation and there
+ is no guarantee that <literal role="se">InnoDB</literal> will
+ function normally with a page size other than 16KB. Problems
+ compiling or running InnoDB may occur.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for one
+ page size cannot use data files or log files from a version
+ built for a different page size.
+ </para>
+ </note>
+
</section>
<section id="innodb-insert-buffering">
@@ -9655,6 +9680,16 @@
<listitem>
<para>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
The default database page size in <literal>InnoDB</literal> is
16KB. By recompiling the code, you can set it to values
ranging from 8KB to 64KB. You must update the values of
@@ -9662,6 +9697,22 @@
<literal>UNIV_PAGE_SIZE_SHIFT</literal> in the
<filename>univ.i</filename> source file.
</para>
+
+ <note>
+ <para>
+ Changing the page size is not a supported operation and
+ there is no guarantee that
+ <literal role="se">InnoDB</literal> will function normally
+ with a page size other than 16KB. Problems compiling or
+ running InnoDB may occur.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for
+ one page size cannot use data files or log files from a
+ version built for a different page size.
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-5.0/se-innodb-core.xml
===================================================================
--- trunk/refman-5.0/se-innodb-core.xml 2009-11-24 19:24:23 UTC (rev 17791)
+++ trunk/refman-5.0/se-innodb-core.xml 2009-11-24 19:47:59 UTC (rev 17792)
Changed blocks: 4, Lines Added: 51, Lines Deleted: 0; 2660 bytes
@@ -6200,6 +6200,16 @@
<title>Physical Structure of an Index</title>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
<para>
All <literal>InnoDB</literal> indexes are B-trees where the
index records are stored in the leaf pages of the tree. The
@@ -6218,6 +6228,21 @@
tree to free the page.
</para>
+ <note>
+ <para>
+ Changing the page size is not a supported operation and there
+ is no guarantee that <literal role="se">InnoDB</literal> will
+ function normally with a page size other than 16KB. Problems
+ compiling or running InnoDB may occur.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for one
+ page size cannot use data files or log files from a version
+ built for a different page size.
+ </para>
+ </note>
+
</section>
<section id="innodb-insert-buffering">
@@ -9594,6 +9619,16 @@
<listitem>
<para>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
The default database page size in <literal>InnoDB</literal> is
16KB. By recompiling the code, you can set it to values
ranging from 8KB to 64KB. You must update the values of
@@ -9601,6 +9636,22 @@
<literal>UNIV_PAGE_SIZE_SHIFT</literal> in the
<filename>univ.i</filename> source file.
</para>
+
+ <note>
+ <para>
+ Changing the page size is not a supported operation and
+ there is no guarantee that
+ <literal role="se">InnoDB</literal> will function normally
+ with a page size other than 16KB. Problems compiling or
+ running InnoDB may occur.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for
+ one page size cannot use data files or log files from a
+ version built for a different page size.
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-5.1/se-innodb-core.xml
===================================================================
--- trunk/refman-5.1/se-innodb-core.xml 2009-11-24 19:24:23 UTC (rev 17791)
+++ trunk/refman-5.1/se-innodb-core.xml 2009-11-24 19:47:59 UTC (rev 17792)
Changed blocks: 4, Lines Added: 57, Lines Deleted: 0; 3060 bytes
@@ -7354,6 +7354,16 @@
<title>Physical Structure of an Index</title>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
<para>
All <literal>InnoDB</literal> indexes are B-trees where the
index records are stored in the leaf pages of the tree. The
@@ -7372,6 +7382,24 @@
tree to free the page.
</para>
+ <note>
+ <para>
+ Changing the page size is not a supported operation and there
+ is no guarantee that <literal role="se">InnoDB</literal> will
+ function normally with a page size other than 16KB. Problems
+ compiling or running InnoDB may occur. In particular,
+ <literal>ROW_FORMAT=COMPRESSED</literal> in the
+ <literal>InnoDB Plugin</literal> assumes that the page size is
+ at most 16KB and uses 14-bit pointers.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for one
+ page size cannot use data files or log files from a version
+ built for a different page size.
+ </para>
+ </note>
+
</section>
<section id="innodb-insert-buffering">
@@ -10767,6 +10795,16 @@
<listitem>
<para>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
The default database page size in <literal>InnoDB</literal> is
16KB. By recompiling the code, you can set it to values
ranging from 8KB to 64KB. You must update the values of
@@ -10774,6 +10812,25 @@
<literal>UNIV_PAGE_SIZE_SHIFT</literal> in the
<filename>univ.i</filename> source file.
</para>
+
+ <note>
+ <para>
+ Changing the page size is not a supported operation and
+ there is no guarantee that
+ <literal role="se">InnoDB</literal> will function normally
+ with a page size other than 16KB. Problems compiling or
+ running InnoDB may occur. In particular,
+ <literal>ROW_FORMAT=COMPRESSED</literal> in the
+ <literal>InnoDB Plugin</literal> assumes that the page size
+ is at most 16KB and uses 14-bit pointers.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for
+ one page size cannot use data files or log files from a
+ version built for a different page size.
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-5.4/se-innodb-core.xml
===================================================================
--- trunk/refman-5.4/se-innodb-core.xml 2009-11-24 19:24:23 UTC (rev 17791)
+++ trunk/refman-5.4/se-innodb-core.xml 2009-11-24 19:47:59 UTC (rev 17792)
Changed blocks: 4, Lines Added: 57, Lines Deleted: 0; 3060 bytes
@@ -7052,6 +7052,16 @@
<title>Physical Structure of an Index</title>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
<para>
All <literal>InnoDB</literal> indexes are B-trees where the
index records are stored in the leaf pages of the tree. The
@@ -7070,6 +7080,24 @@
tree to free the page.
</para>
+ <note>
+ <para>
+ Changing the page size is not a supported operation and there
+ is no guarantee that <literal role="se">InnoDB</literal> will
+ function normally with a page size other than 16KB. Problems
+ compiling or running InnoDB may occur. In particular,
+ <literal>ROW_FORMAT=COMPRESSED</literal> in the
+ <literal>InnoDB Plugin</literal> assumes that the page size is
+ at most 16KB and uses 14-bit pointers.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for one
+ page size cannot use data files or log files from a version
+ built for a different page size.
+ </para>
+ </note>
+
</section>
<section id="innodb-insert-buffering">
@@ -10468,6 +10496,16 @@
<listitem>
<para>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
The default database page size in <literal>InnoDB</literal> is
16KB. By recompiling the code, you can set it to values
ranging from 8KB to 64KB. You must update the values of
@@ -10475,6 +10513,25 @@
<literal>UNIV_PAGE_SIZE_SHIFT</literal> in the
<filename>univ.i</filename> source file.
</para>
+
+ <note>
+ <para>
+ Changing the page size is not a supported operation and
+ there is no guarantee that
+ <literal role="se">InnoDB</literal> will function normally
+ with a page size other than 16KB. Problems compiling or
+ running InnoDB may occur. In particular,
+ <literal>ROW_FORMAT=COMPRESSED</literal> in the
+ <literal>InnoDB Plugin</literal> assumes that the page size
+ is at most 16KB and uses 14-bit pointers.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for
+ one page size cannot use data files or log files from a
+ version built for a different page size.
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-5.5/se-innodb-core.xml
===================================================================
--- trunk/refman-5.5/se-innodb-core.xml 2009-11-24 19:24:23 UTC (rev 17791)
+++ trunk/refman-5.5/se-innodb-core.xml 2009-11-24 19:47:59 UTC (rev 17792)
Changed blocks: 4, Lines Added: 57, Lines Deleted: 0; 3060 bytes
@@ -7019,6 +7019,16 @@
<title>Physical Structure of an Index</title>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
<para>
All <literal>InnoDB</literal> indexes are B-trees where the
index records are stored in the leaf pages of the tree. The
@@ -7037,6 +7047,24 @@
tree to free the page.
</para>
+ <note>
+ <para>
+ Changing the page size is not a supported operation and there
+ is no guarantee that <literal role="se">InnoDB</literal> will
+ function normally with a page size other than 16KB. Problems
+ compiling or running InnoDB may occur. In particular,
+ <literal>ROW_FORMAT=COMPRESSED</literal> in the
+ <literal>InnoDB Plugin</literal> assumes that the page size is
+ at most 16KB and uses 14-bit pointers.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for one
+ page size cannot use data files or log files from a version
+ built for a different page size.
+ </para>
+ </note>
+
</section>
<section id="innodb-insert-buffering">
@@ -10435,6 +10463,16 @@
<listitem>
<para>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
The default database page size in <literal>InnoDB</literal> is
16KB. By recompiling the code, you can set it to values
ranging from 8KB to 64KB. You must update the values of
@@ -10442,6 +10480,25 @@
<literal>UNIV_PAGE_SIZE_SHIFT</literal> in the
<filename>univ.i</filename> source file.
</para>
+
+ <note>
+ <para>
+ Changing the page size is not a supported operation and
+ there is no guarantee that
+ <literal role="se">InnoDB</literal> will function normally
+ with a page size other than 16KB. Problems compiling or
+ running InnoDB may occur. In particular,
+ <literal>ROW_FORMAT=COMPRESSED</literal> in the
+ <literal>InnoDB Plugin</literal> assumes that the page size
+ is at most 16KB and uses 14-bit pointers.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for
+ one page size cannot use data files or log files from a
+ version built for a different page size.
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-6.0.sav/se-innodb-core.xml
===================================================================
--- trunk/refman-6.0.sav/se-innodb-core.xml 2009-11-24 19:24:23 UTC (rev 17791)
+++ trunk/refman-6.0.sav/se-innodb-core.xml 2009-11-24 19:47:59 UTC (rev 17792)
Changed blocks: 4, Lines Added: 57, Lines Deleted: 0; 3072 bytes
@@ -6795,6 +6795,16 @@
<title>Physical Structure of an Index</title>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
<para>
All <literal>InnoDB</literal> indexes are B-trees where the
index records are stored in the leaf pages of the tree. The
@@ -6813,6 +6823,24 @@
tree to free the page.
</para>
+ <note>
+ <para>
+ Changing the page size is not a supported operation and there
+ is no guarantee that <literal role="se">InnoDB</literal> will
+ function normally with a page size other than 16KB. Problems
+ compiling or running InnoDB may occur. In particular,
+ <literal>ROW_FORMAT=COMPRESSED</literal> in the
+ <literal>InnoDB Plugin</literal> assumes that the page size is
+ at most 16KB and uses 14-bit pointers.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for one
+ page size cannot use data files or log files from a version
+ built for a different page size.
+ </para>
+ </note>
+
</section>
<section id="innodb-insert-buffering">
@@ -10166,6 +10194,16 @@
<listitem>
<para>
+ <indexterm>
+ <primary>page size</primary>
+ <secondary>InnoDB</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>InnoDB</primary>
+ <secondary>page size</secondary>
+ </indexterm>
+
The default database page size in <literal>InnoDB</literal> is
16KB. By recompiling the code, you can set it to values
ranging from 8KB to 64KB. You must update the values of
@@ -10173,6 +10211,25 @@
<literal>UNIV_PAGE_SIZE_SHIFT</literal> in the
<filename>univ.i</filename> source file.
</para>
+
+ <note>
+ <para>
+ Changing the page size is not a supported operation and
+ there is no guarantee that
+ <literal role="se">InnoDB</literal> will function normally
+ with a page size other than 16KB. Problems compiling or
+ running InnoDB may occur. In particular,
+ <literal>ROW_FORMAT=COMPRESSED</literal> in the
+ <literal>InnoDB Plugin</literal> assumes that the page size
+ is at most 16KB and uses 14-bit pointers.
+ </para>
+
+ <para>
+ A version of <literal role="se">InnoDB</literal> built for
+ one page size cannot use data files or log files from a
+ version built for a different page size.
+ </para>
+ </note>
</listitem>
<listitem>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r17792 - in trunk: . dynamic-docs/changelog refman-4.1 refman-5.0 refman-5.1 refman-5.4 refman-5.5 refman-6.0.sav | paul.dubois | 24 Nov |
