Server Command Options Variable Name Variable Type Variable Scope Threads_connected Integer Global Threads_created Integer Global Threads_running Integer Global Uptime Integer Global Uptime_since_flush_status Integer Global validate_password_dictionary_file_last_parsed Datetime Global validate_password_dictionary_file_words_count Integer Global validate_password.dictionary_file_last_parsed Datetime Global validate_password.dictionary_file_words_count Integer Global 5.1.7 Server Command Options 732 Some options control the size of buffers or caches. For a given buffer, the server might need to allocate internal data structures. These structures typically are allocated from the total memory allocated to the The following list shows some of the most common server options. Additional options are described in other sections: Some of the items in the list are actually system variables that can be set at server startup. These can be displayed at runtime using the  SHOW VARIABLES  statement. Some items displayed by the preceding mysqld  command do not appear in  SHOW VARIABLES  output; this is because they are options only and not system variables. When you start the  mysqld  server, you can specify program options using any of the methods described in Section 4.2.2, “Specifying Program Options” . The most common methods are to provide options in an option file or on the command line. However, in most cases it is desirable to make sure that the server uses the same options each time it runs. The best way to ensure this is to list them in an option file. See Section 4.2.2.2, “Using Option Files” . That section also describes option file format and syntax. mysqld  reads options from the  [mysqld]  and  [server]  groups.  mysqld_safe  reads options from the [mysqld] ,  [server] ,  [mysqld_safe] , and  [safe_mysqld]  groups.  mysql.server  reads options from the  [mysqld]  and  [mysql.server]  groups. mysqld  accepts many command options. For a brief summary, execute this command: To see the full list, use this command: •Options that affect security: See Section 6.1.4, “Security-Related mysqld Options and Variables” . •SSL-related options: See Command Options for Encrypted Connections. •Binary log control options: See Section 5.4.4, “The Binary Log” . •Replication-related options: See Section 17.1.6, “Replication and Binary Logging Options and Variables” . •Options for loading plugins such as pluggable storage engines: See Section 5.6.1, “Installing and Uninstalling Plugins” . •Options specific to particular storage engines: See Section 15.14, “InnoDB Startup Options and System Variables”  and Section 16.2.1, “MyISAM Startup Options” . mysqld --help mysqld --verbose --help