{"id":1398,"date":"2024-05-08T10:12:05","date_gmt":"2024-05-08T02:12:05","guid":{"rendered":"http:\/\/oneai.eu.org\/?p=1398"},"modified":"2024-05-08T10:12:53","modified_gmt":"2024-05-08T02:12:53","slug":"mysqldb%e5%86%85%e7%bd%ae%e7%b3%bb%e7%bb%9f%e5%8f%98%e9%87%8f","status":"publish","type":"post","link":"https:\/\/oneai.eu.org\/?p=1398","title":{"rendered":"mysqldb\u5185\u7f6e\u7cfb\u7edf\u53d8\u91cf"},"content":{"rendered":"

\u8981\u6df1\u5165\u7814\u7a76mysql\u90a3\u9996\u5148\u5bf9mysql\u7684\u4e00\u4e9b\u7cfb\u7edf\/\u6269\u5c55\u53d8\u91cf\u6709\u4e00\u5b9a\u7684\u4e86\u89e3\uff0c\u56e0\u4e3a\u8fd9\u4e9b\u53d8\u91cf\u4e0d\u4ec5\u51b3\u5b9amysql\u4e00\u4e9b\u914d\u7f6e\u4fe1\u606f\uff0c\u8fd8\u5f71\u54cd\u4e86mysql\u7684\u6027\u80fd\u4f18\u5316\u63d0\u5347\uff0c\u5176\u4e2d\u5305\u62ec\u5b89\u5168\u3001\u4f18\u5316\u3001\u5e76\u53d1\u3001\u590d\u5236\u7b49\u7b49\u3002
\n\u7b14\u8005\u4e0a\u7f51\u67e5\u4e86\u4e00\u4e0b\uff0c\u8fd9\u4e9b\u8d44\u6599\u6709\u9650\uff0c\u4ee5\u53ca\u5b98\u7f51\u7684\u4e00\u4e2a\u4e2d\u6587\u6587\u6863\u4ecb\u7ecd\u7684\u5185\u5bb9\u7b80\u77ed\uff08\u4e0d\u5305\u62ec\u503c\u57df\uff0c\u4f5c\u7528\u57df\uff0c\u6709\u4e9b\u53d8\u91cf\u538b\u6839\u6ca1\u7ffb\u8bd1\u53ea\u662f\u7ed9\u51fa\u503c\uff09\u6240\u4ee5\u60f3\u5199\u7bc7\u6587\u7ae0\uff0c\u4e00\u6765\u5b66\u4e60\u5de9\u56fa\u4e00\u4e0bmysql\uff0c\u4e8c\u6765\u65b9\u4fbf\u4ee5\u540e\u67e5\u9605\u3002\u5176\u4e2d\u5185\u5bb9\u7b14\u8005\u524d\u540e\u7528\u4e8614\u5929\uff0c\u5c3d\u91cf\u67e5\u9605\u5927\u91cf\u8d44\u6599\uff08\u95ee\u4eba\uff0c\u7f51\u4e0a\u67e5\u9605\uff0c\u81ea\u5df1\u6d4b\u8bd5\uff09\u4ee5\u786e\u4fdd\u5c3d\u53ef\u80fd\u6b63\u786e\uff0c\u4e14\u6709\u4e9b\u76f4\u63a5\u4ece\u5b98\u7f51\u82f1\u6587\u6587\u6863\u7ffb\u8bd1\u8fc7\u6765\uff0c\u4f46\u96be\u514d\u4f1a\u51fa\u73b0\u56e0\u4e3a\u77e5\u8bc6\u7ed3\u6784\u4e0d\u5168\u9762\u800c\u6709\u4ec0\u4e48\u7eb0\u6f0f\u3002
\nPS\uff1a
\n\u4e00\u3001\u60f3\u77e5\u9053\u6709\u90a3\u4e9b\u53d8\u91cf\uff08\u7cfb\u7edf\u53d8\u91cf\u3001\u72b6\u6001\u53d8\u91cf\u3001\u96c6\u7fa4\u53d8\u91cf\u3001\u65e5\u5fd7\u53d8\u91cf\u2026\uff09\uff0c\u5728mysqladmin \u4e2d\u8f93\u5165\uff1a\u201cmysqladmin \u2013u \u7528\u6237 \u2013p \u5bc6\u7801 variable\u201d \u6216\u8005\u5728mysql\u547d\u4ee4\u7aef\u7528\u201cshow variables\u201d\u663e\u793a
\n\u67e5\u8be2\u53d8\u91cf\u7684\u503c\uff1aselect @@\u53d8\u91cf\u540d;
\n\u4e8c\u3001\u4ee5\u4e0b\u6240\u6709\u6d4b\u8bd5\u7684\u73af\u5883\uff1awin7\u3001mysql 5.1.49-community-log
\n\u4e09\u3001\u4ee5\u4e0b\u53d8\u91cf\u4e2d\u7684\u4f5c\u7528\u57df\u6709\u5168\u5c40\u3001\u4f1a\u8bdd\uff0c\u503c\u57df\u8868\u793a\u53d8\u91cf\u503c\u7684\u8303\u56f4\uff08\u8fd9\u4e9b\u662f\u4e2d\u6587\u6587\u6863\u9501\u6ca1\u6709\u7684\uff09
\n1\u3001 log_slow_queries | OFF\/ON
\n\u6162\u67e5\u8be2\u8bb0\u5f55\u65e5\u5fd7\uff0c\u6162\u67e5\u8be2\u662f\u6307\u67e5\u8be2\u65f6\u95f4\u8d85\u8fc7\u8bbe\u5b9a\u65f6\u95f4\uff08\u5982\u4e0b\u9762\u8bbe\u4e3a2\u79d2\uff09\u7684\u67e5\u8be2\uff0c\uff08\u8fd8\u6709\u4e2a\u6307\u6807\u662f\u7b2c29\u70b9\u7684min_examined_row_limit\uff09\u8fd9\u4e2a\u53ef\u4ee5\u8bb0\u5f55\u90a3\u4e9b\u67e5\u8be2\u8bed\u53e5\u6bd4\u8f83\u6162\uff0c\u7136\u540e\u901a\u8fc7\u5206\u6790\u8bed\u53e5\u800c\u4f18\u5316\u6570\u636e\u5e93\u6216\u67e5\u8be2\u8bed\u53e5\u3002\u5177\u4f53\u914d\u7f6e\u5728my.ini\u52a0\u5165\uff1a
\nlog_show_queries = \u201c\u65e5\u5fd7\u8def\u5f84\/\u6587\u4ef6\u540d\u201d #\u4fdd\u5b58\u65e5\u5fd7\u7684\u8def\u5f84\u548c\u6587\u4ef6\u540d\uff0c\u786e\u4fdd\u6743\u9650\u53ef\u5199
\nlong_query_time = 2 #\u8d85\u8fc7\u591a\u5c11\u79d2\u5219\u4fdd\u5b58\u67e5\u8be2\u6570\u636e
\nlog-queries-not-using-indexs #\u4e0d\u4f7f\u7528\u4f7f\u7528\u7d22\u5f15
\nPS\uff1a\u52a0\u4e0a\u4ee3\u7801\u540e\u91cd\u542fmysql\u540elog_slow_queries=ON\u72b6\u6001\uff08\u9ed8\u8ba4OFF\uff09
\n\u6d4b\u8bd5\uff1aselect from zd_ask;
\n\u7ed3\u679c\uff1a\u5728\u6307\u5b9a\u7684\u6587\u4ef6\u91cc\u9762\u8bb0\u5f55\u5982\u4e0b
\nC:\\Program Files\\MySQL\\MySQL Server 5.1\\bin\\mysqld, Version: 5.1.49-community-log (MySQL Community Server (GPL)). started with:
\nTCP Port: 3306, Named Pipe: (null)
\nTime Id Command Argument
\nTime: 120425 20:40:49
\nUser@Host: root[root] @ localhost [127.0.0.1]
\nQuery_time: 0.452026 Lock_time: 0.187010 Rows_sent: 12408 Rows_examined: 12408
\nuse bus7zd;
\nSET timestamp=1335357649;
\nselect <\/em> from zd_ask;
\n\u8bf4\u660e\uff1a\u8d85\u8fc7\u65f6\u95f4\u7684\u67e5\u8be2\u8bed\u53e5\uff1aselect * from zd_ask; \u67e5\u5230\u7684\u7ed3\u679c\u6570\uff1a12408 \u65f6\u95f4\uff1a0.452026 \u5176\u4ed6\u5c31\u662f\u73af\u5883\u4fe1\u606f\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 <\/h2>\n

2\u3001log_warnings | 1
\n\u9ed8\u8ba4\u503c\u4e3a1\uff0c\u8868\u793a\u5728\u9519\u8bef\u65e5\u5fd7\u5f53\u4e2d\u6dfb\u52a0\u66f4\u591a\u65e5\u5fd7\uff0c\u65e5\u81f3\u683c\u5f0f\uff1a
\n120426 11:55:09 [Worning]\u5185\u5bb9\uff0c\u4e0a\u7f51\u67e5\u4e86\u4e00\u4e0b\uff0c\u56fd\u5185\u8fd9\u4e2a\u53d8\u91cf\u7684\u8d44\u6599\u5c11\u5f97\u53ef\u601c\uff0c\u67e5\u770b\u5b98\u7f51\u82f1\u6587\u6587\u6863\uff0c\u4f1a\u628a\u4e00\u4e9b\u65ad\u5f00\u94fe\u63a5\u7684\u9519\u8bef\u5199\u8fdb\u9519\u8bef\u65e5\u5fd7\u91cc\u9762\u3002
\n\u53ef\u4ee5\u5728\u914d\u7f6e\u6587\u4ef6my.ini \u52a0\u5165skip-log-warnings=1\u6765\u505c\u6b62log_warning \u7684\u4f7f\u7528\uff0c skip-log-warnings=1\u540e\u5728mysqladmin \u91cc\u9762\u7528\u201dmysqladmin \u2013u \u7528\u6237\u540d \u2013p\u5bc6\u7801 variables\u201d\u67e5\u770b,\u4f1a\u53d1\u73b0log_warning\u7684\u503c\u662f0\u800c\u4e0d\u662f\u9ed8\u8ba4\u76841.
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 <\/h2>\n

3\u3001long_query_time | 10.000000
\n\u8fd9\u662f\u548clog_slow_queries\u4e00\u8d77\u4f7f\u7528\u7684\uff0c\u5b83\u662f\u8bbe\u7f6e\u6162\u67e5\u8be2\u65f6\u95f4\uff0c\u82e5\u503c\u662f0.2\uff0c\u5219\u67e5\u8be2\u5927\u4e8e0.2\u79d2\u7684\u5b9a\u4e3a\u6162\u67e5\u8be2\u3002\u5982\u679c\u542f\u7528\u4e86\u6162\u67e5\u8be2\u65e5\u5fd7\uff0c\u5219\u4f1a\u628a\u6162\u67e5\u8be2\u7684\u4fe1\u606f\u5199\u5982\u6162\u67e5\u8be2\u65e5\u5fd7\u6587\u4ef6\u4e2d\u3002\u5177\u4f53\u53ef\u4ee5\u67e5\u770b
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n\u672c\u6587\u7b2c\u4e00\u70b9\u3002\u6162\u67e5\u8be2\uff1ahttp:\/\/www.phpben.com\/?post=67<\/a><\/p>\n

4\u3001 low_priority_updates | OFF
\n\u8fd9\u4e2a\u53d8\u91cf\u662f\u964d\u4f4emysql\u5199\u6570\u636e\u7684\u6743\u9650\u7684\uff0cmysql\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5199\u64cd\u4f5c\u6743\u9650\u9ad8\u4e8e\u8bfb\u64cd\u4f5c\u3002\u9644\u52a0\u4e00\u4e9b\u77e5\u8bc6\uff1a\u5728mysql MYISAM\u8868\u4e2d\u8bfb\u5199\u662f\u4e32\u884c\uff0c\u5373\u662fselect\u65f6\u9501\u8868\uff0cinsert\u7b49\u5f85\u91ca\u653e\u518d\uff0c\u53cd\u4e4b\u4e00\u6837\u3002\u7136\u540e\u4e3a\u4e86\u51cf\u5c11\u9501\u5b58\u548c\u9501\u8bfb\u7684\u9891\u7387\uff0c\u5219\u5f15\u5165\u4e86concurrent_insert\u8fd9\u4e2a\u53d8\u91cf\uff0c\u4f7f\u8bfb\u5199\u80fd\u5e76\u884c\u64cd\u4f5c\uff08\u5177\u4f53\u6839\u636econcurrent_insert\u503c\u8fd8\u6709mysql\u7248\u672c\u800c\u5b9a\uff09
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n\u5728mysql5.06\u7248\u672c\u4e4b\u540e\uff0cconcurrent_insert=0\u5219\u8bfb\uff08select\uff09\u7684\u65f6\u5019\u4e0d\u80fd\u6267\u884c\u5199\uff08insert\uff09concurrent_insert=1\u5219select\u65f6\u5199\u64cd\u4f5c\u628a\u6570\u636e\u5199\u5728\u6587\u4ef6\uff0cconcurrent_insert=2\u548c1\u5dee\u4e0d\u591a\uff0c\u4e0d\u540c\u7684\u662f\uff1a1\u5728\u6570\u636e\u6ca1\u5185\u5b58\u788e\u7247\uff08\u6d1e\uff09\u624d\u80fd\u5199\u5728\u6587\u4ef6\u5c3e\uff0c\u5426\u5219\u8fd8\u662f\u5199\u5728\u6d1e\u91cc\uff1b\u800c2\u5219\u662f\u5728select\u65f6\u5e76\u53d1\u5199\u5165\u6587\u4ef6\u5c3e\uff0c\u5f53select\u91ca\u653e\u8bfb\u9501\u65f6\uff0c\u6570\u636e\u5199\u5165\u6d1e\u91cc\u9762\u3002---\u63a8\u8350\u7528current_insert=2
\n\u5b98\u7f51\u63cf\u8ff0\uff1a
\nValue
\nDescription
\n0
\nDisables concurrent inserts
\n1
\n(Default) Enables concurrent insert for MyISAM tables that do not have holes
\n2
\nEnables concurrent inserts for all MyISAM tables, even those that have holes. For a table with a hole, new rows are inserted at the end of the table if it is in use by another thread. Otherwise, MySQL acquires a normal write lock and inserts the row into the hole.<\/p>\n

\u56de\u6b63\u9898\uff1a
\nlow_priority_updates=1\u5219\u662f\u6bd4\u4e0a\u8ff0\u65b9\u6cd5\u66f4\u6781\u7aef\uff0c\u76f4\u63a5\u7ed9\u8bfb\u64cd\u4f5c\u4f18\u5148\u4e0e\u5199\u64cd\u4f5c\u3002\uff08\u4e0d\u63a8\u8350\uff09<\/p>\n

5\u3001lower_case_file_system | ON
\n\u8fd9\u662f\u63a7\u5236mysql\u6570\u636e\u5e93\u6587\u4ef6\u540d\u5728\u6587\u4ef6\u7cfb\u7edf\u4e2d\u662f\u5426\u5bf9\u5927\u5c0f\u5199\u654f\u611f\uff0c\u9ed8\u8ba4\u662fON\u5bf9\u5927\u5c0f\u5199\u4e0d\u654f\u611f\uff0cOFF\u7684\u8bdd\u5c31\u662f\u5bf9\u5927\u5c0f\u5199\u654f\u611f\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 <\/p>\n

6\u3001lower_case_table_names | 1
\n\u6b64\u53d8\u91cf\u662f\u8bbe\u7f6e\u6570\u636e\u5e93\u540d\u6216\u8868\u522b\u540d\u662f\u5426\u5927\u5c0f\u5199\u654f\u611f\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n0\uff1a\u5b58\u50a8\u65f6\u6309\u7167\u6307\u5b9a\u7684\u8868\u540d\uff0c\u6bd4\u8f83\u65f6\u5bf9\u5927\u5c0f\u5199\u654f\u611f\u3002
\n1\uff1a\u5b58\u50a8\u65f6\u6309\u7167\u5c0f\u5199\uff08\u4e0d\u7ba1\u8868\u662f\u5426\u6709\u5927\u5199\uff09\uff0c\u6bd4\u8f83\u65f6\u5bf9\u5927\u5c0f\u5199\u4e0d\u654f\u611f\u3002
\n2\uff1a\u5b58\u50a8\u65f6\u6309\u7ed9\u5b9a\u7684\u8868\u540d\uff0c\u6bd4\u8f83\u65f6\u7528\u5c0f\u5199\u3002
\n\u5bf9\u4e8ewindows\u548cMac OX S \u8fd9\u4e9b\u6587\u4ef6\u7cfb\u7edf\u5bf9\u5927\u5c0f\u5199\u654f\u611f\u7684\u7cfb\u7edf\u4e00\u822c\u4e0d\u8bbe0\uff0cwindows\u9ed8\u8ba4\u8bbe\u7f6e\u4e3a1\uff0cMac OX S\u8bbe\u7f6e\u4e3a2\u3002<\/p>\n

7\u3001max_allowed_packet | 1048576
\n8\u3001net_buffer_length | 16384
\n\u5148\u4ecb\u7ecdnet_buffer_length,\u5b83\u662f\u6bcf\u4e2a\u5ba2\u6237\u7aef\u7ebf\u7a0b\u7684\u8fde\u63a5\u7f13\u5b58\u533a\u548c\u7ed3\u679c\u7f13\u51b2\u533a\u90fd\u662f\u901a\u8fc7net_buffer_length\u6765\u521d\u59cb\u5316\uff0cnet_buffer_length\u9ed8\u8ba4\u521d\u59cb\u503c\u662f16384\uff0816K\uff09\uff0c\u4f46\u5176\u503c\u6700\u5927\u53ef\u4ee5\u8fbe\u5230max_allowed_packet\u8bbe\u5b9a\u503c\uff0cmax_allowed_packe\u9ed8\u8ba4\u503c\u662f1M\uff0c\u6700\u5927\u8fbe\u52301073741824\uff081G\uff09\uff0c\u5176\u503c\u5fc5\u987b\u662f1024\u7684\u500d\u6570\uff0c\u5426\u5219\u56de\u843d\u5230\u6700\u9760\u8fd11024\u500d\u6570\u503c\uff08\u59821025\u5219\u503c\u662f1024\uff09\uff0c\u5728\u5185\u5b58\u5141\u8bb8\u7684\u60c5\u51b5\u4e0b\uff0cmax_allowed_packe\u8d8a\u5927\u8d8a\u597d\u3002
\n\u82e5max_allowed_packe\u8bbe\u7f6e\u7684\u5c0f\uff0c\u5f53\u589e\u6539(insert\/update\/load data infile\u2026)\u6570\u636e\u5e93\u65f6\uff0c\u82e5\u51fa\u73b0\u5927\u5b57\u7b26\u4e32\u6216blob\u7c7b\u578b\u5217\u4e14\u5927\u5c0f\u5927\u4e8emax_allowed_packe\u503c\u5219\u4f1a\u51fa\u73b0\u4ee5\u4e0b\u95ee\u9898\u3002
\nMy.ini\u52a0\u5165\u914d\u7f6e
\nnet_buffer_length=1024 #\u9ed8\u8ba4\u662f16384\uff0c\u8fd9\u91cc\u6539\u5c0f\u4e3a\u4e86\u6d4b\u8bd5
\nmax_allowed_packet=1025#\u9ed8\u8ba4\u662f1M\uff0c\u8fd9\u91cc\u867d\u7136\u662f1025\u800c\u4e8b\u5b9e\u4e0a\u503c\u662f1024
\n\u7b14\u8005\u66f4\u65b0\u8868\u67d0\u5217\uff08\u503c\u5927\u4e8e1024\uff09\u5219\u51fa\u73b0\uff1a
\nERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes
\n\u6ce8\u610f\uff1a\u5728version()<5.0.84 net_buffer_length\u53ef\u4ee5\u8bbe\u7f6e\u4f46\u6ca1\u6709\u6548\uff0cversion()=5.0.84\u662f\u53ea\u8bfb<\/h2>\n

9\u3001 max_binlog_cache_size | 4294963200
\n\u8fd9\u662f\u8bbe\u7f6e\u6700\u5927\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7684\u7f13\u5b58\u533a\u5927\u5c0f\u7684\u53d8\u91cf\u3002\u82e5\u5904\u7406\u591a\u8bed\u53e5\u4e8b\u52a1\u65f6\u9700\u8981\u7684\u5185\u5b58\u5927\u5c0f\u6bd4\u8bbe\u7f6e\u503c\u5927\u7684\u8bdd\u5c31\u4f1a\u63d0\u793a\u4e00\u4e2aerror\uff1aMulti-statement transaction required more than 'max_binlog_cache_size' bytes of storage \u3002
\n\u8fd9\u4e2a\u53d8\u91cf\u6700\u5c0f\u503c\u662f4096\uff084K\uff09\uff0c\u6700\u5927\u503c\uff0c\u572832\u4f4d\u7684\u7cfb\u7edf\u4e2d\u662f4G\uff0c64\u4f4d\u7684\u662f16P\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u5728mysql5.0\u4e2d\uff0cmax_binlog_cache_size\u4e00\u4fee\u6539\u5219\u6240\u6709\u4f1a\u8bdd\u90fd\u53d7\u5f71\u54cd\uff08\u53ef\u80fd\u4e4b\u524d\u7684\u53d7\u5ef6\u8fdf\uff0c\u7b14\u8005\u6ca1\u67e5\u8bc1\u8fc7\uff09<\/h2>\n

10\u3001 max_binlog_size | 1073741824
\n\u8fd9\u662f\u8bbe\u7f6e\u6bcf\u4e2a\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6587\u4ef6\u5185\u5bb9\u5927\u5c0f\u7684\u53d8\u91cf\uff0c\u5982\u679c\u5f53\u524d\u6587\u4ef6\u7684\u6570\u636e\u91cf\u5927\u4e8emax_binlog_size\u7684\u503c\u65f6\uff0c\u5219\u4f1a\u5173\u95ed\u6b64\u6587\u4ef6\uff0c\u65b0\u5efa\u4e0b\u4e2a\u6587\u4ef6\u5199\u5165\u6570\u636e\u3002
\n\u4f46\u662f\uff0c\u5f53\u5904\u7406\u591a\u8bed\u53e5\u4e8b\u52a1\uff08\u5927\u4e8b\u52a1\uff09\u65f6\uff0c\u4f1a\u51fa\u73b0\u6587\u4ef6\u6570\u636e\u5927\u5c0f\u6bd4\u6b64\u503c\u8bbe\u7f6e\u503c\u5927\u7684\u60c5\u51b5\u3002\u8fd9\u662f\u56e0\u4e3a\u4e8b\u52a1\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u662f\u5757\u5b58\u50a8\u7684\uff0c\u4e5f\u5c31\u662f\u8bf4\u4e0d\u4f1a\u5206\u5272\u51fa\u6765\u5b58\u653e\u5728\u4e24\u4e2a\u65e5\u5fd7\u6587\u4ef6\u4e2d\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

11\u3001 max_connect_errors | 10
\n\u8bbe\u7f6e\u67d0\u5ba2\u6237\u7aef\u94fe\u63a5mysql\u670d\u52a1\u5668\u5931\u8d25\u6b21\u6570\uff0c\u82e5\u6b21\u6570\u8d85\u8fc7\u6b64\u503c\uff0c\u5219\u9501\u5b9a\u7981\u6b62\u8be5\u5ba2\u6237\u7aef\u94fe\u63a5\u670d\u52a1\u5668\u4e14\u63d0\u793a\u9519\u8bef\uff0c\u82e5\u5728\u672a\u8d85\u8fc7\u6b64\u503c\u6709\u4e00\u6b21\u6210\u529f\u94fe\u63a5\uff0c\u5219\u8ba1\u6570\u5668\u4f1a\u6e05\u96f6\u3002
\n\u8fd9\u662f\u4e00\u4e2a\u4e0e\u6027\u80fd\u65e0\u5173\u7684\u53d8\u91cf\uff0c\u800c\u662f\u5b89\u5168\u65b9\u9762\u8003\u8651\u7684\uff0c\u4e3b\u8981\u9632\u6b62\u7a77\u4e3e\u6cd5\u7834\u89e3\u6570\u636e\u5e93\u7528\u6237\u548c\u5bc6\u7801\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u503c\u662f10\uff0c32\u4f4d\u7cfb\u7edf1~ 4294967295\uff0c64\u4f4d\u7684\u662f1~18446744073709547520
\n\u5b98\u65b9\u8bf4\uff1a\u4e00\u65e6\u9501\u5b9a\uff0c\u8981\u89e3\u9501\u53ea\u6709\u65b9\u6cd5\uff1a\u5728mysql\u5ba2\u6237\u7aefflush hosts \uff1b\u5728mysqladmin\u4e2d\u7528mysqladmin flush-host
\n\u7b14\u8005\u5728\u672c\u673a\u6d4b\u8bd5\u8fc7\uff1a\u8fd9\u4e2a\u529f\u80fd\u7528\u4e0d\u4e86 \u3002<\/h2>\n

12\u3001 max_connections | 100
\n\u8fd9\u4e2a\u8bbe\u7f6e\u6570\u636e\u5e93\u5e76\u53d1\u53ef\u8fde\u63a5\u7684\u6570\u91cf
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u503c\u57df\uff1a
\nVersion()<=5.1.14 \uff1a\u9ed8\u8ba4100
\nVersion()>=5.1.15 \uff1a\u9ed8\u8ba4151 1~16384
\nVersion()>=5.1.17 \uff1a\u9ed8\u8ba4151 1~100000
\n\u8fd9\u662f\u7f51\u7ad9\u6210\u957f\u5fc5\u8981\u4fee\u6539\u7684\u4e00\u4e2a\u53d8\u91cf\uff0c\u5141\u8bb8\u591a\u5c11\u4eba\u5728\u7f51\u7ad9\u4e0a\u5e76\u53d1\u64cd\u4f5c\u3002<\/h2>\n

13\u3001max_delayed_threads | 20
\n\u5ef6\u8fdf\u64cd\u4f5cDelay_insert\u6700\u5927\u7ebf\u7a0b\u6570
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n\u9ed8\u8ba420 \u503c\u57df\uff1a0~16384<\/h2>\n

14\u3001 max_error_count | 64
\nShow warning \u6216show error \u663e\u793awarning\u6216Error\u663e\u793a\u7684\u6700\u5927\u4e2a\u6570\uff0c\u9ed8\u8ba4\u662f64\uff0c\u503c\u57df0~65535.\u6b64\u503c\u4e0d\u80fd\u6539\u592a\u5c0f\uff0c\u5426\u8005\u82e5\u9519\u8bef\u63d0\u793a\u4e2a\u6570\u6bd4\u6b64\u503c\u591a\u7684\u8bdd\u4e0d\u65b9\u4fbf\u8c03\u8bd5\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n\u6ce8\u610f\uff1a\u6b64\u503c\u4e0d\u8981\u8c03\u592a\u5c0f\uff1b\u5bf9\u4e8e\u5df2\u7ecf\u8fd0\u884c\u7cfb\u7edf\uff0c\u53ef\u8bbe\u4e3a0\uff0c\u4e0d\u4f1a\u63d0\u793a\u9519\u8bef\u3002<\/h2>\n

15\u3001max_heap_table_size | 16777216
\n\u5185\u5b58\u8868\u6700\u5927\u884c\u6570\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n\u503c\u57df\uff1a32\u4f4d\u64cd\u4f5c\u7cfb\u7edf16384~4294967295 64\u4f4d\u64cd\u4f5c\u7cfb\u7edf16384 ~ 1844674407370954752
\n\u9ed8\u8ba4\u503c\u90fd\u662f16777216
\n\u66f4\u65b0\u8bbe\u7f6e\u6b64\u503c\u5bf9\u5df2\u5b58\u5728\u7684\u5185\u5b58\u8868\u6ca1\u5f71\u54cd\uff08\u91cd\u542fmysql\u670d\u52a1\u5668\u5c31\u6709\uff09\uff0c\u5bf9create\/update\/truncate\u8bed\u53e5\u6709\u5f71\u54cd\u3002<\/h2>\n

16\u3001max_insert_delayed_threads | 20
\n\u662fmax_delayed_threads\u7684\u522b\u540d\uff0c\u770b\u7b2c13\u70b9\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd<\/h2>\n

17\u3001 max_join_size | 18446744073709551615
\n18\u3001 sql_big_selects | ON
\nmax_join_size\u548csql_big_selects
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\nsql_big_selects\u9ed8\u8ba4\u503c\u662f1\uff0c\u8868\u793a\u6240\u6709select\u67e5\u8be2\u90fd\u6267\u884c\uff08\u4e0d\u7ba1\u65f6\u95f4\u957f\u77ed\uff09\u3002
\nsql_big_selects=0\/OFF\u65f6\uff0cmysql\u5148\u4f30\u7b97\u5355\u8868\u67e5\u8be2\u7ed3\u679c\u884c\u6570\u6216\u591a\u8868\u67e5\u8be2\u7ec4\u5408\u884c\u6570\u7684\u5927\u5c0f\uff0c\u82e5\u6bd4max_join_size\u5927\u65f6\uff0c\u5c31\u4f1a\u653e\u5f03\u8be5\u67e5\u8be2\u8bed\u53e5\u3002
\nmax_join_size\u9ed8\u8ba4\u662f4294967295\uff0c\u503c\u57df\uff1a1~4294967295
\n\u6ce8\u610f\uff1asql_big_selects=0\/OF\u7684\u60c5\u51b5\u4e0b\uff0cmax_join_size\u4e0d\u9f50\u4f5c\u7528\uff0c\u4e14\u5f53max_join_size\u8bbe\u7f6e\u4e3a\u975e\u9ed8\u8ba4\u503c\u65f6\uff0csql_big_selects\u4f1a\u88ab\u91cd\u7f6e\u4e3a0.<\/h2>\n

19\u3001 max_length_for_sort_data | 1024 ====
\n\u786e\u5b9a\u4f7f\u7528\u7684filesort\u7b97\u6cd5\u7684\u7d22\u5f15\u503c\u5927\u5c0f\u7684\u9650\u503c\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n=========\u4ee5\u4e0b\u5f15\u7528\u7f51\u4e0a\u5185\u5bb9\u8fd9\u662f\u5730\u5740\uff1ahttp:\/\/www.itpub.net\/thread-1417429-1-1.html<\/a>
\nmysql\u7684filesort\u7b97\u6cd5\u6709\u4e24\u79cd\uff1a
\n\u4e00\u79cd\u662f\u6700\u521d\u7684\u7b97\u6cd5\uff0c\u5728MySQL 4.1\u4ee5\u524d\u53ea\u6709\u8fd9\u79cd\u7b97\u6cd5\uff0c\u4e00\u79cd\u662f\u6539\u8fdb\u7684filesort\u7b97\u6cd5\uff0c\u5b83\u51fa\u73b0\u5728MySQL 4.1\u4ee5\u540e(blob\u548ctext\u7c7b\u578b\u7684\u5b57\u6bb5\u4e0d\u80fd\u91c7\u7528\u8fd9\u79cd\u6539\u8fdb\u7b97\u6cd5)<\/p>\n

"\u6700\u521d\u7684\u7b97\u6cd5"\u6d41\u7a0b\u5982\u4e0b\uff1a
\n1.\u8bfb\u53d6\u6240\u6709\u7684\u6ee1\u8db3\u6761\u4ef6\u7684\u6570\u636e\uff0c\u53ea\u5305\u542bsort key\u548crow pointer\u4e24\u79cd\u6570\u636e
\n2.\u5728buffer\u4e2d\u6267\u884cqsort\u6392\u5e8f
\n3.\u6392\u5b8c\u5e8f\u540e\uff0c\u518d\u6839\u636erow pointer\u53bb\u8bfb\u53d6\u76f8\u5e94\u7684\u884c\u6570\u636e
\n\u4ece\u4e2d\u53ef\u4ee5\u770b\u51fa\uff0c\u6bcf\u6b21\u6392\u5e8f\u90fd\u9700\u8981\u8bfb\u4e24\u6b21\u8868\uff0c\u800c\u6839\u636erow pointer\u53bb\u8bfb\u8868\u5f80\u5f80\u90fd\u662f\u968f\u673a\u79bb\u6563\u8bfb\u7684\uff0c\u6240\u6709\u5176\u5f00\u9500\u975e\u5e38\u5927\u3002<\/p>\n

\u6539\u8fdb\u540e\u7684filesort\u7b97\u6cd5\u662f\uff1a
\n1.\u8bfb\u53d6\u6240\u9700\u8981\u7684\u6570\u636e\uff0c\u5305\u542bsort key,row pointer\u548c\u67e5\u8be2\u6240\u9700\u8981\u8bbf\u95ee\u7684\u5b57\u6bb5
\n2.\u6839\u636esort key\u6392\u5e8f
\n3.\u6309\u6392\u5e8f\u540e\u7684\u987a\u5e8f\u8bfb\u53d6\u6570\u636e\uff0c\u7531\u4e8esort_buffer_size\u4e2d\u5305\u542b\u4e86\u6240\u9700\u8981\u7684\u5b57\u6bb5\uff0c\u56e0\u6b64\u4e0d\u9700\u8981\u518d\u56de\u8868\u4e86\uff0c\u53ef\u4ee5\u76f4\u63a5\u8fd4\u56de\u7ed3\u679c\u7ed9\u5ba2\u6237\u7aef\u3002
\n\u5f88\u660e\u663e\uff0c\u8fd9\u79cd\u6539\u8fdb\u7684\u65b9\u6cd5\u5bf9sort_buffer_size\u7684\u9700\u6c42\u4e5f\u5927\u5927\u589e\u52a0.<\/p>\n

\u6240\u4ee5\u4e3a\u4e86\u9632\u6b62\u6027\u80fd\u4e0b\u964d\uff0cmysql\u589e\u52a0\u4e86\u4e00\u4e2a\u53c2\u6570max_length_for_sort_data,\u5f53\u7b2c\u4e00\u6b65\u4e2d\u9664\u4e86sort key\u4ee5\u5916\u7684\u5b57\u6bb5\u5185\u5bb9\u5927\u4e8emax_length_for_sort_data\u8fd9\u4e2a\u53c2\u6570\u65f6\uff0cmysql\u5c06\u91c7\u7528\u7b2c\u4e00\u79cd\u6392\u5e8f\u7b97\u6cd5\u3002<\/h2>\n

20\u3001max_prepared_stmt_count | 16382
\n\u8be5\u53d8\u91cf\u8bbe\u7f6e\u9884\u5904\u7406\u8bed\u53e5\u9650\u5236\u6570\u3002\u8fd9\u4e2a\u529f\u80fd\u80fd\u9632\u6b62\u62d2\u7edd\u670d\u52a1\u653b\u51fb\uff0c\u56e0\u4e3a\u653b\u51fb\u53ef\u4ee5\u901a\u8fc7\u5927\u91cf\u7684\u9884\u5904\u7406\u8bed\u53e5\u81f4\u4f7f\u670d\u52a1\u5668\u5185\u5b58\u6ea2\u51fa\u6765\u653b\u51fb\u3002\u8bbe\u7f6e\u6b64\u53d8\u91cf\u5c31\u662f\u4e00\u9053\u5b89\u5168\u5c4f\u969c\uff0c\u6b64\u53d8\u91cf\u5bf9\u539f\u6709\u7684\u9884\u5904\u7406\u8bed\u53e5\u4e0d\u5f71\u54cd\uff0c\u4f46\u82e5\u662f\u9884\u5904\u7406\u8bed\u53e5\u7684\u6570\u91cf\u8d85\u8fc7\u8be5\u53d8\u91cf\u7684\u503c\uff0c\u5219\u4e0d\u4f1a\u65b0\u589e\u9884\u5904\u7406\u8bed\u53e5\uff0c\u800c\u662f\u7b49\u5230\u9884\u5904\u7406\u8bed\u53e5\u7684\u503c\u5c0f\u4e8emax_prepared_stmt_count\u7684\u503c\u624d\u589e\u52a0\u65b0\u8bed\u53e5\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u503c\uff1a16382 \u503c\u57df\uff1a0~1048576
\n\u82e5\u8bbe\u4e3a0\u5219\u8868\u793a\u4e0d\u5141\u8bb8\u9884\u5904\u7406\u8bed\u53e5\u3002
\n\u6ce8\u610f\uff1a\u8be5\u53d8\u91cf\u662fversion()>5.0.21\u624d\u6709<\/h2>\n

21\u3001max_relay_log_size | 0
\n\u4e2d\u7ee7\u65e5\u5fd7\u5927\u5c0f\uff0c\u548c\u7b2c10\u70b9\u7684max_binlog_size\u7c7b\u540c\uff0c\u53ea\u4e0d\u8fc7\u4e2d\u7ee7\u65e5\u5fd7\u662f\u4fdd\u5b58\u4ece\u670d\u52a1\u5668\u7684\u65e5\u5fd7\uff0c\u662f\u4ece\u4e3b\u670d\u52a1\u5668\u590d\u5236\u8fc7\u6765\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u3002
\n\u5f53max_relay_log_size =0\u5219max_relay_log_size=max_binlog_size
\n\u5f53max_relay_log_size >0\u5219\u4e2d\u7ee7\u65e5\u5fd7\u5927\u5c0f\u662fmax_relay_log_size\u8bbe\u5b9a\u7684\u503c
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u503c\uff1a0 \u503c\u57df\uff1a0~1073741824<\/h2>\n

22\u3001max_seeks_for_key | 4294967295
\n\u6b64\u53d8\u91cf\u5047\u5b9a\u7d22\u5f15\u641c\u7d22\u884c\u6570\u6700\u5927\u503c\u3002\u4e5f\u5c31\u662f\u8bf4\u8fd9\u4e2a\u503c\u662f\u7d22\u5f15\u641c\u7d22\u6700\u5927\u503c\u3002\u67e5\u8be2\u4f18\u5316\u5668\u4f1a\u5ffd\u7565\u7d22\u5f15\u57fa\u6570\uff08\u7528show index from table \u53ef\u770b\u5230\u57fa\u6570cardinality\uff09\uff0c\u5b83\u5047\u5b9a\u626b\u63cf\u7d22\u5f15\u5339\u914d\u7684\u884c\u6570\u4e0d\u4f1a\u8d85\u8fc7max_seeks_for_key\u8bbe\u5b9a\u503c\u3002
\n\u5b98\u7f51\uff1a\u53ef\u4ee5\u901a\u8fc7\u6539\u5c0f\u8fd9\u4e2a\u503c\u6765\u5f3a\u5236mysql\u4f7f\u7528\u7d22\u5f15\u6765\u4ee3\u66ff\u5168\u8868\u626b\u63cf\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n\u572832\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba44294967295\uff0c\u503c\u57df\uff1a1~ 4294967295
\n\u572864\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba418446744073709547520\uff0c\u503c\u57df1~18446744073709547520<\/h2>\n

23\u3001 max_sort_length | 1024
\n\u5f53\u6392\u5e8fBLOB\u6216\u8005TEXT\u7c7b\u578b\u5217\u6570\u636e\u65f6\u7528\u7684\u5b57\u8282\u6570\u3002\u5f53\u6570\u636e\u957f\u5ea6> max_sort_length\u8bbe\u5b9a\u503c\uff0c\u6392\u5e8f\u5c31\u7528max_sort_length\u7684\u957f\u5ea6\u6765\u6392\u5e8f\uff0c\u540e\u9762\u7684\u6570\u636e\u88ab\u5ffd\u7565\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n\u9ed8\u8ba4\u662f1024 \u503c\u57df\uff1a4~ 8388608<\/h2>\n

25\u3001max_sp_recursion_depth | 0
\n\u8bbe\u5b9a\u5b58\u50a8\u8fc7\u7a0b\uff08sp=>save procedures\uff09\u6700\u5927\u9012\u5f52\u6570\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n\u9ed8\u8ba40\uff0c\u7981\u6b62\u5b58\u50a8\u8fc7\u7a0b\u9012\u5f52\uff0c\u6700\u5927\u503c255
\nPS\uff1a\u6b64\u53d8\u91cf\u5728version()=5.0.17\u5f15\u5165<\/h2>\n

26\u3001 max_tmp_tables | 32
\n\u8bbe\u5b9a\u5ba2\u6237\u7aef\u540c\u65f6\u80fd\u6253\u5f00\u4e34\u65f6\u8868\u4e2a\u6570\u7684\u6700\u5927\u503c
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba432 \u503c\u57df\uff1a1~4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba432 \u503c\u57df\uff1a1~18446744073709547520
\nPS: \u5b98\u7f51\uff1aThis variable does not yet do anything\uff08\u8be5\u53d8\u91cf\u8fd8\u6ca1\u751f\u6548\uff09<\/h2>\n

27\u3001max_user_connections | 0
\nMysql\u6bcf\u4e2a\u7528\u6237\u80fd\u540c\u65f6\u94fe\u63a5\u670d\u52a1\u5668\u6700\u5927\u503c\u30020\u8868\u793a\u6ca1\u6709\u9650\u5236
\n\u9ed8\u8ba4\u503c\uff1a0 \u503c\u57df\uff1a1~ 4294967295
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd<\/h2>\n

28\u3001max_write_lock_count | 4294967295
\n\u8bbe\u5b9a\u6570\u636e\u8868\u5199\u9501\u5b9a\u6700\u5927\u6570\uff0c\u6ce8\u610f\uff1a\u8fd9\u662f\u5bf9\u540c\u4e00\u4e2a\u8868\u6765\u8bf4\u7684\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba44294967295 \u503c\u57df\uff1a1~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba418446744073709547520 \u503c\u57df\uff1a1~18446744073709547520
\n\u7f51\u4e0a\u6709\u4eba\u8bf4\uff1a\u5f53\u5bf9\u540c\u4e00\u4e2a\u8868\u9501\u5b9a\u4e2a\u6570\u8d85\u8fc7\u8bbe\u5b9a\u503c\u7684\u65f6\u5019\uff0c\u670d\u52a1\u5668\u4f1a\u91ca\u653e\u8bfb\u9501\u5b9a\u3002
\n\u7b14\u8005\u6709\u4e9b\u6000\u7591\uff0c\u505a\u4e86\u4e2a\u6d4b\u8bd5\uff1a
\nmax_write_lock_count =4294967295
\n\u5f00\u542f\u4e09\u4e2a\u5ba2\u6237\u7aef\uff0c\u7b2c\u4e00\u4e2a\u9501\u5b9a\u5199\uff0c\u7b2c\u4e8c\u4e2aselect\u8bfb\u53d6\uff0c\u7b2c\u4e09\u4e2a\u6709\u52a0\u4e00\u4e2a\u9501\u5b9a\uff0c\u987a\u5e8f1\u30012\u30013
\n\u5f53\u7b14\u8005\u5f00\u7b2c\u4e00\u4e2a\u9501\u5b9a\u65f6\uff0c\u8bfb\u5ba2\u6237\u7aef\u8fd8\u5728\u7b49\u5f85\u3002
\nmax_write_lock_count =2
\n\u7b2c\u4e00\u9501\u5b9a\u8868\uff0c\u7b2c\u4e8cselcet\u8bed\u53e5\uff0c\u7b2c\u4e09\u9501\u5b9a\u8868
\n1\u3001 \u89e3\u5f00\u7b2c\u4e00\u4e2a\u9501\uff0cselect\u8fd9\u8fb9\u6ca1\u53cd\u5e94
\n2\u3001 \u518d\u52a0\u4e00\u4e2a\u9501\u5b9a\uff08\u4e09\u4e2a\uff0c\u89e3\u5f00\u4e00\u4e2a\u8fd8\u6709\u4e24\u4e2a\uff09\uff0cselcct\u8fd9\u8fb9\u8fd8\u662f\u6ca1\u53cd\u5e94
\n3\u3001 \u52a0\u4e00\u4e2a\u5ba2\u6237\u7aefinsert\u6570\u636e\uff0c\u5373\u65f63\u95011\u63d2\u51651\u67e5\u627e\uff0c\u5f53\u89e3\u5f00\u4e00\u4e2a\u9501\u65f6\uff0cselcet\u548c\u63d2\u5165\u90fd\u6709\u4e86\u53cd\u5e94\u4e14\u6b63\u5e38\u8fd0\u884c\u3002
\n\u7b14\u8005\u7ed3\u8bba\u662f\uff1a
\n\u5e94\u8be5\u662f\uff1a\u5f53\u5199\u9501\u5b9a\u8d85\u8fc7\u9650\u5236\u4e14\u6709\u5176\u4ed6\u5ba2\u6237\u7aef\u5199\u64cd\u4f5c\u65f6\uff0c\u90e8\u5206\u8bfb\u64cd\u4f5c\u88ab\u91ca\u653e\u3002<\/h2>\n

29\u3001min_examined_row_limit | 0
\n\u8fd9\u4e5f\u662f\u5224\u65ad\u4e00\u4e2a\u67e5\u8be2\u662f\u5426\u662f\u6162\u67e5\u8be2\u7684\u4e00\u4e2a\u53d8\u91cf\uff0c\u53c2\u8003\u7b2c1\u70b9\u7684log_slow_queries
\n\u82e5\u67e5\u8be2\u7684\u7ed3\u679c\u96c6\u884c\u6570\u5927\u4e8emin_examined_row_limit\u503c\uff0c\u5219\u67e5\u8be2\u88ab\u5f53\u4f5c\u6162\u67e5\u8be2\u5199\u5165\u6162\u67e5\u8be2\u65e5\u5fd7\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba44294967295\u503c\u57df\uff1a1~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba418446744073709547520 \u503c\u57df\uff1a1~18446744073709547520<\/h2>\n

30\u3001multi_range_count | 256
\nveriosn=5.03\u52a0\u5165\u8be5\u53d8\u91cf
\n\u8bbe\u5b9a\u67e5\u8be2\u8bed\u53e5\u4e2drange\u8303\u56f4\u6700\u5927\u4e2a\u6570,\u5982\u201cwhere id>100 and userId<50\u201d\u662f\u4e24\u4e2a\u8303\u56f4\u3002
\n\u9ed8\u8ba4\u662f256
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd
\n\u503c\u57df\uff1a1~ 4294967295
\n\u4e00\u822c\u4e0d\u6539\u6b64\u53c2\u6570\u3002<\/h2>\n

31\u3001 myisam_data_pointer_size | 6
\n\u9ed8\u8ba4\u6307\u9488\u5927\u5c0f\uff0c\u5355\u4f4d\u662f\u5b57\u8282\uff0c MAX_ROWS\u4e0d\u6307\u5b9a\u65f6\uff0cCREATE TABLE\u4f7f\u7528\u8be5\u53d8\u91cf\u521b\u5efaMyISAM\u8868\u3002\u9ed8\u8ba4\u503c\u662f6\u3002\u503c\u57df\uff1a2~7
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

32\u3001 myisam_max_sort_file_size | 107374182400
\n\u5f53\u7528\u5230REPAIR TABLE, ALTER TABLE, LOAD DATA INFILE\u7684\u65f6\u5019\uff0c\u76f8\u5e94\u7684\u7d22\u5f15\u4f1a\u88ab\u91cd\u5efa\uff0c\u7136\u540e\u8981\u7528\u5230\u4e34\u65f6\u6587\u4ef6\uff0c\u6b64\u53d8\u91cf\u5c31\u662f\u8bbe\u7f6e\u4e34\u65f6\u6587\u4ef6\u5927\u5c0f\u7684\u3002\u5982\u679c\u7d22\u5f15\u6587\u4ef6\u5927\u5c0f\u6bd4\u6b64\u503c\u5c0f\uff0c\u7cfb\u7edf\u5219\u8c03\u7528\u901f\u5ea6\u66f4\u6162\u7684\u952e\u503c\u521b\u5efa\u7d22\u5f15\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u662f2G
\n\u5b98\u7f51\u5efa\u8bae\uff1a\u5982\u679cMyISAM\u7d22\u5f15\u6587\u4ef6\u5927\u4e8e2G\u4e14\u786c\u76d8\u7a7a\u95f4\u5141\u8bb8\uff0c\u589e\u5927\u8be5\u503c\u53ef\u4ee5\u63d0\u9ad8\u6027\u80fd\u3002\u6ce8\u610f\u7684\u662f\u589e\u52a0\u7684\u7a7a\u95f4\u662f\u5305\u542b\u539f\u6765\u7d22\u5f15\u6587\u4ef6\u7a7a\u95f4\u7684\u3002<\/h2>\n

33\u3001 myisam_mmap_size | 4294967295
\nMmp:memory mapping \u5185\u5b58\u6620\u5c04
\n\u8bbe\u7f6e\u4f7f\u7528\u5185\u5b58\u6620\u5c04\u538b\u7f29MyISAM\u8868\u6587\u4ef6\u7684\u6700\u5927\u5185\u5b58\u91cf\u7684\u53d8\u91cf\u3002
\n\u5982\u679c\u8bb8\u591a\u538b\u7f29MyISAM\u8868\u4f7f\u7528\uff0c\u53ef\u4ee5\u901a\u8fc7\u964d\u4f4e\u8be5\u503c\u6765\u51cf\u4f4e\u5185\u5b58\u4ea4\u6362\u95ee\u9898\u51fa\u73b0\u7684\u53ef\u80fd\u6027\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba44294967295\u503c\u57df\uff1a1~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba418446744073709547520 \u503c\u57df\uff1a1~18446744073709547520<\/h2>\n

34\u3001myisam_recover_options | OFF
\n\u8bbe\u7f6eMyISAM\u5b58\u50a8\u6a21\u5f0f\uff0c\u5b83\u7684\u503c\u53ef\u4ee5\u662fOFF, DEFAULT, BACKUP, FORCE, QUICK\u4efb\u610f\u7ec4\u5408\uff0c\u7ec4\u5408\u503c\u5219\u7528\u2018,\u2019\u9694\u5f00\u3002
\n\u9ed8\u8ba4\u662fOFF\u3002
\n\u82e5\u975eOFF\u7684\u8bdd\uff0c\u8868\u793a\u6bcf\u6b21\u6253\u5f00MyISAM\u8868\u90fd\u68c0\u67e5\u8868\u662f\u5426\u5d29\u6e83\u6216\u8005\u975e\u6b63\u5e38\u4fdd\u5b58\uff0c\u5426\u5219\u548c\u5c1d\u8bd5\u4fee\u590d\u8868\u3002
\n\u4fee\u590d\u6309\u7167\u503c\u9009\u9879\u800c\u5b9a\uff1a
\nOFF\uff1a\u5173\u95ed
\nDEFAULT\uff1a\u4fee\u590d\u4e2d\u6ca1\u6709BACKUP, FORCE, QUICK
\nBACKUP\uff1a\u5982\u679c\u4fee\u590d\u8fc7\u7a0b\u4e2d\u7528\u6237\u4fee\u6539\u6570\u636e\uff0c\u5219\u628a\u201c\u8868\u540d.MYD\u201d\u6587\u4ef6\u5907\u4efd\u6210\u201c\u8868\u540d-\u65f6\u95f4.BAK\u201d\u6587\u4ef6
\nFORCE\uff1a\u7ee7\u7eed\u4fee\u590d\u6570\u636e\u5373\u4fbf\u662f\u4e22\u5931\u5927\u91cf\u6570\u636e
\nQUICK\uff1a\u4e0d\u68c0\u67e5\u8868\u4e2d\u7684\u884c\uff0c\u5982\u679c\u6ca1\u6709\u4efb\u4f55\u5220\u9664\u5757\u3002
\n\u8fd8\u6709\u7684\u662f\uff0c\u4fee\u590d\u4e4b\u524d\uff0cmysql\u4f1a\u5728\u9519\u8bef\u65e5\u5fd7\u4e2d\u5199\u5165note\uff0c\u8fd9\u4e2anote\u5173\u4e8e\u4fee\u590d\u7684\u3002
\n\u5b98\u7f51\u5efa\u8bae\uff1a\u5982\u679c\u60f3\u5728\u4e0d\u53d7\u7528\u6237\u6253\u6270\u7684\u60c5\u51b5\u4e0b\u4fee\u590d\u6570\u636e\uff0c\u5219\u8bbe\u7f6e\u4e3a\u201cBACKUP, FORCE\u201d\u3002\u8fd9\u6837\u7684\u8bdd\uff0c\u5c31\u5f3a\u5236\u4fee\u590d\u5373\u4fbf\u6709\u4eba\u5220\u9664\u6570\u636e\uff0c\u4fee\u590d\u5b8c\u4e86\u8fd8\u53ef\u4ee5\u7528\u5907\u4efd\u6570\u636e\u67e5\u770b\u53d1\u751f\u60c5\u51b5\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

35\u3001 myisam_repair_threads | 1
\nmyisam_repair_threads =1 \u5219\u5728repair by sort\u65f6\uff0cMyISAM\u8868\u7d22\u5f15\u5728\u5404\u81ea\u7ebf\u7a0b\u4e2d\u5e76\u53d1\u521b\u5efa\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40|\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba41 \u503c\u57df\uff1a1~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba41 \u503c\u57df\uff1a1~18446744073709547520<\/h2>\n

36\u3001 myisam_sort_buffer_size | 31457280
\nREPAIR TABLE\u6216\u5219 CREATE INDEX \u548c ALTER TABLE\u521b\u5efa\u7d22\u5f15\u7684\u65f6\u5019\uff0c.\u7ed9\u5206\u914d\u7684\u7f13\u51b2\u533a\u7684\u5927\u5c0f\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40|\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba48388608 \u503c\u57df\uff1a4~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba48388608 \u503c\u57df\uff1a4~18446744073709547520<\/h2>\n

37\u3001myisam_stats_method | nulls_unequal
\n\u8be5\u53d8\u91cf\u544a\u8bc9\u670d\u52a1\u5668\uff0c\u5728\u670d\u52a1\u5668\u6536\u96c6\u6709\u5173MyISAM\u8868\u7684\u7d22\u5f15\u503c\u7684\u5206\u5e03\u7edf\u8ba1\u65f6\u5982\u4f55\u5904\u7406NULL\u503c\u3002\u53d8\u91cf\u53ef\u9009\u4e09\u4e2a\u503c\uff1anulls_equal, nulls_unequal, nulls_ignored.
\nNulls_equal \u65f6\uff0c\u6240\u6709null\u503c\u90fd\u88ab\u5f53\u6210\u4e00\u6837\uff0c\u5f62\u6210\u4e00\u4e2a\u5927\u5c0f\u662fnull\u503c\u4e2a\u6570\u7684\u5355\u503c\u7ec4\u3002
\nnulls_unequal\u65f6\uff0cnull\u88ab\u8ba4\u4e3a\u662f\u4e0d\u4e00\u6837\u7684\uff08\u5c3d\u7ba1\u6211\u4eec\u770b\u6765\u662f\u4e00\u6837\uff09\uff0c\u6bcf\u4e2anull\u5f62\u6210\u4e00\u4e2a\u5927\u5c0f\u4e3a1\u7684\u4e0d\u540c\u503c\u7ec4\u3002
\nnulls_ignored\u65f6\uff0c\u503c\u88ab\u5ffd\u7565
\nPS\uff1a\u81f3\u4e8e\u4e3a\u4ec0\u4e48\u8981\u8fd9\u6837\u533a\u522b\u5bf9\u5f85\uff0c\u8fd9\u91cc\u6709\u8bb2\u89e3http:\/\/www.phpben.com\/?post=69<\/h2>\n

38\u3001myisam_use_mmap | OFF
\n\u8fd9\u4e2a\u53d8\u91cf\u5f00\u542f\u7684\u8bdd\uff0c\u5c31\u5229\u7528\u5185\u5b58\u6620\u5c04\u6765\u8bfb\u548c\u5199myisam\u8868\uff0c\u9ed8\u8ba4\u662f\u5173\u95ed\u7684OFF\uff0c\u4e00\u822c\u5185\u5b58\u670d\u9970\u5f88\u5927\u7684\u60c5\u51b5\u4e0b\u662f\u4e0d\u4f1a\u5f00\u542f\u8fd9\u4e00\u9879
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

39\u3001named_pipe | OFF
\n\u8be5\u53d8\u91cf\u6307\u793amysql\u670d\u52a1\u5668\u662f\u5426\u652f\u6301\u7ba1\u9053\u8fde\u63a5\u3002
\n\u53ea\u4f7f\u7528windows\u7cfb\u7edf
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

40\u3001 net_read_timeout | 30
\n\u8bbe\u7f6e\u670d\u52a1\u5668\u653e\u5f03\u8bfb\u524d\u591a\u5c11\u79d2\u4ee5\u7b49\u5230\u66f4\u591a\u7684\u8fde\u63a5\u6570\u636e\uff0c\u5f53\u670d\u52a1\u5668\u4ece\u5ba2\u6237\u7aef\u8bfb\u53d6\uff0cnet_read_timeout\u662f\u8bbe\u65bd\u591a\u5c11\u79d2\u540e\u7ec8\u6b62\u8bfb\uff0c\u800c\u7c7b\u662f\u7684\u53d8\u91cfnet_write_timeout\u8bbe\u7f6e\u7ec8\u6b62\u5199\u3002\u4e5f\u5c31\u662fmysql\u4e3a\u4e86\u4fdd\u8bc1\u8fde\u63a5\u4e0d\u88ab\u6d6a\u8d39\u5728\u65e0\u5c3d\u7684\u7b49\u5f85\u4e2d\uff0cmysql \u901a\u8fc7net_read_timeout\u3001net_write_timeout\u6765\u4e3b\u52a8\u7ec8\u6b62\u8fde\u63a5\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u503c\u57df\uff1a\u9ed8\u8ba430 \u6700\u5c0f\u662f1<\/h2>\n

41\u3001net_write_timeout | 60
\n\u770b\u4e0a\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u503c\u57df\uff1a\u9ed8\u8ba460 \u6700\u5c0f\u662f1<\/h2>\n

42\u3001net_retry_count | 10
\n\u5982\u679c\u8bfb\u6216\u5199\u4e00\u4e2a\u901a\u4fe1\u7aef\u53e3\u4e2d\u65ad\uff0cmysql\u653e\u5f03\u524d\u5c1d\u8bd5\u8fde\u63a5\u7684\u6b21\u6570\u3002\u5728FreeBSD\u7cfb\u7edf\u4e2d\u6b64\u503c\u5e94\u8bbe\u7f6e\u5f88\u9ad8\uff0c\u56e0\u4e3aFreeBSD\u5185\u90e8\u4e2d\u65ad\u88ab\u53d1\u9001\u5230\u6240\u6709\u7ebf\u7a0b\u53bb\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40|\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba410 \u503c\u57df\uff1a1~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba410 \u503c\u57df\uff1a1~18446744073709547520<\/h2>\n

43\u3001 new | OFF
\n\u8be5\u53d8\u91cf\u7528\u4e8emysql4.0\u542f\u7528mysql4.1\u4e00\u4e9b\u65b0\u529f\u80fd\uff0c\u548c\u4e3a\u4e86\u4fdd\u6301\u5411\u540e\u517c\u5bb9\u6027\u3002\u5728mysql5.6\u4e2d\uff0c\u8fd9\u4e2a\u53d8\u91cf\u7684\u503c\u90fd\u662fOFF\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40|\u4f1a\u8bdd
\n\u9ed8\u8ba4\u662fFalse<\/h2>\n

44\u3001 old | OFF
\nOld\u662f\u517c\u5bb9\u6027\u53d8\u91cf\u3002\u9ed8\u8ba4\u88ab\u7981\u7528\uff0c\u5728\u65e7\u7248\u672c\u7684\u670d\u52a1\u5668\u53ef\u4ee5\u901a\u8fc7\u91cd\u542f\u670d\u52a1\u5668\u65f6\u542f\u7528\u3002
\n\u76ee\u524d\uff0cold\u88ab\u542f\u7528\u65f6\uff0c\u5b83\u6539\u53d8\u4f7f\u7528\u7d22\u5f15\u63d0\u793a\u7684\u9ed8\u8ba4\u8303\u56f4\u5230MySQL5.1.17\u4e4b\u524d\u3002\u4e5f\u5c31\u662f\u8bf4\uff0c\u6ca1\u6709FOR\u5b50\u53e5\u4ec5\u9002\u7528\u4e8e\u5982\u4f55\u4f7f\u7528\u7d22\u5f15\u68c0\u7d22\u884c\uff0c\u800c\u4e0d\u662f\u89e3\u51b3ORDER BY\u6216GROUP BY\u5b50\u53e5\u7684\u7d22\u5f15\u63d0\u793a\u3002\u5728\u590d\u5236\u8bbe\u7f6e\u542f\u7528\u8fd9\u4e2a\u53d8\u91cf\u65f6\u8981\u6ce8\u610f\u4e9b\uff0c\u57fa\u4e8e\u8bed\u53e5\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\uff0c\u4e3b\u4ece\u670d\u52a1\u5668\u6709\u4e0d\u540c\u7684\u6a21\u5f0f\u53ef\u80fd\u4f1a\u5bfc\u81f4\u590d\u5236\u9519\u8bef\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u662f\uff1aOFF<\/h2>\n

45\u3001old_alter_table | OFF
\n\u5f53\u8be5\u53d8\u91cf\u88ab\u542f\u7528\uff0c\u5219mysql\u670d\u52a1\u5668\u4e0d\u4f1a\u4f7f\u7528alert table \u4f18\u5316\u65b9\u6cd5\u3002\u5728mysql5.0\u548c\u66f4\u65e9\u7248\u672c\uff0c\u5148\u7528\u4e2a\u4e34\u65f6\u8868\uff0c\u590d\u5236\u6570\u636e\u8fdb\u53bb\uff0c\u7136\u540e\u91cd\u547d\u540d\u5230\u539f\u59cb\u7684\u4e34\u65f6\u8868\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u503c\uff1aOFF<\/h2>\n

46\u3001old_passwords | OFF
\n\u8be5\u53d8\u91cf\u8bbe\u7f6e\u662f\u5426\u542f\u7528mysql4.1\u4e4b\u524d\u7684\u8d26\u6237\u5bc6\u7801\u7c7b\u578b\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u503c\uff1aOFF<\/h2>\n

47\u3001 open_files_limit | 622
\n\u8bbe\u7f6e\u64cd\u4f5c\u7cfb\u7edf\u5141\u8bb8mysqld\u5141\u8bb8\u6253\u5f00\u7684\u6587\u4ef6\u6570\u3002\u8fd9\u662f\u7cfb\u7edf\u5141\u8bb8\u7684\u771f\u6b63\u503c\uff0c\u53ef\u80fd\u548c\u4f60\u7528--open-files-limit\u9009\u9879\u7ed9mysqld\u6216mysqld_safe\u8bbe\u7f6e\u7684\u503c\u4e0d\u540c\u3002\u8be5\u503c\u662f0\u7684\u7cfb\u7edf\u4e0a\uff0cMySQL\u4e0d\u80fd\u66f4\u6539\u6253\u5f00\u7684\u6587\u4ef6\u6570
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u503c\uff1a0 \u503c\u57df\uff1a0-65535<\/h2>\n

48\u3001optimizer_prune_level | 1
\n\u8be5\u53d8\u91cf\u4e3a1\uff0c\u63a7\u5236\u542f\u53d1\u5f0f\u5e94\u7528\u5728\u67e5\u8be2\u4f18\u5316\u8fc7\u7a0b\u4e2d\uff0c\u4ece\u4f18\u5316\u7a7a\u95f4\u4e2d\u526a\u53bb\u4e0d\u592a\u6709\u7528\u7684\u90e8\u5206\u8ba1\u5212\u3002
\n\u503c0\u7981\u7528\u542f\u53d1\u5f0f\u4f18\u5316\u6267\u884c\u7a77\u4e3e\u641c\u7d22\u3002
\n\u503c1\u65f6\u8ba9\u4f18\u5316\u5668\u6839\u636e\u88ab\u68c0\u7d22\u7684\u884c\u6570\u901a\u8fc7\u4e2d\u95f4\u8ba1\u5212\u6765\u526a\u53bb\u4e0d\u592a\u6709\u7528\u7684\u8ba1\u5212\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u9ed8\u8ba4\u503c\uff1a1
\n\u503c\u57df\u662f\uff1a0\u62161<\/h2>\n

49\u3001 optimizer_search_depth | 62
\n\u67e5\u8be2\u4f18\u5316\u5668\u8fdb\u884c\u7684\u641c\u7d22\u7684\u6700\u5927\u6df1\u5ea6\u3002\u5982\u679c\u503c\u5927\u4e8e\u67e5\u8be2\u4e2d\u7684\u5173\u7cfb\u6570\u5219\u67e5\u8be2\u65b9\u6848\u6bd4\u8f83\u4f73\uff0c\u4f46\u751f\u6210\u67e5\u8be2\u6267\u884c\u65b9\u6848\u9700\u8981\u7684\u65f6\u95f4\u66f4\u957f\u3002\u503c\u5927\u4e8e\u67e5\u8be2\u4e2d\u7684\u5173\u7cfb\u6570\u5219\u8fd4\u56de\u7684\u6267\u884c\u65b9\u6848\u66f4\u5feb\uff0c\u4f46\u65b9\u6848\u8fdc\u6ca1\u6709\u4f18\u5316\u3002\u5982\u679c\u8bbe\u7f6e\u4e3a0, \u7cfb\u7edf\u81ea\u52a8\u9009\u62e9\u5408\u7406\u7684\u503c\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u9ed8\u8ba4\u503c\uff1a62
\n\u503c\u57df\u662f\uff1a0-62
\nps:\u4e0a\u8ff0\u7684\u5173\u7cfb\u6570\u5373\u65f6join\u8fde\u7ed3\u4e2d\u7684\u8868\u6570\u3002
\n\u5982\u679coptimizer_search_depth\u8bbe\u7f6e\u8fc7\u5927\uff0c\u90a3\u4e48join\u65f6\uff0c\u83b7\u53d6\u6700\u4f18\u6267\u884c\u8ba1\u5212\u7684\u4ee3\u4ef7\u5341\u5206\u5de8\u5927\u3002
\noptimizer_search_depth = join tables\u7684\u6570\u91cf\uff0c\u4e00\u5b9a\u80fd\u83b7\u5f97\u6700\u4f18\u6267\u884c\u8ba1\u5212(\u6839\u636emysql\u7684\u4ee3\u4ef7\u4f30\u8ba1\u6a21\u578b)\uff0c\u4f46\u662f\u8ba1\u7b97\u4ee3\u4ef7\u5927\u3002
\noptimizer_search_depth < join tables\u7684\u6570\u91cf\uff0c\u83b7\u53d6\u7684\u6267\u884c\u8ba1\u5212\uff0c\u662f\u5c40\u90e8\u6700\u4f18\uff0c\u4f46\u662f\u8ba1\u7b97\u4ee3\u4ef7\u5c0f\u3002
\noptimizer_search_depth\u53c2\u6570\uff0c\u5bf9\u4e8e\u5355\u8868\u67e5\u8be2\u65e0\u610f\u4e49\u3002<\/h2>\n

50\u3001 optimizer_switch | index_merge=on,index_merge_union=on,
\nindex_merge_sort_union=on,index_merge_intersection=on
\n\u4f18\u5316\u5668\u9009\u9879\uff0c\u6709\u5f88\u591a\u9009\u9879\u3002
\nbatched_key_access
\nControls use of BKA join algorithm
\nblock_nested_loop
\nControls use of BNL join algorithm
\nengine_condition_pushdown
\nControls engine condition pushdown
\nindex_condition_pushdown
\nControls index condition pushdown
\nindex_merge
\nControls all Index Merge optimizations
\nindex_merge_intersection
\nControls the Index Merge Intersection Access optimization
\nindex_merge_sort_union
\nControls the Index Merge Sort-Union Access optimization
\nindex_merge_union
\nControls the Index Merge Union Access optimization
\nmrr
\nControls the Multi-Range Read strategy
\nmrr_cost_based
\nControls use of cost-based MRR if mrr=on
\nsemijoin
\nControls all semi-join strategies
\nfirstmatch
\nControls the semi-join FirstMatch strategy
\nloosescan
\nControls the semi-join LooseScan strategy (not to be confused with LooseScan for GROUP BY)
\nmaterialization
\nControls materialization (including semi-join materialization)<\/p>\n

\n\n\n\n\n\n
51\u3001pid_file<\/th>\nC:\\ProgramData\\MySQL\\MySQL Server 5.1\\Data\\Bsky-PC.pid
\n\u8fdb\u7a0bID (PID)\u6587\u4ef6\u7684\u8def\u5f84\u540d\u3002\u53ef\u4ee5\u7528--pid-file\u9009\u9879\u8bbe\u7f6e\u8be5\u53d8\u91cf
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u503c\u57df\u662f\uff1a\u6587\u4ef6\u76ee\u5f55\uff0c\u5b57\u7b26\u4e32<\/th>\n<\/tr>\n<\/thead>\n
52\u3001 plugin_dir<\/td>\nC:\\Program Files\\MySQL\\MySQL Server<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

5.1\\lib\/plugin
\n\u63d2\u4ef6\u76ee\u5f55\u7684\u8def\u5f84\u3002\u5728MySQL 5.1.2\u4e2d\u52a0\u5165\u4e86\u8be5\u53d8\u91cf\u3002
\n\u5982\u679c\u63d2\u4ef6\u76ee\u5f55\u5bf9\u670d\u52a1\u5668\u53ef\u5199\uff0c\u5219\u6709\u53ef\u80fd\u7ed9\u7528\u6237\u901a\u8fc7\u201cSELECT ... INTO DUMPFILE\u201d\u5728\u76ee\u5f55\u4e2d\u5199\u53ef\u6267\u884c\u4ee3\u7801\u3002\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u63d2\u4ef6\u76ee\u5f55\u53ea\u8bfb\u6765\u963b\u6b62\u6216\u8005\u7ed9\u76ee\u5f55\u8bbe\u7f6e--secure-file-priv select\u53ef\u5199\u8001\u4fdd\u6301\u5b89\u5168 \u3002
\n\u7c7b\u578b\uff1a\u76ee\u5f55\u540d
\n\u9ed8\u8ba4\u662f\uff1amysql\u5b89\u88c5\u76ee\u5f55\/lib\/pligin<\/h2>\n

53\u3001 port | 3306
\nMysql\u76d1\u542ctcp\/ip\u7aef\u53e3\u53f7
\n\u9ed8\u8ba43306<\/h2>\n

54\u3001 preload_buffer_size | 32768
\n\u91cd\u8f7d\u7d22\u5f15\u65f6\u5206\u914d\u7684\u7f13\u51b2\u533a\u5927\u5c0f
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u9ed8\u8ba4\u503c\uff1a32768
\n\u503c\u57df\u662f\uff1a1024~1073741824
\n55\u3001 profiling | OFF
\n\u8bbe\u7f6eshow profile \u547d\u4ee4\u662f\u5426\u53ef\u7528\u3002
\n\u5f53profiling=0\/OFF \u5219show profile\u4e0d\u53ef\u7528
\n\u5f53profiling=1\/ON \u5219show profile\u53ef\u7528
\nps: show profile\u662f\u663e\u793a\u67e5\u8be2\u4e00\u4e9b\u4fe1\u606f\u3002<\/h2>\n

56\u3001profiling_history_size | 15
\n\u8bbe\u7f6eshow profile \u547d\u4ee4\u663e\u793a\u591a\u5c11\u6761\u67e5\u8be2\u7684\u3002
\n\u9ed8\u8ba4\u662f15\uff0c\u6700\u5927\u503c\u662f100
\n\u82e5\u6b64\u53d8\u91cf\u7684\u503c\u662f0\u5219profiling=0\/OFF<\/h2>\n

57\u3001protocol_version | 10
\nMySQL\u670d\u52a1\u5668\u4f7f\u7528\u7684\u5ba2\u6237\u7aef\/\u670d\u52a1\u5668\u534f\u8bae\u7684\u7248\u672c
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

58\u3001 pseudo_thread_id | 0
\n\u8fd9\u4e2a\u53d8\u91cf\u662f\u5185\u90e8\u670d\u52a1\u5668\u4f7f\u7528\u3002<\/h2>\n

59\u3001query_alloc_block_size | 8192
\n\u8bed\u53e5\u89e3\u6790\u548c\u6267\u884c\u8fc7\u7a0b\u4e2d\u521b\u5efa\u7684\u5bf9\u8c61\u5206\u914d\u7684\u5185\u5b58\u5757\u5206\u914d\u5927\u5c0f\u3002\u5982\u679c\u4f60\u6709\u5185\u5b58\u788e\u7247\u7684\u95ee\u9898\uff0c\u5b83\u53ef\u80fd\u6709\u52a9\u4e8e\u63d0\u9ad8\u6b64\u53c2\u6570\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\uff0c\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba48192 \u503c\u57df\uff1a1024~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba48192 \u503c\u57df\uff1a1024~18446744073709547520<\/h2>\n

60\u3001query_cache_limit | 1048576
\n\u4e0d\u8981\u7f13\u5b58\u5927\u4e8e\u8be5\u503c\u7684\u7ed3\u679c\u3002\u9ed8\u8ba4\u503c\u662f1048576(1MB)\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\uff0c\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba41048576 \u503c\u57df\uff1a0~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba41048576 \u503c\u57df\uff1a0~18446744073709547520<\/h2>\n

61\u3001 query_cache_min_res_unit | 4096
\n\u67e5\u8be2\u7f13\u5b58\u5206\u914d\u7684\u6700\u5c0f\u5757\u7684\u5927\u5c0f(\u5b57\u8282)\u3002 \u9ed8\u8ba4\u503c\u662f4096(4KB)
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba44096 \u503c\u57df\uff1a512~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba44096 \u503c\u57df\uff1a512~18446744073709547520<\/h2>\n

62\u3001query_cache_size | 104857600
\n\u4e3a\u7f13\u5b58\u67e5\u8be2\u7ed3\u679c\u5206\u914d\u7684\u5185\u5b58\u7684\u6570\u91cf\u3002\u9ed8\u8ba4\u503c\u662f0\uff0c\u5373\u7981\u7528\u67e5\u8be2\u7f13\u5b58\u3002
\n\u8bf7\u6ce8\u610f\u5373\u4f7fquery_cache_type\u8bbe\u7f6e\u4e3a0\u4e5f\u5c06\u5206\u914d\u6b64\u6570\u91cf\u7684\u5185\u5b58\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba40 \u503c\u57df\uff1a0~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba40 \u503c\u57df\uff1a0~18446744073709547520<\/h2>\n

63\u3001query_cache_type | ON
\n\u8bbe\u7f6e\u67e5\u8be2\u7f13\u5b58\u7c7b\u578b\u3002\u8bbe\u7f6eGLOBAL\u503c\u53ef\u4ee5\u8bbe\u7f6e\u540e\u9762\u7684\u6240\u6709\u5ba2\u6237\u7aef\u8fde\u63a5\u7684\u7c7b\u578b\u3002\u5ba2\u6237\u7aef\u53ef\u4ee5\u8bbe\u7f6eSESSION\u503c\u4ee5\u5f71\u54cd\u4ed6\u4eec\u81ea\u5df1\u5bf9\u67e5\u8be2\u7f13\u5b58\u7684\u4f7f\u7528\u3002\u4e0b\u9762\u7684\u8868\u663e\u793a\u4e86\u53ef\u80fd\u7684\u503c\u3002
\n0\u6216OFF
\n\u4e0d\u8981\u7f13\u5b58\u6216\u67e5\u8be2\u7ed3\u679c\u3002\u8bf7\u6ce8\u610f\u8fd9\u6837\u4e0d\u4f1a\u53d6\u6d88\u5206\u914d\u7684\u67e5\u8be2\u7f13\u5b58\u533a\u3002\u8981\u60f3\u53d6\u6d88\uff0c\u4f60\u5e94\u5c06query_cache_size\u8bbe\u7f6e\u4e3a0\u3002
\n1\u6216ON
\n\u7f13\u5b58\u9664\u4e86\u4ee5SELECT SQL_NO_CACHE\u5f00\u5934\u7684\u6240\u6709\u67e5\u8be2\u7ed3\u679c\u3002
\n2\u6216DEMAND
\n\u53ea\u7f13\u5b58\u4ee5SELECT SQL_NO_CACHE\u5f00\u5934\u7684\u67e5\u8be2\u7ed3\u679c\u3002<\/h2>\n

64\u3001query_cache_wlock_invalidate | OFF
\n\u4e00\u822c\u60c5\u51b5\uff0c\u5f53\u5ba2\u6237\u7aef\u5bf9MyISAM\u8868\u8fdb\u884cWRITE\u9501\u5b9a\u65f6\uff0c\u5982\u679c\u67e5\u8be2\u7ed3\u679c\u4f4d\u4e8e\u67e5\u8be2\u7f13\u5b58\u4e2d\uff0c\u5219\u5176\u5b83\u5ba2\u6237\u7aef\u672a\u88ab\u9501\u5b9a\uff0c\u53ef\u4ee5\u5bf9\u8be5\u8868\u8fdb\u884c\u67e5\u8be2\u3002\u5c06\u8be5\u53d8\u91cf\u8bbe\u7f6e\u4e3a1\uff0c\u5219\u53ef\u4ee5\u5bf9\u8868\u8fdb\u884cWRITE\u9501\u5b9a\uff0c\u4f7f\u67e5\u8be2\u7f13\u5b58\u5185\u6240\u6709\u5bf9\u8be5\u8868\u8fdb\u884c\u7684\u67e5\u8be2\u53d8\u5f97\u975e\u6cd5\u3002\u8fd9\u6837\u5f53\u9501\u5b9a\u751f\u6548\u65f6\uff0c\u53ef\u4ee5\u5f3a\u5236\u5176\u5b83\u8bd5\u56fe\u8bbf\u95ee\u8868\u7684\u5ba2\u6237\u7aef\u6765\u7b49\u5f85\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u503c\u57df\uff1a
\n\u9ed8\u8ba4FALSE<\/h2>\n

65\u3001query_prealloc_size | 8192
\n\u7528\u4e8e\u67e5\u8be2\u5206\u6790\u548c\u6267\u884c\u7684\u56fa\u5b9a\u7f13\u51b2\u533a\u7684\u5927\u5c0f\u3002\u5728\u67e5\u8be2\u4e4b\u95f4\u8be5\u7f13\u51b2\u533a\u4e0d\u91ca\u653e\u3002\u5982\u679c\u4f60\u6267\u884c\u590d\u6742\u67e5\u8be2\uff0c\u5206\u914d\u66f4\u5927\u7684query_prealloc_size\u503c\u53ef\u4ee5\u5e2e\u52a9\u63d0\u9ad8\u6027\u80fd\uff0c\u56e0\u4e3a\u5b83\u53ef\u4ee5\u964d\u4f4e\u67e5\u8be2\u8fc7\u7a0b\u4e2d\u670d\u52a1\u5668\u5206\u914d\u5185\u5b58\u7684\u9700\u6c42\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba48192 \u503c\u57df\uff1a8192~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba48192 \u503c\u57df\uff1a8192~18446744073709547520<\/h2>\n

66\u3001rand_seed1 |
\n67\u3001rand_seed2 |
\n\u8fd9\u4e24\u4e2a\u53d8\u91cf\u53ea\u4f5c\u7528\u57df\u53ea\u662f\u4f1a\u8bdd\u5c42\uff0c\u53ef\u4ee5\u53ef\u5199\u4e0d\u53ef\u8bfb\uff0c\u6240\u4ee5\u7528show vriabales\u662f\u663e\u793a\u4e0d\u4e86\u53d8\u91cf\u7684\u503c\u3002
\n\u8fd9\u4e24\u4e2a\u53d8\u91cf\u662f\u4e3a\u4e86\u4f7frand()\u51fd\u6570\u652f\u6301\u88ab\u590d\u5236\u3002\u5728\u542b\u6709rand()\u67e5\u8be2\u4e2d\uff0c\u4e3b\u670d\u52a1\u5668\u5fc5\u987b\u7ed9\u4ece\u670d\u52a1\u5668\u4f20\u9012\u4e24\u4e2a\u503c\uff0c\u5b83\u4eec\u7528\u4e8e\u79cd\u5b50\u968f\u673a\u6570\u53d1\u751f\u5668\u3002\u4ece\u670d\u52a1\u5668\u4f7f\u7528\u8fd9\u4e9b\u503c\u6765\u8bbe\u7f6e\u4f1a\u8bdd\u53d8\u91cfrand_seed1\u548crand_seed2 \u4ee5\u81f3\u4ece\u670d\u52a1\u5668\u4ea7\u751f\u4e0e\u4e3b\u670d\u52a1\u5668\u76f8\u540c\u7684\u503c\u3002<\/h2>\n

68\u3001range_alloc_block_size | 4096
\n\u8be5\u53d8\u91cf\u662f\u8bbe\u7f6e\u8303\u56f4\u4f18\u5316\u65f6\u5206\u914d\u7684\u5757\u7684\u5927\u5c0f\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u9ed8\u8ba48192
\n\u503c\u57df\uff1a8192~ 4294967295<\/h2>\n

69\u3001 read_buffer_size | 2097152
\n\u6bcf\u4e2a\u7ebf\u7a0b\u8fde\u7eed\u626b\u63cf\u65f6\u4e3a\u626b\u63cf\u7684\u6bcf\u4e2a\u8868\u5206\u914d\u7684\u7f13\u51b2\u533a\u7684\u5927\u5c0f(\u5b57\u8282)\u3002\u5982\u679c\u8fdb\u884c\u591a\u6b21\u8fde\u7eed\u626b\u63cf\uff0c\u53ef\u80fd\u9700\u8981\u589e\u52a0\u8be5\u503c\uff0c \u9ed8\u8ba4\u503c\u4e3a131072\u3002\u8be5\u503c\u5e94\u662f4K\u7684\u500d\u6570\uff0c\u5982\u679c\u4e0d\u662f4k\u7684\u500d\u6570\uff0c\u5219\u56de\u6eda\u5230\u6700\u63a5\u8fd14k\u500d\u6570\u7684\u503c\u3002
\n\u503c\u57df\uff1a4K~2G<\/h2>\n

70\u3001read_only | OFF
\n\u5f53\u53d8\u91cf\u5bf9\u590d\u5236\u4ece\u670d\u52a1\u5668\u8bbe\u7f6e\u4e3aON\u65f6\uff0c\u4ece\u670d\u52a1\u5668\u4e0d\u5141\u8bb8\u66f4\u65b0\uff0c\u9664\u975e\u901a\u8fc7\u4ece\u670d\u52a1\u5668\u7684\u7ebf\u7a0b\u6216\u7528\u6237\u62e5\u6709SUPER\u6743\u9650\u3002\u53ef\u4ee5\u786e\u4fdd\u4ece\u670d\u52a1\u5668\u4e0d\u63a5\u53d7\u5ba2\u6237\u7aef\u7684\u66f4\u65b0\u547d\u4ee4\u3002
\nREAD_ONLY\u4e0d\u9002\u7528\u4e34\u65f6\u8868\uff0c\u4e5f\u9632\u6b62\u670d\u52a1\u5668\u65e5\u5fd7\u8868\u63d2\u5165\u884c\uff0c\u8fd9\u4e2a\u53d8\u91cf\u5e76\u4e0d\u59a8\u788d\u5206\u6790TABLE\u6216OPTIMIZE TABLE\u547d\u4ee4\u8bed\u53e5\u7684\u4f7f\u7528\uff0c\u56e0\u4e3a\u5176\u76ee\u7684\u662f\u4e3a\u4e86\u9632\u6b62\u8868\u7684\u7ed3\u6784\u6216\u5185\u5bb9\u7684\u53d8\u5316\u3002
\nREAD_ONLY\u53ea\u5b58\u5728\u4e00\u4e2a\u5168\u5c40\u53d8\u91cf\uff0c\u6240\u4ee5\u9700\u8981SUPER\u6743\u9650\u624d\u80fd\u6539\u53d8\u5176\u503c\u3002\u5728\u4e3b\u670d\u52a1\u5668\u4e0a\u7684\u8bbe\u7f6e\u4e3aREAD_ONLY\u4e0d\u4f1a\u88ab\u590d\u5236\u5230\u4ece\u670d\u52a1\u5668\u3002\u53ef\u4ee5\u5728\u4e3b\u4ece\u670d\u52a1\u5668\u4e0a\u5206\u5f00\u3001\u72ec\u7acb\u7684\u8bbe\u7f6eREAD_ONLY\u7684\u503c\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u662f\uff1afalse<\/h2>\n

71\u3001 read_rnd_buffer_size | 262144
\n\u5f53\u6392\u5e8f\u540e\u6309\u6392\u5e8f\u540e\u7684\u987a\u5e8f\u8bfb\u53d6\u884c\u65f6\uff0c\u5219\u901a\u8fc7\u8be5\u7f13\u51b2\u533a\u8bfb\u53d6\u884c\uff0c\u907f\u514d\u641c\u7d22\u786c\u76d8\u3002\u5c06\u8be5\u53d8\u91cf\u8bbe\u7f6e\u4e3a\u8f83\u5927\u7684\u503c\u53ef\u4ee5\u5927\u5927\u6539\u8fdbORDER BY\u7684\u6027\u80fd\u3002\u4f46\u662f\uff0c\u8fd9\u662f\u4e3a\u6bcf\u4e2a\u5ba2\u6237\u7aef\u5206\u914d\u7684\u7f13\u51b2\u533a\uff0c\u56e0\u6b64\u4f60\u4e0d\u5e94\u5c06\u5168\u5c40\u53d8\u91cf\u8bbe\u7f6e\u4e3a\u8f83\u5927\u7684\u503c\u3002\u76f8\u53cd\uff0c\u53ea\u4e3a\u9700\u8981\u8fd0\u884c\u5927\u67e5\u8be2\u7684\u5ba2\u6237\u7aef\u66f4\u6539\u4f1a\u8bdd\u53d8\u91cf\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u9ed8\u8ba4262144
\n\u503c\u57df\uff1a8200~ 4294967295<\/h2>\n

72\u3001relay_log_index |
\n\u4f7f\u7528\u7684\u4e2d\u7ee7\u65e5\u5fd7\u7d22\u5f15\u6587\u4ef6\u7684\u540d\u79f0\u3002\u9ed8\u8ba4\u540d\u79f0\u662fHOST_NAM_relay_bin.index\u6570\u636e\u76ee\u5f55\u4e2d\uff0c\u5176\u4e2dhost_name\u662f\u4ece\u670d\u52a1\u5668\u7684\u540d\u79f0\u3002
\n\u5982\u679c\u6307\u5b9a\u6b64\u9009\u9879\uff0c\u6307\u5b9a\u7684\u503c\u4e5f\u88ab\u7528\u4f5c\u4e2d\u7ee7\u65e5\u5fd7\u7684\u4e3b\u6863\u540d\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u503c\uff1a\u6587\u4ef6\u540d
\nps\uff1a\u7b14\u8005\u8fd9\u91cc\u6ca1\u6709\u4e2d\u7ee7\u65e5\u5fd7\uff0c\u6240\u4ee5\u4e3a\u7a7a\u3002<\/h2>\n

73\u3001relay_log_info_file | relay-log.info
\n\u8fd9\u662f\u4ece\u670d\u52a1\u5668\u4fdd\u5b58\u4e2d\u7ee7\u65e5\u5fd7\u6709\u5173\u4fe1\u606f\u7684\u6587\u4ef6\u540d\u3002
\n\u9ed8\u8ba4\u662frelay-log.info<\/h2>\n

74\u3001 relay_log_purge | ON
\n\u5f53\u4e0d\u518d\u9700\u8981\u4e2d\u7ee7\u65e5\u5fd7\u65f6\u7981\u7528\u6216\u542f\u7528\u81ea\u52a8\u6e05\u7a7a\u4e2d\u7ee7\u65e5\u5fd7\u3002\u9ed8\u8ba4\u503c\u662f1(\u542f\u7528)\u3002
\n\u8fd9\u662f\u4e00\u4e2a\u5168\u5c40\u53d8\u91cf\u4e14\u53ef\u4ee5\u901a\u8fc7SET GLOBAL relay_log_purge = N.\u6765\u52a8\u6001\u6539\u53d8\u3002<\/h2>\n

75\u3001 relay_log_space_limit | 0
\n\u6240\u6709\u4e2d\u7ee7\u65e5\u5fd7\u7a7a\u95f4\u5927\u5c0f\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba40 \u503c\u57df\uff1a0~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba40 \u503c\u57df\uff1a0~18446744073709547520<\/h2>\n

76\u3001 report_host |
\n-- report_host \u9009\u9879\u7684\u503c
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u5b57\u7b26\u4e32\u7c7b\u578b\u503c<\/h2>\n

77\u3001 report_password |
\n-- report_password \u9009\u9879\u7684\u503c \uff0c\u4e0eMySQL\u7684\u590d\u5236\u7528\u6237\u5e10\u6237\u4f7f\u7528\u7684\u5bc6\u7801\u4e0d\u76f8\u540c\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u5b57\u7b26\u4e32\u7c7b\u578b\u503c<\/h2>\n

78\u3001 report_port | 3306
\n-- report_port \u9009\u9879\u7684\u503c
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u662f0
\nPs:version()>5.6.5<\/h2>\n

79\u3001 report_user |
\n-- report_user \u9009\u9879\u7684\u503c \uff0c\u4e0eMySQL\u7684\u590d\u5236\u7528\u6237\u5e10\u6237\u4f7f\u7528\u7684\u8d26\u6237\u4e0d\u76f8\u540c\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

80\u3001 rpl_recovery_rank | 0<\/h2>\n

81\u3001 secure_auth | OFF
\n\u5982\u679c\u7528--secure-auth\u9009\u9879\u542f\u52a8\u4e86MySQL\u670d\u52a1\u5668\uff0c\u5b83\u5c06\u963b\u585e\u6709\u65e7\u683c\u5f0f(4.1\u4e4b\u524d)\u5bc6\u7801\u7684\u6240\u6709\u8d26\u6237\u6240\u53d1\u8d77\u7684\u8fde\u63a5\u3002\u5728\u8fd9\u79cd\u60c5\u51b5\u4e0b\uff0c\u8be5\u53d8\u91cf\u7684\u503c\u4e3aON\uff0c\u5426\u5219\u4e3aOFF\u3002<\/p>\n

\u5982\u679c\u4f60\u60f3\u8981\u9632\u6b62\u4f7f\u7528\u65e7\u683c\u5f0f\u7684\u5bc6\u7801(\u81f4\u4f7f\u7f51\u7edc\u901a\u4fe1\u4e0d\u5b89\u5168)\uff0c\u4f60\u5e94\u542f\u7528\u8be5\u9009\u9879\u3002
\nVersion()<=5.6.4\u9ed8\u8ba4\u662fOFF
\nVersion()>=5.6.5 \u9ed8\u8ba4\u662fON<\/h2>\n

82\u3001 secure_file_priv |
\n\u8be5\u53d8\u91cf\u9ed8\u8ba4\u4e3a\u7a7a\uff0c\u82e5\u7ed9\u8be5\u53d8\u91cf\u8d4b\u503c\uff08\u76ee\u5f55\uff09\uff0c\u5219\u9650\u5236\u51fd\u6570load_file(),load data,\u548cselect \u2026 into outfile \u8bed\u53e5\u53ea\u6709\u5728\u76f8\u5e94\u76ee\u5f55\u4e0b\u8d77\u4f5c\u7528\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u4e3a\u7a7a<\/h2>\n

83\u3001server_id | 0
\n--server-id\u9009\u9879\u7684\u503c\u3002\u7528\u4e8e\u4e3b\u590d\u5236\u670d\u52a1\u5668\u548c\u4ece\u590d\u5236\u670d\u52a1\u5668\u3002
\n\u9ed8\u8ba4\u503c\uff1a0
\n\u503c\u57df\uff1a0~ 4294967295<\/h2>\n

84\u3001 shared_memory | OFF
\n(\u53ea\u7528\u4e8eWindows)\u670d\u52a1\u5668\u662f\u5426\u5141\u8bb8\u5171\u4eab\u5185\u5b58\u8fde\u63a5\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

85\u3001shared_memory_base_name | MYSQL
\n(\u53ea\u7528\u4e8eWindows)\u8bf4\u660e\u670d\u52a1\u5668\u662f\u5426\u5141\u8bb8\u5171\u4eab\u5185\u5b58\u8fde\u63a5\uff0c\u5e76\u4e3a\u5171\u4eab\u5185\u5b58\u8bbe\u7f6e\u8bc6\u522b\u7b26\u3002\u5f53\u5728\u5355\u53f0\u673a\u5668\u4e0a\u8fd0\u884c\u591a\u4e2aMySQL\u5b9e\u4f8b\u65f6\u5f88\u6709\u7528\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

86\u3001skip_external_locking | ON
\n\u5982\u679cmysqld\u4f7f\u7528\u5916\u90e8\u9501\u5b9a\uff0c\u8be5\u503c\u4e3aOFF\uff0c\u5426\u5219\u662fON\u3002\u8fd9\u4e2a\u5728MYISAM\u8868\u4e2d\u6709\u4f5c\u7528<\/h2>\n

87\u3001skip_name_resolve | OFF
\n\u8fd9\u662f\u53d8\u91cf\u662f\u901a\u8fc7\u9009\u9879\u2014skip-name-resolve\u8bbe\u7f6e\u3002
\n\u82e5\u662fON\uff0c\u5728\u68c0\u67e5\u5ba2\u6237\u7aef\u8fde\u63a5\u65f6\uff0cmysqld\u4f1a\u89e3\u6790\u4e3b\u673a\u540d\u3002
\n\u82e5\u662fOFF\uff0cmysqld\u4f7f\u7528\u552f\u4e00\u7684IP\u53f7\u7801\u548c\u6240\u6709\u5728\u6388\u6743\u8868\u7684Host\u5217\u503c\u5fc5\u987b\u662fIP\u5730\u5740\u6216localhost<\/h2>\n

88\u3001skip_networking | OFF
\n\u5982\u679c\u670d\u52a1\u5668\u53ea\u5141\u8bb8\u672c\u5730(\u975eTCP\/IP)\u8fde\u63a5\uff0c\u8be5\u503c\u4e3aON\u3002\u5728Unix\u4e2d\uff0c\u672c\u5730\u8fde\u63a5\u4f7f\u7528Unix\u5957\u63a5\u5b57\u6587\u4ef6\u3002\u5728Windows\u4e2d\uff0c\u672c\u5730\u8fde\u63a5\u4f7f\u7528\u547d\u540d\u7ba1\u9053\u6216\u5171\u4eab\u5185\u5b58\u3002\u5728NetWare\u4e2d\uff0c\u53ea\u652f\u6301TCP\/IP\u8fde\u63a5\uff0c\u56e0\u6b64\u4e0d\u8981\u5c06\u8be5\u53d8\u91cf\u8bbe\u7f6e\u4e3aON\u3002<\/h2>\n

89\u3001 skip_show_database | OFF
\n\u9632\u6b62\u4e0d\u5177\u6709SHOW DATABASES\u6743\u9650\u7684\u4eba\u4eec\u4f7f\u7528SHOW DATABASES\u8bed\u53e5\u3002\u5982\u679c\u4f60\u62c5\u5fc3\u7528\u6237\u80fd\u591f\u770b\u89c1\u5c5e\u4e8e\u5176\u5b83\u7528\u6237\u7684\u6570\u636e\u5e93\uff0c\u8fd9\u6837\u8bbe\u7f6e\u53ef\u4ee5\u63d0\u9ad8\u5b89\u5168\u6027\u3002\u5176\u6548\u679c\u53d6\u51b3\u4e8eSHOW DATABASES\u6743\u9650\uff1a\u5982\u679c\u53d8\u91cf\u503c\u4e3aON\uff0c\u53ea\u5141\u8bb8\u5177\u6709SHOW DATABASES\u6743\u9650\u7684\u4eba\u4eec\u4f7f\u7528SHOW DATABASES \u8bed\u53e5\uff0c\u5e76\u4e14\u8be5\u8bed\u53e5\u5c06\u663e\u793a\u6240\u6709\u6570\u636e\u5e93\u540d\u3002\u5982\u679c\u503c\u4e3aOFF\uff0c\u5141\u8bb8\u6240\u6709\u7528\u6237\u6267\u884cSHOW DATABASES\uff0c\u4f46\u53ea\u663e\u793a\u7528\u6237\u5177\u6709SHOW DATABASES\u6216\u5176\u5b83\u6743\u9650\u7684\u6570\u636e\u5e93\u7684\u540d\u79f0\u3002
\nps:\u8fd9\u4e2a\u5bf9mysql\u670d\u52a1\u5668\u5b89\u5168\u6027\u80fd\u63d0\u5347\u5f88\u6709\u7528<\/h2>\n

90\u3001 slave_compressed_protocol | OFF
\n\u5982\u679cON\uff0c\u5219\u5728\u4e3b\u3001\u4ece\u670d\u52a1\u5668\u5747\u652f\u6301\uff0c\u4f7f\u7528\u4ece\/\u4e3b\u538b\u7f29\u534f\u8bae\u3002
\n\u9ed8\u8ba4\u662fOFF<\/h2>\n

91\u3001 slave_exec_mode | STRICT
\n\u63a7\u5236\u5728\u590d\u5236\u7684\u51b2\u7a81\u89e3\u51b3\u548c\u9519\u8bef\u68c0\u67e5\u4e2d\u662f\u4f7f\u7528IDEMPOTENT\u6a21\u5f0f\u8fd8\u662fSTRICT\u6a21\u5f0f\u3002
\nIDEMPOTENT\u6a21\u5f0f\u4f1a\u53d1\u751f\u6291\u5236\u91cd\u590d\u952e\u548cno-key-found\u9519\u8bef\uff0c\u8fd9\u79cd\u6a21\u5f0f\u4e0b\uff0c\u5e94\u91c7\u7528\u591a\u4e3b\u590d\u5236\uff0c\u5faa\u73af\u590d\u5236\uff0c\u548c\u5176\u4ed6\u4e00\u4e9b\u7279\u6b8a\u7684\u590d\u5236\u573a\u666f\u3002
\n\u662f\u9ed8\u8ba4\u6a21\u5f0f\uff0c\u5e76\u9002\u7528\u4e8e\u5176\u4ed6\u5927\u591a\u6570\u60c5\u51b5\u4e0b\u3002<\/h2>\n

92\u3001slave_load_tmpdir | C:\\Windows\\TEMP
\n\u8fd9\u662f\u4ece\u670d\u52a1\u5668\u590d\u5236load data infile\u8bed\u53e5\u65f6\u5728\u54ea\u91cc\u751f\u6210\u4e34\u65f6\u6587\u4ef6\u7684\u76ee\u5f55\u3002
\n\u9ed8\u8ba4\u662f\u662f\u7cfb\u7edf\u7684tmp\u6587\u4ef6\u5939\u3002<\/h2>\n

93\u3001slave_net_timeout | 3600
\n\u653e\u5f03\u8bfb\u64cd\u4f5c\u524d\u7b49\u5f85\u4e3b\/\u4ece\u8fde\u63a5\u7684\u66f4\u591a\u6570\u636e\u7684\u7b49\u5f85\u79d2\u6570\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba43600
\n\u6700\u5c0f\u503c1<\/h2>\n

94\u3001 slave_skip_errors | OFF
\n\u6b63\u5e38\u7684\u6765\u8bf4\uff0c\u5f53\u51fa\u73b0\u9519\u8bef\u7684\u65f6\u5019\uff0c\u590d\u5236\u5c31\u4f1a\u505c\u6b62\u3002
\n\u8be5\u53d8\u91cf\u4e3aON\u7684\u65f6\u5019\uff0c\u5219\u544a\u8bc9\u670d\u52a1\u5668\u590d\u5236\u4e0d\u7ba1\u5728\u4efb\u4f55\u9519\u8bef\u63d0\u793a\u7684\u60c5\u51b5\u4e0b\u90fd\u7ee7\u7eed\u8fdb\u884c\u4e0b\u53bb\u3002
\n\u9ed8\u8ba4\uff1aOFF
\n\u503c\u6709\u4ee5\u4e0b\uff1a
\n[list of error codes]
\nall
\nddl_exist_errors<\/h2>\n

95\u3001slave_transaction_retries | 10
\n\u5982\u679c\u56e0\u4e3aInnoDB\u51fa\u73b0\u6b7b\u9501\u6216\u8d85\u8fc7InnoDB\u7684innodb_lock_wait_timeout\u8bbe\u7f6e\u7684\u65f6\u95f4\uff0c\u590d\u5236\u4ece\u670d\u52a1\u5668SQL\u7ebf\u7a0b\u672a\u80fd\u6267\u884c\u4e8b\u52a1\uff0c\u5728\u63d0\u793a\u9519\u8bef\u5e76\u505c\u6b62\u524d\u5b83\u81ea\u52a8\u91cd\u590dslave_transaction_retries\u6b21\u3002 \u9ed8\u8ba4\u503c\u662f10\u3002<\/h2>\n

96\u3001 slow_launch_time | 2
\n\u5f53\u521b\u5efa\u7ebf\u7a0b\u7684\u65f6\u95f4\u8d85\u8fc7\u8be5\u79d2\u6570\uff0c\u670d\u52a1\u5668\u5219\u589e\u52a0Slow_launch_threads\u72b6\u6001\u53d8\u91cf\u3002<\/h2>\n

97\u3001slow_query_log | OFF
\n98\u3001slow_query_log_file | C:\\ProgramData\\MySQL\\MySQL Server 5.
\n1\\Data\\Bsky-PC-slow.log
\nslow_query_log\u662f\u5426\u5f00\u542f\u6162\u67e5\u8be2\u65e5\u5fd7\u3002slow_query_log_file\u662f\u6162\u67e5\u8be2\u65e5\u5fd7\u7684\u8def\u5f84\u3002
\n\u8fd9\u4e2a\u548c\u7b2c\u4e00\u70b9\u7c7b\u4f3c<\/h2>\n

99\u3001 socket | MySQL
\n\u5728uninx\u5e73\u53f0\u4e0a\uff0c\u8be5\u53d8\u91cf\u7684\u503c\u662f\u7528\u4e8e\u672c\u5730\u5ba2\u6237\u7aef\u8fde\u63a5\u7684socket\u6587\u4ef6\u7684\u540d\u5b57\uff0c\u9ed8\u8ba4\u662f\u2018tmp\/mysql.socket\u2019(\u5bf9\u4e8e\u4e00\u4e9b\u5206\u5e03\u5f0f\u4e2d\uff0c\u6bd4\u8f83\u7279\u6b8a\uff0c\u5982RPMs \u4e2d\u662f\/var\/lib\/mysql)
\n\u5728windows\uff0c\u5219\u662f\u672c\u5730\u5ba2\u6237\u7aef\u547d\u540d\u7ba1\u9053\u8fde\u63a5\u7684\u6587\u4ef6\u540d\uff0c\u9ed8\u8ba4\u662fmysql\uff08\u4e0d\u533a\u5206\u5927\u5c0f\u5199\uff09<\/h2>\n

100\u3001 sort_buffer_size | 262144
\n\u6bcf\u4e2a\u6392\u5e8f\u7ebf\u7a0b\u5206\u914d\u7684\u7f13\u51b2\u533a\u7684\u5927\u5c0f\u3002\u589e\u52a0\u8be5\u503c\u53ef\u4ee5\u52a0\u5febORDER BY\u6216GROUP BY\u64cd\u4f5c\u3002
\n\u5f53\u7528show global status\u8f93\u51fa\u4fe1\u606f\u540e\uff0c\u770b\u5230\u5f88\u591aSort_merge_passes\u8f93\u51fa\uff0c\u5219\u8981\u589e\u52a0sort_buffer_size \u7684\u503c\u6765\u63d0\u9ad8order by \u3001group by \u7684\u6027\u80fd\uff0c\u8fd9\u79cd\u60c5\u51b5\u901a\u8fc7\u4f18\u5316\u5668\u4f18\u5316\u548c\u7d22\u5f15\u662f\u4e0d\u8d77\u4f5c\u7528\u3002
\n\u9ed8\u8ba42G \u6700\u59274G
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba42097144 \u503c\u57df\uff1a0~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba42097144 \u503c\u57df\uff1a0~18446744073709547520<\/h2>\n

101\u3001 sql_auto_is_null | ON
\n\u5982\u679csql_auto_is_null=1\/ON\uff0c\u5219\u4f1a\u81ea\u52a8\u7684\u63d2\u5165\u7ed9\u81ea\u52a8\u589e\u957f\u5217\u63d2\u5165\u503c\u3002
\n\u8be5\u503c\u53ef\u4ee5\u901a\u8fc7\u4e00\u4e0b\u6765\u83b7\u53d6
\nSELECT * FROM tbl_name WHERE auto_col IS NULL
\n\u5982\u679c\u6709\u8fd4\u56de\u884c\u6570\u636e\uff0c\u5219\u63d2\u5165\u7684\u6570\u503c\u548clast_insert_id()\u51fd\u6570\u8fd4\u56de\u7684\u503c\u662f\u4e00\u81f4\u3002
\n\u9ed8\u8ba4\u662f0<\/h2>\n

102\u3001 sql_big_tables | OFF
\n\u4fdd\u5b58\u6240\u6709\u4e34\u65f6\u503c\u5728\u6587\u4ef6\u4e2d\u6765\u542f\u7528\u5927\u578b\u7ed3\u679c\u96c6\uff0c\u6b64\u9009\u9879\u53ef\u9632\u6b62\u6700\u201c\u8868\u5df2\u6ee1\u201d\u7684\u9519\u8bef\uff0c\u800c\u4e14\u8fd8\u51cf\u6162\u67e5\u8be2\u5185\u5b58\u4e2d\u7684\u8868\u5c31\u8db3\u591f\u4e86\u3002\u81eaMySQL3.23.2\u4e2d\uff0c\u670d\u52a1\u5668\u80fd\u591f\u5904\u7406\u5927\u7684\u7ed3\u679c\uff0c\u5c0f\u4e34\u65f6\u8868\u4f7f\u7528\u5185\u5b58\u548c\u5207\u6362\u5230\u78c1\u76d8\u8868\u5728\u5fc5\u8981\u65f6\u81ea\u52a8\u8bbe\u7f6e\u3002<\/h2>\n

103\u3001 sql_buffer_result | OFF
\n\u82e5\u662f1\uff0csql_buffer_result\u5f3a\u8feb\u7528select\u8bed\u53e5\u8fd4\u56de\u7684\u7ed3\u679c\u4fdd\u5b58\u5728\u4e34\u65f6\u8868\u3002\u8fd9\u6837\u53ef\u4ee5\u63d0\u524d\u89e3\u5f00\u8868\u7684\u9501\u5b9a\uff0c\u4e14\u5f53\u7ed9\u5ba2\u6237\u7aef\u53d1\u9001\u7ed3\u679c\u96c6\u8981\u5f88\u4e45\u7684\u60c5\u51b5\u4e0b\u5f88\u6709\u7528\u3002
\n\u9ed8\u8ba4\u503c0
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\uff0c\u4f1a\u8bdd<\/h2>\n

104\u3001sql_log_bin | ON
\n\u8be5\u53d8\u91cf\u63a7\u5236\u8bed\u53e5\u662f\u5426\u5199\u8fdb\u4e8c\u8fdb\u5236\u65e5\u5fd7\u3002
\n\u9ed8\u8ba4\u662f\u5f00\u542f\u3002\u901a\u8fc7\u6539\u53d8\u6b64\u53d8\u91cf\u6765\u6539\u53d8\u4f1a\u8bdd\u503c\uff0c\u4e0d\u8fc7\u8981\u6709super\u6743\u9650
\nPs:\u5728version 5.6\u4e2d\u6ca1\u4ea4\u6613\u6216\u5b50\u67e5\u8be2\u7684\u60c5\u51b5\u4e0b\u4e0d\u53ef\u4ee5\u901a\u8fc7set @@session.sql_log_bin\u6765\u8bbe\u7f6e<\/h2>\n

105\u3001sql_log_off | OFF
\n\u8be5\u53d8\u91cf\u63a7\u5236\u662f\u5426\u5199\u8fdb\u5e38\u89c4\u65e5\u5fd7\u3002\u9ed8\u8ba4\u662fOFF\u8868\u793a\u5199\uff0c\u901a\u8fc7\u6539\u53d8\u6b64\u53d8\u91cf\u6765\u6539\u53d8\u4f1a\u8bdd\u503c\uff0c\u4e0d\u8fc7\u8981\u6709super\u6743\u9650<\/h2>\n

106\u3001 sql_log_update | ON
\n\u662f\u5426\u5f00\u542f\u66f4\u65b0\u65e5\u5fd7\u3002\u8be6\u60c5\u53ef\u4ee5\u770bhttp:\/\/www.phpben.com\/?post=67
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

107\u3001 sql_low_priority_updates | OFF
\n\u8be5\u63a7\u5236\u63a7\u5236\u8bfb\u5199\u4f18\u5148\u7ea7\u3002
\n\u82e5\u503c\u4e3a1\/ON\uff0c\u5219\u8bfb\u4f18\u5148\u4e8e\u5199\u3002\u5373\u662f\u6240\u6709INSERT, UPDATE, DELETE\u548c LOCK TABLE WRITE \u8bed\u53e5\u90fd\u8981\u7b49\u6ca1\u6709 SELECT\u6216LOCK TABLE READ\u4f5c\u7528\u4e8e\u8868\u4e0a
\nps:\u4e00\u822c\u60c5\u51b5\u4e0b\u5199\u4f18\u5148\u4e8e\u8bfb<\/h2>\n

108\u3001sql_max_join_size | 18446744073709551615
\n\u4e0d\u5141\u8bb8\u53ef\u80fd\u9700\u8981\u68c0\u67e5\u591a\u4e8emax_join_size\u884c(\u4e3a\u5355\u4e2a\u8868\u8bed\u53e5)\u6216\u884c\u7ec4\u5408(\u4e3a\u591a\u4e2a\u8868\u8bed\u53e5)\u6216\u53ef\u80fd\u6267\u884c\u5927\u4e8emax_join_size\u6b21\u786c\u76d8\u67e5\u8be2\u7684SELECT\u8bed\u53e5\u3002\u901a\u8fc7\u8bbe\u7f6e\u8be5\u503c\uff0c\u4f60\u53ef\u4ee5\u6355\u83b7\u952e\u4f7f\u7528\u4e0d\u6b63\u786e\u5e76\u53ef\u80fd\u82b1\u5f88\u957f\u65f6\u95f4\u7684SELECT\u8bed\u53e5\u3002\u5982\u679c\u7528\u6237\u60f3\u8981\u6267\u884c\u6ca1\u6709WHERE\u5b50\u53e5\u7684\u82b1\u8f83\u957f\u65f6\u95f4\u6216\u8fd4\u56de\u6570\u767e\u4e07\u884c\u7684\u8054\u63a5\uff0c\u5219\u8bbe\u7f6e\u5b83\u3002
\n\u5c06\u8be5\u53d8\u91cf\u8bbe\u7f6e\u4e3aDEFAULT\u4e4b\u5916\u7684\u503c\uff0c\u5c06SQL_BIG_SELECTS\u7684\u503c\u91cd\u8bbe\u4e3a0\u3002\u5982\u679c\u4f60\u91cd\u65b0\u8bbe\u7f6eSQL_BIG_SELECTS\u503c\uff0csql_max_join_size\u53d8\u91cf\u88ab\u5ffd\u7565\u3002
\n\u5982\u679c\u67e5\u8be2\u7ed3\u679c\u4f4d\u4e8e\u67e5\u8be2\u7f13\u5b58\u4e2d\uff0c\u5219\u4e0d\u68c0\u67e5\u7ed3\u679c\u5927\u5c0f\uff0c\u56e0\u4e3a\u524d\u9762\u5df2\u7ecf\u8ba1\u7b97\u4e86\u7ed3\u679c\uff0c\u4e0d\u4f1a\u8981\u6c42\u670d\u52a1\u5668\u5c06\u5b83\u53d1\u9001\u7ed9\u5ba2\u6237\u7aef\u3002
\nps: max_join_size\u7b49\u540c\u4e8esql_max_join_size<\/h2>\n

109\u3001sql_mode | STRICT_TRANS_TABLES,NO_AUTO_CREATE_U
\nSER,NO_ENGINE_SUBSTITUTION <\/h2>\n

110\u3001 sql_notes | ON
\n\u82e5\u662f1\/on,warning_count\u6570\u4f1a\u589e\u52a0\u4e14\u670d\u52a1\u5668\u4f1a\u8bb0\u5f55\u8b66\u544a\u5185\u5bb9\uff0c\u5426\u8005\u4e0d\u4f1a\u3002
\nmysqldump\u8f93\u51fa\u5185\u5bb9\u5230\u8fd9\u4e2a\u53d8\u91cf\u8bbe\u7f6e\u4e3a0\uff0c\u4f7f\u91cd\u8f7d\u8f6c\u50a8\u6587\u4ef6\u4e0d\u4f1a\u4ea7\u751f\u8b66\u544a\u4e8b\u4ef6\u4e0d\u5f71\u54cd\u91cd\u8f7d\u64cd\u4f5c\u7684\u5b8c\u6574\u6027\u3002<\/h2>\n

111\u3001sql_quote_show_create | ON
\n\u82e5\u503c\u4e3a1\uff0c\u5219\u4f1a\u7ed9SHOW CREATE TABLE\u548cSHOW CREATE DATABASE\u6dfb\u52a0\u670d\u52a1\u5668\u5f15\u53f7\u8868\u793a\u7b26
\n\u5426\u5219\u5f15\u53f7\u88ab\u7981\u7528\u3002<\/h2>\n

112\u3001 sql_safe_updates | OFF
\n\u503c\u82e5\u662f1\uff0c\u5219mysql\u5219\u9000\u51fa\u5728where\u548climit\u5b57\u53e5\u4e2d\u6ca1\u5173\u952e\u5b57\u7684update\u6216delete\u8bed\u53e5\u3002\u8fd9\u6709\u5229\u4e8e\u6355\u6293\u5230\u952e\u4f7f\u7528\u4e0d\u5f53\u7684update\u6216delete\u8bed\u53e5\u3002
\n\u9ed8\u8ba4\u503c\u662f0<\/h2>\n

113\u3001sql_select_limit | 18446744073709551615
\n\u8fd9\u662f\u8bbe\u7f6eselect\u67e5\u8be2\u8bed\u53e5\u8fd4\u56de\u6570\u636e\u6700\u5927\u884c\u6570\u3002\u4e00\u4e2a\u65b0\u7684\u8fde\u63a5\u7684\u9ed8\u8ba4\u503c\u662f\u670d\u52a1\u5668\u5141\u8bb8\u6bcf\u4e2a\u8868\u7684\u6700\u5927\u884c\u6570\u3002\u5982\u679c\u4f60\u5df2\u7ecf\u6539\u53d8\u4e86\u6781\u9650\uff0c\u9ed8\u8ba4\u503c\u53ef\u4ee5\u901a\u8fc7\u6307\u5b9a\u4e00\u4e2aDEFAULT\u503c\u6062\u590d\u3002<\/h2>\n

114\u3001sql_slave_skip_counter |
\n\u4ece\u670d\u52a1\u5668\u5e94\u8df3\u8fc7\u7684\u4ece\u4e3b\u670d\u52a1\u5668\u4f20\u6765\u7684\u4e8b\u4ef6\u7684\u6570\u91cf\u3002<\/h2>\n

115\u3001 sql_warnings | OFF
\n\u8be5\u53d8\u91cf\u64cd\u4f5c\u5355\u884c\u63d2\u5165\u6570\u636e\u51fa\u73b0warning\u9519\u8bef\u65f6\u662f\u5426\u4ea7\u751f\u4e00\u4e2awarning\u5b57\u7b26\u4e32\u4fe1\u606f\u3002
\n\u9ed8\u8ba4\u503c\u662f0\uff0c1\u7684\u8bdd\u5c31\u4ea7\u751f\u4fe1\u606f\u3002<\/h2>\n

116\u3001 ssl_ca |
\n\u4e00\u4e2a\u53d7\u4fe1\u4efb\u7684SSL\u7684CA\u5217\u8868\u4e2d\u7684\u6587\u4ef6\u8def\u5f84\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

117\u3001ssl_capath |
\n\u5305\u542b\u53d7\u4fe1\u4efb\u7684SSL PEM\u683c\u5f0f\u7684CA\u8bc1\u4e66\u76ee\u5f55\u7684\u8def\u5f84\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

118\u3001ssl_cert |
\n\u4e3a\u5efa\u7acb\u4e00\u4e2a\u5b89\u5168\u7684\u8fde\u63a5\u4f7f\u7528\u7684SSL\u8bc1\u4e66\u6587\u4ef6\u7684\u540d\u79f0\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

119\u3001 ssl_cipher |
\n\u5141\u8bb8\u4f7f\u7528SSL\u52a0\u5bc6\u7684\u5bc6\u7801\u5217\u8868\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

120\u3001ssl_key |
\n\u4e3a\u5efa\u7acb\u4e00\u4e2a\u5b89\u5168\u7684\u8fde\u63a5\u4f7f\u7528\u7684SSL\u5bc6\u94a5\u6587\u4ef6\u7684\u540d\u79f0\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

121\u3001storage_engine | InnoDB
\n\u9ed8\u8ba4\u7684\u5b58\u50a8\u5f15\u64ce\u3002<\/h2>\n

122\u3001sync_binlog | 0
\n\u5f53\u503c>0,\u5219\u6bcf\u4e00\u4e2async_binlog\u5199\u4e8c\u8fdb\u5236\u65e5\u5fd7\u540emysql\u90fd\u540c\u6b65\u8be5\u65e5\u5fd7\u5230\u78c1\u76d8\u4e2d\uff08fddatasync()\uff09.
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba40 \u503c\u57df\uff1a0~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba40 \u503c\u57df\uff1a0~18446744073709547520<\/h2>\n

123\u3001sync_frm | ON
\n\u82e5\u503c\u4e3a1\uff0c\u4efb\u4f55\u975e\u4e34\u65f6\u8868\u5728\u521b\u5efa\u5176.frm\u6587\u4ef6\u65f6\u4f1a\u540c\u6b65\u5230\u78c1\u76d8\u3002\u8fd9\u4f1a\u901f\u5ea6\u53d8\u6162\u4f46\u6570\u636e\u5954\u6e83\u65f6\u5b89\u5168\u70b9\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u53d8\u91cf\u3002
\n\u9ed8\u8ba4\u662f\uff1atrue<\/h2>\n

124\u3001system_time_zone |
\n\u670d\u52a1\u5668\u7cfb\u7edf\u65f6\u533a\u3002\u5f53 \u670d\u52a1\u5668\u5f00\u59cb\u6267\u884c\u65f6\uff0c\u5b83\u7ee7\u627f\u673a\u5668\u9ed8\u8ba4\u65f6\u533a\u8bbe\u7f6e\u503c\uff0c\u53ef\u4ee5\u7531\u8fd0\u884c\u670d\u52a1\u5668\u7684\u8d26\u6237\u6216\u5728\u542f\u52a8\u811a\u672c\u4e2d\u8fdb\u884c\u4fee\u6539\u3002\u8be5\u503c\u7528\u6765\u8bbe\u7f6esystem_time_zone\u3002\u5178\u578b\u60c5\u51b5\u7528TZ\u73af\u5883\u53d8\u91cf\u6765\u6307\u5b9a\u65f6\u533a\u3002\u8fd8\u53ef\u4ee5\u7528mysqld_safe\u811a\u672c\u7684--timez\u9009\u9879\u6765\u6307\u5b9a\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40 <\/h2>\n

125\u3001table_definition_cache | 256
\n\u53ef\u4ee5\u5b58\u50a8\u5728\u5b9a\u4e49\u7f13\u5b58\u7684\u8868\u5b9a\u4e49\u7684\u6570\u76ee\uff0c\u5982\u679c\u4f7f\u7528\u5927\u91cf\u7684\u8868\uff0c\u4f60\u53ef\u4ee5\u521b\u5efa\u4e00\u4e2a\u5927\u8868\u7684\u5b9a\u4e49\u7f13\u5b58\uff0c\u52a0\u5feb\u5f00\u653e\u8868\uff0c\u4ed6\u8868\u5b9a\u4e49\u7f13\u5b58\u5360\u7528\u8f83\u5c11\u7684\u7a7a\u95f4\uff0c\u5e76\u4e14\u4e0d\u4f7f\u7528\u6587\u4ef6\u63cf\u8ff0\u7b26\uff0c\u4e0d\u50cf\u6b63\u5e38\u7684\u8868\u7f13\u5b58\u3002\u6700\u4f4e\u548c\u9ed8\u8ba4\u503c\u5747\u4e3a400\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u503c\uff1a400
\n\u503c\u57df\uff1a0~ 524288<\/h2>\n

126\u3001 table_lock_wait_timeout | 50
\n\u8fd9\u4e2a\u53c2\u6570\u5df2\u7ecf\u6ca1\u7528\u4e86<\/h2>\n

127\u3001 table_open_cache | 256
\n\u6240\u6709\u7ebf\u7a0b\u4e00\u5171\u80fd\u6253\u5f00\u7684\u8868\u7684\u6570\u91cf\uff0c\u589e\u52a0\u8be5\u503c\u589e\u52a0mysqld\u8981\u6c42\u7684\u6587\u4ef6\u63cf\u8ff0\u7b26\u7684\u6570\u91cf\u3002
\n\u53ef\u4ee5\u901a\u8fc7\u68c0\u67e5Opened_tables\u72b6\u6001\u53d8\u91cf\u6765\u68c0\u67e5\u662f\u5426\u8981\u589e\u52a0\u8be5\u503c\u3002
\n\u5982\u679cOpened_tables\u72b6\u6001\u53d8\u91cf\u5f88\u5927\u5219\u4e0d\u9700\u8981\u7528flush tables\uff0c\u800c\u662f\u600e\u4e48\u8be5\u53d8\u91cf\u7684\u503c\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u9ed8\u8ba4\u503c\uff1a400
\n\u503c\u57df\uff1a400~52488<\/h2>\n

128\u3001table_type | InnoDB
\n\u9ed8\u8ba4\u521b\u5efa\u8868\u65f6\u7528\u5230\u7684\u5f15\u64ce<\/h2>\n

129\u3001thread_cache_size | 8
\n\u8be5\u53d8\u91cf\u8bbe\u7f6e\u591a\u5c11\u4e2a\u7ebf\u7a0b\u670d\u52a1\u5668\u91cd\u7528\u7f13\u5b58\u3002\u5f53\u4e00\u4e2a\u5ba2\u6237\u7aef\u65ad\u5f00\u8fde\u63a5\u7684\u65f6\u5019\uff0c\u8be5\u5ba2\u6237\u7aef\u7684\u7ebf\u7a0b\u603b\u6570\u8fd8\u6ca1\u8d85\u8fc7\u8be5\u503c\u6570\u65f6\uff0c\u5219\u8fd8\u662f\u4fdd\u5b58\u5728\u7f13\u51b2\u533a\u5185\u3002
\n\u5982\u679c\u6709\u5f88\u591a\u65b0\u7684\u8fde\u63a5\uff0c\u5219\u53ef\u4ee5\u901a\u8fc7\u589e\u52a0\u8be5\u503c\u6765\u63d0\u4ea4\u6027\u80fd\u3002
\n\u901a\u5e38\u60c5\u51b5\u4e0b\uff0c\u8fd9\u5e76\u4e0d\u80fd\u63d0\u4f9b\u4e00\u4e2a\u663e\u7740\u7684\u6027\u80fd\u6539\u8fdb\uff0c\u9664\u975e\u4f60\u6709\u4e00\u4e2a\u5f88\u597d\u7684\u7ebf\u7a0b\u6267\u884c\u3002
\n\u4f46\u662f\uff0c\u5982\u679c\u670d\u52a1\u5668\u6bcf\u79d2\u6709\u6210\u5343\u65b0\u8fde\u63a5\u7684\u8bdd\uff0c\u5219\u9700\u8981\u786e\u4fdd\u8be5\u503c\u8db3\u591f\u5927\u4ee5\u81f3\u4e8e\u65b0\u7684\u8fde\u63a5\u7684\u7ebf\u7a0b\u53ef\u4ee5\u4fdd\u5b58\u5728\u7f13\u5b58\u533a\u5185\u3002
\n\u9ed8\u8ba4\u503c\uff1a0
\n\u503c\u57df\uff1a0~16384<\/h2>\n

130\u3001thread_handling | one-thread-per-connection
\n\u670d\u52a1\u5668\u7528\u4ec0\u4e48\u7ebf\u7a0b\u53e5\u67c4\u6765\u63a7\u5236\u8fde\u63a5\u7ebf\u7a0b\u3002
\n\u5f53\u503c\u662fno-theads,\u670d\u52a1\u5668\u4f7f\u7528\u5355\u72ec\u7684\u7ebf\u7a0b
\n\u5f53\u503c\u662fone-thread-per-connection\uff0c\u670d\u52a1\u5668\u7528\u4e00\u4e2a\u7ebf\u7a0b\u63a7\u5236\u6bcf\u4e00\u4e2a\u5ba2\u6237\u8fde\u63a5\u3002
\n\u5f53\u503c\u662fno-threads,\u5728linux\u4e0bdebug\u662f\u5f88\u6709\u7528\u7684\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

131\u3001thread_stack | 196608
\n\u6bcf\u4e2a\u7ebf\u7a0b\u7684\u6808\u7684\u5927\u5c0f\u3002crash-me\u6d4b\u8bd5\u68c0\u6d4b\u5230\u7684\u9650\u5236\uff0c\u5f88\u591a\u90fd\u662f\u4f9d\u8d56\u4e8e\u8fd9\u4e2a\u503c\u3002
\n\u5982\u679c\u7ebf\u7a0b\u7684\u5806\u6808\u5927\u5c0f\u662f\u592a\u5c0f\u4e86\uff0c\u5b83\u9650\u5236\u4e86\u590d\u6742\u7684\u670d\u52a1\u5668\u53ef\u4ee5\u5904\u7406\u7684SQL\u8bed\u53e5\uff0c\u5b58\u50a8\u8fc7\u7a0b\u7684\u9012\u5f52\u6df1\u5ea6\uff0c\u548c\u5176\u4ed6\u6d88\u8017\u5185\u5b58\u7684\u884c\u52a8\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba4196608 \u503c\u57df\uff1a131072~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba4262144 \u503c\u57df\uff1a262144 ~18446744073709547520<\/h2>\n

132\u3001 time_format | %H:%i:%s
\n\u8be5\u53d8\u91cf\u88ab\u5f03\u7528<\/h2>\n

133\u3001time_zone | SYSTEM
\n\u5f53\u524d\u7684\u65f6\u533a\u3002\u521d\u4f7f\u503c\u662f'SYSTEM'(\u4f7f\u7528system_time_zone\u7684\u503c)\uff0c\u4f46\u53ef\u4ee5\u7528--default-time-zone\u9009\u9879\u5728\u670d\u52a1\u5668\u542f\u52a8\u65f6\u663e\u5f0f\u6307\u5b9a\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd<\/h2>\n

134\u3001timed_mutexes | OFF<\/h2>\n

135\u3001 timestamp | 1335315763
\n\u65f6\u95f4\u6233<\/p>\n

\u8bbe\u7f6e\u6b64\u5ba2\u6237\u7aef\u7684\u65f6\u95f4\u3002\u8fd9\u662f\u7528\u6765\u53d6\u5f97\u539f\u59cb\u65f6\u95f4\u6233\uff0c\u5982\u679c\u60a8\u4f7f\u7528\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6062\u590d\u884c\u3002 timestamp_value\u5e94\u8be5\u662f\u4e00\u4e2aUnix\u7eaa\u5143\u65f6\u95f4\u6233\uff0c\u800c\u4e0d\u662f\u4e00\u4e2aMySQL\u65f6\u95f4\u6233\u3002<\/h2>\n

136\u3001 tmp_table_size | 15728640
\n\u5982\u679c\u5185\u5b58\u5185\u7684\u4e34\u65f6\u8868\u8d85\u8fc7\u8be5\u503c\uff0cMySQL\u81ea\u52a8\u5c06\u5b83\u8f6c\u6362\u4e3a\u786c\u76d8\u4e0a\u7684MyISAM\u8868\u3002\u5982\u679c\u4f60\u6267\u884c\u8bb8\u591a\u9ad8\u7ea7GROUP BY\u67e5\u8be2\u5e76\u4e14\u6709\u5927\u91cf\u5185\u5b58\uff0c\u5219\u53ef\u4ee5\u589e\u52a0tmp_table_size\u7684\u503c\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u9ed8\u8ba4\u503c\uff1a0
\n\u503c\u57df\uff1a1024~ 4294967295<\/h2>\n

137\u3001 tmpdir | C:\\Windows\\TEMP
\n\u4e34\u65f6\u76ee\u5f55\u7684\u8def\u5f84<\/h2>\n

138\u3001 transaction_alloc_block_size | 8192
\n\u5c06\u4fdd\u5b58\u5230\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e2d\u7684\u4e8b\u52a1\u7684\u67e5\u8be2\u800c\u5206\u914d\u7684\u5185\u5b58\u5757\u7684\u5927\u5c0f
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba48192 \u503c\u57df\uff1a1024~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba48192\u503c\u57df\uff1a1024 ~18446744073709547520<\/h2>\n

139\u3001transaction_prealloc_size | 4096
\n\u4e3atransaction_alloc_blocks\u5206\u914d\u7684\u56fa\u5b9a\u7f13\u51b2\u533a\u7684\u5927\u5c0f\uff08\u5b57\u8282\uff09\uff0c\u5728\u4e24\u6b21\u67e5\u8be2\u4e4b\u95f4\u4e0d\u4f1a\u91ca\u653e\u3002\u4f7f\u8be5\u503c\u8db3\u591f\u5927\uff0c\u5c06\u6240\u6709\u67e5\u8be2\u56fa\u5b9a\u5230\u4e00\u4e2a\u4e8b\u52a1\u4e2d\uff0c\u53ef\u4ee5\u907f\u514d\u591a\u6b21malloc()\u8c03\u7528\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba44096 \u503c\u57df\uff1a1024~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba44096\u503c\u57df\uff1a1024 ~18446744073709547520<\/h2>\n

140\u3001 tx_isolation | REPEATABLE-READ
\n\u9ed8\u8ba4\u4e8b\u52a1\u9694\u79bb\u7ea7\u522b\u3002\u9ed8\u8ba4\u503c\u4e3aREPEATABLE-READ
\n\u8be5\u53d8\u91cf\u53ef\u4ee5\u88ab\u76f4\u63a5\u8bbe\u7f6e\uff08\u5168\u5c40\uff09\uff0c\u4e5f\u53ef\u4ee5\u901a\u8fc7set transaction=\u503c \u8bed\u53e5\u6765\u8bbe\u7f6e\u3002
\n\u503c\u53ef\u4ee5\u662f\uff1a
\nREAD-UNCOMMITTED
\nREAD-COMMITTED
\nREPEATABLE-READ
\nSERIALIZABLE<\/h2>\n

141\u3001unique_checks | ON
\n\u8be5\u53d8\u91cf\u63a7\u5236\u662f\u5426\u5728InnoDB\u8868\u7684\u8f85\u52a9\u7d22\u5f15\u7684\u552f\u4e00\u6027\u8fdb\u884c\u68c0\u67e5\u3002
\n\u5f53\u503c\u662f0\/OFF\uff0c\u5219\u670d\u52a1\u5668\u5047\u8bbe\u8f93\u5165\u7684\u6570\u636e\u4e0d\u5b58\u5728\u91cd\u590d\u952e\uff0c\u50a8\u5b58\u5f15\u64ce\u5219\u8df3\u8fc7\u8fd0\u884c\u3002\uff08\u8fd9\u4e2a\u662f\u4f60\u8981\u50a8\u5b58\u7684\u6570\u636e\u4e0d\u7528\u552f\u4e00\u6027\uff09
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u9ed8\u8ba4\u503c\u662f1<\/h2>\n

142\u3001updatable_views_with_limit | YES
\n\u8be5\u53d8\u91cf\u63a7\u5236\u5982\u679c\u66f4\u65b0\u5305\u542bLIMIT\u5b50\u53e5\uff0c\u662f\u5426\u53ef\u4ee5\u5728\u5f53\u524d\u8868\u4e2d\u4f7f\u7528\u4e0d\u5305\u542b\u4e3b\u5173\u952e\u5b57\u7684\u89c6\u56fe\u8fdb\u884c\u66f4\u65b0\u3002(\u901a\u5e38\u7528GUI\u5de5\u5177\u751f\u6210\u8fd9\u7c7b\u66f4\u65b0)\u3002\u66f4\u65b0\u6307UPDATE\u6216DELETE\u8bed\u53e5\u3002\u8fd9\u513f\u4e3b\u5173\u952e\u5b57\u6307PRIMARY KEY\uff0c\u6216\u4e00\u4e2aUNIQUE\u7d22\u5f15\uff0c\u5176\u4e2d\u4efb\u4f55\u5217\u4e0d\u53ef\u4ee5\u5305\u542bNULL\u3002
\n\u8be5\u53d8\u91cf\u6709\u4e24\u4e2a\u503c\uff1a
\n\u503c\u662f1\u6216YES\uff1a\u53ea\u53d1\u51fa\u8b66\u544a(\u6ca1\u6709\u9519\u8bef\u6d88\u606f)\u3002\u8fd9\u662f \u9ed8\u8ba4\u503c\u3002
\n\u503c\u662f0\u6216NO\uff1a\u7981\u6b62\u66f4\u65b0\u3002
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u9ed8\u8ba4\u503c\u662f1<\/h2>\n

143\u3001version | 5.1.49-community
\n\u670d\u52a1\u5668\u7684\u7248\u672c\u53f7<\/h2>\n

144\u3001version_comment | MySQL Community Server (GPL)
\nconfigure\u811a\u672c\u6709\u4e00\u4e2a--with-comment\u9009\u9879\uff0c\u5f53\u6784\u5efaMySQL\u65f6\u53ef\u4ee5\u8fdb\u884c\u6ce8\u91ca\u3002\u8be5\u53d8\u91cf\u5305\u542b\u6ce8\u91ca\u503c
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40<\/h2>\n

145\u3001version_compile_machine | ia32
\n\u8be5Mysql\u7a0b\u5e8f\u662f\u7528\u4ec0\u4e48\u5de5\u5177\u7f16\u8bd1\u51fa\u6765\u7684<\/h2>\n

146\u3001version_compile_os | Win32
\n\u8be5Mysql\u7a0b\u5e8f\u662f\u7f16\u8bd1\u65f6\u7684\u64cd\u4f5c\u7cfb\u7edf<\/h2>\n

147\u3001wait_timeout | 28800
\n\u670d\u52a1\u5668\u5173\u95ed\u975e\u4ea4\u4e92\u8fde\u63a5\u4e4b\u524d\u7b49\u5f85\u6d3b\u52a8\u7684\u79d2\u6570
\n\u4f5c\u7528\u57df\uff1a\u5168\u5c40\u3001\u4f1a\u8bdd
\n\u503c\u57df\uff1a
\n32\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba428800 \u503c\u57df\uff1a1~ 4294967295
\n64\u4f4d\u7cfb\u7edf\uff1a\u9ed8\u8ba428800 \u503c\u57df\uff1a1 ~18446744073709547520<\/h2>\n

148\u3001 warning_count | 1
\n\u4e0a\u4e00\u4e2a\u67e5\u8be2\u8bed\u53e5\u51fa\u73b0\u7684errors, warnings, notes\u9519\u8bef\u7684\u6570\u76ee\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u8981\u6df1\u5165\u7814\u7a76mysql\u90a3\u9996\u5148\u5bf9mysql\u7684\u4e00\u4e9b\u7cfb\u7edf\/\u6269\u5c55\u53d8\u91cf\u6709\u4e00\u5b9a\u7684\u4e86\u89e3\uff0c\u56e0\u4e3a\u8fd9\u4e9b\u53d8\u91cf\u4e0d\u4ec5\u51b3\u5b9amysql\u4e00\u4e9b\u914d\u7f6e\u4fe1\u606f\uff0c\u8fd8\u5f71\u54cd\u4e86mysql\u7684\u6027\u80fd\u4f18\u5316\u63d0\u5347\uff0c\u5176\u4e2d\u5305\u62ec\u5b89\u5168\u3001\u4f18\u5316\u3001\u5e76\u53d1\u3001\u590d\u5236\u7b49\u7b49\u3002 \u7b14\u8005\u4e0a\u7f51\u67e5\u4e86\u4e00\u4e0b\uff0c\u8fd9\u4e9b\u8d44\u6599\u6709\u9650\uff0c\u4ee5\u53ca\u5b98\u7f51\u7684\u4e00\u4e2a\u4e2d\u6587\u6587\u6863\u4ecb\u7ecd\u7684\u5185\u5bb9\u7b80\u77ed\uff08\u4e0d\u5305\u62ec\u503c\u57df\uff0c\u4f5c\u7528\u57df\uff0c\u6709\u4e9b\u53d8\u91cf\u538b\u6839\u6ca1\u7ffb\u8bd1\u53ea\u662f\u7ed9\u51fa\u503c\uff09\u6240\u4ee5\u60f3\u5199\u7bc7\u6587\u7ae0\uff0c\u4e00\u6765\u5b66\u4e60\u5de9\u56fa\u4e00\u4e0bmysql\uff0c\u4e8c\u6765\u65b9\u4fbf\u4ee5\u540e\u67e5\u9605\u3002\u5176\u4e2d\u5185\u5bb9\u7b14\u8005\u524d\u540e\u7528\u4e8614\u5929\uff0c\u5c3d\u91cf\u67e5\u9605\u5927\u91cf\u8d44\u6599\uff08\u95ee\u4eba\uff0c\u7f51\u4e0a\u67e5\u9605\uff0c\u81ea\u5df1\u6d4b\u8bd5\uff09\u4ee5\u786e\u4fdd\u5c3d\u53ef\u80fd\u6b63\u786e\uff0c\u4e14\u6709\u4e9b\u76f4\u63a5\u4ece\u5b98\u7f51\u82f1\u6587\u6587\u6863\u7ffb\u8bd1\u8fc7\u6765\uff0c\u4f46\u96be\u514d\u4f1a\u51fa\u73b0\u56e0\u4e3a\u77e5\u8bc6\u7ed3\u6784\u4e0d\u5168\u9762\u800c\u6709\u4ec0\u4e48\u7eb0\u6f0f\u3002 PS\uff1a \u4e00\u3001\u60f3\u77e5\u9053\u6709\u90a3\u4e9b\u53d8\u91cf\uff08\u7cfb\u7edf\u53d8\u91cf\u3001\u72b6\u6001\u53d8\u91cf\u3001\u96c6\u7fa4\u53d8\u91cf\u3001\u65e5\u5fd7\u53d8\u91cf\u2026\uff09\uff0c\u5728mysqladmin \u4e2d\u8f93\u5165\uff1a\u201cmysqladmin \u2013u \u7528\u6237 \u2013p \u5bc6\u7801 variable\u201d \u6216\u8005\u5728mysql\u547d\u4ee4\u7aef\u7528\u201cshow variables\u201d\u663e\u793a \u67e5\u8be2\u53d8\u91cf\u7684\u503c\uff1aselect @@\u53d8\u91cf\u540d; \u4e8c\u3001\u4ee5\u4e0b\u6240\u6709\u6d4b\u8bd5\u7684\u73af\u5883\uff1awin7\u3001mysql 5.1.49-community-log \u4e09\u3001\u4ee5\u4e0b\u53d8\u91cf\u4e2d\u7684\u4f5c\u7528\u57df\u6709\u5168\u5c40\u3001\u4f1a\u8bdd\uff0c\u503c\u57df\u8868\u793a\u53d8\u91cf\u503c\u7684\u8303\u56f4\uff08\u8fd9\u4e9b\u662f\u4e2d\u6587\u6587\u6863\u9501\u6ca1\u6709\u7684\uff09 1\u3001 log_slow_queries | OFF\/ON \u6162\u67e5\u8be2\u8bb0\u5f55\u65e5\u5fd7\uff0c\u6162\u67e5\u8be2\u662f\u6307\u67e5\u8be2\u65f6\u95f4\u8d85\u8fc7\u8bbe\u5b9a\u65f6\u95f4\uff08\u5982\u4e0b\u9762\u8bbe\u4e3a2\u79d2\uff09\u7684\u67e5\u8be2\uff0c\uff08\u8fd8\u6709\u4e2a\u6307\u6807\u662f\u7b2c29\u70b9\u7684min_examined_row_limit\uff09\u8fd9\u4e2a\u53ef\u4ee5\u8bb0\u5f55\u90a3\u4e9b\u67e5\u8be2\u8bed\u53e5\u6bd4\u8f83\u6162\uff0c\u7136\u540e\u901a\u8fc7\u5206\u6790\u8bed\u53e5\u800c\u4f18\u5316\u6570\u636e\u5e93\u6216\u67e5\u8be2\u8bed\u53e5\u3002\u5177\u4f53\u914d\u7f6e\u5728my.ini\u52a0\u5165\uff1a log_show_queries = \u201c\u65e5\u5fd7\u8def\u5f84\/\u6587\u4ef6\u540d\u201d #\u4fdd\u5b58\u65e5\u5fd7\u7684\u8def\u5f84\u548c\u6587\u4ef6\u540d\uff0c\u786e\u4fdd\u6743\u9650\u53ef\u5199 long_query_time = 2 #\u8d85\u8fc7\u591a\u5c11\u79d2\u5219\u4fdd\u5b58\u67e5\u8be2\u6570\u636e log-queries-not-using-indexs #\u4e0d\u4f7f\u7528\u4f7f\u7528\u7d22\u5f15 PS\uff1a\u52a0\u4e0a\u4ee3\u7801\u540e\u91cd\u542fmysql\u540elog_slow_queries=ON\u72b6\u6001\uff08\u9ed8\u8ba4OFF\uff09 \u6d4b\u8bd5\uff1aselect from zd_ask; \u7ed3\u679c\uff1a\u5728\u6307\u5b9a\u7684\u6587\u4ef6\u91cc\u9762\u8bb0\u5f55\u5982\u4e0b C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin\\mysqld, Version: 5.1.49-community-log (MySQL Community Server (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument Time: 120425 20:40:49 User@Host: root[root] @ localhost [127.0.0.1] Query_time: 0.452026 Lock_time: 0.187010 Rows_sent: 12408 Rows_examined: 12408 use bus7zd; SET timestamp=1335357649; select from zd_ask; \u8bf4\u660e\uff1a\u8d85\u8fc7\u65f6\u95f4\u7684\u67e5\u8be2\u8bed\u53e5\uff1aselect * from zd_ask; \u67e5\u5230\u7684\u7ed3\u679c\u6570\uff1a12408 \u65f6\u95f4\uff1a0.452026 \u5176\u4ed6\u5c31\u662f\u73af\u5883\u4fe1\u606f\u3002 \u4f5c\u7528\u57df\uff1a\u5168\u5c40 2\u3001log_warnings | 1 \u9ed8\u8ba4\u503c\u4e3a1\uff0c\u8868\u793a\u5728\u9519\u8bef\u65e5\u5fd7\u5f53\u4e2d\u6dfb\u52a0\u66f4\u591a\u65e5\u5fd7\uff0c\u65e5\u81f3\u683c\u5f0f\uff1a 120426 11:55:09 [Worning]\u5185\u5bb9\uff0c\u4e0a\u7f51\u67e5\u4e86\u4e00\u4e0b\uff0c\u56fd\u5185\u8fd9\u4e2a\u53d8\u91cf\u7684\u8d44\u6599\u5c11\u5f97\u53ef\u601c\uff0c\u67e5\u770b\u5b98\u7f51\u82f1\u6587\u6587\u6863\uff0c\u4f1a\u628a\u4e00\u4e9b\u65ad\u5f00\u94fe\u63a5\u7684\u9519\u8bef\u5199\u8fdb\u9519\u8bef\u65e5\u5fd7\u91cc\u9762\u3002 \u53ef\u4ee5\u5728\u914d\u7f6e\u6587\u4ef6my.ini \u52a0\u5165skip-log-warnings=1\u6765\u505c\u6b62log_warning \u7684\u4f7f\u7528\uff0c skip-log-warnings=1\u540e\u5728mysqladmin \u91cc\u9762\u7528\u201dmysqladmin \u2013u \u7528\u6237\u540d \u2013p\u5bc6\u7801 variables\u201d\u67e5\u770b,\u4f1a\u53d1\u73b0log_warning\u7684\u503c\u662f0\u800c\u4e0d\u662f\u9ed8\u8ba4\u76841. \u4f5c\u7528\u57df\uff1a\u5168\u5c40 3\u3001long_query_time | 10.000000 \u8fd9\u662f\u548clog_slow_queries\u4e00\u8d77\u4f7f\u7528\u7684\uff0c\u5b83\u662f\u8bbe\u7f6e\u6162\u67e5\u8be2\u65f6\u95f4\uff0c\u82e5\u503c\u662f0.2\uff0c\u5219\u67e5\u8be2\u5927\u4e8e0.2\u79d2\u7684\u5b9a\u4e3a\u6162\u67e5\u8be2\u3002\u5982\u679c\u542f\u7528\u4e86\u6162\u67e5\u8be2\u65e5\u5fd7\uff0c\u5219\u4f1a\u628a\u6162\u67e5\u8be2\u7684\u4fe1\u606f\u5199\u5982\u6162\u67e5\u8be2\u65e5\u5fd7\u6587\u4ef6\u4e2d\u3002\u5177\u4f53\u53ef\u4ee5\u67e5\u770b \u4f5c\u7528\u57df\uff1a\u5168\u5c40 \u3001\u4f1a\u8bdd \u672c\u6587\u7b2c\u4e00\u70b9\u3002\u6162\u67e5\u8be2\uff1ahttp:\/\/www.phpben.com\/?post=67 4\u3001 low_priority_updates | OFF \u8fd9\u4e2a\u53d8\u91cf\u662f\u964d\u4f4emysql\u5199\u6570\u636e\u7684\u6743\u9650\u7684\uff0cmysql\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u5199\u64cd\u4f5c\u6743\u9650\u9ad8\u4e8e\u8bfb\u64cd\u4f5c\u3002\u9644\u52a0\u4e00\u4e9b\u77e5\u8bc6\uff1a\u5728mysql MYISAM\u8868\u4e2d\u8bfb\u5199\u662f\u4e32\u884c\uff0c\u5373\u662fselect\u65f6\u9501\u8868\uff0cinsert\u7b49\u5f85\u91ca\u653e\u518d\uff0c\u53cd\u4e4b\u4e00\u6837\u3002\u7136\u540e\u4e3a\u4e86\u51cf\u5c11\u9501\u5b58\u548c\u9501\u8bfb\u7684\u9891\u7387\uff0c\u5219\u5f15\u5165\u4e86concurrent_insert\u8fd9\u4e2a\u53d8\u91cf\uff0c\u4f7f\u8bfb\u5199\u80fd\u5e76\u884c\u64cd\u4f5c\uff08\u5177\u4f53\u6839\u636econcurrent_insert\u503c\u8fd8\u6709mysql\u7248\u672c\u800c\u5b9a\uff09 …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","footnotes":""},"categories":[83],"tags":[],"class_list":["post-1398","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1398","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1398"}],"version-history":[{"count":1,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1398\/revisions"}],"predecessor-version":[{"id":1399,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1398\/revisions\/1399"}],"wp:attachment":[{"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1398"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1398"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oneai.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1398"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}