Author: paul
Date: 2008-06-19 21:17:10 +0200 (Thu, 19 Jun 2008)
New Revision: 10984
Log:
r31778@arctic: paul | 2008-06-19 14:15:38 -0500
Be more explicit that:
- Dash and underscore are equivalent in program options
- Option value Multiplier suffixes can be used as startup, but not
expressions, whereas the converse is true for SET at runtime
Modified:
trunk/it/refman-5.1/programs-using.xml
trunk/pt/refman-5.1/programs-using.xml
trunk/refman-4.1/programs-using.xml
trunk/refman-5.0/programs-using.xml
trunk/refman-5.1/programs-using.xml
trunk/refman-6.0/programs-using.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:32117
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31727
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:32117
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:31778
Modified: trunk/it/refman-5.1/programs-using.xml
===================================================================
--- trunk/it/refman-5.1/programs-using.xml 2008-06-19 15:47:25 UTC (rev 10983)
+++ trunk/it/refman-5.1/programs-using.xml 2008-06-19 19:17:10 UTC (rev 10984)
Changed blocks: 5, Lines Added: 49, Lines Deleted: 10; 3652 bytes
@@ -37,8 +37,8 @@
<para>
Arguments that begin with a single or double dash
(<quote><literal>-</literal></quote>,
- <quote><literal>--</literal></quote>) are option arguments.
- Options typically specify the type of connection a program should
+ <quote><literal>--</literal></quote>) specify program options.
+ Options typically indicate the type of connection a program should
make to the server or affect its operational mode. Option syntax
is described in <xref linkend="program-options"/>.
</para>
@@ -325,6 +325,19 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ Within option names, dash
+ (<quote><literal>-</literal></quote>) and underscore
+ (<quote><literal>_</literal></quote>) may be used
+ interchangeably. For example,
+ <option>--skip-grant-tables</option> and
+ <option>--skip_grant_tables</option> are equivalent.
+ (However, the leading dashes cannot be given as
+ underscores.)
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
@@ -1214,9 +1227,15 @@
<para>
Many MySQL programs have internal variables that can be set at
- runtime. Program variables are set the same way as any other
- long option that takes a value. For example,
- <command>mysql</command> has a
+ runtime using the <literal>SET</literal> statement. See
+ <xref linkend="set-option"/>, and
+ <xref linkend="using-system-variables"/>.
+ </para>
+
+ <para>
+ Most of these program variables also can be set at server
+ startup by using the same syntax that applies to specifying
+ program options. For example, <command>mysql</command> has a
<literal>max_allowed_packet</literal> variable that controls the
maximum size of its communication buffer. To set the
<literal>max_allowed_packet</literal> variable for
@@ -1294,6 +1313,31 @@
future.
</para>
+ <para>
+ Suffixes for specifying a multiple can be used when setting a
+ variable at server startup, but not to set the value with
+ <literal>SET</literal> at runtime. On the other hand, with
+ <literal>SET</literal> you can assign a variable's value using
+ an expression, which is not true when you set a variable at
+ server startup. For example, the first of the following lines is
+ legal at server startup, but the second is not:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql --max_allowed_packet=16M</userinput>
+shell> <userinput>mysql --max_allowed_packet=16*1024*1024</userinput>
+</programlisting>
+
+ <para>
+ Conversely, the second of the following lines is legal at
+ runtime, but the first is not:
+ </para>
+
+<programlisting>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16M;</userinput>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16*1024*1024;</userinput>
+</programlisting>
+
<note>
<para>
Before MySQL 4.0.2, the only syntax for setting program
@@ -1307,11 +1351,6 @@
</para>
</note>
- <para>
- Many server system variables can also be set at runtime. For
- details, see <xref linkend="using-system-variables"/>.
- </para>
-
</section>
<section id="option-defaults-equals">
Modified: trunk/pt/refman-5.1/programs-using.xml
===================================================================
--- trunk/pt/refman-5.1/programs-using.xml 2008-06-19 15:47:25 UTC (rev 10983)
+++ trunk/pt/refman-5.1/programs-using.xml 2008-06-19 19:17:10 UTC (rev 10984)
Changed blocks: 5, Lines Added: 49, Lines Deleted: 10; 3652 bytes
@@ -37,8 +37,8 @@
<para>
Arguments that begin with a single or double dash
(<quote><literal>-</literal></quote>,
- <quote><literal>--</literal></quote>) are option arguments.
- Options typically specify the type of connection a program should
+ <quote><literal>--</literal></quote>) specify program options.
+ Options typically indicate the type of connection a program should
make to the server or affect its operational mode. Option syntax
is described in <xref linkend="program-options"/>.
</para>
@@ -325,6 +325,19 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ Within option names, dash
+ (<quote><literal>-</literal></quote>) and underscore
+ (<quote><literal>_</literal></quote>) may be used
+ interchangeably. For example,
+ <option>--skip-grant-tables</option> and
+ <option>--skip_grant_tables</option> are equivalent.
+ (However, the leading dashes cannot be given as
+ underscores.)
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
@@ -1214,9 +1227,15 @@
<para>
Many MySQL programs have internal variables that can be set at
- runtime. Program variables are set the same way as any other
- long option that takes a value. For example,
- <command>mysql</command> has a
+ runtime using the <literal>SET</literal> statement. See
+ <xref linkend="set-option"/>, and
+ <xref linkend="using-system-variables"/>.
+ </para>
+
+ <para>
+ Most of these program variables also can be set at server
+ startup by using the same syntax that applies to specifying
+ program options. For example, <command>mysql</command> has a
<literal>max_allowed_packet</literal> variable that controls the
maximum size of its communication buffer. To set the
<literal>max_allowed_packet</literal> variable for
@@ -1294,6 +1313,31 @@
future.
</para>
+ <para>
+ Suffixes for specifying a multiple can be used when setting a
+ variable at server startup, but not to set the value with
+ <literal>SET</literal> at runtime. On the other hand, with
+ <literal>SET</literal> you can assign a variable's value using
+ an expression, which is not true when you set a variable at
+ server startup. For example, the first of the following lines is
+ legal at server startup, but the second is not:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql --max_allowed_packet=16M</userinput>
+shell> <userinput>mysql --max_allowed_packet=16*1024*1024</userinput>
+</programlisting>
+
+ <para>
+ Conversely, the second of the following lines is legal at
+ runtime, but the first is not:
+ </para>
+
+<programlisting>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16M;</userinput>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16*1024*1024;</userinput>
+</programlisting>
+
<note>
<para>
Before MySQL 4.0.2, the only syntax for setting program
@@ -1307,11 +1351,6 @@
</para>
</note>
- <para>
- Many server system variables can also be set at runtime. For
- details, see <xref linkend="using-system-variables"/>.
- </para>
-
</section>
<section id="option-defaults-equals">
Modified: trunk/refman-4.1/programs-using.xml
===================================================================
--- trunk/refman-4.1/programs-using.xml 2008-06-19 15:47:25 UTC (rev 10983)
+++ trunk/refman-4.1/programs-using.xml 2008-06-19 19:17:10 UTC (rev 10984)
Changed blocks: 5, Lines Added: 49, Lines Deleted: 9; 3712 bytes
@@ -37,8 +37,8 @@
<para>
Arguments that begin with a single or double dash
(<quote><literal>-</literal></quote>,
- <quote><literal>--</literal></quote>) are option arguments.
- Options typically specify the type of connection a program should
+ <quote><literal>--</literal></quote>) specify program options.
+ Options typically indicate the type of connection a program should
make to the server or affect its operational mode. Option syntax
is described in <xref linkend="program-options"/>.
</para>
@@ -325,6 +325,19 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ Within option names, dash
+ (<quote><literal>-</literal></quote>) and underscore
+ (<quote><literal>_</literal></quote>) may be used
+ interchangeably. For example,
+ <option>--skip-grant-tables</option> and
+ <option>--skip_grant_tables</option> are equivalent.
+ (However, the leading dashes cannot be given as
+ underscores.)
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
@@ -1181,8 +1194,15 @@
<para>
Many MySQL programs have internal variables that can be set at
- runtime. As of MySQL 4.0.2, program variables are set the same
- way as any other long option that takes a value. For example,
+ runtime using the <literal>SET</literal> statement. See
+ <xref linkend="set-option"/>, and
+ <xref linkend="using-system-variables"/>.
+ </para>
+
+ <para>
+ As of MySQL 4.0.2, most of these program variables also can be
+ set at server startup by using the same syntax that applies to
+ specifying program options. For example,
<command>mysql</command> has a
<literal>max_allowed_packet</literal> variable that controls the
maximum size of its communication buffer. To set the
@@ -1262,6 +1282,31 @@
</para>
<para>
+ Suffixes for specifying a multiple can be used when setting a
+ variable at server startup, but not to set the value with
+ <literal>SET</literal> at runtime. On the other hand, with
+ <literal>SET</literal> you can assign a variable's value using
+ an expression, which is not true when you set a variable at
+ server startup. For example, the first of the following lines is
+ legal at server startup, but the second is not:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql --max_allowed_packet=16M</userinput>
+shell> <userinput>mysql --max_allowed_packet=16*1024*1024</userinput>
+</programlisting>
+
+ <para>
+ Conversely, the second of the following lines is legal at
+ runtime, but the first is not:
+ </para>
+
+<programlisting>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16M;</userinput>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16*1024*1024;</userinput>
+</programlisting>
+
+ <para>
Prior to MySQL 4.0.2, program variable names are not recognized
as option names. Instead, use the
<option>--set-variable</option> option to assign a value to a
@@ -1302,11 +1347,6 @@
in MySQL 4.0.2 and up, but is deprecated.
</para>
- <para>
- Many server system variables can also be set at runtime. For
- details, see <xref linkend="using-system-variables"/>.
- </para>
-
</section>
<section id="option-defaults-equals">
Modified: trunk/refman-5.0/programs-using.xml
===================================================================
--- trunk/refman-5.0/programs-using.xml 2008-06-19 15:47:25 UTC (rev 10983)
+++ trunk/refman-5.0/programs-using.xml 2008-06-19 19:17:10 UTC (rev 10984)
Changed blocks: 5, Lines Added: 49, Lines Deleted: 10; 3643 bytes
@@ -37,8 +37,8 @@
<para>
Arguments that begin with a single or double dash
(<quote><literal>-</literal></quote>,
- <quote><literal>--</literal></quote>) are option arguments.
- Options typically specify the type of connection a program should
+ <quote><literal>--</literal></quote>) specify program options.
+ Options typically indicate the type of connection a program should
make to the server or affect its operational mode. Option syntax
is described in <xref linkend="program-options"/>.
</para>
@@ -325,6 +325,19 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ Within option names, dash
+ (<quote><literal>-</literal></quote>) and underscore
+ (<quote><literal>_</literal></quote>) may be used
+ interchangeably. For example,
+ <option>--skip-grant-tables</option> and
+ <option>--skip_grant_tables</option> are equivalent.
+ (However, the leading dashes cannot be given as
+ underscores.)
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
@@ -1214,9 +1227,15 @@
<para>
Many MySQL programs have internal variables that can be set at
- runtime. Program variables are set the same way as any other
- long option that takes a value. For example,
- <command>mysql</command> has a
+ runtime using the <literal>SET</literal> statement. See
+ <xref linkend="set-option"/>, and
+ <xref linkend="using-system-variables"/>.
+ </para>
+
+ <para>
+ Most of these program variables also can be set at server
+ startup by using the same syntax that applies to specifying
+ program options. For example, <command>mysql</command> has a
<literal>max_allowed_packet</literal> variable that controls the
maximum size of its communication buffer. To set the
<literal>max_allowed_packet</literal> variable for
@@ -1294,6 +1313,31 @@
future.
</para>
+ <para>
+ Suffixes for specifying a multiple can be used when setting a
+ variable at server startup, but not to set the value with
+ <literal>SET</literal> at runtime. On the other hand, with
+ <literal>SET</literal> you can assign a variable's value using
+ an expression, which is not true when you set a variable at
+ server startup. For example, the first of the following lines is
+ legal at server startup, but the second is not:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql --max_allowed_packet=16M</userinput>
+shell> <userinput>mysql --max_allowed_packet=16*1024*1024</userinput>
+</programlisting>
+
+ <para>
+ Conversely, the second of the following lines is legal at
+ runtime, but the first is not:
+ </para>
+
+<programlisting>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16M;</userinput>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16*1024*1024;</userinput>
+</programlisting>
+
<note>
<para>
Before MySQL 4.0.2, the only syntax for setting program
@@ -1307,11 +1351,6 @@
</para>
</note>
- <para>
- Many server system variables can also be set at runtime. For
- details, see <xref linkend="using-system-variables"/>.
- </para>
-
</section>
<section id="option-defaults-equals">
Modified: trunk/refman-5.1/programs-using.xml
===================================================================
--- trunk/refman-5.1/programs-using.xml 2008-06-19 15:47:25 UTC (rev 10983)
+++ trunk/refman-5.1/programs-using.xml 2008-06-19 19:17:10 UTC (rev 10984)
Changed blocks: 5, Lines Added: 49, Lines Deleted: 10; 3643 bytes
@@ -37,8 +37,8 @@
<para>
Arguments that begin with a single or double dash
(<quote><literal>-</literal></quote>,
- <quote><literal>--</literal></quote>) are option arguments.
- Options typically specify the type of connection a program should
+ <quote><literal>--</literal></quote>) specify program options.
+ Options typically indicate the type of connection a program should
make to the server or affect its operational mode. Option syntax
is described in <xref linkend="program-options"/>.
</para>
@@ -325,6 +325,19 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ Within option names, dash
+ (<quote><literal>-</literal></quote>) and underscore
+ (<quote><literal>_</literal></quote>) may be used
+ interchangeably. For example,
+ <option>--skip-grant-tables</option> and
+ <option>--skip_grant_tables</option> are equivalent.
+ (However, the leading dashes cannot be given as
+ underscores.)
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
@@ -1214,9 +1227,15 @@
<para>
Many MySQL programs have internal variables that can be set at
- runtime. Program variables are set the same way as any other
- long option that takes a value. For example,
- <command>mysql</command> has a
+ runtime using the <literal>SET</literal> statement. See
+ <xref linkend="set-option"/>, and
+ <xref linkend="using-system-variables"/>.
+ </para>
+
+ <para>
+ Most of these program variables also can be set at server
+ startup by using the same syntax that applies to specifying
+ program options. For example, <command>mysql</command> has a
<literal>max_allowed_packet</literal> variable that controls the
maximum size of its communication buffer. To set the
<literal>max_allowed_packet</literal> variable for
@@ -1294,6 +1313,31 @@
future.
</para>
+ <para>
+ Suffixes for specifying a multiple can be used when setting a
+ variable at server startup, but not to set the value with
+ <literal>SET</literal> at runtime. On the other hand, with
+ <literal>SET</literal> you can assign a variable's value using
+ an expression, which is not true when you set a variable at
+ server startup. For example, the first of the following lines is
+ legal at server startup, but the second is not:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql --max_allowed_packet=16M</userinput>
+shell> <userinput>mysql --max_allowed_packet=16*1024*1024</userinput>
+</programlisting>
+
+ <para>
+ Conversely, the second of the following lines is legal at
+ runtime, but the first is not:
+ </para>
+
+<programlisting>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16M;</userinput>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16*1024*1024;</userinput>
+</programlisting>
+
<note>
<para>
Before MySQL 4.0.2, the only syntax for setting program
@@ -1307,11 +1351,6 @@
</para>
</note>
- <para>
- Many server system variables can also be set at runtime. For
- details, see <xref linkend="using-system-variables"/>.
- </para>
-
</section>
<section id="option-defaults-equals">
Modified: trunk/refman-6.0/programs-using.xml
===================================================================
--- trunk/refman-6.0/programs-using.xml 2008-06-19 15:47:25 UTC (rev 10983)
+++ trunk/refman-6.0/programs-using.xml 2008-06-19 19:17:10 UTC (rev 10984)
Changed blocks: 5, Lines Added: 49, Lines Deleted: 10; 3643 bytes
@@ -37,8 +37,8 @@
<para>
Arguments that begin with a single or double dash
(<quote><literal>-</literal></quote>,
- <quote><literal>--</literal></quote>) are option arguments.
- Options typically specify the type of connection a program should
+ <quote><literal>--</literal></quote>) specify program options.
+ Options typically indicate the type of connection a program should
make to the server or affect its operational mode. Option syntax
is described in <xref linkend="program-options"/>.
</para>
@@ -325,6 +325,19 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ Within option names, dash
+ (<quote><literal>-</literal></quote>) and underscore
+ (<quote><literal>_</literal></quote>) may be used
+ interchangeably. For example,
+ <option>--skip-grant-tables</option> and
+ <option>--skip_grant_tables</option> are equivalent.
+ (However, the leading dashes cannot be given as
+ underscores.)
+ </para>
+ </listitem>
+
</itemizedlist>
<para>
@@ -1212,9 +1225,15 @@
<para>
Many MySQL programs have internal variables that can be set at
- runtime. Program variables are set the same way as any other
- long option that takes a value. For example,
- <command>mysql</command> has a
+ runtime using the <literal>SET</literal> statement. See
+ <xref linkend="set-option"/>, and
+ <xref linkend="using-system-variables"/>.
+ </para>
+
+ <para>
+ Most of these program variables also can be set at server
+ startup by using the same syntax that applies to specifying
+ program options. For example, <command>mysql</command> has a
<literal>max_allowed_packet</literal> variable that controls the
maximum size of its communication buffer. To set the
<literal>max_allowed_packet</literal> variable for
@@ -1292,6 +1311,31 @@
future.
</para>
+ <para>
+ Suffixes for specifying a multiple can be used when setting a
+ variable at server startup, but not to set the value with
+ <literal>SET</literal> at runtime. On the other hand, with
+ <literal>SET</literal> you can assign a variable's value using
+ an expression, which is not true when you set a variable at
+ server startup. For example, the first of the following lines is
+ legal at server startup, but the second is not:
+ </para>
+
+<programlisting>
+shell> <userinput>mysql --max_allowed_packet=16M</userinput>
+shell> <userinput>mysql --max_allowed_packet=16*1024*1024</userinput>
+</programlisting>
+
+ <para>
+ Conversely, the second of the following lines is legal at
+ runtime, but the first is not:
+ </para>
+
+<programlisting>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16M;</userinput>
+mysql> <userinput>SET GLOBAL max_allowed_packet=16*1024*1024;</userinput>
+</programlisting>
+
<note>
<para>
Before MySQL 4.0.2, the only syntax for setting program
@@ -1305,11 +1349,6 @@
</para>
</note>
- <para>
- Many server system variables can also be set at runtime. For
- details, see <xref linkend="using-system-variables"/>.
- </para>
-
</section>
<section id="option-defaults-equals">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r10984 - in trunk: . it/refman-5.1 pt/refman-5.1 refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul | 19 Jun |
