MySQL parameter description

Source: Internet
Author: User

Guidance:
1. back_log
Specify the number of possible MySQL connections. When the MySQL main thread receives many connection requests in a short time, this parameter takes effect. Then the main thread takes some time (although very short) to check the connection and start a new thread.
The value of the back_log parameter indicates how many requests can be stored in the stack within a short time before MySQL temporarily stops responding to a new request. If the system has many connections in a short period of time, you need to increase the value of this parameter, which specifies the size of the listener queue for the incoming TCP/IP connection. Different operating systems have their own limits on the queue size. Trying to set back_log to be higher than your operating system limit will be invalid.
When you observe the MySQL process list, you will find a large number of 264084 | unauthenticated users | XXX. xxx. xxx. xxx | null | connect | null | login | when a null process is to be connected, increase the value of back_log. The default value of back_log is 50.
2. basedir
The path of the MySQL main program, that is, the value of the -- basedir parameter.
3. bdb_cache_size
The size of the cache index and row arrangement buffer allocated to the bdb type data table. If the DBD type data table is not used, the -- skip-bdb parameter should be loaded when MySQL is started to avoid Memory waste.
4. bdb_log_buffer_size
The cache index and row arrangement buffer size allocated to the bdb type data table. If the DBD type data table is not used, set this parameter to 0, or load the -- skip-bdb parameter when starting MySQL to avoid Memory waste.
5. bdb_home
See the -- bdb-home option.
6. bdb_max_lock
Specifies the maximum number of lock table processes (10000 by default). This parameter can be used if a data table of the bdb type is used. If the bdb: Lock table is out of available locks or got error 12 from... error is found during execution of large transaction processing or query, the value of this parameter should be increased.
7. bdb_logdir
Specifies the location where logs are stored when a bdb data table is used to provide services. That is, the value of -- bdb-logdir.
8. bdb_shared_data
If the -- bdb-shared-data option is used, the value of this parameter is on.
9. bdb_tmpdir
Temporary File directory of the bdb type data table. That is, the value of -- bdb-tmpdir.
10. binlog_cache_size
Specify the cache size used by SQL query statements during query request processing for Binary logs. If it is frequently used for processing a large number of complex SQL expressions, you should increase the value of this parameter to improve performance.
11. bulk_insert_buffer_size
Specify that the MyISAM data table uses a special tree structure for caching. The whole bulk can accelerate the insert operation (insert... select, insert... values (...), (...),..., and load data infile. This parameter limits the cache size of the tree structure used by each thread. If it is set to 0, the cache acceleration function is disabled. Note: The cache operation corresponding to this parameter can only be performed by users into non-empty data tables! The default value is 8 Mb.
12. character_set
The default Character Set of MySQL.
13. character_sets
The character set that MySQL can provide.
14. concurrent_inserts
If this parameter is enabled, MySQL allows the insert operation while executing the Select Operation. If you want to disable this parameter, you can load the -- safe option when starting mysqld, or use the -- skip-new option. The default value is on.
15. connect_timeout
Specify the maximum number of seconds for the MySQL service to wait for a response to a connection message. After this time, MySQL returns bad handshake to the client.
16. datadir
Specifies the database path. That is, the value of the -- datadir option.
17. delay_key_write
This parameter is only valid for MyISAM data tables. There are the following types of values:
Off: If the create table... delayed_key_writes statement is used in the table creation statement, all
Delayed_key_writes;
On: If you use create table... delayed_key_writes In the table creation statement, use this option (default );
ALL: All open data tables are processed according to delayed_key_writes.
If delayed_key_writes is enabled
The key buffer of the data table of the delayed_key_writes option, unless the data table is closed. This parameter greatly increases the speed of writing key values.
Degree. If this parameter is used, check all data tables: myisamchk -- fast -- force.
18. delayed_insert_limit
After the delayed_insert_limit row is inserted, the insert delayed processing Module checks whether there are unexecuted select statements. If yes, execute these statements before proceeding.
19. delayed_insert_timeout
The time for an insert delayed thread to wait for the insert statement before termination.
20. delayed_queue_size
The size of the queue allocated for processing insert delayed (in the unit of action ). If the queue is full, any insert delayed user must wait for the queue space to be released before continuing.
21. Flush
Load the -- flush parameter when MySQL is started to enable this function.
22. flush_time
If this parameter is set to a non-zero value, all opened tables are shut down every flush_time second to release resources and sync to the disk. Note: this parameter is recommended only when Windows9x/me is used or the current operating system resources are seriously insufficient!
23. ft_boolean_syntax
The search engine maintainer wants to change the operators allowed for logical full-text search. These are controlled by the ft_boolean_syntax variable.
24. ft_min_word_len
Specify the minimum length of the indexed keyword. Note: after this parameter value is changed, the index must be rebuilt!
25. ft_max_word_len
Specifies the maximum length of the indexed keyword. Note: after this parameter value is changed, the index must be rebuilt!
26. ft_max_word_len_for_sort
Specify the maximum length of keywords that can be used in the process of rapid full-text index reconstruction using repair, create index, or alter table. Keywords that exceed the length limit will be inserted at low speed. Increase the value of this parameter, MySQL will create a larger temporary file (this will reduce the CPU load, but the efficiency will depend on the disk I/O efficiency ), and put less key values in the memory in a sort.
27. ft_stopword_file
Read the list from the file specified by the ft_stopword_file variable. After the stopword list is modified, the Fulltext index must be rebuilt.
28. have_innodb
Yes: MySQL supports InnoDB data tables; Disable: Use -- skip-InnoDB to disable InnoDB data tables.
29. have_bdb
Yes: MySQL supports Berkeley data tables; Disable: Use -- skip-bdb to disable support for Berkeley data tables.
30. have_raid
Yes: Enable MySQL to support raid.
31. have_openssl
Yes: enables MySQL to support the SSL encryption protocol.
32. init_file
Specify a file containing an SQL query statement. The file will be loaded when MySQL is started, and the SQL statement in the file will also be executed.
33. interactive_timeout
The number of seconds that the server waits for action on an interactive connection before closing it. An interactive customer is defined as a customer who uses the client_interactive option for mysql_real_connect. Wait_timeout is also visible.
34. join_buffer_size
The buffer size used for all join operations (not the join operation using indexes ). The buffer zone allocates a buffer for each join between two tables. When an index is increased, increasing this value will allow you to get a faster join. (The best way to get a quick join is to increase the index .)
35. key_buffer_size
The buffer size used for index blocks, increasing the size of indexes (for all reads and writes) that can be better processed, so that you can afford that much. If you make it too large, the system will start to grow slowly. You must leave some space for the OS file system cache. To get more speed when writing multiple rows.
36. Language
The language in which the user outputs the error message.
37. large_file_support
Enable support for large files.
38. locked_in_memory
Use -- memlock to lock mysqld in the memory.
39. Log
Record all query operations.
40. log_update
Enable Update log.
41. log_bin
Enable binary log.
42. log_slave_updates
This parameter must be enabled if chainchain synchronization or synchronization between multiple slave instances is used.
43. long_query_time
If the time used by a query exceeds the value of this parameter, the query operation is recorded in slow_queries.
44. lower_case_table_names
1: MySQL uses lowercase letters for SQL operations;
0: disable this function.
Note: If this parameter is used, all data tables should be converted to lowercase letters before enabling.
45. max_allowed_packet
The maximum size of a query statement package. The message buffer is initialized to net_buffer_length, but can be added to max_allowed_packet as needed. If the value is too small, an error will occur when processing the large package. This value must be added if a large blob column is used.
46. net_buffer_length
The communication buffer is reset to this size during query. Do not change the value of this parameter, but if the memory is insufficient, you can set it to the expected size of the query. (That is, the expected length of the SQL statement sent by the customer. If the statement exceeds this length, the buffer is automatically expanded until max_allowed_packet bytes .)
47. max_binlog_cache_size
Specify the maximum size of binary log cache. If the value is too small, MySQL will encounter an error when executing a complex query statement.
48. max_binlog_size
Specifies the maximum size of binary log files. The default value is 1 GB.
49. max_connections
Number of customers allowed to connect to the MySQL server at the same time. If the value is exceeded, MySQL returns the too connector connections error. However, MySQL can solve the problem by itself.
50. max_connect_errors
If an error connection is interrupted for the same host that exceeds the value of this parameter, the connection to the host is disabled. To unban the host, run: flush host ;.
51. max_delayed_threads
Do not start threads with more than this number to process the insert delayed statement. If you try to insert data to a new table after all the insert delayed threads are used, the row will be inserted, as if the delayed attribute was not specified.
52. max_heap_table_size
The maximum capacity that can be used by the memory table.
53. max_join_size
If you want to query the Union of more than max_join_size records, an error is returned. If you want to execute a statement without a where statement, which takes a lot of time and returns the join of millions of rows, you need to increase the value of this parameter.
54. max_sort_length
The number of bytes used for sorting blob or text values (each value is used only in the header of max_sort_length; others are ignored ).
55. max_user_connections
Specifies the maximum number of connections from the same user. If it is set to 0, no restriction is imposed.
56. max_tmp_tables
(This parameter does not work yet ). The maximum number of temporary tables that a customer can open at the same time.
57. max_write_lock_count
When max_write_lock_count write locks occur, some locked read operations are allowed to begin. Avoid too many write locks and read operations in a long wait state.
58. myisam_recover_options
That is, the value of the -- MyISAM-Recover option.
Re: http://kb.discuz.net/index.php? Title = MySQL % E5 % 8f % 82% E6 % 95% B0 % E8 % af % B4 % E6 % 98% 8E

This article is transferred from
Http://hi.baidu.com/junny_z/blog/item/87a7d503454d43743912bb98.html

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.