Unix Postinstallation Procedures
136
Script
Option Groups
mysql.server
[mysqld]
,
[mysql.server]
,
[server]
[mysqld-major_version]
means that groups with names like
[mysqld-4.1]
and
[mysqld-5.0]
are read by servers having versions 4.1.x, 5.0.x, and so forth. This feature can be
used to specify options that can be read only by servers within a given release series.
For backward compatibility,
mysql.server
also reads the
[mysql_server]
group and
mysqld_safe
also reads the
[safe_mysqld]
group. However, you should update your option files to
use the
[mysql.server]
and
[mysqld_safe]
groups instead when using MySQL 5.0.
For more information on MySQL configuration files and their structure and contents, see
Section 4.2.3.3, “Using Option Files”
.
2.18.1.3. Starting and Troubleshooting the MySQL Server
This section provides troubleshooting suggestions for problems starting the server on Unix. If you are
using Windows, see
Section 2.10.5, “Troubleshooting a MySQL Installation Under Windows”
.
If you have problems starting the server, here are some things to try:
• Check the error log to see why the server does not start.
• Specify any special options needed by the storage engines you are using.
• Make sure that the server knows where to find the data directory.
• Make sure that the server can access the data directory. The ownership and permissions of the data
directory and its contents must be set such that the server can read and modify them.
• Verify that the network interfaces the server wants to use are available.
Some storage engines have options that control their behavior. You can create a
my.cnf
file and
specify startup options for the engines that you plan to use. If you are going to use storage engines that
support transactional tables (
InnoDB
,
BDB
,
NDB
), be sure that you have them configured the way you
want before starting the server:
• If you are using
InnoDB
tables, see
Section 14.2.1, “
InnoDB
Configuration”
.
• If you are using
BDB
(Berkeley DB) tables, see
Section 14.5.3, “
BDB
Startup Options”
.
• If you are using MySQL Cluster, see
Section 17.3, “MySQL Cluster Configuration”
.
Storage engines will use default option values if you specify none, but it is recommended that you
review the available options and specify explicit values for those for which the defaults are not
appropriate for your installation.
When the
mysqld
server starts, it changes location to the data directory. This is where it expects to
find databases and where it expects to write log files. The server also writes the pid (process ID) file in
the data directory.
The data directory location is hardwired in when the server is compiled. This is where the server looks
for the data directory by default. If the data directory is located somewhere else on your system, the
server will not work properly. You can determine what the default path settings are by invoking
mysqld
with the
--verbose
[425]
and
--help
[400]
options.
If the default locations do not match the MySQL installation layout on your system, you can override
them by specifying options to
mysqld
or
mysqld_safe
on the command line or in an option file.
To specify the location of the data directory explicitly, use the
--datadir
[404]
option. However,
normally you can tell
mysqld
the location of the base directory under which MySQL is installed and it
looks for the data directory there. You can do this with the
--basedir
[401]
option.
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...