MySQL Server Administration

1.Server Option and Variable Reference
    1).SHOW [GLOBAL | SESSION] STATUS
    2).Show collation;
    3).show variables like '%...%'
   
2.Server Response to Signals
    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).

3.INFORMATION_SCHEMA Tables
     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.
    
4.MySQL Performance Schema
The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level.