Configuring and Tuning the Server - Learning MySQL - page 381

060514 12:39:11 [ERROR] /usr/local/mysql/bin/mysqld: Disk is full writing
'/usr/local/mysql/data/Moodle/mdl_user.MYI' (Errcode: 49).
Waiting for someone to free space... Retry in 60 secs
log-slow-queries
This tells mysqld to log queries that take an unusually long time to process. You
can use this information together with the EXPLAIN command to determine how
best to tune the server or optimize the tables. Queries that take a time longer than
the value of the long_query_time server variable are logged.
pid-file
For servers running on Linux and Mac OS X, this tells mysqld to save its process
ID to the specified file; by default, this is <hostname>.pid (for Linux systems) or
<hostname>.local.pid (for Mac OS X systems) and located in the MySQL data
directory.
port
This is the port the MySQL server should listen to for incoming connections. The
default MySQL port is 3306. If there's already a server listening on that port, you'll
need to specify a different port. We described how to do this in Chapter 2. On a
Linux or Mac OS X system, connections from a client on the same system go
through a Unix socket file rather than through this TCP port.
shared-memory-base-name
For servers running on Windows, this tells mysqld to use the specified shared
memory name. The default value is MYSQL . If you want to run multiple MySQL
servers on a single Windows host, you'll need to specify a different value for each
server.
skip-networking
With this option, you can ask the server to not listen to a TCP port for incoming
connections. This is more secure, as only connections from clients on the same
system as the server ( localhost ) will be accepted. On a Linux or Mac OS X system,
clients connect through the Unix socket file (described next). Under Windows,
clients need to connect through a named pipe, so you'll need to set the enable-
named-pipe option for this to work.
socket
The absolute path to the Unix socket file on Linux and Mac OS X, or the named
pipe under Windows, that the server uses for incoming connections from the local
host. The default path is /tmp/mysql.sock for the Unix socket, and MYSQL for the
Windows named pipe. You generally need to specify a different value only if there's
already a server using the default socket.
tmpdir
This tells mysqld where to store its temporary files.
user
On Linux and Mac OS X, the server tries to run under your account; if you start
the server from the root account, the server will run with all the privileges of this