Internet Express for Tru64 UNIX Version 6.10 Administration Guide (5900-1418, March 2011)

Starting and Stopping the MySQL Server Using a Command Line
Internet Express provides a startup script for MySQL in /sbin/init.d/mysql.
Use the following command to start MySQL on the command line:
# /sbin/init.d/mysql start
Use the following command to stop MySQL on the command line:
# /sbin/init.d/mysql stop
MySQL Configuration Files
The file /etc/my.cnf stores default startup options for both the server and for clients. To ensure
the proper configuration of this file, the MySQL developers have included four sample my.cnf files
within the distribution:
• my-huge.cnf.sh
• my-large.cnf.sh
• my-medium.cnf.sh
• my-small.cnf.sh
Each of these files denotes recommended configuration settings in accordance with system resource
availability.
These files are available under /usr/local/mysql/share/mysql.
MySQL Log Files
The MySQL log files are created under /usr/local/mysql/logs.
The error log file indicates when mysqld was started and stopped and also any critical errors that
occur while the server is running. If mysqld notices a table that needs to be automatically checked
or repaired, it writes a message to the error log.
The general log is a general record of actions taken by mysqld. The server writes information to
this log when clients connect or disconnect, and it logs each SQL statement received from clients.
The general log can be useful when you suspect an error in a client and want to know exactly
what the client sent to mysqld.
Viewing the MySQL Error Log
View the contents of the MySQL error log from the Administration Utility, as follows:
1. From the Manage Components menu, choose MYSQL Database Management System. The
Manage MYSQL menu is displayed .
2. On the Manage MYSQL menu, choose View MYSQL Error Log. The contents of the log file
are displayed. Use the standard navigation features to advance page by page, go to a specific
page, or search for a particular text string.
Viewing the MySQL General Log
View the contents of the MySQL error log from the Administration Utility, as follows:
1. From the Manage Components menu, choose MYSQL Database Management System. The
Manage MYSQL menu is displayed .
2. On the Manage MYSQL menu, choose View MYSQL General Log. The contents of the log file
are displayed. Use the standard navigation features to advance page by page, go to a specific
page, or search for a particular text string.
Administering MySQL 259