Author: paul
Date: 2006-02-10 16:51:19 +0100 (Fri, 10 Feb 2006)
New Revision: 1276
Log:
r7307@frost: paul | 2006-02-10 09:50:16 -0600
Revise intro to system variable section.
Modified:
trunk/
trunk/refman-4.1/database-administration.xml
trunk/refman-5.0/database-administration.xml
trunk/refman-5.1/database-administration.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7297
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2927
+ b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:7307
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:2927
Modified: trunk/refman-4.1/database-administration.xml
===================================================================
--- trunk/refman-4.1/database-administration.xml 2006-02-10 13:05:01 UTC (rev 1275)
+++ trunk/refman-4.1/database-administration.xml 2006-02-10 15:51:19 UTC (rev 1276)
@@ -2046,32 +2046,90 @@
</para>
<para>
- To see the names and values of system variables, use the
- <literal>SHOW VARIABLES</literal> statement. To view the
- default values for these variables, use <command>mysqld
- <option>--verbose --help</option></command>. (For a listing of
- the default values, see <xref linkend="server-parameters"/>).
+ There are several ways to see the names and values of system
+ variables:
</para>
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ To see the values that a server will use based on its
+ compiled-in defaults and any option files that it reads,
+ use this command (omit <option>--verbose</option> before
+ MySQL 4.1.1):
+ </para>
+
+<programlisting>
+mysqld --verbose --help
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ To see the values that a server will use based on its
+ compiled-in defaults, ignoring the settings in any option
+ files, use this command (omit <option>--verbose</option>
+ before MySQL 4.1.1):
+ </para>
+
+<programlisting>
+mysqld --no-defaults --verbose --help
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ To see the current values used by a running server, use
+ the <literal>SHOW VARIABLES</literal> statement.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
<para>
This section provides a description of each system variable.
Variables with no version indicated have been present since at
- least MySQL 3.22. <literal>InnoDB</literal> system variables
- are listed at <xref linkend="innodb-parameters"/>.
+ least MySQL 3.22.
</para>
<para>
- For additional system variable information, see
- <xref linkend="using-system-variables"/>, which discusses the
- syntax for setting and displaying system variable values, and
- <xref linkend="dynamic-system-variables"/>, which lists the
- variables that can be set at runtime.
- <xref linkend="innodb-parameters"/>, lists
- <literal>InnoDB</literal> system variables. Information on
- tuning sytem variables can be found in
- <xref linkend="server-parameters"/>.
+ For additional system variable information, see these
+ sections:
</para>
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <xref linkend="using-system-variables"/>, discusses the
+ syntax for setting and displaying system variable values.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="dynamic-system-variables"/>, lists the
+ variables that can be set at runtime.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Information on tuning sytem variables can be found in
+ <xref linkend="server-parameters"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="innodb-parameters"/>, lists
+ <literal>InnoDB</literal> system variables.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
<para>
<emphasis>Note</emphasis>: Some of the following variable
descriptions refer to <quote>enabling</quote> or
Modified: trunk/refman-5.0/database-administration.xml
===================================================================
--- trunk/refman-5.0/database-administration.xml 2006-02-10 13:05:01 UTC (rev 1275)
+++ trunk/refman-5.0/database-administration.xml 2006-02-10 15:51:19 UTC (rev 1276)
@@ -1999,13 +1999,45 @@
</para>
<para>
- To see the names and values of system variables, use the
- <literal>SHOW VARIABLES</literal> statement. To view the
- default values for these variables, use <command>mysqld
- <option>--verbose --help</option></command>. (For a listing of
- the default values, see <xref linkend="server-parameters"/>).
+ There are several ways to see the names and values of system
+ variables:
</para>
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ To see the values that a server will use based on its
+ compiled-in defaults and any option files that it reads,
+ use this command:
+ </para>
+
+<programlisting>
+mysqld --verbose --help
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ To see the values that a server will use based on its
+ compiled-in defaults, ignoring the settings in any option
+ files, use this command:
+ </para>
+
+<programlisting>
+mysqld --no-defaults --verbose --help
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ To see the current values used by a running server, use
+ the <literal>SHOW VARIABLES</literal> statement.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
<remark role="todo">
Make the following reference to RefMan-4.1 a link.
</remark>
@@ -2019,17 +2051,42 @@
</para>
<para>
- For additional system variable information, see
- <xref linkend="using-system-variables"/>, which discusses the
- syntax for setting and displaying system variable values, and
- <xref linkend="dynamic-system-variables"/>, which lists the
- variables that can be set at runtime.
- <xref linkend="innodb-parameters"/>, lists
- <literal>InnoDB</literal> system variables. Information on
- tuning sytem variables can be found in
- <xref linkend="server-parameters"/>.
+ For additional system variable information, see these
+ sections:
</para>
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <xref linkend="using-system-variables"/>, discusses the
+ syntax for setting and displaying system variable values.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="dynamic-system-variables"/>, lists the
+ variables that can be set at runtime.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Information on tuning sytem variables can be found in
+ <xref linkend="server-parameters"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="innodb-parameters"/>, lists
+ <literal>InnoDB</literal> system variables.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
<para>
<emphasis>Note</emphasis>: Some of the following variable
descriptions refer to <quote>enabling</quote> or
Modified: trunk/refman-5.1/database-administration.xml
===================================================================
--- trunk/refman-5.1/database-administration.xml 2006-02-10 13:05:01 UTC (rev 1275)
+++ trunk/refman-5.1/database-administration.xml 2006-02-10 15:51:19 UTC (rev 1276)
@@ -2030,13 +2030,45 @@
</para>
<para>
- To see the names and values of system variables, use the
- <literal>SHOW VARIABLES</literal> statement. To view the
- default values for these variables, use <command>mysqld
- <option>--verbose --help</option></command>. (For a listing of
- the default values, see <xref linkend="server-parameters"/>).
+ There are several ways to see the names and values of system
+ variables:
</para>
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ To see the values that a server will use based on its
+ compiled-in defaults and any option files that it reads,
+ use this command:
+ </para>
+
+<programlisting>
+mysqld --verbose --help
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ To see the values that a server will use based on its
+ compiled-in defaults, ignoring the settings in any option
+ files, use this command:
+ </para>
+
+<programlisting>
+mysqld --no-defaults --verbose --help
+</programlisting>
+ </listitem>
+
+ <listitem>
+ <para>
+ To see the current values used by a running server, use
+ the <literal>SHOW VARIABLES</literal> statement.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
<remark role="todo">
Make the following reference to RefMan-4.1 a link.
</remark>
@@ -2051,17 +2083,42 @@
</para>
<para>
- For additional system variable information, see
- <xref linkend="using-system-variables"/>, which discusses the
- syntax for setting and displaying system variable values, and
- <xref linkend="dynamic-system-variables"/>, which lists the
- variables that can be set at runtime.
- <xref linkend="innodb-parameters"/>, lists
- <literal>InnoDB</literal> system variables. Information on
- tuning sytem variables can be found in
- <xref linkend="server-parameters"/>.
+ For additional system variable information, see these
+ sections:
</para>
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <xref linkend="using-system-variables"/>, discusses the
+ syntax for setting and displaying system variable values.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="dynamic-system-variables"/>, lists the
+ variables that can be set at runtime.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ Information on tuning sytem variables can be found in
+ <xref linkend="server-parameters"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="innodb-parameters"/>, lists
+ <literal>InnoDB</literal> system variables.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+
<para>
<emphasis>Note</emphasis>: Some of the following variable
descriptions refer to <quote>enabling</quote> or
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r1276 - in trunk: . refman-4.1 refman-5.0 refman-5.1 | paul | 10 Feb |
