Author: mcbrown
Date: 2010-08-04 17:52:15 +0200 (Wed, 04 Aug 2010)
New Revision: 22070
Log:
More updates on installation and related notes
Modified:
trunk/refman-5.1/extending-mysql.xml
trunk/refman-5.1/installing-bsd.xml
trunk/refman-5.1/installing-generic-binary.xml
trunk/refman-5.1/installing-postinstall.xml
trunk/refman-5.1/installing-windows.xml
trunk/refman-5.1/programs-installation.xml
trunk/refman-5.5/installing-core.xml
trunk/refman-5.5/programs-installation.xml
Modified: trunk/refman-5.1/extending-mysql.xml
===================================================================
--- trunk/refman-5.1/extending-mysql.xml 2010-08-04 14:57:06 UTC (rev 22069)
+++ trunk/refman-5.1/extending-mysql.xml 2010-08-04 15:52:15 UTC (rev 22070)
Changed blocks: 1, Lines Added: 9, Lines Deleted: 0; 932 bytes
@@ -5225,6 +5225,15 @@
</para>
<para>
+ Binary distributions of MySQL server from Oracle include a
+ specific debug binary, <filename>mysqld-debug</filename>. This
+ is a build including the debugging information and is built in
+ the same way as the debug build format described in
+ <xref linkend="compiling-for-debuggin"/>. You should use this
+ build when debugging the MySQL server.
+ </para>
+
+ <para>
If <command>mysqld</command> doesn't want to start, you should
verify that you don't have any <filename>my.cnf</filename> files
that interfere with your setup! You can check your
Modified: trunk/refman-5.1/installing-bsd.xml
===================================================================
--- trunk/refman-5.1/installing-bsd.xml 2010-08-04 14:57:06 UTC (rev 22069)
+++ trunk/refman-5.1/installing-bsd.xml 2010-08-04 15:52:15 UTC (rev 22070)
Changed blocks: 1, Lines Added: 0, Lines Deleted: 35; 1946 bytes
@@ -83,41 +83,6 @@
</programlisting>
<para>
- FreeBSD is known to have a very low default file handle limit. See
- <xref linkend="not-enough-file-handles"/>. Start the server by using
- the <option role="mysqld_safe">--open-files-limit</option> option
- for <command>mysqld_safe</command>, or raise the limits for the
- <command>mysqld</command> user in
- <filename>/etc/login.conf</filename> and rebuild it with
- <literal>cap_mkdb /etc/login.conf</literal>. Also be sure that you
- set the appropriate class for this user in the password file if you
- are not using the default (use <literal>chpass
- mysqld-user-name</literal>). See <xref linkend="mysqld-safe"/>.
- </para>
-
- <para>
- In current versions of FreeBSD (at least 4.x and greater), you may
- increase the limit on the amount of memory available for a process
- by adding the following entries to the
- <filename>/boot/loader.conf</filename> file and rebooting the
- machine (these are not settings that can be changed at run time with
- the <command>sysctl</command> command):
- </para>
-
-<programlisting>
-kern.maxdsiz="1073741824" # 1GB
-kern.dfldsiz="1073741824" # 1GB
-kern.maxssiz="134217728" # 128MB
-</programlisting>
-
- <para>
- For older versions of FreeBSD, you must recompile your kernel to
- change the maximum data segment size for a process. In this case,
- you should look at the <literal>MAXDSIZ</literal> option in the
- <literal>LINT</literal> config file for more information.
- </para>
-
- <para>
If you get problems with the current date in MySQL, setting the
<literal>TZ</literal> variable should help. See
<xref linkend="environment-variables"/>.
Modified: trunk/refman-5.1/installing-generic-binary.xml
===================================================================
--- trunk/refman-5.1/installing-generic-binary.xml 2010-08-04 14:57:06 UTC (rev 22069)
+++ trunk/refman-5.1/installing-generic-binary.xml 2010-08-04 15:52:15 UTC (rev 22070)
Changed blocks: 5, Lines Added: 32, Lines Deleted: 6; 3767 bytes
@@ -40,13 +40,15 @@
</para>
<para>
- If you want to compile a debug version of MySQL from a source
- distribution, you should add
+ Debug versions of the <command>mysqld</command> binary are available
+ as <command>mysqld-debug</command>. If you would like to compile a
+ debug version of MySQL from a source distribution, you should add
<option role="configure">--with-debug</option> or
<option role="configure">--with-debug=full</option> to the
<command>configure</command> command used to configure the
distribution and remove any <option>-fomit-frame-pointer</option>
- options.
+ options. For more information on compiling from source, see
+ <xref linkend="installing-source"/>.
</para>
<para>
@@ -161,7 +163,7 @@
<programlisting>
shell> <userinput>groupadd mysql</userinput>
-shell> <userinput>useradd -g mysql mysql</userinput>
+shell> <userinput>useradd -r -g mysql mysql</userinput>
shell> <userinput>cd /usr/local</userinput>
shell> <userinput>gunzip < <replaceable>/path/to/mysql-VERSION-OS</replaceable>.tar.gz | tar xvf -</userinput>
shell> <userinput>ln -s <replaceable>full-path-to-mysql-VERSION-OS</replaceable> mysql</userinput>
@@ -171,7 +173,9 @@
shell> <userinput>scripts/mysql_install_db --user=mysql</userinput>
shell> <userinput>chown -R root .</userinput>
shell> <userinput>chown -R mysql data</userinput>
+shell> <userinput>cp /usr/local/mysql/support-files/my-<replaceable>small</replaceable>/etc/my.cnf # Optional</userinput>
shell> <userinput>bin/mysqld_safe --user=mysql &</userinput>
+shell> <userinput>cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql.server # Optional</userinput>
</programlisting>
<note>
@@ -206,14 +210,16 @@
<programlisting>
shell> <userinput>groupadd mysql</userinput>
-shell> <userinput>useradd -g mysql mysql</userinput>
+shell> <userinput>useradd -r -g mysql mysql</userinput>
</programlisting>
<note>
<para>
The above will create a user that has login permissions to
your server. You may wish to disable the account, as the user
- is only required for ownership, not login, purposes.
+ is only required for ownership, not login, purposes. You can
+ do this on Linux by using the <option>-r</option> command-line
+ option.
</para>
</note>
@@ -409,6 +415,26 @@
<listitem>
<para>
+ You may want to optionally copy one of the provided
+ configuration files from the <filename>support-files</filename>
+ directory into your <filename>/etc/</filename> directory. There
+ are different sample configuration files for different use
+ cases, server types, and CPU and RAM configurations. If you want
+ to use one of these standard files, you should copy it to
+ <filename>/etc/my.cnf</filename>, or
+ <filename>/etc/mysql/my.cnf</filename> and edit and check the
+ configuration before starting your MySQL server for the first
+ time.
+ </para>
+
+ <para>
+ If you do not copy one of the standard configuration files, the
+ MySQL server will be started with the default settings.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
If the plugin directory is writable by the server, it may be
possible for a user to write executable code to a file in the
directory using <literal role="stmt" condition="select">SELECT
Modified: trunk/refman-5.1/installing-postinstall.xml
===================================================================
--- trunk/refman-5.1/installing-postinstall.xml 2010-08-04 14:57:06 UTC (rev 22069)
+++ trunk/refman-5.1/installing-postinstall.xml 2010-08-04 15:52:15 UTC (rev 22070)
Changed blocks: 1, Lines Added: 4, Lines Deleted: 2; 1002 bytes
@@ -913,8 +913,10 @@
<para>
Invoke <command>mysql.server</command>. This script is used
primarily at system startup and shutdown on systems that use
- System V-style run directories, where it usually is
- installed under the name <literal>mysql</literal>. The
+ System V-style run directories (i.e.
+ <filename>/etc/init.d</filename> and run-level specific
+ directories), where it usually is installed under the name
+ <literal>mysql</literal>. The
<command>mysql.server</command> script starts the server by
invoking <command>mysqld_safe</command>. See
<xref linkend="mysql-server"/>.
Modified: trunk/refman-5.1/installing-windows.xml
===================================================================
--- trunk/refman-5.1/installing-windows.xml 2010-08-04 14:57:06 UTC (rev 22069)
+++ trunk/refman-5.1/installing-windows.xml 2010-08-04 15:52:15 UTC (rev 22070)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 0; 1003 bytes
@@ -4165,6 +4165,19 @@
binary and ensure that this binary is accessible from Visual
Studio.
</para>
+
+ <note>
+ <para>
+ The default location for the Windows version of
+ <command>bison</command> installs into the
+ <filename>C:\Program Files\GnuWin32</filename>. Some
+ utilities, including <command>m4</command>, may fail to find
+ <command>bison</command> because of the space in the
+ directory name. You can resolve this by installing into a
+ directory that does not contain a space; for example
+ <filename>C:\GnuWin32</filename>.
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-5.1/programs-installation.xml
===================================================================
--- trunk/refman-5.1/programs-installation.xml 2010-08-04 14:57:06 UTC (rev 22069)
+++ trunk/refman-5.1/programs-installation.xml 2010-08-04 15:52:15 UTC (rev 22070)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 0; 1024 bytes
@@ -863,6 +863,18 @@
<command>mysql_install_db</command> will use that server.
</para>
+ <note>
+ <para>
+ If you have set a custom <literal>TMPDIR</literal> variable
+ when performing the installation, and the specified directory
+ is not accessible, the execution of
+ <command>mysql_install_db</command> may fail. You should unset
+ <literal>TMPDIR</literal>, or set <literal>TMPDIR</literal> to
+ point to the system temporary directory (usually
+ <filename>/tmp</filename>).
+ </para>
+ </note>
+
<para>
<command>mysql_install_db</command> supports the following
options, which can be specified on the command line or in the
Modified: trunk/refman-5.5/installing-core.xml
===================================================================
--- trunk/refman-5.5/installing-core.xml 2010-08-04 14:57:06 UTC (rev 22069)
+++ trunk/refman-5.5/installing-core.xml 2010-08-04 15:52:15 UTC (rev 22070)
Changed blocks: 1, Lines Added: 13, Lines Deleted: 0; 1028 bytes
@@ -9357,6 +9357,19 @@
binary and ensure that this binary is accessible from Visual
Studio.
</para>
+
+ <note>
+ <para>
+ The default location for the Windows version of
+ <command>bison</command> installs into the
+ <filename>C:\Program Files\GnuWin32</filename>. Some
+ utilities, including <command>m4</command>, may fail to
+ find <command>bison</command> because of the space in the
+ directory name. You can resolve this by installing into a
+ directory that does not contain a space; for example
+ <filename>C:\GnuWin32</filename>.
+ </para>
+ </note>
</listitem>
<listitem>
Modified: trunk/refman-5.5/programs-installation.xml
===================================================================
--- trunk/refman-5.5/programs-installation.xml 2010-08-04 14:57:06 UTC (rev 22069)
+++ trunk/refman-5.5/programs-installation.xml 2010-08-04 15:52:15 UTC (rev 22070)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 0; 1024 bytes
@@ -710,6 +710,18 @@
<command>mysql_install_db</command> will use that server.
</para>
+ <note>
+ <para>
+ If you have set a custom <literal>TMPDIR</literal> variable
+ when performing the installation, and the specified directory
+ is not accessible, the execution of
+ <command>mysql_install_db</command> may fail. You should unset
+ <literal>TMPDIR</literal>, or set <literal>TMPDIR</literal> to
+ point to the system temporary directory (usually
+ <filename>/tmp</filename>).
+ </para>
+ </note>
+
<para>
<command>mysql_install_db</command> supports the following
options, which can be specified on the command line or in the
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r22070 - in trunk: refman-5.1 refman-5.5 | mc.brown | 4 Aug |
