MySQL Server Administration

[size=medium]
[b]1.Server Option and Variable Reference[/b]
1).SHOW [GLOBAL | SESSION] STATUS
2).Show collation;
3).show variables like '%...%'

[b]2.Server Response to Signals[/b]
a).SIGTERM causes the server to shut down.
b).SIGHUP causes the server to reload the grant tables and flush the logs (like FLUSH PRIVILEGES and FLUSH LOGS).

[b]3.INFORMATION_SCHEMA Tables[/b]
INFORMATION_SCHEMA provides access to database metadata.
Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are used for this information are data dictionary and system catalog.
INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables. They are actually views, not base tables, so there are no files associated with them.

[b]4.MySQL Performance Schema[/b]
The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level.

[/size]