Learning Mysql

060514 12:39:11 ERROR /usr/local/mysql/bin/mysqld: Disk is full writing '/usr/local/mysql/data/Moodle/mdl_user.MYI' (Errcode: Waiting for someone to free space. Retry in 60 secs log-slow-queries
This tells mysqld to log queries that take an unusually longtime 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 .pid (for Linux systems) or
.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 Xor 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 whereto 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

Download 4.24 Mb.

Share with your friends: