summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorunknown <jcole@tetra.spaceapes.com>2001-09-27 13:27:30 -0500
committerunknown <jcole@tetra.spaceapes.com>2001-09-27 13:27:30 -0500
commitf7ff692468166570a249d67661efffe7065c649b (patch)
tree262260f6c2ea4e9cce8c52a27b7dff2a2579e4f7
parenta353f6249ce88e6b652e3a8b15af4a3f5f96bc72 (diff)
parent1216cfdf65f0f439e73fd5ff840978f34344d5f4 (diff)
downloadmariadb-git-f7ff692468166570a249d67661efffe7065c649b.tar.gz
Merge jcole@work.mysql.com:/home/bk/mysql-4.0
into tetra.spaceapes.com:/home/jcole/bk/mysql-4.0 Docs/manual.texi: Auto merged
-rw-r--r--Docs/manual.texi85
1 files changed, 42 insertions, 43 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index 908230a4745..0d9cc3c156c 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -1,4 +1,4 @@
-input texinfo @c -*-texinfo-*-
+\input texinfo @c -*-texinfo-*-
@c Copyright 1997-2001 TcX AB, Detron HB and MySQL Finland AB
@c
@c *********************************************************
@@ -5079,7 +5079,6 @@ database. @xref{Privileges}.
@item mSQL
Has a file @file{mSQL.acl} in which you can grant read/write privileges for
users.
-@item
@end table
@@ -10408,7 +10407,7 @@ all other cases if the client has TCP/IP installed. The host name specifies
which protocol is used:
@multitable @columnfractions .3 .7
-@strong{Host name} @tab @strong{Protocol}
+@item @strong{Host name} @tab @strong{Protocol}
@item NULL (none) @tab On NT, try named pipes first; if that doesn't work, use TCP/IP. On Win95/Win98, TCP/IP is used.
@item . @tab Named pipes
@item localhost @tab TCP/IP to current host
@@ -11194,6 +11193,7 @@ crash when @code{make} tries to run @code{lint} on C++ files.
* OpenBSD 2.8:: OpenBSD 2.8 Notes
@end menu
+This section contains notes on OpenBSD.
@node OpenBSD 2.5, OpenBSD 2.8, OpenBSD, BSD Notes
@subsubsection OpenBSD 2.5 Notes
@@ -11225,6 +11225,7 @@ usage, and crashes.
* BSDI4:: BSD/OS 4.x notes
@end menu
+This section contains notes on BSD/OS.
@node BSDI2, BSDI3, BSDI, BSD Notes
@subsubsection BSD/OS Version 2.x Notes
@@ -15226,28 +15227,28 @@ servers:
At least the following options should be different per server:
-@table @code
+@itemize
@item port=#
@item socket=path
@item pid-file=path
-@end table
+@end itemize
The following options should be different, if they are used:
-@table @code
+@itemize
@item log=path
@item log-bin=path
@item log-update=path
@item log-isam=path
@item bdb-logdir=path
-@end table
+@end itemize
If you want more performance, you can also specify the following differently:
-@table @code
+@itemize
@item tmpdir=path
@item bdb-tmpdir=path
-@end table
+@end itemize
@xref{Command-line options}.
@@ -18827,11 +18828,11 @@ and the server, because the server does all the work when you use
@code{myisamchk} also has a number of other options you can use to improve
the performance of a table:
-@table @code
+@itemize
@item -S, --sort-index
@item -R index_num, --sort-records=index_num
@item -a, --analyze
-@end table
+@end itemize
For a full description of the option. @xref{myisamchk syntax}.
@@ -18912,7 +18913,7 @@ myisamchk -r --silent --sort-index -O sort_buffer_size=16M */*.MYI
To get a description of a table or statistics about it, use the commands shown
below. We explain some of the information in more detail later:
-@table @code
+@itemize @bullet
@item myisamchk -d tbl_name
Runs @code{myisamchk} in ``describe mode'' to produce a description of
your table. If you start the MySQL server using the
@@ -18931,7 +18932,7 @@ must read the whole table.
@item myisamchk -eiv tbl_name
This is like @code{-eis}, but tells you what is being done.
-@end table
+@end itemize
@cindex examples, @code{myisamchk} output
@cindex @code{myisamchk}, example output
@@ -19077,7 +19078,7 @@ Explanations for the types of information @code{myisamchk} produces are
given below. The ``keyfile'' is the index file. ``Record'' and ``row''
are synonymous:
-@table @code
+@itemize @bullet
@item ISAM file
Name of the ISAM (index) file.
@@ -19137,7 +19138,7 @@ Other possible values are @code{Compressed} and @code{Packed}.
A list of all keys in the table. For each key, some low-level information
is presented:
-@table @code
+@itemize @minus
@item Key
This key's number.
@@ -19171,7 +19172,7 @@ records there are per value for this key. A unique key always has a
value of 1. This may be updated after a table is loaded (or greatly
changed) with @code{myisamchk -a}. If this is not updated at all, a default
value of 30 is given.
-@end table
+@end itemize
@item
In the first example above, the 9th key is a multi-part key with two parts.
@@ -19237,7 +19238,7 @@ the sum of all such losses, in bytes.
When the dynamic table format is used, record fragments are linked with
pointers (4 to 7 bytes each). @code{Linkdata} is the sum of the amount of
storage used by all such pointers.
-@end table
+@end itemize
If a table has been compressed with @code{myisampack}, @code{myisamchk
-d} prints additional information about each table column. See
@@ -19893,7 +19894,7 @@ indicates 16 megabytes. The case of suffix letters does not matter;
@code{16M} and @code{16m} are equivalent:
@cindex variables, values
-@table @code
+@itemize
@item @code{ansi_mode}.
Is @code{ON} if @code{mysqld} was started with @code{--ansi}.
@xref{ANSI mode}.
@@ -20329,7 +20330,7 @@ The version number for the server.
@item @code{wait_timeout}
The number of seconds the server waits for activity on a connection before
closing it. See also @code{interactive_timeout}.
-@end table
+@end itemize
The manual section that describes tuning MySQL contains some
information of how to tune the above variables. @xref{Server parameters}.
@@ -20952,7 +20953,7 @@ Most of the options to @code{safe_mysqld} are the same as the options to
@code{safe_mysqld} supports the following options:
-@table @code
+@itemize
@item --basedir=path
@item --core-file-size=#
Size of the core file @code{mysqld} should be able to create. Passed to @code{ulimit -c}.
@@ -20979,7 +20980,7 @@ Number of files @code{mysqld} should be able to open. Passed to @code{ulimit -n}
@item --timezone=#
Set the timezone (the @code{TZ}) variable to the value of this parameter.
@item --user=#
-@end table
+@end itemize
The @code{safe_mysqld} script is written so that it normally is able to start
a server that was installed from either a source or a binary version of
@@ -21059,7 +21060,7 @@ list. Anything after a white space is ignored.
@code{mysqld_multi} supports the following options:
-@table @code
+@itemize
@cindex config-file option
@item --config-file=...
Alternative config file. NOTE: This will not affect this program's own
@@ -21104,7 +21105,7 @@ MySQL user for @code{mysqladmin}.
@cindex version option
@item --version
Print the version number and exit.
-@end table
+@end itemize
Some notes about @code{mysqld_multi}:
@@ -21277,7 +21278,7 @@ file. It is permissible to omit the @file{.MYI} extension.
@code{myisampack} supports the following options:
-@table @code
+@itemize @bullet
@item -b, --backup
Make a backup of the table as @code{tbl_name.OLD}.
@@ -21331,7 +21332,7 @@ Wait and retry if table is in use. If the @code{mysqld} server was
invoked with the @code{--skip-locking} option, it is not a good idea to
invoke @code{myisampack} if the table might be updated during the
packing process.
-@end table
+@end itemize
@cindex examples, compressed tables
The sequence of commands shown below illustrates a typical table compression
@@ -23923,10 +23924,9 @@ logs. In pre 3.23.26 versions the command was called
is a comma-separated list of @code{master_def} where @code{master_def} is
one of the following: @code{MASTER_HOST}, @code{MASTER_USER},
@code{MASTER_PASSWORD}, @code{MASTER_PORT}, @code{MASTER_CONNECT_RETRY},
-@code{MASTER_LOG_FILE}, @code{MASTER_LOG_POS}. Example:
+@code{MASTER_LOG_FILE}, @code{MASTER_LOG_POS}. For example:
@example
-
CHANGE MASTER TO
MASTER_HOST='master2.mycompany.com',
MASTER_USER='replication',
@@ -23934,7 +23934,6 @@ CHANGE MASTER TO
MASTER_PORT=3306,
MASTER_LOG_FILE='master2-bin.001',
MASTER_LOG_POS=4;
-
@end example
You only need to specify the values that need to be changed. The values that
@@ -24612,7 +24611,7 @@ multi-threaded tests to the benchmark suite.
For example, (run on the same NT 4.0 machine):
@multitable @columnfractions .6 .2 .2
-@strong{Reading 2000000 rows by index} @tab @strong{Seconds} @tab @strong{Seconds}
+@item @strong{Reading 2000000 rows by index} @tab @strong{Seconds} @tab @strong{Seconds}
@item mysql @tab 367 @tab 249
@item mysql_odbc @tab 464
@item db2_odbc @tab 1206
@@ -24624,7 +24623,7 @@ For example, (run on the same NT 4.0 machine):
@end multitable
@multitable @columnfractions .6 .2 .2
-@strong{Inserting (350768) rows} @tab @strong{Seconds} @tab @strong{Seconds}
+@item @strong{Inserting (350768) rows} @tab @strong{Seconds} @tab @strong{Seconds}
@item mysql @tab 381 @tab 206
@item mysql_odbc @tab 619
@item db2_odbc @tab 3460
@@ -41973,12 +41972,12 @@ You need to use the following functions when you want to create a
threaded client. @xref{Threaded clients}.
@menu
-* my_init():: @code{my_init()}
-* mysql_thread_init():: @code{mysql_thread_init()}
-* mysql_thread_end():: @code{mysql_thread_end()}
+* my_init:: @code{my_init()}
+* mysql_thread_init:: @code{mysql_thread_init()}
+* mysql_thread_end:: @code{mysql_thread_end()}
@end menu
-@node my_init(), mysql_thread_init(), C Thread functions, C Thread functions
+@node my_init, mysql_thread_init, C Thread functions, C Thread functions
@subsubsection @code{my_init()}
@findex @code{my_init()}
@@ -41997,7 +41996,7 @@ This is automatically called by @code{mysql_init()},
none.
-@node mysql_thread_init(), mysql_thread_end(), my_init(), C Thread functions
+@node mysql_thread_init, mysql_thread_end, my_init, C Thread functions
@subsubsection @code{mysql_thread_init()}
@findex @code{mysql_thread_init()}
@@ -42013,7 +42012,7 @@ This is automatically called by @code{my_init()} and @code{mysql_connect()}.
none.
-@node mysql_thread_end(), , mysql_thread_init(), C Thread functions
+@node mysql_thread_end, , mysql_thread_init, C Thread functions
@subsubsection @code{mysql_thread_end()}
@findex @code{mysql_thread_end()}
@@ -42043,11 +42042,11 @@ possible to choose between using the embedded MySQL server and
a stand-alone server without modifying any code.
@menu
-* mysql_server_init()::
-* mysql_server_end()::
+* mysql_server_init:: @code{mysql_server_init()}
+* mysql_server_end:: @code{mysql_server_end()}
@end menu
-@node mysql_server_init(), mysql_server_end(), C Embedded Server functions, C Embedded Server functions
+@node mysql_server_init, mysql_server_end, C Embedded Server functions, C Embedded Server functions
@subsubsection @code{mysql_server_init()}
@findex @code{mysql_server_init()}
@@ -42107,7 +42106,7 @@ int main(void) @{
none.
-@node mysql_server_end(), , mysql_server_init(), C Embedded Server functions
+@node mysql_server_end, , mysql_server_init, C Embedded Server functions
@subsubsection @code{mysql_server_end()}
@findex @code{mysql_server_end()}
@@ -46230,7 +46229,7 @@ With source code. By Matthias Fichtner.
A library to use MySQL with Delphi}.
@item @uref{http://www.geocities.com/CapeCanaveral/2064/mysql.html, Delphi TDataset-component}.
-@item
+
@item @uref{http://www.mysql.com/Downloads/Contrib/Win32/SBMySQL50Share.exe, Delphi 5 Shareware MySQL Dataset Components}
@end itemize
@@ -49932,10 +49931,10 @@ Fix storage of floating-point values in @code{TIME} columns.
Changed parsing of @code{TIME} strings to be more strict. Now the
fractional second part is detected (and currently skipped). The
following formats are supported:
-@table @code
+@itemize
@item [[DAYS] [H]H:]MM:]SS[.fraction]
@item [[[[[H]H]H]H]MM]SS[.fraction]
-@end table
+@end itemize
@item
Detect (and ignore) second fraction part from @code{DATETIME}.
@item