| List: | Commits | « Previous MessageNext Message » | |
| From: | plavin | Date: | April 23 2007 9:34pm |
| Subject: | svn commit - mysqldoc@docsrva: r6077 - trunk/refman-5.1 | ||
| View as plain text | |||
Author: plavin Date: 2007-04-23 21:34:39 +0200 (Mon, 23 Apr 2007) New Revision: 6077 Log: Add mysql client ids Modified: trunk/refman-5.1/client-utility-programs.xml Modified: trunk/refman-5.1/client-utility-programs.xml =================================================================== --- trunk/refman-5.1/client-utility-programs.xml 2007-04-23 19:24:03 UTC (rev 6076) +++ trunk/refman-5.1/client-utility-programs.xml 2007-04-23 19:34:39 UTC (rev 6077) Changed blocks: 96, Lines Added: 1061, Lines Deleted: 72; 55605 bytes @@ -114,12 +114,17 @@ <primary>myisamchk</primary> </indexterm> - <command>myisamchk</command> + <indexterm> + <primary>isamchk</primary> + </indexterm> + + <command>myisamchk</command>, <command>isamchk</command> </para> <para> A utility to describe, check, optimize, and repair - <literal>MyISAM</literal> tables. See + <literal>MyISAM</literal> tables. <command>isamchk</command> + is a similar program for <literal>ISAM</literal> tables. See <xref linkend="myisamchk"/>. </para> </listitem> @@ -130,7 +135,11 @@ <primary>myisamlog</primary> </indexterm> - <command>myisamlog</command> + <indexterm> + <primary>isamlog</primary> + </indexterm> + + <command>myisamlog</command>, <command>isamlog</command> </para> <para> @@ -146,7 +155,11 @@ <primary>myisampack</primary> </indexterm> - <command>myisampack</command> + <indexterm> + <primary>pack_isam</primary> + </indexterm> + + <command>myisampack</command>, <command>pack_isam</command> </para> <para> @@ -337,6 +350,22 @@ <listitem> <para> <indexterm> + <primary>mysql_find_rows</primary> + </indexterm> + + <command>mysql_find_rows</command> + </para> + + <para> + A utility that reads update log files and extracts queries + that match a given regular expression. See + <xref linkend="mysql-find-rows"/>. + </para> + </listitem> + + <listitem> + <para> + <indexterm> <primary>mysql_fix_extensions</primary> </indexterm> @@ -371,6 +400,21 @@ <listitem> <para> <indexterm> + <primary>mysql_tableinfo</primary> + </indexterm> + + <command>mysql_tableinfo</command> + </para> + + <para> + A utility that generates database metadata. + <xref linkend="mysql-tableinfo"/>. + </para> + </listitem> + + <listitem> + <para> + <indexterm> <primary>mysql_waitpid</primary> </indexterm> @@ -1210,6 +1254,10 @@ <primary>myisamchk</primary> </indexterm> + <indexterm> + <primary>isamchk</primary> + </indexterm> + <refmeta> <refentrytitle><command>myisamchk</command></refentrytitle> @@ -1232,6 +1280,16 @@ </cmdsynopsis> </refsynopsisdiv> + <refsynopsisdiv> + <cmdsynopsis> + <command>myisamchk [<replaceable>options</replaceable>] <replaceable>tbl_name</replaceable> ...</command> + </cmdsynopsis> + + <cmdsynopsis> + <command>isamchk [<replaceable>options</replaceable>] <replaceable>tbl_name</replaceable> …</command> + </cmdsynopsis> + </refsynopsisdiv> + <refsection id="myisamchk-description"> <title>Description</title> @@ -1331,6 +1389,7 @@ <programlisting> shell> <userinput>myisamchk --silent --fast <replaceable>/path/to/datadir/*/*</replaceable>.MYI</userinput> +shell> <userinput>isamchk --silent <replaceable>/path/to/datadir/*/*</replaceable>.ISM</userinput> </programlisting> <para> @@ -1344,6 +1403,9 @@ <userinput>--key_buffer_size=64M --sort_buffer_size=64M \</userinput> <userinput>--read_buffer_size=1M --write_buffer_size=1M \</userinput> <userinput><replaceable>/path/to/datadir/*/*</replaceable>.MYI</userinput> +shell> <userinput>isamchk --silent --force --key_buffer_size=64M \</userinput> + <userinput>--sort_buffer_size=64M --read_buffer_size=1M --write_buffer_size=1M \</userinput> + <userinput><replaceable>/path/to/datadir/*/*</replaceable>.ISM</userinput> </programlisting> <para> @@ -1684,6 +1746,14 @@ </informaltable> <para> + It is also possible to set variables by using + <option>--set-variable=<replaceable>var_name</replaceable>=<replaceable>value</replaceable></option> + or <option>-O + <replaceable>var_name</replaceable>=<replaceable>value</replaceable></option> + syntax. However, this syntax is deprecated as of MySQL 4.0. + </para> + + <para> The possible <command>myisamchk</command> variables and their default values can be examined with <command>myisamchk --help</command>: @@ -1754,10 +1824,20 @@ more information, see the description of <literal>myisam_stats_method</literal> in <xref linkend="server-system-variables"/>, and - <xref linkend="myisam-index-statistics"/>. + <xref linkend="myisam-index-statistics"/>. For MySQL + ¤t-series;, <literal>stats_method</literal> was added in + MySQL 5.0.14. For older versions, the statistics collection + method is equivalent to <literal>nulls_equal</literal>. </para> <para> + The <literal>ft_min_word_len</literal> and + <literal>ft_max_word_len</literal> variables are available as + of MySQL 4.0.0. <literal>ft_stopword_file</literal> is + available as of MySQL 4.0.19. + </para> + + <para> <literal>ft_min_word_len</literal> and <literal>ft_max_word_len</literal> indicate the minimum and maximum word length for <literal>FULLTEXT</literal> indexes. @@ -2231,6 +2311,34 @@ </listitem> <listitem> + <para id="option_myisamchk_no-symlinks"> + <indexterm> + <primary>myisamchk</primary> + <secondary>no-symlinks option</secondary> + </indexterm> + + <indexterm> + <primary>no-symlinks option</primary> + <secondary>myisamchk</secondary> + </indexterm> + + <option>--no-symlinks</option>, <option>-l</option> + </para> + + <para> + Do not follow symbolic links. Normally + <command>myisamchk</command> repairs the table that a + symlink points to. This option does not exist as of MySQL + 4.0 because versions from 4.0 on do not remove symlinks + during repair operations. + </para> + </listitem> + + <listitem> + <remark role="todo"> + Is this considered stable yet? [js] + </remark> + <para id="option_myisamchk_max-record-length"> <indexterm> <primary>myisamchk</primary> @@ -2367,6 +2475,28 @@ </listitem> <listitem> + <para id="option_myisamchk_set-character-set"> + <indexterm> + <primary>myisamchk</primary> + <secondary>set-character-set option</secondary> + </indexterm> + + <indexterm> + <primary>set-character-set option</primary> + <secondary>myisamchk</secondary> + </indexterm> + + <option>--set-character-set=<replaceable>name</replaceable></option> + </para> + + <para> + Change the character set used by the table indexes. This + option was replaced by <option>--set-collation</option> in + MySQL 5.0.3. + </para> + </listitem> + + <listitem> <para id="option_myisamchk_set-collation"> <indexterm> <primary>myisamchk</primary> @@ -2771,6 +2901,10 @@ <primary>myisamlog</primary> </indexterm> + <indexterm> + <primary>isamlog</primary> + </indexterm> + <refmeta> <refentrytitle><command>myisamlog</command></refentrytitle> @@ -2793,6 +2927,16 @@ </cmdsynopsis> </refsynopsisdiv> + <refsynopsisdiv> + <cmdsynopsis> + <command>myisamlog [<replaceable>options</replaceable>] [<replaceable>log_file</replaceable> [<replaceable>tbl_name</replaceable>] ...]</command> + </cmdsynopsis> + + <cmdsynopsis> + <command>isamlog [<replaceable>options</replaceable>] [<replaceable>log_file</replaceable> [<replaceable>tbl_name</replaceable>] ...]</command> + </cmdsynopsis> + </refsynopsisdiv> + <refsection id="myisamlog-description"> <title>Description</title> @@ -2808,6 +2952,7 @@ <programlisting> shell> <userinput>myisamlog [<replaceable>options</replaceable>] [<replaceable>log_file</replaceable> [<replaceable>tbl_name</replaceable>] ...]</userinput> +shell> <userinput>isamlog [<replaceable>options</replaceable>] [<replaceable>log_file</replaceable> [<replaceable>tbl_name</replaceable>] ...]</userinput> </programlisting> <para> @@ -2815,7 +2960,9 @@ recovery is done (<option>-r</option>), all writes and possibly updates and deletes are done and errors are only counted. The default log file name is - <filename>myisam.log</filename> if no + <filename>myisam.log</filename> for + <command>myisamlog</command> and <filename>isam.log</filename> + for <command>isamlog</command> if no <replaceable>log_file</replaceable> argument is given, If tables are named on the command line, only those tables are updated. @@ -3040,6 +3187,16 @@ </cmdsynopsis> </refsynopsisdiv> + <refsynopsisdiv> + <cmdsynopsis> + <command>myisampack [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> ...</command> + </cmdsynopsis> + + <cmdsynopsis> + <command>pack_isam [<replaceable>options</replaceable>] <replaceable>file_name</replaceable> …</command> + </cmdsynopsis> + </refsynopsisdiv> + <refsection id="myisampack-description"> <title>Description</title> @@ -3067,6 +3224,18 @@ </para> <para> + A similar utility, <command>pack_isam</command>, compresses + <literal>ISAM</literal> tables. Because + <literal>ISAM</literal> tables are deprecated, this section + discusses only <command>myisampack</command>, but the general + procedures for using <command>myisampack</command> are also + true for <command>pack_isam</command> unless otherwise + specified. References to <command>myisamchk</command> should + be read as references to <command>isamchk</command> if you are + using <command>pack_isam</command>. + </para> + + <para> Please note the following: </para> @@ -3890,6 +4059,16 @@ </programlisting> <para> + A similar procedure applies for <literal>ISAM</literal> + tables. After using <command>pack_isam</command>, use + <command>isamchk</command> to re-create the indexes: + </para> + +<programlisting> +shell> <userinput>isamchk -rq --sort-index --analyze <replaceable>tbl_name</replaceable>.ISM</userinput> +</programlisting> + + <para> After you have installed the packed table into the MySQL database directory, you should execute <command>mysqladmin flush-tables</command> to force <command>mysqld</command> to @@ -3898,7 +4077,8 @@ <para> To unpack a packed table, use the <option>--unpack</option> - option to <command>myisamchk</command>. + option to <command>myisamchk</command> or + <command>isamchk</command>. </para> </refsection> @@ -4065,7 +4245,7 @@ <itemizedlist> <listitem> - <para> + <para id="option_mysql_help"> <indexterm> <primary>mysql</primary> <secondary>help option</secondary> @@ -4085,7 +4265,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_auto-rehash"> <indexterm> <primary>mysql</primary> <secondary>auto-rehash option</secondary> @@ -4110,7 +4290,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_batch" > <indexterm> <primary>mysql</primary> <secondary>batch option</secondary> @@ -4132,7 +4312,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_character-sets-dir"> <indexterm> <primary>mysql</primary> <secondary>character-sets-dir option</secondary> @@ -4153,7 +4333,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_column-names"> <indexterm> <primary>mysql</primary> <secondary>column-names option</secondary> @@ -4173,7 +4353,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_compress"> <indexterm> <primary>mysql</primary> <secondary>compress option</secondary> @@ -4194,7 +4374,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_database"> <indexterm> <primary>mysql</primary> <secondary>database option</secondary> @@ -4216,7 +4396,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_debug"> <indexterm> <primary>mysql</primary> <secondary>debug option</secondary> @@ -4242,7 +4422,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_debug-info"> <indexterm> <primary>mysql</primary> <secondary>debug-info option</secondary> @@ -4262,7 +4442,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_default-character-set"> <indexterm> <primary>mysql</primary> <secondary>default-character-set option</secondary> @@ -4283,7 +4463,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_delimiter"> <indexterm> <primary>mysql</primary> <secondary>delimiter option</secondary> @@ -4304,7 +4484,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_execute"> <indexterm> <primary>mysql</primary> <secondary>execute option</secondary> @@ -4327,7 +4507,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_force"> <indexterm> <primary>mysql</primary> <secondary>force option</secondary> @@ -4347,7 +4527,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_host"> <indexterm> <primary>mysql</primary> <secondary>host option</secondary> @@ -4368,7 +4548,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_html"> <indexterm> <primary>mysql</primary> <secondary>html option</secondary> @@ -4388,7 +4568,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_ignore-spaces"> <indexterm> <primary>mysql</primary> <secondary>ignore-spaces option</secondary> @@ -4411,7 +4591,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_line-numbers"> <indexterm> <primary>mysql</primary> <secondary>line-numbers option</secondary> @@ -4432,7 +4612,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_local-infile"> <indexterm> <primary>mysql</primary> <secondary>local-infile option</secondary> @@ -4473,7 +4653,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_named-commands"> <indexterm> <primary>mysql</primary> <secondary>named-commands option</secondary> @@ -4498,7 +4678,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_no-auto-rehash"> <indexterm> <primary>mysql</primary> <secondary>no-auto-rehash option</secondary> @@ -4519,7 +4699,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_no-beep"> <indexterm> <primary>mysql</primary> <secondary>no-beep option</secondary> @@ -4539,7 +4719,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_no-named-commands"> <indexterm> <primary>mysql</primary> <secondary>no-named-commands option</secondary> @@ -4566,7 +4746,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_no-pager"> <indexterm> <primary>mysql</primary> <secondary>no-pager option</secondary> @@ -4587,7 +4767,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_no-tee"> <indexterm> <primary>mysql</primary> <secondary>no-tee option</secondary> @@ -4609,7 +4789,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_one-database"> <indexterm> <primary>mysql</primary> <secondary>one-database option</secondary> @@ -4631,7 +4811,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_pager"> <indexterm> <primary>mysql</primary> <secondary>pager option</secondary> @@ -4660,7 +4840,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_password"> <indexterm> <primary>mysql</primary> <secondary>password option</secondary> @@ -4693,7 +4873,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_port"> <indexterm> <primary>mysql</primary> <secondary>port option</secondary> @@ -4714,7 +4894,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_prompt"> <indexterm> <primary>mysql</primary> <secondary>prompt option</secondary> @@ -4737,7 +4917,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_protocol"> <indexterm> <primary>mysql</primary> <secondary>protocol option</secondary> @@ -4757,7 +4937,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_quick"> <indexterm> <primary>mysql</primary> <secondary>quick option</secondary> @@ -4780,7 +4960,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_raw"> <indexterm> <primary>mysql</primary> <secondary>raw option</secondary> @@ -4801,7 +4981,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_reconnect"> <indexterm> <primary>mysql</primary> <secondary>reconnect option</secondary> @@ -4824,7 +5004,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_safe-updates" > <indexterm> <primary>mysql</primary> <secondary>safe-updates option</secondary> @@ -4861,7 +5041,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_secure_auth"> <indexterm> <primary>mysql</primary> <secondary>secure-auth option</secondary> @@ -4896,7 +5076,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_show-warnings"> <indexterm> <primary>mysql</primary> <secondary>show-warnings option</secondary> @@ -4918,7 +5098,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_sigint-ignore"> <indexterm> <primary>mysql</primary> <secondary>sigint-ignore option</secondary> @@ -4939,7 +5119,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_silent"> <indexterm> <primary>mysql</primary> <secondary>silent option</secondary> @@ -4960,7 +5140,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_skip-column-names"> <indexterm> <primary>mysql</primary> <secondary>skip-column-names option</secondary> @@ -4980,7 +5160,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_skip-line-numbers"> <indexterm> <primary>mysql</primary> <secondary>skip-line-numbers option</secondary> @@ -5001,7 +5181,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_socket"> <indexterm> <primary>mysql</primary> <secondary>socket option</secondary> @@ -5024,7 +5204,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_ssl"> <indexterm> <primary>mysql</primary> <secondary>SSL options</secondary> @@ -5047,7 +5227,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_table"> <indexterm> <primary>mysql</primary> <secondary>table option</secondary> @@ -5069,7 +5249,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_tee"> <indexterm> <primary>mysql</primary> <secondary>tee option</secondary> @@ -5092,7 +5272,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_unbuffered"> <indexterm> <primary>mysql</primary> <secondary>unbuffered option</secondary> @@ -5112,7 +5292,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_user"> <indexterm> <primary>mysql</primary> <secondary>user option</secondary> @@ -5133,7 +5313,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_verbose"> <indexterm> <primary>mysql</primary> <secondary>verbose option</secondary> @@ -5157,7 +5337,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_version"> <indexterm> <primary>mysql</primary> <secondary>version option</secondary> @@ -5177,7 +5357,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_vertical"> <indexterm> <primary>mysql</primary> <secondary>vertical option</secondary> @@ -5200,7 +5380,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_wait"> <indexterm> <primary>mysql</primary> <secondary>wait option</secondary> @@ -5221,7 +5401,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_xml"> <indexterm> <primary>mysql</primary> <secondary>xml option</secondary> @@ -5308,7 +5488,7 @@ <itemizedlist> <listitem> - <para> + <para id="option_mysql_connect_timeout"> <indexterm> <primary>timeout</primary> <secondary><literal>connect_timeout</literal> variable</secondary> @@ -5328,7 +5508,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_max_alowed_packet"> <indexterm> <primary><literal>max_allowed_packet</literal> variable</primary> </indexterm> @@ -5343,7 +5523,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_max_join_size"> <indexterm> <primary><literal>max_join_size</literal> variable</primary> </indexterm> @@ -5374,7 +5554,7 @@ </listitem> <listitem> - <para> + <para id="option_mysql_select_limit"> <indexterm> <primary><literal>select_limit</literal> variable</primary> </indexterm> @@ -5479,6 +5659,10 @@ <title><command>mysql</command> Commands</title> + <remark role="todo"> + describe 4.1 help system + </remark> + <para> <command>mysql</command> sends each SQL statement that you issue to the server to be executed. There is also a set of @@ -5950,6 +6134,10 @@ </programlisting> </listitem> + <listitem> + <para></para> + </listitem> + </itemizedlist> </refsection> @@ -10464,6 +10652,50 @@ </para> <para> + Before MySQL 4.1.2, out-of-range numeric values such as + <literal>-inf</literal> and <literal>inf</literal>, as well as + <literal>NaN</literal> (not-a-number) values are dumped by + <command>mysqldump</command> as <literal>NULL</literal>. You + can see this using the following sample table: + </para> + +<programlisting> +mysql> <userinput>CREATE TABLE t (f DOUBLE);</userinput> +mysql> <userinput>INSERT INTO t VALUES(1e+111111111111111111111);</userinput> +mysql> <userinput>INSERT INTO t VALUES(-1e111111111111111111111);</userinput> +mysql> <userinput>SELECT f FROM t;</userinput> ++------+ +| f | ++------+ +| inf | +| -inf | ++------+ +</programlisting> + + <para> + For this table, <command>mysqldump</command> produces the + following data output: + </para> + +<programlisting> +-- +-- Dumping data for table `t` +-- + +INSERT INTO t VALUES (NULL); +INSERT INTO t VALUES (NULL); +</programlisting> + + <para> + The significance of this behavior is that if you dump and + restore the table, the new table has contents that differ from + the original contents. This problem is fixed as of MySQL + 4.1.2; you cannot insert <literal>inf</literal> in the table, + so this <command>mysqldump</command> behavior is only relevant + when you deal with old servers. + </para> + + <para> <command>mysqldump</command> supports the following options: </para> @@ -10733,6 +10965,11 @@ <option>--compatible=oracle</option> does not map data types to Oracle types or use Oracle comment syntax. </para> + + <para> + <emphasis>This option requires a server version of 4.1.0 + or higher</emphasis>. With older servers, it does nothing. + </para> </listitem> <listitem> @@ -10870,7 +11107,8 @@ Use <replaceable>charset_name</replaceable> as the default character set. See <xref linkend="character-sets"/>. If no character set is specified, <command>mysqldump</command> - uses <literal>utf8</literal>. + uses <literal>utf8</literal>, + and earlier versions use <literal>latin1</literal>. </para> </listitem> @@ -10913,7 +11151,9 @@ <para> On a master replication server, delete the binary logs after performing the dump operation. This option - automatically enables <option>--master-data</option>. + automatically enables <option>--first-slave</option> + before MySQL 4.1.8 and enables + <option>--master-data</option>. </para> </listitem> @@ -11317,7 +11557,8 @@ with <literal>READ LOCAL</literal> to allow concurrent inserts in the case of <literal>MyISAM</literal> tables. For transactional tables such as - <literal>InnoDB</literal>, + <literal>InnoDB</literal> + and <literal>BDB</literal>, <option>--single-transaction</option> is a much better option, because it does not need to lock the tables at all. @@ -11826,6 +12067,15 @@ </para> <para> + This option is not supported for MySQL Cluster tables; the + results cannot be guaranteed to be consistent due to the + fact that the <literal>NDBCluster</literal> storage engine + supports only the <literal>READ_COMMITTED</literal> + transaction isolation level. You should always use + <literal>NDB</literal> backup and restore instead. + </para> + + <para> To dump large tables, you should combine this option with <option>--quick</option>. </para> @@ -12509,7 +12759,8 @@ tables, but it can be run only on the same machine where the database directories are located. <command>mysqlhotcopy</command> works only for backing up - <literal>MyISAM</literal> and <literal>ARCHIVE</literal> + <literal>MyISAM</literal> and <literal>ISAM</literal> tables, + and <literal>ARCHIVE</literal> tables. It runs on Unix and NetWare. </para> @@ -13843,6 +14094,98 @@ </section> + <section id="fake-id-for-mysqlmanagerc-manpage-section-wrapper"> + + <title>fake title for mysqlmanagerc manpage section wrapper</title> + + <refentry id="mysqlmanagerc"> + + <indexterm> + <primary>mysqlmanagerc</primary> + </indexterm> + + <refmeta> + <refentrytitle><command>mysqlmanagerc</command></refentrytitle> + + <manvolnum>1</manvolnum> + <refmiscinfo class="manual">MySQL Database System</refmiscinfo> + <refmiscinfo class="source">MySQL</refmiscinfo> + <refmiscinfo class="refman">Internal Test-Suite Program</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>mysqlmanagerc</refname> + + <refpurpose>internal test-suite program</refpurpose> + </refnamediv> + + <refsynopsisdiv> + <cmdsynopsis> + <command>mysqlmanagerc [<replaceable>options</replaceable>]</command> + </cmdsynopsis> + </refsynopsisdiv> + + <refsection id="mysqlmanagerc-description"> + + <title>Description</title> + + <para> + This program was used internally for test purposes. As of + MySQL 5.0, it is no longer used. + </para> + + </refsection> + + </refentry> + + </section> + + <section id="fake-id-for-mysqlmanager-pwgen-manpage-section-wrapper"> + + <title>fake title for mysqlmanager-pwgen manpage section wrapper</title> + + <refentry id="mysqlmanager-pwgen"> + + <indexterm> + <primary>mysqlmanager-pwgen</primary> + </indexterm> + + <refmeta> + <refentrytitle><command>mysqlmanager-pwgen</command></refentrytitle> + + <manvolnum>1</manvolnum> + <refmiscinfo class="manual">MySQL Database System</refmiscinfo> + <refmiscinfo class="source">MySQL</refmiscinfo> + <refmiscinfo class="refman">Internal Test-Suite Program</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>mysqlmanager-pwgen</refname> + + <refpurpose>internal test-suite program</refpurpose> + </refnamediv> + + <refsynopsisdiv> + <cmdsynopsis> + <command>mysqlmanager-pwgen [<replaceable>options</replaceable>]</command> + </cmdsynopsis> + </refsynopsisdiv> + + <refsection id="mysqlmanager-pwgen-description"> + + <title>Description</title> + + <para> + This program was used internally for test purposes. As of + MySQL 5.0, it is no longer used. + </para> + + </refsection> + + </refentry> + + </section> + <section id="fake-id-for-mysqlshow-manpage-section-wrapper"> <title>fake title for mysqlshow manpage section wrapper</title> @@ -14184,6 +14527,12 @@ considered insecure. See <xref linkend="password-security"/>. </para> + + <para> + Specifying a password on the command line should be + considered insecure. See + <xref linkend="password-security"/>. + </para> </listitem> <listitem> @@ -14439,7 +14788,7 @@ </para> <programlisting> -shell> <userinput>mysqlslap [<replaceable>options</replaceable>]</userinput> +shell> <userinput>mysqlslap [<replaceable>options</replaceable>]<replaceable>db_name</replaceable></userinput> </programlisting> <para> @@ -15240,6 +15589,12 @@ </para> <para> + The results may assist you in determining which queries result + in table scans and where it would be beneficial to add indexes + to your tables. + </para> + + <para> Invoke <command>mysql_convert_table_format</command> like this: </para> @@ -15262,7 +15617,17 @@ <listitem> <para> - <option>--help</option> + <indexterm> + <primary>mysql_explain_log</primary> + <secondary>help option</secondary> + </indexterm> + + <indexterm> + <primary>help option</primary> + <secondary>mysql_explain_log</secondary> + </indexterm> + + <option>--help</option>, <option>-?</option> </para> <para> @@ -15282,7 +15647,18 @@ <listitem> <para> - <option>--host=<replaceable>host_name</replaceable></option> + <indexterm> + <primary>mysql_explain_log</primary> + <secondary>host option</secondary> + </indexterm> + + <indexterm> + <primary>host option</primary> + <secondary>mysql_explain_log</secondary> + </indexterm> + + <option>--host=<replaceable>host_name</replaceable></option>, + <option>-h <replaceable>host_name</replaceable></option> </para> <para> @@ -15292,7 +15668,18 @@ <listitem> <para> - <option>--password=<replaceable>password</replaceable></option> + <indexterm> + <primary>mysql_explain_log</primary> + <secondary>password option</secondary> + </indexterm> + + <indexterm> + <primary>password option</primary> + <secondary>mysql_explain_log</secondary> + </indexterm> + + <option>--password=<replaceable>password</replaceable></option>, + <option>-p <replaceable>password</replaceable></option> </para> <para> @@ -15321,7 +15708,18 @@ <listitem> <para> - <option>--socket=<replaceable>path</replaceable></option> + <indexterm> + <primary>mysql_explain_log</primary> + <secondary>socket option</secondary> + </indexterm> + + <indexterm> + <primary>socket option</primary> + <secondary>mysql_explain_log</secondary> + </indexterm> + + <option>--socket=<replaceable>path</replaceable></option>, + <option>-S <replaceable>path</replaceable></option> </para> <para> @@ -15357,7 +15755,18 @@ <listitem> <para> - <option>--user=<replaceable>user_name</replaceable></option> + <indexterm> + <primary>mysql_explain_log</primary> + <secondary>user option</secondary> + </indexterm> + + <indexterm> + <primary>user option</primary> + <secondary>mysql_explain_log</secondary> + </indexterm> + + <option>--user=<replaceable>user_name</replaceable></option>, + <option>-u <replaceable>user_name</replaceable></option> </para> <para> @@ -15394,6 +15803,191 @@ </section> + <section id="fake-id-for-mysql-find-rows-manpage-section-wrapper"> + + <title>fake title for mysql_find_rows manpage section wrapper</title> + + <refentry id="mysql-find-rows"> + + <indexterm> + <primary>mysql_find_rows</primary> + </indexterm> + + <refmeta> + <refentrytitle><command>mysql_find_rows</command></refentrytitle> + + <manvolnum>1</manvolnum> + <refmiscinfo class="manual">MySQL Database System</refmiscinfo> + <refmiscinfo class="source">MySQL</refmiscinfo> + <refmiscinfo class="version">¤t-series;</refmiscinfo> + <refmiscinfo class="refman">Extract Queries from Update Log</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>mysql_find_rows</refname> + + <refpurpose>extract queries from update log</refpurpose> + </refnamediv> + + <refsynopsisdiv> + <cmdsynopsis> + <command>mysql_find_rows [<replaceable>options</replaceable>] [<replaceable>file_name</replaceable> ...]</command> + </cmdsynopsis> + </refsynopsisdiv> + + <refsection id="mysql-find-rows-description"> + + <title>Description</title> + + <para> + <command>mysql_find_rows</command> reads update log files and + extracts queries that match a given regular expression or that + contain <literal>USE + <replaceable>db_name</replaceable></literal> or + <literal>SET</literal> statements. + </para> + + <para> + Invoke <command>mysql_find_rows</command> like this: + </para> + +<programlisting> +shell> <userinput>mysql_find_rows [<replaceable>options</replaceable>] [<replaceable>file_name</replaceable> ...]</userinput> +</programlisting> + + <para> + Each <replaceable>file_name</replaceable> argument should be + the name of an updat log file. If no filenames are given, + <command>mysql_find_rows</command> reads the standard input. + </para> + + <para> + Examples: + </para> + +<programlisting> +mysql_find_rows --regexp=problem_table --rows=20 < update.log +mysql_find_rows --regexp=problem_table update-log.1 update-log.2 +</programlisting> + + <para> + <command>mysql_find_rows</command> supports the following + options: + </para> + + <itemizedlist> + + <listitem> + <para> + <indexterm> + <primary>mysql_find_rows</primary> + <secondary>help option</secondary> + </indexterm> + + <indexterm> + <primary>help option</primary> + <secondary>mysql_find_rows</secondary> + </indexterm> + + <option>--help</option>, <option>--Information</option> + </para> + + <para> + Display a help message and exit. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_find_rows</primary> + <secondary>regexp option</secondary> + </indexterm> + + <indexterm> + <primary>regexp option</primary> + <secondary>mysql_find_rows</secondary> + </indexterm> + + <option>--regexp=<replaceable>pattern</replaceable></option> + </para> + + <para> + Display queries that match the pattern. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_find_rows</primary> + <secondary>rows option</secondary> + </indexterm> + + <indexterm> + <primary>rows option</primary> + <secondary>mysql_find_rows</secondary> + </indexterm> + + <option>--rows=<replaceable>N</replaceable></option> + </para> + + <para> + Quit after displaying <replaceable>N</replaceable> + queries. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_find_rows</primary> + <secondary>skip-use-db option</secondary> + </indexterm> + + <indexterm> + <primary>skip-use-db option</primary> + <secondary>mysql_find_rows</secondary> + </indexterm> + + <option>--skip-use-db</option> + </para> + + <para> + Do not include <literal>USE + <replaceable>db_name</replaceable></literal> statements in + the output. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_find_rows</primary> + <secondary>start_row option</secondary> + </indexterm> + + <indexterm> + <primary>start_row option</primary> + <secondary>mysql_find_rows</secondary> + </indexterm> + + <option>--start_row=<replaceable>N</replaceable></option> + </para> + + <para> + Start output from this row. + </para> + </listitem> + + </itemizedlist> + + </refsection> + + </refentry> + + </section> + <section id="fake-id-for-mysql-fix-extensions-manpage-section-wrapper"> <title>fake title for mysql_fix_extensions manpage section wrapper</title> @@ -15679,6 +16273,401 @@ </section> + <section id="fake-id-for-mysql-tableinfo-manpage-section-wrapper"> + + <title>fake title for mysql_tableinfo manpage section wrapper</title> + + <refentry id="mysql-tableinfo"> + + <indexterm> + <primary>mysql_tableinfo</primary> + </indexterm> + + <refmeta> + <refentrytitle><command>mysql_tableinfo</command></refentrytitle> + + <manvolnum>1</manvolnum> + <refmiscinfo class="manual">MySQL Database System</refmiscinfo> + <refmiscinfo class="source">MySQL</refmiscinfo> + <refmiscinfo class="version">¤t-series;</refmiscinfo> + <refmiscinfo class="refman">Generate Database Metadata</refmiscinfo> + </refmeta> + + <refnamediv> + <refname>mysql_tableinfo</refname> + + <refpurpose>generate database metadata</refpurpose> + </refnamediv> + + <refsynopsisdiv> + <cmdsynopsis> + <command>mysql_tableinfo [<replaceable>options</replaceable>] <replaceable>db_name</replaceable> [<replaceable>db_like</replaceable> [<replaceable>tbl_like</replaceable>]]</command> + </cmdsynopsis> + </refsynopsisdiv> + + <refsection id="mysql-tableinfo-description"> + + <title>Description</title> + + <para> + <command>mysql_tableinfo</command> creates tables and + populates them with database metadata. It uses <literal>SHOW + DATABASES</literal>, <literal>SHOW TABLES</literal>, + <literal>SHOW TABLE STATUS</literal>, <literal>SHOW + COLUMNS</literal>, and <literal>SHOW INDEX</literal> to obtain + the metadata. + </para> + + <para> + In MySQL 5.0 and up, the <literal>INFORMATION_SCHEMA</literal> + database contains the same kind of information in the + <literal>SCHEMATA</literal>, <literal>TABLES</literal>, + <literal>COLUMNS</literal>, and <literal>STATISTICS</literal> + tables. See <xref linkend="information-schema"/>. + </para> + + <para> + Invoke <command>mysql_tableinfo</command> like this: + </para> + +<programlisting> +shell> <userinput>mysql_tableinfo [<replaceable>options</replaceable>] <replaceable>db_name</replaceable> [<replaceable>db_like</replaceable> [<replaceable>tbl_like</replaceable>]]</userinput> +</programlisting> + + <para> + The <replaceable>db_name</replaceable> argument indicates + which database <command>mysql_tableinfo</command> should use + as the location for the metadata tables. The database will be + created if it does not exist. The tables will be named + <literal>db</literal>, <literal>tbl</literal> (or + <literal>tbl_status</literal>), <literal>col</literal>, and + <literal>idx</literal>. + </para> + + <para> + If the <replaceable>db_like</replaceable> or + <replaceable>tbl_like</replaceable> arguments are given, they + are used as patterns and metadata is generated only for + databases or tables that match the patterns. These arguments + default to <literal>%</literal> if not given. + </para> + + <para> + Examples: + </para> + +<programlisting> +mysql_tableinfo info +mysql_tableinfo info world +mysql_tableinfo info mydb tmp% +</programlisting> + + <para> + Each of the commands stores information into tables in the + <literal>info</literal> database. The first stores information + for all databases and tables. The second stores information + for all tables in the <literal>world</literal> database. The + third stores information for tables in the + <literal>mydb</literal> database that have names matching the + pattern <literal>tmp%</literal>. + </para> + + <para> + <command>mysql_tableinfo</command> supports the following + options: + </para> + + <itemizedlist> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>help option</secondary> + </indexterm> + + <indexterm> + <primary>help option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--help</option> + </para> + + <para> + Display a help message and exit. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>clear option</secondary> + </indexterm> + + <indexterm> + <primary>clear option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--clear</option> + </para> + + <para> + Before populating each metadata table, drop it if it + exists. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>clear-only option</secondary> + </indexterm> + + <indexterm> + <primary>clear-only option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--clear-only</option> + </para> + + <para> + Similar to <option>--clear</option>, but exits after + dropping the metadata tables to be populated. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>col option</secondary> + </indexterm> + + <indexterm> + <primary>col option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--col</option> + </para> + + <para> + Generate column metadata into the <literal>col</literal> + table. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>host option</secondary> + </indexterm> + + <indexterm> + <primary>host option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--host=<replaceable>host_name</replaceable></option>, + <option>-h <replaceable>host_name</replaceable></option> + </para> + + <para> + Connect to the MySQL server on the given host. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>idx option</secondary> + </indexterm> + + <indexterm> + <primary>idx option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--idx</option> + </para> + + <para> + Generate index metadata into the <literal>idx</literal> + table. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>password option</secondary> + </indexterm> + + <indexterm> + <primary>password option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--password=<replaceable>password</replaceable></option>, + <option>-p<replaceable>password</replaceable></option> + </para> + + <para> + The password to use when connecting to the server. Note + that the password value is not optional for this option, + unlike for other MySQL programs. You can use an option + file to avoid giving the password on the command line. + </para> + + <para> + Specifying a password on the command line should be + considered insecure. See + <xref linkend="password-security"/>. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>port option</secondary> + </indexterm> + + <indexterm> + <primary>port option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--port=<replaceable>port_num</replaceable></option>, + <option>-P <replaceable>port_num</replaceable></option> + </para> + + <para> + The TCP/IP port number to use for the connection. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>prefix option</secondary> + </indexterm> + + <indexterm> + <primary>prefix option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--prefix=<replaceable>prefix_str</replaceable></option> + </para> + + <para> + Add <replaceable>prefix_str</replaceable> at the beginning + of each metadata table name. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>quiet option</secondary> + </indexterm> + + <indexterm> + <primary>quiet option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--quiet</option>, <option>-q</option> + </para> + + <para> + Be silent except for errors. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>socket option</secondary> + </indexterm> + + <indexterm> + <primary>socket option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--socket=<replaceable>path</replaceable></option>, + <option>-S <replaceable>path</replaceable></option> + </para> + + <para> + The Unix socket file to use for the connection. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>tbl-status option</secondary> + </indexterm> + + <indexterm> + <primary>tbl-status option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--tbl-status</option> + </para> + + <para> + Use <literal>SHOW TABLE STATUS</literal> instead of + <literal>SHOW TABLES</literal>. This provides more + complete information, but is slower. + </para> + </listitem> + + <listitem> + <para> + <indexterm> + <primary>mysql_tableinfo</primary> + <secondary>user option</secondary> + </indexterm> + + <indexterm> + <primary>user option</primary> + <secondary>mysql_tableinfo</secondary> + </indexterm> + + <option>--user=<replaceable>user_name</replaceable></option>, + <option>-u <replaceable>user_name</replaceable></option> + </para> + + <para> + The MySQL username to use when connecting to the server. + </para> + </listitem> + + </itemizedlist> + + </refsection> + + </refentry> + + </section> + <section id="fake-id-for-mysql-waitpid-manpage-section-wrapper"> <title>fake title for mysql_waitpid manpage section wrapper</title>
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r6077 - trunk/refman-5.1 | plavin | 23 Apr |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 1.211 sec. using MySQL 5.1.14-beta-log