MySQL server parameter description and view setting method

View parameters: SHOW VARIABLES

Set parameter: SET GLOBAL parameter name = value;. For example, set the maximum number of database connections to: SET GLOBAL max_connections=1000.

You can get a table of all mysql options and configurable variables with the command shell > mysqld-help. Output the following information:

Possible variables for option--set-variable (- o) are:

Back_log current value:5 / / the number of connections that mysql can have. Back _ log indicates how many connection requests can be stored in the stack during the time mysql pauses to accept connections.

The time the connect_timeout current value:5 / / mysql server waits for a connection before replying with bad handshake

Delayed_insert_timeout current value:200 / / the time an insert delayed waits for insert before terminating

The delayed_insert_limit current value:50 / / insert delayed processor will check to see if any select statements are not executed, and if so, execute them before continuing

Delayed_queue_size current value:1000 / / how big a team is assigned to insert delayed

Flush_time current value:0 / / if it is set to non-0, then every flush_time time, all tables are closed

The time that the interactive_timeout current value:28800 / / server waits on the foreign interactive connection before shutting it down

Join_buffer_size current value:131072 / / use the size of the buffer connected to all

Key_buffer_size current value:1048540 / / the buffer size of the index block, which can be increased to better handle the index.

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 / / the size of a packet

Max_connections current value:300 / / number of simultaneous connections allowed

Max_connect_errors current value:10 / / if there are more than this number of broken connections, further connections will be blocked and can be resolved with flush hosts

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 be read

Max_sort_length current value:1024 / / the number of bytes used when sorting blob or text

Max_tmp_tables current value:32 / / the number of temporary tables with a connection open at the same time

Max_write_lock_count current value:4294967295 / / specifies a value (usually very small) to start mysqld, resulting in a read lock after a certain number of write locks

The size of the net_buffer_length current value:16384 / / communication buffer, which is reset when queried

Query_buffer_size current value:0 / / buffer size when querying

Record_buffer current value:131072 / / the size of the buffer allocated for each table scanned by each sequentially scanned connection

Sort_buffer current value:2097116 / / the size of the buffer allocated per sorted connection

Table_cache current value:64 / / the number of tables opened for all connections

Thread_concurrency current value:10 / /

Size of tmp_table_size current value:1048576 / / temporary table

Thread_stack current value:131072 / / size of each thread

The amount of time the wait_timeout current value:28800 / / server waits on a connection before closing it 3