Author: mcbrown
Date: 2007-12-20 10:48:12 +0100 (Thu, 20 Dec 2007)
New Revision: 9411
Log:
Adding Windows restrictions section to the manual
Modified:
trunk/refman-4.1/installing.xml
trunk/refman-4.1/restrictions.xml
trunk/refman-5.0/installing-cs-core.xml
trunk/refman-5.0/restrictions.xml
trunk/refman-5.1/installing-core.xml
trunk/refman-5.1/restrictions.xml
trunk/refman-6.0/installing-core.xml
trunk/refman-6.0/restrictions.xml
Modified: trunk/refman-4.1/installing.xml
===================================================================
--- trunk/refman-4.1/installing.xml 2007-12-20 03:22:59 UTC (rev 9410)
+++ trunk/refman-4.1/installing.xml 2007-12-20 09:48:12 UTC (rev 9411)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 0; 541 bytes
@@ -2599,6 +2599,11 @@
</itemizedlist>
<para>
+ For a list of limitations within the Windows version of MySQL, see
+ <xref linkend="limits-windows"/>.
+ </para>
+
+ <para>
There may also be other requirements, depending on how you plan to
use MySQL:
</para>
Modified: trunk/refman-4.1/restrictions.xml
===================================================================
--- trunk/refman-4.1/restrictions.xml 2007-12-20 03:22:59 UTC (rev 9410)
+++ trunk/refman-4.1/restrictions.xml 2007-12-20 09:48:12 UTC (rev 9411)
Changed blocks: 1, Lines Added: 89, Lines Deleted: 0; 3315 bytes
@@ -696,6 +696,95 @@
</section>
+ <section id="limits-windows">
+
+ <title>Windows Platform Limitations</title>
+
+ <para>
+ The following limitations apply only to the Windows platform:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The number of open file descriptors on Windows is limited to
+ a maximum of 2048, which may limit the ability to open a
+ large number of tables simultaneously. This limit is due to
+ the compatibility functions used to open files on Windows
+ that use the POSIX compatibility layer.
+ </para>
+
+ <para>
+ This limitation will also cause problems if you try to set
+ <option>max_open_files</option> to a value greater than the
+ 2048 file limit.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ On Windows 32-bit platforms it is not possible to use more
+ than 2GB of RAM within a single process, including MySQL.
+ This is because the physical address limit on Windows 32-bit
+ is 4GB and the default setting within Windows is to split
+ the RAM between kernel (2GB) and user/applications (2GB).
+ </para>
+
+ <para>
+ You can increase this limit to 3GB by specifying the
+ <option>/3GB</option> option in the
+ <filename>boot.ini</filename> file. This changes the
+ kernel/application memory split to 1GB and 3GB respectively.
+ This boot option is available on Windows XP, Windows Server
+ 2003, and Windows Server 2008.
+ </para>
+
+ <para>
+ To use more memory than this you will need to use a 64-bit
+ version of Windows.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ When using <literal>MyISAM</literal> tables, you cannot use
+ aliases within Windows link to the data files on another
+ volume and then link back to the main MySQL
+ <option>datadir</option> location.
+ </para>
+
+ <para>
+ This facility is often used to move the data and index files
+ to a RAID or other fast solution, while retaining the main
+ <filename>.FRM</filename> files in the default data
+ directory configured with the <option>datadir</option>
+ option.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The timers within MySQL used on Windows are of a lower
+ precision than the timers used on Linux. For most situations
+ you may not notice a difference, but the delay implied by a
+ call to <literal>SLEEP()</literal> on Windows and Linux may
+ differ slightly due to the differences in precision.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </section>
+
</section>
</appendix>
Modified: trunk/refman-5.0/installing-cs-core.xml
===================================================================
--- trunk/refman-5.0/installing-cs-core.xml 2007-12-20 03:22:59 UTC (rev 9410)
+++ trunk/refman-5.0/installing-cs-core.xml 2007-12-20 09:48:12 UTC (rev 9411)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 0; 565 bytes
@@ -2604,6 +2604,11 @@
</itemizedlist>
<para>
+ For a list of limitations within the Windows version of MySQL, see
+ <xref linkend="limits-windows"/>.
+ </para>
+
+ <para>
There may also be other requirements, depending on how you plan to
use MySQL:
</para>
Modified: trunk/refman-5.0/restrictions.xml
===================================================================
--- trunk/refman-5.0/restrictions.xml 2007-12-20 03:22:59 UTC (rev 9410)
+++ trunk/refman-5.0/restrictions.xml 2007-12-20 09:48:12 UTC (rev 9411)
Changed blocks: 1, Lines Added: 89, Lines Deleted: 0; 3317 bytes
@@ -1434,6 +1434,95 @@
</section>
+ <section id="limits-windows">
+
+ <title>Windows Platform Limitations</title>
+
+ <para>
+ The following limitations apply only to the Windows platform:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The number of open file descriptors on Windows is limited to
+ a maximum of 2048, which may limit the ability to open a
+ large number of tables simultaneously. This limit is due to
+ the compatibility functions used to open files on Windows
+ that use the POSIX compatibility layer.
+ </para>
+
+ <para>
+ This limitation will also cause problems if you try to set
+ <option>max_open_files</option> to a value greater than the
+ 2048 file limit.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ On Windows 32-bit platforms it is not possible to use more
+ than 2GB of RAM within a single process, including MySQL.
+ This is because the physical address limit on Windows 32-bit
+ is 4GB and the default setting within Windows is to split
+ the RAM between kernel (2GB) and user/applications (2GB).
+ </para>
+
+ <para>
+ You can increase this limit to 3GB by specifying the
+ <option>/3GB</option> option in the
+ <filename>boot.ini</filename> file. This changes the
+ kernel/application memory split to 1GB and 3GB respectively.
+ This boot option is available on Windows XP, Windows Server
+ 2003, and Windows Server 2008.
+ </para>
+
+ <para>
+ To use more memory than this you will need to use a 64-bit
+ version of Windows.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ When using <literal>MyISAM</literal> tables, you cannot use
+ aliases within Windows link to the data files on another
+ volume and then link back to the main MySQL
+ <option>datadir</option> location.
+ </para>
+
+ <para>
+ This facility is often used to move the data and index files
+ to a RAID or other fast solution, while retaining the main
+ <filename>.FRM</filename> files in the default data
+ directory configured with the <option>datadir</option>
+ option.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The timers within MySQL used on Windows are of a lower
+ precision than the timers used on Linux. For most situations
+ you may not notice a difference, but the delay implied by a
+ call to <literal>SLEEP()</literal> on Windows and Linux may
+ differ slightly due to the differences in precision.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </section>
+
</section>
</appendix>
Modified: trunk/refman-5.1/installing-core.xml
===================================================================
--- trunk/refman-5.1/installing-core.xml 2007-12-20 03:22:59 UTC (rev 9410)
+++ trunk/refman-5.1/installing-core.xml 2007-12-20 09:48:12 UTC (rev 9411)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 0; 556 bytes
@@ -2623,6 +2623,11 @@
</itemizedlist>
<para>
+ For a list of limitations within the Windows version of MySQL, see
+ <xref linkend="limits-windows"/>.
+ </para>
+
+ <para>
There may also be other requirements, depending on how you plan to
use MySQL:
</para>
Modified: trunk/refman-5.1/restrictions.xml
===================================================================
--- trunk/refman-5.1/restrictions.xml 2007-12-20 03:22:59 UTC (rev 9410)
+++ trunk/refman-5.1/restrictions.xml 2007-12-20 09:48:12 UTC (rev 9411)
Changed blocks: 1, Lines Added: 89, Lines Deleted: 0; 3317 bytes
@@ -1473,6 +1473,95 @@
</section>
+ <section id="limits-windows">
+
+ <title>Windows Platform Limitations</title>
+
+ <para>
+ The following limitations apply only to the Windows platform:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The number of open file descriptors on Windows is limited to
+ a maximum of 2048, which may limit the ability to open a
+ large number of tables simultaneously. This limit is due to
+ the compatibility functions used to open files on Windows
+ that use the POSIX compatibility layer.
+ </para>
+
+ <para>
+ This limitation will also cause problems if you try to set
+ <option>max_open_files</option> to a value greater than the
+ 2048 file limit.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ On Windows 32-bit platforms it is not possible to use more
+ than 2GB of RAM within a single process, including MySQL.
+ This is because the physical address limit on Windows 32-bit
+ is 4GB and the default setting within Windows is to split
+ the RAM between kernel (2GB) and user/applications (2GB).
+ </para>
+
+ <para>
+ You can increase this limit to 3GB by specifying the
+ <option>/3GB</option> option in the
+ <filename>boot.ini</filename> file. This changes the
+ kernel/application memory split to 1GB and 3GB respectively.
+ This boot option is available on Windows XP, Windows Server
+ 2003, and Windows Server 2008.
+ </para>
+
+ <para>
+ To use more memory than this you will need to use a 64-bit
+ version of Windows.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ When using <literal>MyISAM</literal> tables, you cannot use
+ aliases within Windows link to the data files on another
+ volume and then link back to the main MySQL
+ <option>datadir</option> location.
+ </para>
+
+ <para>
+ This facility is often used to move the data and index files
+ to a RAID or other fast solution, while retaining the main
+ <filename>.FRM</filename> files in the default data
+ directory configured with the <option>datadir</option>
+ option.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The timers within MySQL used on Windows are of a lower
+ precision than the timers used on Linux. For most situations
+ you may not notice a difference, but the delay implied by a
+ call to <literal>SLEEP()</literal> on Windows and Linux may
+ differ slightly due to the differences in precision.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </section>
+
</section>
</appendix>
Modified: trunk/refman-6.0/installing-core.xml
===================================================================
--- trunk/refman-6.0/installing-core.xml 2007-12-20 03:22:59 UTC (rev 9410)
+++ trunk/refman-6.0/installing-core.xml 2007-12-20 09:48:12 UTC (rev 9411)
Changed blocks: 1, Lines Added: 5, Lines Deleted: 0; 556 bytes
@@ -2633,6 +2633,11 @@
</itemizedlist>
<para>
+ For a list of limitations within the Windows version of MySQL, see
+ <xref linkend="limits-windows"/>.
+ </para>
+
+ <para>
There may also be other requirements, depending on how you plan to
use MySQL:
</para>
Modified: trunk/refman-6.0/restrictions.xml
===================================================================
--- trunk/refman-6.0/restrictions.xml 2007-12-20 03:22:59 UTC (rev 9410)
+++ trunk/refman-6.0/restrictions.xml 2007-12-20 09:48:12 UTC (rev 9411)
Changed blocks: 1, Lines Added: 89, Lines Deleted: 0; 3317 bytes
@@ -1444,6 +1444,95 @@
</section>
+ <section id="limits-windows">
+
+ <title>Windows Platform Limitations</title>
+
+ <para>
+ The following limitations apply only to the Windows platform:
+ </para>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The number of open file descriptors on Windows is limited to
+ a maximum of 2048, which may limit the ability to open a
+ large number of tables simultaneously. This limit is due to
+ the compatibility functions used to open files on Windows
+ that use the POSIX compatibility layer.
+ </para>
+
+ <para>
+ This limitation will also cause problems if you try to set
+ <option>max_open_files</option> to a value greater than the
+ 2048 file limit.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ On Windows 32-bit platforms it is not possible to use more
+ than 2GB of RAM within a single process, including MySQL.
+ This is because the physical address limit on Windows 32-bit
+ is 4GB and the default setting within Windows is to split
+ the RAM between kernel (2GB) and user/applications (2GB).
+ </para>
+
+ <para>
+ You can increase this limit to 3GB by specifying the
+ <option>/3GB</option> option in the
+ <filename>boot.ini</filename> file. This changes the
+ kernel/application memory split to 1GB and 3GB respectively.
+ This boot option is available on Windows XP, Windows Server
+ 2003, and Windows Server 2008.
+ </para>
+
+ <para>
+ To use more memory than this you will need to use a 64-bit
+ version of Windows.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ When using <literal>MyISAM</literal> tables, you cannot use
+ aliases within Windows link to the data files on another
+ volume and then link back to the main MySQL
+ <option>datadir</option> location.
+ </para>
+
+ <para>
+ This facility is often used to move the data and index files
+ to a RAID or other fast solution, while retaining the main
+ <filename>.FRM</filename> files in the default data
+ directory configured with the <option>datadir</option>
+ option.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ The timers within MySQL used on Windows are of a lower
+ precision than the timers used on Linux. For most situations
+ you may not notice a difference, but the delay implied by a
+ call to <literal>SLEEP()</literal> on Windows and Linux may
+ differ slightly due to the differences in precision.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
+ </section>
+
</section>
</appendix>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r9411 - in trunk: refman-4.1 refman-5.0 refman-5.1 refman-6.0 | mcbrown | 20 Dec |
