MySQL Server parameter description and view Setup method _mysql

View parameters: Show VARIABLES;
Set parameters: Set global parameter name =value, such as setting the maximum number of database connections to: Set global max_connections=1000.

Use the Shell>mysqld-help command to get a table of all MySQL options and configurable variables. Output The following information:
Possible variables for option--set-variable (-O) are:
Back_log current Value:5//requires the number of connections that MySQL can have. Back_log indicates how many connection requests can be in the stack when MySQL pauses to accept connections
Connect_timeout current Value:5//mysql server waits for a connection before it is answered with bad handshake (poor translation)
Delayed_insert_timeout current value:200//An insert delayed waits for an insert before terminating
Delayed_insert_limit current VALUE:50//insert delayed processor will check that any SELECT statements are not executed and, if so, execute them before continuing
Delayed_queue_size current value:1000//How many teams are allocated for insert delayed
Flush_time Current value:0//If set to non 0, then every flush_time time, all tables are closed
Interactive_timeout current value:28800//server wait time on Ocean Interactive connection before closing it
Join_buffer_size current value:131072//buffer size with all connections
Key_buffer_size current value:1048540//term the size of the buffer of the index block, increasing it to handle the index better
Lower_case_table_names Current value:0//
Long_query_time Current Value:10//If a query takes longer than this time, the slow_queried count will increase
Max_allowed_packet current value:1048576//size of a package
Max_connections current value:300//number of simultaneous connections allowed
Max_connect_errors Current VALUE:10//If there are more than this number of interrupt connections, will block further connections, you can use the flush hosts to resolve
Max_delayed_threads current VALUE:15//The number of processing insert delayed that can be started
Max_heap_table_size Current value:16777216//
Max_join_size current value:4294967295//number of connections allowed to read
Max_sort_length current value:1024//number of bytes used in the sort blob or text
Max_tmp_tables current VALUE:32//number of temporary tables open at the same time for a connection
Max_write_lock_count current value:4294967295//Specify a value (usually very small) to start the mysqld so that a read lock appears after a certain number of write locks
Net_buffer_length current value:16384//communication buffer size-reset to that size at query time
Query_buffer_size current value:0//query-time buffer size
Record_buffer current value:131072//the size of the buffer allocated for each table scanned by the connection for each sequential scan
Sort_buffer current value:2097116//the size of the buffer allocated for each of the sorted connections
Table_cache current value:64//number of tables opened for all connections
Thread_concurrency Current Value:10//
Tmp_table_size current value:1048576//Temp Table size
Thread_stack current value:131072//size of each thread
Wait_timeout current value:28800//server waits on a connection before it closes 3