Oracle 5.0, Справочное руководство

Страница: 561 / 3232

Server-Side Help
541
5.1.8. Server-Side Help
MySQL Server supports a
HELP
statement that returns online information from the MySQL Reference
manual (see Section 13.8.3, “
HELP
Syntax” ). The proper operation of this statement requires that
the help tables in the
mysql
database be initialized with help topic information, which is done by
processing the contents of the
fill_help_tables.sql
script.
If you install MySQL using a binary or source distribution on Unix, help table setup occurs when you
run
mysql_install_db
. For an RPM distribution on Linux or binary distribution on Windows, help
table setup occurs as part of the MySQL installation process.
If you upgrade MySQL using a binary distribution, the help tables are not upgraded automatically, but
you can upgrade them manually. Locate the
fill_help_tables.sql
file in the
share
or
share/
mysql
directory. Change location into that directory and process the file with the
mysql
client as
follows:
shell> mysql -u root mysql < fill_help_tables.sql
You can also obtain the latest
fill_help_tables.sql
at any time to upgrade your help tables.
Download the proper file for your version of MySQL from http://dev.mysql.com/doc/index-other.html .
After downloading and uncompressing the file, process it with
mysql
as described previously.
If you are working with Bazaar and a MySQL development source tree, you will need to download the
fill_help_tables.sql
file because the tree contains only a “stub” version.
5.1.9. Server Response to Signals
On Unix, signals can be sent to processes.
mysqld
responds to signals sent to it as follows:
•
SIGTERM
causes the server to shut down.
•
SIGHUP
causes the server to reload the grant tables and flush the logs (like
FLUSH PRIVILEGES
and
FLUSH LOGS
). It also writes a status report to the error log that has this format:
Status information:
Current dir: /var/mysql/data/
Running threads: 0 Stack size: 196608
Current locks:
Key caches:
default
Buffer_size: 8388600
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 0
not flushed: 0
w_requests: 0
writes: 0
r_requests: 0
reads: 0
handler status:
read_key: 0
read_next: 0
read_rnd 0
read_first: 1
write: 0
delete 0
update: 0
Table status:
Opened tables: 5
Open tables: 0
Open files: 7