Author: paul
Date: 2007-07-24 22:09:52 +0200 (Tue, 24 Jul 2007)
New Revision: 7197
Log:
r27880@polar: paul | 2007-07-24 14:00:46 -0500
If you use Windows .sym files for database linking, you cannot use
--innodb_file_per_table. (Shane)
Modified:
trunk/refman-4.1/news-4.1.xml
trunk/refman-4.1/optimization.xml
trunk/refman-5.0/news-5.0.xml
trunk/refman-5.0/optimization.xml
trunk/refman-5.1/optimization.xml
trunk/refman-5.2/optimization.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:27877
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22908
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18941
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:27880
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:22908
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:18941
Modified: trunk/refman-4.1/news-4.1.xml
===================================================================
--- trunk/refman-4.1/news-4.1.xml 2007-07-24 20:09:14 UTC (rev 7196)
+++ trunk/refman-4.1/news-4.1.xml 2007-07-24 20:09:52 UTC (rev 7197)
Changed blocks: 2, Lines Added: 2, Lines Deleted: 2; 1106 bytes
@@ -3590,7 +3590,7 @@
<literal>InnoDB</literal> now caches a list of unflushed files
instead of scanning for unflushed files during a table flush
operation. This improves performance when
- <option>--innodb-file-per-table</option> is set on a system
+ <option>--innodb_file_per_table</option> is set on a system
with a large number of <literal>InnoDB</literal> tables. (Bug
#15653)
</para>
@@ -4419,7 +4419,7 @@
<para>
Performing a <literal>RENAME TABLE</literal> on an InnoDB
table when the server is started with the
- <option>--innodb-file-per-table</option> option and the data
+ <option>--innodb_file_per_table</option> option and the data
directory is a symlink caused a server crash. (Bug #15991)
</para>
</listitem>
Modified: trunk/refman-4.1/optimization.xml
===================================================================
--- trunk/refman-4.1/optimization.xml 2007-07-24 20:09:14 UTC (rev 7196)
+++ trunk/refman-4.1/optimization.xml 2007-07-24 20:09:52 UTC (rev 7197)
Changed blocks: 1, Lines Added: 25, Lines Deleted: 3; 1341 bytes
@@ -12511,11 +12511,33 @@
<para>
After this, all tables created in the database
<literal>foo</literal> are created in
- <filename>D:\data\foo</filename>. <emphasis>Note that the
- symbolic link is not used if a directory with the same name as
- the database exists in the MySQL data directory</emphasis>.
+ <filename>D:\data\foo</filename>.
</para>
+ <para>
+ The following limitations apply to the use of
+ <filename>.sym</filename> files for database symbolic linking
+ on Windows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The symbolic link is not used if a directory with the same
+ name as the database exists in the MySQL data directory.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ The <option>--innodb_file_per_table</option> option cannot
+ be used.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
</section>
</section>
Modified: trunk/refman-5.0/news-5.0.xml
===================================================================
--- trunk/refman-5.0/news-5.0.xml 2007-07-24 20:09:14 UTC (rev 7196)
+++ trunk/refman-5.0/news-5.0.xml 2007-07-24 20:09:52 UTC (rev 7197)
Changed blocks: 2, Lines Added: 2, Lines Deleted: 2; 1076 bytes
@@ -6309,7 +6309,7 @@
InnoDB now caches a list of unflushed files instead of
scanning for unflushed files during a table flush operation.
This improves performance when
- <option>--innodb-file-per-table</option> is set on a system
+ <option>--innodb_file_per_table</option> is set on a system
with a large number of InnoDB tables. (Bug #15653)
</para>
</listitem>
@@ -7036,7 +7036,7 @@
<para>
Performing a <literal>RENAME TABLE</literal> on an InnoDB
table when the server is started with the
- <option>--innodb-file-per-table</option> option and the data
+ <option>--innodb_file_per_table</option> option and the data
directory is a symlink caused a server crash. (Bug #15991)
</para>
</listitem>
Modified: trunk/refman-5.0/optimization.xml
===================================================================
--- trunk/refman-5.0/optimization.xml 2007-07-24 20:09:14 UTC (rev 7196)
+++ trunk/refman-5.0/optimization.xml 2007-07-24 20:09:52 UTC (rev 7197)
Changed blocks: 2, Lines Added: 26, Lines Deleted: 4; 1635 bytes
@@ -14741,7 +14741,7 @@
<filename>C:\mysql\data</filename> and you want to have
database <literal>foo</literal> located at
<filename>D:\data\foo</filename>. Set up a symlink using this
- procedure
+ procedure:
</para>
<orderedlist>
@@ -14772,11 +14772,33 @@
<para>
After this, all tables created in the database
<literal>foo</literal> are created in
- <filename>D:\data\foo</filename>. <emphasis>Note that the
- symbolic link is not used if a directory with the same name as
- the database exists in the MySQL data directory</emphasis>.
+ <filename>D:\data\foo</filename>.
</para>
+ <para>
+ The following limitations apply to the use of
+ <filename>.sym</filename> files for database symbolic linking
+ on Windows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The symbolic link is not used if a directory with the same
+ name as the database exists in the MySQL data directory.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ The <option>--innodb_file_per_table</option> option cannot
+ be used.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
</section>
</section>
Modified: trunk/refman-5.1/optimization.xml
===================================================================
--- trunk/refman-5.1/optimization.xml 2007-07-24 20:09:14 UTC (rev 7196)
+++ trunk/refman-5.1/optimization.xml 2007-07-24 20:09:52 UTC (rev 7197)
Changed blocks: 1, Lines Added: 25, Lines Deleted: 3; 1341 bytes
@@ -15115,11 +15115,33 @@
<para>
After this, all tables created in the database
<literal>foo</literal> are created in
- <filename>D:\data\foo</filename>. <emphasis>Note that the
- symbolic link is not used if a directory with the same name as
- the database exists in the MySQL data directory</emphasis>.
+ <filename>D:\data\foo</filename>.
</para>
+ <para>
+ The following limitations apply to the use of
+ <filename>.sym</filename> files for database symbolic linking
+ on Windows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The symbolic link is not used if a directory with the same
+ name as the database exists in the MySQL data directory.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ The <option>--innodb_file_per_table</option> option cannot
+ be used.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
</section>
</section>
Modified: trunk/refman-5.2/optimization.xml
===================================================================
--- trunk/refman-5.2/optimization.xml 2007-07-24 20:09:14 UTC (rev 7196)
+++ trunk/refman-5.2/optimization.xml 2007-07-24 20:09:52 UTC (rev 7197)
Changed blocks: 1, Lines Added: 25, Lines Deleted: 3; 1341 bytes
@@ -15063,11 +15063,33 @@
<para>
After this, all tables created in the database
<literal>foo</literal> are created in
- <filename>D:\data\foo</filename>. <emphasis>Note that the
- symbolic link is not used if a directory with the same name as
- the database exists in the MySQL data directory</emphasis>.
+ <filename>D:\data\foo</filename>.
</para>
+ <para>
+ The following limitations apply to the use of
+ <filename>.sym</filename> files for database symbolic linking
+ on Windows:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The symbolic link is not used if a directory with the same
+ name as the database exists in the MySQL data directory.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ The <option>--innodb_file_per_table</option> option cannot
+ be used.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
</section>
</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r7197 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.2 | paul | 24 Jul |
