{"id":1293,"date":"2017-01-28T20:59:30","date_gmt":"2017-01-28T12:59:30","guid":{"rendered":"http:\/\/www.royalwzy.com\/?p=1293"},"modified":"2017-01-28T21:30:16","modified_gmt":"2017-01-28T13:30:16","slug":"mysql-ocp-04-%e6%9c%8d%e5%8a%a1%e5%99%a8%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"http:\/\/www.royalwzy.com\/?p=1293","title":{"rendered":"MySQL OCP-04-\u670d\u52a1\u5668\u914d\u7f6e"},"content":{"rendered":"
—\u00a0MySQL\u914d\u7f6e\u9009\u9879;<\/div>\n
1.\u9884\u7f16\u8bd1\u7684\u9009\u9879:<\/div>\n
\u00a0 \u00a0 1.\u5728\u751f\u6210RPM\u5305\u65f6\u6307\u5b9a\u7684\u9009\u9879;<\/div>\n
\u00a0 \u00a0 2.\u5728\u6e90\u7801\u5b89\u88c5\u65f6\u6307\u5b9a\u7684\u9009\u9879;<\/div>\n
2.\u547d\u4ee4\u884c\u9009\u9879:<\/div>\n
\u00a0 \u00a0 1.\u53ef\u4ee5\u5728\u542f\u52a8\u670d\u52a1\u5668(mysqld)\u65f6\u5728\u547d\u4ee4\u884c\u4e0a\u6307\u5b9a\u542f\u52a8\u9009\u9879;<\/div>\n
\u00a0 \u00a0 2.\u9ed8\u8ba4\u60c5\u51b5\u4e0b,\u670d\u52a1\u5668\u5728\u8fd0\u884c\u65f6\u4f7f\u7528\u5176\u914d\u7f6e\u53d8\u91cf\u7684\u9884\u7f16\u8bd1\u503c;\u4f46\u662f,\u5982\u679c\u9ed8\u8ba4\u503c\u4e0d\u9002\u5408\u73af\u5883,\u5219\u53ef\u6dfb\u52a0\u8fd0\u884c\u65f6\u9009\u9879,\u8ba9\u670d\u52a1\u5668\u4f7f\u7528\u5176\u4ed6\u503c\u6765\u6267\u884c\u4ee5\u4e0b\u64cd\u4f5c:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.\u6307\u5b9a\u91cd\u8981\u7684\u76ee\u5f55\u548c\u6587\u4ef6\u7684\u4f4d\u7f6e;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.\u63a7\u5236\u670d\u52a1\u5668\u5199\u5165\u7684\u65e5\u5fd7\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.\u8986\u76d6\u670d\u52a1\u5668\u4e0e\u6027\u80fd\u76f8\u5173\u7684\u53d8\u91cf\u7684\u5185\u7f6e\u503c(\u5373,\u63a7\u5236\u6700\u5927\u540c\u65f6\u8fde\u63a5\u6570\u4ee5\u53ca\u7f13\u51b2\u533a\u548c\u9ad8\u901f\u7f13\u5b58\u7684\u5927\u5c0f);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 4.\u5728\u670d\u52a1\u5668\u542f\u52a8\u65f6\u542f\u7528\u6216\u7981\u7528\u9884\u7f16\u8bd1\u7684\u5b58\u50a8\u5f15\u64ce\u901a\u8fc7\u4f7f\u7528\u547d\u4ee4\u884c\u9009\u9879\u6216\u9009\u9879\u6587\u4ef6,\u6216\u8005\u4f7f\u7528\u4e24\u8005\u7684\u7ec4\u5408,\u53ef\u4ee5\u6307\u5b9a\u670d\u52a1\u5668\u542f\u52a8\u65f6\u7684\u8fd0\u884c\u65f6\u9009\u9879(\u4ee5\u66f4\u6539\u5176\u914d\u7f6e\u548c\u884c\u4e3a);<\/div>\n
\u00a0 \u00a0 3.\u547d\u4ee4\u884c\u9009\u9879\u4f18\u5148\u4e8e\u9009\u9879\u6587\u4ef6\u4e2d\u7684\u4efb\u4f55\u8bbe\u7f6e<\/div>\n
3.\u914d\u7f6e\u6587\u4ef6\u9009\u9879:\u5728\u914d\u7f6e\u6587\u4ef6my.cnf\u4e2d\u6307\u5b9a\u7684\u542f\u52a8\u9009\u9879;\u6700\u5e38\u7528\u7684\u65b9\u5f0f;<\/div>\n
4.\u67e5\u770b\u76f8\u5173\u5e2e\u52a9mysqld\u00a0–verbose\u00a0–help;<\/div>\n
<\/div>\n
—\u00a0\u4f7f\u7528\u9009\u9879\u6587\u4ef6\u7684\u539f\u56e0;<\/div>\n
1.\u5c06\u9009\u9879\u653e\u5728\u6587\u4ef6\u4e2d\u540e,\u4e0d\u9700\u8981\u6bcf\u6b21\u542f\u52a8\u670d\u52a1\u5668\u65f6\u90fd\u5728\u547d\u4ee4\u884c\u4e0a\u6307\u5b9a\u9009\u9879;\u5bf9\u4e8e\u590d\u6742\u7684\u9009\u9879(\u5982\u7528\u4e8e\u914d\u7f6eInnoDB\u8868\u7a7a\u95f4\u7684\u9009\u9879),\u8fd9\u6837\u505a\u66f4\u52a0\u65b9\u4fbf,\u5e76\u4e14\u66f4\u4e0d\u5bb9\u6613\u51fa\u9519;<\/div>\n
2.\u5982\u679c\u6240\u6709\u670d\u52a1\u5668\u9009\u9879\u90fd\u5728\u4e00\u4e2a\u9009\u9879\u6587\u4ef6\u4e2d,\u5219\u53ef\u6982\u89c8\u670d\u52a1\u5668\u7684\u914d\u7f6e\u60c5\u51b5;<\/div>\n
3.MySQL\u7a0b\u5e8f\u53ef\u4ee5\u8bbf\u95ee\u591a\u4e2a\u9009\u9879\u6587\u4ef6\u4e2d\u7684\u9009\u9879,\u8981\u521b\u5efa\u6216\u4fee\u6539\u67d0\u4e2a\u9009\u9879\u6587\u4ef6,\u5fc5\u987b\u62e5\u6709\u8be5\u6587\u4ef6\u7684\u5199\u5165\u6743\u9650;\u5ba2\u6237\u673a\u7a0b\u5e8f\u4ec5\u9700\u8981\u8bfb\u53d6\u8bbf\u95ee\u6743\u9650;<\/div>\n
<\/div>\n
—\u00a0\u9009\u9879\u6587\u4ef6\u7ec4;<\/div>\n
1.\u9009\u9879\u6587\u4ef6\u4e2d\u7684\u9009\u9879\u6309\u7ec4\u8fdb\u884c\u7ec4\u7ec7,\u6bcf\u4e2a\u7ec4\u524d\u9762\u6709\u4e00\u4e2a\u4e3a\u7ec4\u547d\u540d\u7684[group-name]\u884c,\u901a\u5e38,\u7ec4\u540d\u79f0\u662f\u9009\u9879\u7ec4\u9002\u7528\u7684\u7a0b\u5e8f\u7684\u7c7b\u522b\u6216\u540d\u79f0;<\/div>\n
\u9009\u9879\u7ec4\u793a\u4f8b\u5305\u62ec:<\/div>\n
2.[client]:\u7528\u4e8e\u6307\u5b9a\u9002\u7528\u4e8e\u6240\u6709\u5ba2\u6237\u673a\u7a0b\u5e8f\u7684\u9009\u9879;[client]\u7ec4\u7684\u4e00\u4e2a\u5e38\u89c1\u7528\u9014\u662f\u6307\u5b9a\u8fde\u63a5\u53c2\u6570,\u56e0\u4e3a\u5728\u4e00\u822c\u60c5\u51b5\u4e0b,\u4e0d\u7ba1\u4f7f\u7528\u4ec0\u4e48\u5ba2\u6237\u673a\u7a0b\u5e8f,\u90fd\u8981\u5efa\u7acb\u5230\u540c\u4e00\u4e2a\u670d\u52a1\u5668\u7684\u8fde\u63a5;<\/div>\n
3.[mysql]\u548c[mysqldump]:\u5206\u522b\u7528\u4e8e\u6307\u5b9a\u9002\u7528\u4e8emysql\u548cmysqldump\u5ba2\u6237\u673a\u7684\u9009\u9879;\u6b64\u5916,\u4e5f\u53ef\u4ee5\u5355\u72ec\u6307\u5b9a\u5176\u4ed6\u5ba2\u6237\u673a\u9009\u9879;<\/div>\n
4.[server]:\u7528\u4e8e\u6307\u5b9a\u540c\u65f6\u9002\u7528\u4e8emysqld\u548cmysqld_safe\u670d\u52a1\u5668\u7a0b\u5e8f\u7684\u9009\u9879;<\/div>\n
5.[mysqld],[mysqld-5.6],[mysqld56]\u548c[mysqld_safe]:\u7528\u4e8e\u6307\u5b9a\u9002\u7528\u4e8e\u4e0d\u540c\u670d\u52a1\u5668\u7248\u672c\u6216\u542f\u52a8\u65b9\u6cd5\u7684\u9009\u9879;<\/div>\n
<\/div>\n
—\u00a0\u7f16\u5199\u9009\u9879\u6587\u4ef6;<\/div>\n
1.\u8981\u521b\u5efa\u6216\u4fee\u6539\u67d0\u4e2a\u9009\u9879\u6587\u4ef6,\u6700\u7ec8\u7528\u6237\u5fc5\u987b\u62e5\u6709\u8be5\u6587\u4ef6\u7684\u5199\u5165\u6743\u9650;\u670d\u52a1\u5668\u672c\u8eab\u4ec5\u9700\u8981\u8bfb\u53d6\u8bbf\u95ee\u6743\u9650;\u670d\u52a1\u5668\u8bfb\u53d6\u9009\u9879\u6587\u4ef6,\u4f46\u4e0d\u521b\u5efa\u6216\u4fee\u6539\u9009\u9879\u6587\u4ef6;<\/div>\n
2.\u5982\u4f55\u5728\u9009\u9879\u6587\u4ef6\u4e2d\u5199\u5165\u4e00\u4e2a\u9009\u9879:<\/div>\n
\u00a0 \u00a0 1.\u4f7f\u7528\u957f\u9009\u9879\u683c\u5f0f(\u50cf\u547d\u4ee4\u884c\u4e0a\u4f7f\u7528\u7684\u90a3\u6837),\u4f46\u7701\u7565\u524d\u5bfc\u77ed\u5212\u7ebf;<\/div>\n
\u00a0 \u00a0 2.\u5982\u679c\u67d0\u4e2a\u9009\u9879\u53d6\u503c,\u5219\u5141\u8bb8\u5728\u7b49\u53f7\u4e24\u5219\u52a0\u7a7a\u683c(\u00a0=\u00a0);\u6b64\u89c4\u5219\u4e0d\u9002\u7528\u4e8e\u5728\u547d\u4ee4\u884c\u4e0a\u6307\u5b9a\u7684\u9009\u9879,eg:\u6307\u5b9a\u9ed8\u8ba4\u9009\u9879\u6587\u4ef6;<\/div>\n
3.\u5728\u5e7b\u706f\u7247\u4e0a\u7684\u793a\u4f8b\u4e2d,\u8bf7\u6ce8\u610f\u4ee5\u4e0b\u65b9\u9762:<\/div>\n
\u00a0 \u00a0 1.[client]:\u6b64\u7ec4\u4e2d\u7684\u9009\u9879\u9002\u7528\u4e8e\u6240\u6709\u6807\u51c6\u5ba2\u6237\u673a;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.host:\u6307\u5b9a\u670d\u52a1\u5668\u4e3b\u673a\u540d;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.compress:\u6307\u793a\u5ba2\u6237\u673a\/\u670d\u52a1\u5668\u534f\u8bae\u5bf9\u901a\u8fc7\u7f51\u7edc\u53d1\u9001\u7684\u901a\u4fe1\u4f7f\u7528\u538b\u7f29;<\/div>\n
\u00a0 \u00a0 2.[mysql]:\u6b64\u7ec4\u4e2d\u7684\u9009\u9879\u4ec5\u9002\u7528\u4e8emysql\u5ba2\u6237\u673a;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.show-warnings:\u6307\u793aMySQL\u5728\u6bcf\u6761\u8bed\u53e5\u540e\u663e\u793a\u4efb\u4f55\u5f53\u524d\u8b66\u544a;<\/div>\n
\u00a0 \u00a0 3.mysql\u5ba2\u6237\u673a\u540c\u65f6\u4f7f\u7528[client]\u548c[mysql]\u7ec4\u4e2d\u7684\u9009\u9879,\u56e0\u6b64\u5c06\u4f7f\u7528\u663e\u793a\u7684\u5168\u90e8\u4e09\u4e2a\u9009\u9879;<\/div>\n
<\/div>\n
—\u00a0\u9009\u9879\u6587\u4ef6\u4f4d\u7f6e;<\/div>\n
1.Linux:<\/div>\n
\u00a0 \u00a0 1.\/etc\/my.cnf;<\/div>\n
\u00a0 \u00a0 2.\/etc\/mysql\/my.cnf;<\/div>\n
\u00a0 \u00a0 3.\/usr\/local\/mysql\/etc\/my.cnf;<\/div>\n
\u00a0 \u00a0 4.~\/.my.cnf;<\/div>\n
\u00a0 \u00a0 5.\u5982\u679c\u8bbe\u7f6e\u4e86MYSQL_HOME\u73af\u5883\u53d8\u91cf,\u5219\u5c06\u641c\u7d22$MYSQL_HOME\/my.cnf\u6587\u4ef6;<\/div>\n
2.Windows:<\/div>\n
\u00a0 \u00a0 1.C:\\\u76ee\u5f55\u4e0b\u7684my.ini\u548cmy.cnf;<\/div>\n
\u00a0 \u00a0 2.C:\\Windows(\u6216C:\\WinNT)\u76ee\u5f55;<\/div>\n
\u00a0 \u00a0 3.C:\\Program\u00a0Files\\MySQL\\MySQL\u00a0Server\u00a0<version\u00a0number>\u76ee\u5f55;<\/div>\n
3.MySQL\u547d\u4ee4\u884c\u7a0b\u5e8f\u4f1a\u5728MySQL\u5b89\u88c5\u76ee\u5f55\u4e2d\u641c\u7d22\u9009\u9879\u6587\u4ef6;<\/div>\n
<\/div>\n
—\u00a0\u9009\u9879\u6587\u4ef6\u4e2d\u7684\u542f\u52a8\u9009\u9879;<\/div>\n
\u8981\u5728\u9009\u9879\u6587\u4ef6\u4e2d\u6307\u5b9a\u670d\u52a1\u5668\u9009\u9879,\u9700\u8981\u5728[mysqld]\u6216[server]\u7ec4\u4e0b\u6307\u793a\u7279\u5b9a\u9009\u9879;<\/div>\n
1.\u65e5\u5fd7\u8bb0\u5f55:\u53ef\u4ee5\u901a\u8fc7\u542f\u7528\u6240\u9700\u65e5\u5fd7\u7684\u7c7b\u578b\u4e3a\u670d\u52a1\u5668\u542f\u7528\u65e5\u5fd7\u8bb0\u5f55;\u6bd4\u5982:<\/div>\n
\u00a0 \u00a0 1.general_log\u00a0#\u00a0\u5e38\u89c4\u67e5\u8be2\u65e5\u5fd7;<\/div>\n
\u00a0 \u00a0 2.log-bin\u00a0 \u00a0 \u00a0 \u00a0#\u00a0\u4e8c\u8fdb\u5236\u65e5\u5fd7;<\/div>\n
\u00a0 \u00a0 3.slow_query_log\u00a0 \u00a0 #\u00a0\u6162\u901f\u67e5\u8be2\u65e5\u5fd7;<\/div>\n
2.\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce:\u53ef\u4ee5\u4f7f\u7528–default-storage-engine\u9009\u9879\u6307\u5b9a\u4e0d\u540c\u4e8eInnoDB\u7684\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce;<\/div>\n
3.\u7cfb\u7edf\u53d8\u91cf:\u53ef\u4ee5\u901a\u8fc7\u8bbe\u7f6e\u670d\u52a1\u5668\u7cfb\u7edf\u53d8\u91cf\u503c\u6765\u5b9a\u5236\u670d\u52a1\u5668;<\/div>\n
\u00a0 \u00a0 1.max_connections=200\u00a0#\u00a0\u589e\u52a0\u5141\u8bb8\u7684\u6700\u5927\u8fde\u63a5\u6570;<\/div>\n
\u00a0 \u00a0 2.innodb_buffer_pool_instances=4\u00a0 #\u00a0\u589e\u52a0InnoDB\u7f13\u51b2\u6c60\u6570\u7684\u9ed8\u8ba4\u503c;<\/div>\n
4.\u5171\u4eab\u5185\u5b58:\u5728Windows\u4e0a\u9ed8\u8ba4\u4e0d\u542f\u7528;\u53ef\u4ee5\u4f7f\u7528shared-memory\u9009\u9879\u6765\u542f\u7528\u547d\u540d\u7ba1\u9053\u652f\u6301;<\/div>\n
5.\u547d\u540d\u7ba1\u9053:\u8981\u542f\u7528\u547d\u540d\u7ba1\u9053\u652f\u6301,\u4f7f\u7528enable-named-pipe\u9009\u9879;<\/div>\n
<\/div>\n
—\u00a0\u6837\u4f8b\u9009\u9879\u6587\u4ef6;<\/div>\n
1.Linux:<\/div>\n
\u00a0 \u00a0 1.\u5bf9\u4e8eRPM\u5b89\u88c5,\u6837\u4f8b\u9009\u9879\u6587\u4ef6\u5728\/usr\/share\/mysql\u4e2d;<\/div>\n
\u00a0 \u00a0 2.\u5bf9\u4e8eTAR\u6587\u4ef6\u5b89\u88c5,\u6837\u4f8b\u6587\u4ef6\u5728MySQL\u5b89\u88c5\u76ee\u5f55\u4e0b\u7684share\u76ee\u5f55\u4e2d;<\/div>\n
2.Windows:\u9009\u9879\u6587\u4ef6\u4f4d\u4e8eMySQL\u5b89\u88c5\u76ee\u5f55(my.ini)\u4e2d;<\/div>\n
3.\u5982\u679c\u591a\u6b21\u6307\u5b9a\u4e00\u4e2a\u9009\u9879(\u4e0d\u7ba1\u662f\u5728\u540c\u4e00\u4e2a\u9009\u9879\u6587\u4ef6\u4e2d,\u8fd8\u662f\u5728\u591a\u4e2a\u9009\u9879\u6587\u4ef6\u4e2d),\u5219\u6700\u540e<\/div>\n
\u51fa\u73b0\u7684\u9009\u9879\u503c\u4f18\u5148;<\/div>\n
\u00a0 \u00a0 1.–defaults-file=<file_name>:\u4f7f\u7528\u6307\u5b9a\u4f4d\u7f6e\u7684\u9009\u9879\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 2.–defaults-extra-file=<file_name>:\u4f7f\u7528\u6307\u5b9a\u4f4d\u7f6e\u7684\u5176\u4ed6\u9009\u9879\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 3.–no-defaults:\u5ffd\u7565\u6240\u6709\u9009\u9879\u6587\u4ef6;<\/div>\n
eg:\u8981\u4f7f\u7528\/etc\/my-opts.cnf\u6587\u4ef6\u800c\u5ffd\u7565\u6807\u51c6\u9009\u9879\u6587\u4ef6,\u53ef\u4ee5:shell>\u00a0mysql\u00a0–defaults-file=\/etc\/my-opts.cnf;<\/div>\n
<\/div>\n
—\u00a0\u663e\u793a\u9009\u9879\u6587\u4ef6\u4e2d\u7684\u9009\u9879;<\/div>\n
1.#\u00a0my_print_defaults\u00a0–defaults-file=\/usr\/local\/mysql\/my.cnf\u00a0client\u00a0mysql\u00a0mysqld;<\/div>\n
2.#\u00a0mysql\u00a0–print-defaults:\u8c8c\u4f3c\u6253\u5370\u4e0d\u51fa\u6765;<\/div>\n
<\/div>\n
—\u00a0\u906e\u853d\u9a8c\u8bc1\u9009\u9879;<\/div>\n
1.\u5efa\u8bae\u4e0d\u8981\u4f7f\u7528mysql\u00a0-uroot\u00a0-poracle\u5f62\u5f0f\u5728\u547d\u4ee4\u884c\u4e0a\u6307\u5b9a\u53e3\u4ee4;\u7f3a\u70b9:\u53ef\u4ee5\u901a\u8fc7history\u547d\u4ee4\u67e5\u770b\u5230\u5bc6\u7801;<\/div>\n
2.\u4e3a\u65b9\u4fbf\u8d77\u89c1,\u53ef\u4ee5\u5c06\u53e3\u4ee4\u653e\u5728[client]\u9009\u9879\u7ec4\u4e2d,\u4f46\u53e3\u4ee4\u4ee5\u7eaf\u6587\u672c\u65b9\u5f0f\u5b58\u50a8,\u5bf9\u9009\u9879\u6587\u4ef6\u6709\u8bfb\u53d6\u8bbf\u95ee\u6743\u9650\u7684\u4efb\u4f55\u4eba\u90fd\u80fd\u8f7b\u6613\u5730\u770b\u5230;<\/div>\n
3.\u5229\u7528mysql_config_editor\u5b9e\u7528\u7a0b\u5e8f,\u53ef\u4ee5\u5c06\u9a8c\u8bc1\u51ed\u8bc1\u5b58\u50a8\u5728\u52a0\u5bc6\u7684\u767b\u5f55\u6587\u4ef6.mylogin.cnf\u4e2d;\u5728Linux\u548cUNIX\u4e0a,\u8be5\u6587\u4ef6\u4f4d\u7f6e\u662f\u5f53\u524d\u7528\u6237\u7684\u4e3b\u76ee\u5f55;MySQL\u5ba2\u6237\u673a\u7a0b\u5e8f\u4ee5\u540e\u53ef\u4ee5\u8bfb\u53d6\u8be5\u6587\u4ef6\u4ee5\u83b7\u53d6\u7528\u4e8e\u8fde\u63a5\u5230MySQL\u670d\u52a1\u5668\u7684\u9a8c\u8bc1\u51ed\u8bc1;<\/div>\n
TIPS:\u52a0\u5bc6\u65b9\u6cd5\u662f\u53ef\u9006\u7684,\u56e0\u6b64\u4e0d\u5e94\u5047\u8bbe\u51ed\u8bc1\u5bf9\u4efb\u4f55\u6709\u6587\u4ef6\u8bfb\u53d6\u7279\u6743\u7684\u4eba\u90fd\u662f\u5b89\u5168\u7684;\u76f8\u53cd,\u8be5\u529f\u80fd\u4f7f\u5f97\u907f\u514d\u4f7f\u7528\u7eaf\u6587\u672c\u51ed\u8bc1\u53d8\u5f97\u66f4\u5bb9\u6613;<\/div>\n
4.\u6587\u4ef6\u8bf4\u660e:<\/div>\n
.mylogin.cnf\u767b\u5f55\u6587\u4ef6\u7684\u672a\u52a0\u5bc6\u683c\u5f0f\u7531\u9009\u9879\u7ec4\u7ec4\u6210,\u7c7b\u4f3c\u4e8e\u5176\u4ed6\u9009\u9879\u6587\u4ef6;<\/div>\n
.mylogin.cnf\u4e2d\u7684\u6bcf\u4e2a\u9009\u9879\u7ec4\u79f0\u4e3a\u201c\u767b\u5f55\u8def\u5f84\u201d,\u4ec5\u5141\u8bb8\u4e00\u7ec4\u6709\u9650\u7684\u9009\u9879:\u4e3b\u673a,\u7528\u6237\u548c\u53e3\u4ee4;\u53ef\u5c06\u767b\u5f55\u8def\u5f84\u89c6\u4e3a\u4e00\u7ec4\u503c,\u53ef\u4ee5\u6307\u793a\u670d\u52a1\u5668\u4e3b\u673a\u4ee5\u53ca\u7528\u4e8e\u670d\u52a1\u5668\u9a8c\u8bc1\u7684\u51ed\u8bc1;eg:<\/div>\n
\u00a0 \u00a0 [admin]<\/div>\n
\u00a0 \u00a0 user\u00a0=\u00a0root<\/div>\n
\u00a0 \u00a0 password\u00a0=\u00a0oracle<\/div>\n
\u00a0 \u00a0 host\u00a0=\u00a0127.0.0.1<\/div>\n
<\/div>\n
—\u00a0\u767b\u5f55\u8def\u5f84;<\/div>\n
1.\u521b\u5efa\u767b\u5f55\u8def\u5f84:mysql_config_editor\u00a0set\u00a0–login-path=admin\u00a0–host=localhost\u00a0–user=root\u00a0–password;\u5982\u679c\u8c03\u7528mysql_config_editor\u65f6\u4e0d\u4f7f\u7528–login-path\u9009\u9879,\u5219\u5c06\u4f7f\u7528[client]\u767b\u5f55\u8def\u5f84;\u9ed8\u8ba4\u60c5\u51b5\u4e0b,\u6240\u6709\u6807\u51c6\u5ba2\u6237\u673a\u90fd\u4f7f\u7528\u6b64\u767b\u5f55\u8def\u5f84;<\/div>\n
\u00a0 \u00a0 1.\u67e5\u770b\u751f\u6210\u7684\u6587\u4ef6:ll\u00a0~\/.mylogin.cnf;<\/div>\n
\u00a0 \u00a0 2.\u767b\u5f55:mysql\u00a0–login-path=admin;<\/div>\n
2.\u4ee5\u7eaf\u6587\u672c\u683c\u5f0f\u67e5\u770b\u5355\u4e2a\u767b\u5f55\u8def\u5f84:mysql_config_editor\u00a0print\u00a0–login-path=admin;<\/div>\n
3.\u4ee5\u7eaf\u6587\u672c\u683c\u5f0f\u67e5\u770b\u6240\u6709\u767b\u5f55\u8def\u5f84:mysql_config_editor\u00a0print\u00a0–all;<\/div>\n
4.\u5220\u9664\u767b\u5f55\u8def\u5f84:mysql_config_editor\u00a0remove\u00a0–login-path=admin;<\/div>\n
<\/div>\n
—\u00a0\u670d\u52a1\u5668\u7cfb\u7edf\u53d8\u91cf;<\/div>\n
1.\u67e5\u770b\u6240\u6709\u53c2\u6570\u7684\u9ed8\u8ba4\u503c\u548c\u8bfb\u53d6\u9009\u9879\u6587\u4ef6\u4e4b\u540e\u7684\u503c:mysqld\u00a0–verbose\u00a0–help;<\/div>\n
2.\u67e5\u770b\u6240\u6709\u53c2\u6570\u7684\u9ed8\u8ba4\u503c\u548c\u5ffd\u7565\u4efb\u4f55\u9009\u9879\u6587\u4ef6\u4e2d\u7684\u8bbe\u7f6e:mysqld\u00a0–no-defaults\u00a0–verbose\u00a0–help;<\/div>\n
3.\u67e5\u770b\u53d8\u91cf\u503c,\u6ca1\u6709\u5176\u4ed6\u542f\u52a8\u9009\u9879:SHOW\u00a0GLOBAL\u00a0VARIABLES;<\/div>\n
<\/div>\n
—\u00a0\u52a8\u6001\u7cfb\u7edf\u53d8\u91cf;<\/div>\n
1.MySQL\u7ef4\u62a4\u4e86\u4e24\u79cd\u5305\u542b\u7cfb\u7edf\u53d8\u91cf\u7684\u4f5c\u7528\u57df:<\/div>\n
\u00a0 \u00a0 1.GLOBAL\u53d8\u91cf\u5f71\u54cd\u670d\u52a1\u5668\u7684\u6574\u4f53\u64cd\u4f5c;<\/div>\n
\u00a0 \u00a0 2.SESSION\u53d8\u91cf\u5f71\u54cd\u5176\u5bf9\u5355\u4e2a\u5ba2\u6237\u673a\u8fde\u63a5\u7684\u64cd\u4f5c;<\/div>\n
\u00a0 \u00a0 3.\u53d8\u91cf\u5b58\u5728\u4e8e\u4efb\u4e00\u4f5c\u7528\u57df\u4e2d,\u4e5f\u53ef\u540c\u65f6\u5b58\u5728\u4e8e\u4e24\u4e2a\u4f5c\u7528\u57df\u4e2d;<\/div>\n
2.\u53d8\u91cf\u53ca\u5176\u4f5c\u7528\u57df\u7684\u793a\u4f8b\u5305\u62ec:<\/div>\n
\u00a0 \u00a0 1.\u4ec5\u5168\u5c40:key_buffer_size,query_cache_size;<\/div>\n
\u00a0 \u00a0 2.\u5168\u5c40\u548c\u4f1a\u8bdd:sort_buffer_size,max_join_size;<\/div>\n
\u00a0 \u00a0 3.\u4ec5\u4f1a\u8bdd:timestamp,error_count;<\/div>\n
3.\u5728\u66f4\u6539\u53d8\u91cf\u503c\u65f6,\u9002\u7528\u4ee5\u4e0b\u51e0\u70b9:<\/div>\n
\u00a0 \u00a0 1.\u8bbe\u7f6e\u4f1a\u8bdd\u53d8\u91cf\u4e0d\u9700\u8981\u4efb\u4f55\u7279\u6b8a\u7279\u6743,\u4f46\u5ba2\u6237\u673a\u53ea\u80fd\u66f4\u6539\u81ea\u5df1\u7684\u4f1a\u8bdd\u53d8\u91cf,\u4e0d\u80fd\u66f4\u6539\u5176\u4ed6\u4efb\u4f55\u5ba2\u6237\u673a\u7684\u4f1a\u8bdd\u53d8\u91cf;<\/div>\n
\u00a0 \u00a0 2.LOCAL\u548c@@local\u662fSESSION\u548c@@session\u7684\u540c\u4e49\u8bcd;<\/div>\n
\u00a0 \u00a0 3.\u5982\u679c\u4e0d\u6307\u5b9aGLOBAL\u6216SESSION,\u5219\u5f53\u4f1a\u8bdd\u53d8\u91cf\u5b58\u5728\u65f6,SET\u5c06\u66f4\u6539\u4f1a\u8bdd\u53d8\u91cf;\u4f1a\u8bdd\u53d8\u91cf\u4e0d\u5b58\u5728\u65f6,\u5c06\u4ea7\u751f\u9519\u8bef;<\/div>\n
TIPS:\u4fee\u6539\u7684\u5168\u5c40\u53c2\u6570\u4e0d\u4f1a\u5728\u9009\u9879\u6587\u4ef6\u4e2d\u53cd\u5e94\u51fa\u6765,\u9700\u8981\u624b\u52a8\u4fee\u6539,\u4ee5\u4fbf\u4e0b\u6b21\u542f\u52a8\u540e\u751f\u6548;\u4e0eOracle\u5bf9\u6bd4;<\/div>\n
<\/div>\n
—\u00a0\u663e\u793a\u52a8\u6001\u7cfb\u7edf\u53d8\u91cf;<\/div>\n
\u8bbe\u5b9a\u7279\u5b9a\u7684\u53d8\u91cf\u65f6\u8981\u6ce8\u610f\u8d4b\u503c\u7684\u7c7b\u578b;<\/div>\n
<\/div>\n
—\u00a0\u7ed3\u6784\u5316\u7cfb\u7edf\u53d8\u91cf;<\/div>\n
1.MySQL\u652f\u6301\u4e00\u79cd\u7ed3\u6784\u5316\u53d8\u91cf\u7c7b\u578b,\u8be5\u53d8\u91cf\u7c7b\u578b\u53ef\u4ee5\u6307\u5b9a\u63a7\u5236\u952e\u9ad8\u901f\u7f13\u5b58\u64cd\u4f5c\u7684\u53c2\u6570;\u952e\u9ad8\u901f\u7f13\u5b58\u7ed3\u6784\u5316\u53d8\u91cf\u5177\u6709\u4ee5\u4e0b\u7ec4\u4ef6:<\/div>\n
\u00a0 \u00a0 1.key_buffer_size;<\/div>\n
\u00a0 \u00a0 2.key_cache_block_size;<\/div>\n
\u00a0 \u00a0 3.key_cache_division_limit;<\/div>\n
\u00a0 \u00a0 4.key_cache_age_threshold;<\/div>\n
2.\u8981\u5f15\u7528\u7ed3\u6784\u5316\u53d8\u91cf\u5b9e\u4f8b\u7684\u7ec4\u4ef6,\u53ef\u4f7f\u7528\u590d\u5408\u540d\u79f0:instance_name.component_name;<\/div>\n
\u793a\u4f8b:hot_cache.key_buffer_size\/hot_cache.key_cache_block_size;cold_cache.key_cache_block_size;<\/div>\n
3.\u76f8\u5173\u6587\u6863:http:\/\/dev.mysql.com\/doc\/refman\/5.6\/en\/structured-system-variables.html\u3002<\/div>\n
<\/div>\n
—\u00a0\u670d\u52a1\u5668\u72b6\u6001\u53d8\u91cf;<\/div>\n
1.LOCAL\u662fSESSION\u7684\u540c\u4e49\u8bcd;<\/div>\n
2.\u5982\u679c\u6ca1\u6709\u4fee\u9970\u7b26,\u5219\u9ed8\u8ba4\u503c\u4e3aSESSION;<\/div>\n
3.SHOW\u00a0STATUS\u793a\u4f8b:mysql>\u00a0SHOW\u00a0GLOBAL\u00a0STATUS;<\/div>\n
<\/div>\n
—\u00a0SQL\u6a21\u5f0f;<\/div>\n
SQL\u6a21\u5f0f\u7531\u63a7\u5236\u67e5\u8be2\u5904\u7406\u67d0\u4e9b\u65b9\u9762\u7684\u53ef\u9009\u503c\u7ec4\u6210,\u8bbe\u7f6e\u4e86\u76f8\u5e94\u7684SQL\u6a21\u5f0f\u540e,\u5ba2\u6237\u673a\u5c31\u53ef\u4ee5\u5bf9\u4ee5\u4e0b\u9879\u76ee\u8fdb\u884c\u67d0\u79cd\u7a0b\u5ea6\u7684\u63a7\u5236:<\/div>\n
\u00a0 \u00a0 1.\u8f93\u5165\u6570\u636e:SQL\u6a21\u5f0f\u53ef\u7528\u4e8e\u6307\u793a\u670d\u52a1\u5668\u5bf9\u63a5\u53d7\u8f93\u5165\u6570\u636e\u7684\u5bbd\u5bb9\u5ea6;<\/div>\n
\u00a0 \u00a0 2.\u6807\u51c6SQL\u7b26\u5408\u6027:SQL\u6a21\u5f0f\u53ef\u7528\u4e8e\u542f\u7528\u6216\u7981\u7528\u4e0e\u6807\u51c6SQL\u7b26\u5408\u6027\u76f8\u5173\u7684\u884c\u4e3a;<\/div>\n
\u00a0 \u00a0 3.\u517c\u5bb9\u6027:SQL\u6a21\u5f0f\u53ef\u7528\u4e8e\u6539\u8fdb\u4e0e\u5176\u4ed6\u6570\u636e\u5e93\u7cfb\u7edf\u7684\u517c\u5bb9\u6027;<\/div>\n
<\/div>\n
—\u00a0\u8bbe\u7f6eSQL\u6a21\u5f0f;<\/div>\n
1.\u53ef\u4ee5\u4f7f\u7528–sql-mode\u9009\u9879\u8bbe\u7f6e\u670d\u52a1\u5668\u542f\u52a8\u65f6\u7684\u9ed8\u8ba4SQL\u6a21\u5f0f;<\/div>\n
2.\u5355\u4e2a\u5ba2\u6237\u673a\u53ef\u6309\u81ea\u5df1\u7684\u8981\u6c42\u5728\u9009\u9879\u6587\u4ef6\u5185\u914d\u7f6eSQL\u6a21\u5f0f;<\/div>\n
3.\u5982\u679c\u6ca1\u6709\u4fee\u9970\u7b26,\u5219SET\u5c06\u66f4\u6539\u4f1a\u8bddSQL\u6a21\u5f0f;\u8c03\u7528SET\u8bed\u53e5\u65f6\u53ef\u4ee5\u5e26\u4e00\u4e2a\u7a7a\u5b57\u7b26\u4e32\u6765\u6e05\u9664\u5f53\u524dSQL\u6a21\u5f0f,\u4e5f\u53ef\u4ee5\u5e26\u4e00\u4e2a\u6216\u591a\u4e2a\u6a21\u5f0f\u540d\u79f0(\u7528\u9017\u53f7\u5206\u9694);<\/div>\n
4.\u5982\u679c\u503c\u4e3a\u7a7a\u6216\u8005\u5305\u542b\u591a\u4e2a\u6a21\u5f0f\u540d\u79f0,\u5219\u5fc5\u987b\u5c06\u503c\u653e\u5728\u5f15\u53f7\u4e2d;\u5982\u679c\u503c\u5305\u542b\u4e00\u4e2a\u6a21\u5f0f\u540d\u79f0,\u5219\u5f15\u53f7\u53ef\u6709\u53ef\u65e0;SQL\u00a0\u6a21\u5f0f\u503c\u4e0d\u533a\u5206\u5927\u5c0f\u5199;<\/div>\n
5.\u67e5\u770b\u5f53\u524d\u7684sql_mode\u6a21\u5f0f:<\/div>\n
\u00a0 \u00a0 1.\u4f7f\u7528SELECT\u8bed\u53e5\u68c0\u67e5\u5f53\u524d\u7684sql_mode\u8bbe\u7f6e:SELECT\u00a0@@sql_mode;<\/div>\n
\u00a0 \u00a0 2.\u67e5\u770b\u7cfb\u7edf\u53d8\u91cf:SHOW\u00a0VARIABLES\u00a0LIKE\u00a0‘sql_mode’;<\/div>\n
\u4f8b\u5b50:<\/div>\n
\u00a0 \u00a0 1.\u4f7f\u7528\u5355\u4e2a\u6a21\u5f0f\u503c\u8bbe\u7f6eSQL\u6a21\u5f0f:SET\u00a0sql_mode\u00a0=\u00a0ANSI_QUOTES;\u00a0SET\u00a0sql_mode\u00a0=\u00a0‘TRADITIONAL’;<\/div>\n
\u00a0 \u00a0 2.\u4f7f\u7528\u591a\u4e2a\u6a21\u5f0f\u540d\u79f0\u8bbe\u7f6eSQL\u6a21\u5f0f:SET\u00a0sql_mode\u00a0=\u00a0‘IGNORE_SPACE,ANSI_QUOTES,NO_ENGINE_SUBSTITUTION’;<\/div>\n
<\/div>\n
—\u00a0\u5e38\u7528SQL\u6a21\u5f0f;<\/div>\n
1.STRICT_TRANS_TABLES,STRICT_ALL_TABLES:\u6ca1\u6709\u8fd9\u4e9b\u6a21\u5f0f,MySQL\u5c06\u63a5\u53d7\u7f3a\u5c11,\u8d85\u51fa\u8303\u56f4\u6216\u683c\u5f0f\u4e0d\u6b63\u786e\u7684\u503c;\u542f\u7528\u00a0STRICT_TRANS_TABLES\u65f6\u5c06\u4e3a\u4e8b\u52a1\u8868\u8bbe\u7f6e\u201c\u4e25\u683c\u6a21\u5f0f\u201d;\u4e5f\u53ef\u5728\u9ed8\u8ba4\u7684my.cnf\u6587\u4ef6\u4e2d\u542f\u7528;\u542f\u7528STRICT_ALL_TABLES\u00a0\u65f6\u5c06\u4e3a\u6240\u6709\u8868\u8bbe\u7f6e\u4e25\u683c\u6a21\u5f0f;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0CREATE\u00a0DATABASE\u00a0db1;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0USE\u00a0db1;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0CREATE\u00a0TABLE\u00a0t(id\u00a0INT);<\/div>\n
\u00a0 \u00a0 mysql>\u00a0INSERT\u00a0INTO\u00a0t\u00a0VALUES\u00a0(‘1’);<\/div>\n
\u00a0 \u00a0 mysql>\u00a0commit;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0INSERT\u00a0INTO\u00a0t\u00a0VALUES\u00a0(‘x’);<\/div>\n
\u00a0 \u00a0 mysql>\u00a0commit;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0SELECT\u00a0*\u00a0FROM\u00a0t;<\/div>\n
\u00a0 \u00a0 +——+<\/div>\n
\u00a0 \u00a0 |\u00a0id\u00a0 \u00a0|<\/div>\n
\u00a0 \u00a0 +——+<\/div>\n
\u00a0 \u00a0 |\u00a0 \u00a0 1\u00a0|<\/div>\n
\u00a0 \u00a0 |\u00a0 \u00a0 0\u00a0|<\/div>\n
\u00a0 \u00a0 +——+<\/div>\n
\u00a0 \u00a0 mysql>\u00a0SELECT\u00a0@@sql_mode;<\/div>\n
\u00a0 \u00a0 +————————+<\/div>\n
\u00a0 \u00a0 |\u00a0@@sql_mode\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0|<\/div>\n
\u00a0 \u00a0 +————————+<\/div>\n
\u00a0 \u00a0 |\u00a0NO_ENGINE_SUBSTITUTION\u00a0|<\/div>\n
\u00a0 \u00a0 +————————+<\/div>\n
\u00a0 \u00a0 mysql>\u00a0SET\u00a0sql_mode=’STRICT_TRANS_TABLES,STRICT_ALL_TABLES’;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0SELECT\u00a0@@sql_mode;<\/div>\n
\u00a0 \u00a0 +—————————————+<\/div>\n
\u00a0 \u00a0 |\u00a0@@sql_mode\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 |<\/div>\n
\u00a0 \u00a0 +—————————————+<\/div>\n
\u00a0 \u00a0 |\u00a0STRICT_TRANS_TABLES,STRICT_ALL_TABLES\u00a0|<\/div>\n
\u00a0 \u00a0 +—————————————+<\/div>\n
\u00a0 \u00a0 mysql>\u00a0INSERT\u00a0INTO\u00a0t\u00a0VALUES\u00a0(‘x’);<\/div>\n
\u00a0 \u00a0 ERROR\u00a01366\u00a0(HY000):\u00a0Incorrect\u00a0integer\u00a0value:\u00a0‘x’\u00a0for\u00a0column\u00a0‘id’\u00a0at\u00a0row\u00a01<\/div>\n
2.TRADITIONAL:\u542f\u7528\u6b64SQL\u6a21\u5f0f\u53ef\u5bf9\u8f93\u5165\u6570\u636e\u503c\u65bd\u52a0\u7c7b\u4f3c\u4e8e\u5176\u4ed6\u6570\u636e\u5e93\u670d\u52a1\u5668\u7684\u9650\u5236;\u5728\u6b64\u6a21\u5f0f\u4e0b,\u4f7f\u7528GRANT\u8bed\u53e5\u53ef\u521b\u5efa\u8981\u6c42\u6307\u5b9a\u53e3\u4ee4\u7684\u7528\u6237;<\/div>\n
3.IGNORE_SPACE:\u9ed8\u8ba4\u60c5\u51b5\u4e0b,\u5fc5\u987b\u8c03\u7528\u51fd\u6570\u540d\u79f0\u4e0e\u540e\u63a5\u62ec\u53f7\u95f4\u6ca1\u6709\u7a7a\u683c\u7684\u51fd\u6570;\u542f\u7528\u6b64\u6a21\u5f0f\u540e,\u5141\u8bb8\u5b58\u5728\u6b64\u7c7b\u7a7a\u683c,\u5e76\u4f7f\u51fd\u6570\u540d\u79f0\u6210\u4e3a\u4fdd\u7559\u5b57;<\/div>\n
4.ERROR_FOR_DIVISION_BY_ZERO:\u9ed8\u8ba4\u60c5\u51b5\u4e0b,\u9664\u6570\u4e3a\u96f6\u65f6\u5c06\u4ea7\u751f\u7ed3\u679cNULL,\u5728\u542f\u7528\u6b64\u6a21\u5f0f\u7684\u60c5\u51b5\u4e0b\u63d2\u5165\u6570\u636e\u65f6,\u9664\u6570\u4e3a\u96f6\u5c06\u5bfc\u81f4\u51fa\u73b0\u8b66\u544a,\u5728\u4e25\u683c\u6a21\u5f0f\u4e0b\u5c06\u51fa\u73b0\u9519\u8bef;(\u8fd9\u4e2a\u6a21\u5f0f\u4e4b\u540e\u4f1a\u88ab\u5e9f\u5f03\u6389)<\/div>\n
\u00a0 \u00a0 mysql>\u00a0INSERT\u00a0INTO\u00a0t\u00a0VALUES\u00a0(2\/1);<\/div>\n
\u00a0 \u00a0 mysql>\u00a0INSERT\u00a0INTO\u00a0t\u00a0VALUES\u00a0(2\/0);<\/div>\n
\u00a0 \u00a0 mysql>\u00a0SET\u00a0sql_mode=’STRICT_TRANS_TABLES,STRICT_ALL_TABLES,ERROR_FOR_DIVISION_BY_ZERO’;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0SELECT\u00a0@@sql_mode;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0INSERT\u00a0INTO\u00a0t\u00a0VALUES\u00a0(2\/0);<\/div>\n
\u00a0 \u00a0 ERROR\u00a01365\u00a0(22012):\u00a0Division\u00a0by\u00a00<\/div>\n
5.ANSI:\u4f7f\u7528\u6b64\u7ec4\u5408\u6a21\u5f0f\u5c06\u4f7fMySQL\u670d\u52a1\u5668\u53d8\u5f97\u66f4\u52a0\u201c\u7c7b\u4f3c\u4e8eANSI\u201d;\u5373,\u6b64\u6a21\u5f0f\u652f\u6301\u7684\u884c\u4e3a\u66f4\u50cf\u6807\u51c6SQL,\u5982ANSI_QUOTES\u548cPIPES_AS_CONCAT;<\/div>\n
6.NO_ENGINE_SUBSTITUTION:\u5982\u679c\u5728\u521b\u5efa\u6216\u66f4\u6539\u8868\u65f6\u6307\u5b9a\u4e86\u4e0d\u53ef\u7528\u7684\u5b58\u50a8\u5f15\u64ce,\u9664\u975e\u542f\u7528\u4e86\u6b64\u6a21\u5f0f,\u5426\u5219MySQL\u00a0\u5c06\u66ff\u6362\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce;\u8fd9\u662f\u9ed8\u8ba4\u7684SQL\u6a21\u5f0f;<\/div>\n
<\/div>\n
—\u00a0\u65e5\u5fd7\u6587\u4ef6;<\/div>\n
1.\u9519\u8bef\u65e5\u5fd7(error\u00a0log):<\/div>\n
\u00a0 \u00a0 1.\u8bb0\u5f55MySQL\u542f\u52a8,\u5173\u95ed\u548c\u8fd0\u884c\u65f6\u4ea7\u751f\u7684\u91cd\u5927\u7684\u9519\u8bef\u7684\u4fe1\u606f;<\/div>\n
\u00a0 \u00a0 2.\u5982\u679cmysqld\u8b66\u544a\u4e00\u4e2a\u8868\u9700\u8981\u81ea\u52a8\u7684\u68c0\u67e5\u6216\u8005\u4fee\u590d,\u4e5f\u4f1a\u8bb0\u5f55\u4e00\u4e2a\u9519\u8bef\u65e5\u5fd7;<\/div>\n
\u00a0 \u00a0 3.\u53ef\u4ee5\u4f7f\u7528–log-error=file_name\u9009\u9879\u6765\u6307\u5b9a\u9519\u8bef\u65e5\u5fd7\u6587\u4ef6,\u5982\u679c\u6ca1\u6709\u6307\u5b9a,\u5219\u7cfb\u7edf\u9ed8\u8ba4\u5728data\u76ee\u5f55\u4e0b\u751f\u4ea7\u4e00\u4e2ahostname.err\u7684\u6587\u4ef6;\u4e5f\u53ef\u4ee5\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u914d\u7f6elog_error\u53d8\u91cf;<\/div>\n
\u00a0 \u00a0 4.\u4e3b\u8981\u662f\u7531mysqld_safe\u811a\u672c\u53ef\u521b\u5efa\u9519\u8bef\u65e5\u5fd7,\u5e76\u5728\u542f\u52a8\u670d\u52a1\u5668\u65f6\u5c06\u5176\u8f93\u51fa\u91cd\u5b9a\u5411\u5230\u8be5\u9519\u8bef\u65e5\u5fd7;<\/div>\n
\u00a0 \u00a0 5.\u67e5\u8be2log_error\u7684\u4f4d\u7f6e:>show\u00a0variables\u00a0like\u00a0‘log_error’;\u67e5\u770b\u4e3b\u673a\u540d:>system\u00a0hostname;<\/div>\n
2.\u5e38\u89c4\u67e5\u8be2\u65e5\u5fd7(general\u00a0query\u00a0log):<\/div>\n
\u00a0 \u00a0 1.\u5e38\u89c4\u67e5\u8be2\u65e5\u5fd7\u8bb0\u5f55\u670d\u52a1\u5668\u8fd0\u884c\u671f\u95f4\u6536\u5230\u7684\u6240\u6709\u8bed\u53e5.\u5f53\u5ba2\u6237\u7aef\u8fde\u63a5\u6216\u8005\u65ad\u5f00\u7684\u65f6\u5019\u670d\u52a1\u5668\u4f1a\u8bb0\u5f55\u4fe1\u606f\u5230\u65e5\u5fd7\u4e2d,\u5e76\u8bb0\u5f55\u6240\u6709\u4ece\u5ba2\u6237\u7aef\u63a5\u6536\u5230\u7684sql\u8bed\u53e5,\u5b83\u5bf9\u4e8e\u5728\u5ba2\u6237\u7aef\u4e2d\u6392\u9519\u548c\u67e5\u770b\u662f\u54ea\u4e2a\u5ba2\u6237\u7aef\u53d1\u9001\u7684\u547d\u4ee4\u5f88\u6709\u5e2e\u52a9;<\/div>\n
\u00a0 \u00a0 2.mysqld\u662f\u6309\u7167\u63a5\u6536\u5230\u547d\u4ee4\u7684\u65b9\u5f0f\u8bb0\u5f55\u8bed\u53e5\u7684,\u8fd9\u53ef\u80fd\u8ddf\u5b83\u4eec\u6267\u884c\u7684\u987a\u5e8f\u4e0d\u540c(\u8fd9\u4e0e\u4e8c\u8fdb\u5236\u65e5\u5fd7\u662f\u6709\u533a\u522b\u7684,\u4e8c\u8fdb\u5236\u65e5\u5fd7\u662f\u6267\u884c\u540e\u8bb0\u5f55);<\/div>\n
\u00a0 \u00a0 3.\u4f7f\u7528–general_log=[0|OFF|1|ON]\u6765\u63a7\u5236\u662f\u5426\u6253\u5f00\u5e38\u89c4\u67e5\u8be2\u65e5\u5fd7\u548c–general_log_file=file_name\u6765\u6307\u5b9a\u751f\u6210\u7684\u5e38\u89c4\u67e5\u8be2\u65e5\u5fd7\u6587\u4ef6(\u5728mysql5.1.6\u4e2d\u53ef\u4ee5\u4f7f\u7528–log\u9009\u9879\u542f\u52a8\u548c\u4f7f\u7528–log-output\u9009\u9879\u6307\u5b9a\u65e5\u5fd7\u8f93\u51fa\u7684\u4f4d\u7f6e),\u4e5f\u53ef\u4ee5\u8f93\u51fa\u5230”Server\u00a0Log\u00a0Tables”\u8868\u4e2d;\u5982\u679c\u6ca1\u6709\u6307\u5b9afile_name,\u9ed8\u8ba4\u662f\u5728data\u76ee\u5f55\u4e0b\u751f\u4ea7\u4e00\u4e2ahostname.log\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 4.\u670d\u52a1\u5668\u91cd\u65b0\u542f\u52a8\u548clog\u00a0flush\u4e0d\u4f1a\u4ea7\u751f\u4e00\u4e2a\u65b0\u7684\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 5.\u9ed8\u8ba4\u6b64\u529f\u80fd\u5173\u95ed,\u901a\u8fc7show\u00a0variables\u00a0like\u00a0‘general_log%’\u6765\u67e5\u770b;<\/div>\n
\u00a0 \u00a0 6.\u8bbe\u7f6e\u6253\u5f00\u4e00\u822c\u67e5\u8be2\u65e5\u5fd7:set\u00a0global\u00a0general_log=1;set\u00a0global\u00a0general_log_file=file_name(\u4e24\u4e2a\u53d8\u91cf\u4f1a\u540c\u65f6\u6253\u5f00\u5173\u95ed,\u6253\u5f00\u4e4b\u540e\u7acb\u5373\u751f\u6548);<\/div>\n
\u00a0 \u00a0 7.\u53ef\u4ee5\u5728\u542f\u52a8\u7684\u65f6\u5019\u6307\u5b9a–general-file\u9009\u9879\u6216\u8005\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6307\u5b9ageneral_log=1,general_file_log=\/path;<\/div>\n
\u00a0 \u00a0 8.\u4e00\u822c\u4e0d\u6253\u5f00\u6b64\u65e5\u5fd7\u529f\u80fd,\u6570\u636e\u91cf\u592a\u5927,\u5982\u679c\u6253\u5f00\u53ef\u4ee5\u653e\u5230\u5355\u72ec\u7684\u78c1\u76d8\u4e2d.<\/div>\n
\u00a0 \u00a0 9.log_output\u53d8\u91cf\u503c:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.FILE:\u4fdd\u5b58\u5230\u6587\u4ef6\u4e2d;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.TABLE:\u4fdd\u5b58\u5230\u8868\u4e2d;SET\u00a0GLOBAL\u00a0log_output\u00a0=\u00a0‘TABLE’;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.\u6e05\u7a7a\u65e5\u5fd7\u8868:TRUNCATE\u00a0mysql.general_log;<\/div>\n
\u00a0 \u00a0 10.\u5907\u4efd\u5207\u6362\u4e00\u822c\u65e5\u5fd7\u6587\u4ef6:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.\u5148\u5907\u4efd:>mv\u00a0hostname.log\u00a0hostname.log.bak<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.\u5207\u6362\u65e5\u5fd7\u7ec4:mysqladmin\u00a0flush-logs;<\/div>\n
3.\u6162\u67e5\u8be2\u65e5\u5fd7(slow\u00a0query\u00a0log):<\/div>\n
\u00a0 \u00a0 1.\u8c03\u4f18\u65f6\u4f7f\u7528,\u8bb0\u5f55\u8d85\u51fa\u6307\u5b9a\u65f6\u95f4\u7684sql\u8bed\u53e5;<\/div>\n
\u00a0 \u00a0 2.\u6162\u67e5\u8be2\u65e5\u5fd7\u4e3b\u8981\u8bb0\u5f55\u6267\u884c\u65f6\u95f4\u8d85\u8fc7long_query_time\u53d8\u91cf\u6307\u5b9a\u65f6\u95f4\u7684sql\u8bed\u53e5,\u8fd9\u4e2a\u65f6\u95f4\u4e0d\u5305\u62ec\u83b7\u5f97\u9501\u7684\u65f6\u95f4,\u53ea\u5305\u542b\u6267\u884c\u65f6\u95f4,\u7cfb\u7edf\u9ed8\u8ba4\u65f6\u95f4\u662f1s(long_query_time=1.0000);<\/div>\n
\u00a0 \u00a0 3.\u4f7f\u7528–slow-query-log=0|1\u9009\u9879\u548c–slow_query_log_file=file_name\u9009\u9879\u6307\u5b9a(\u5728mysql5.1.6\u7248\u672c\u53ef\u4ee5\u6307\u5b9amysqld\u7684–long-slow-queries=file_name\u9009\u9879\u542f\u52a8);<\/div>\n
\u00a0 \u00a0 4.\u547d\u4ee4\u884c\u53c2\u6570:–log-slow-queries=file_name;\u6307\u5b9a\u6162\u67e5\u8be2\u65e5\u5fd7\u6587\u4ef6<\/div>\n
\u00a0 \u00a0 5.\u7cfb\u7edf\u53d8\u91cf:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.slow_query_log:\u5f00\u542f\u6162\u67e5\u8be2\u529f\u80fd,set\u00a0global\u00a0slow_query_log\u00a0=\u00a0[0|OFF|1|ON];<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.slow_query_log_file:\u6307\u5b9a\u6162\u67e5\u8be2\u65e5\u5fd7\u6587\u4ef6,\u7cfb\u7edf\u9ed8\u8ba4\u662f\u5728data\u76ee\u5f55\u4e0b\u7684hostname-slow.log\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.long_query_time:\u6307\u5b9a\u67e5\u8be2\u7684\u6700\u5927\u65f6\u95f4,set\u00a0global\u00a0long_query_time=n;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 4.log_queries_not_using_indexes:\u4e0d\u7528\u7d22\u5f15\u7684\u6162\u67e5\u8be2,\u9ed8\u8ba4\u662f\u529f\u80fd\u5173\u95ed\u7684;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.\u67e5\u770b\u67d0\u4e2a\u8868\u662f\u5426\u6709\u7d22\u5f15:>\u00a0show\u00a0index\u00a0from\u00a0t;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.\u6253\u5f00\u6b64\u529f\u80fd:>set\u00a0global\u00a0log_queries_not_using_indexes\u00a0=1;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3.\u67e5\u770b\u53d8\u91cf:>show\u00a0variables\u00a0like\u00a0‘log_queries_not_using_indexes’;<\/div>\n
\u00a0 \u00a0 6.log_output\u53d8\u91cf\u503c:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.FILE:\u4fdd\u5b58\u5230\u6587\u4ef6\u4e2d;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.TABLE:\u4fdd\u5b58\u5230\u8868\u4e2d;SET\u00a0GLOBAL\u00a0log_output\u00a0=\u00a0‘TABLE’;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.\u6e05\u7a7a\u65e5\u5fd7\u8868:TRUNCATE\u00a0mysql.slow_log;<\/div>\n
\u00a0 \u00a0 7.\u5206\u6790\u6162\u65e5\u5fd7\u6587\u4ef6\u7684\u5de5\u5177:mysqldumpslow,\u67e5\u770b\u5177\u4f53\u7684\u5e2e\u52a9\u662f\u7528mysqldumpslow\u00a0–help;<\/div>\n
4.\u4e8c\u8fdb\u5236\u65e5\u5fd7(binary\u00a0log):<\/div>\n
\u00a0 \u00a0 1.\u8bb0\u5f55\u6240\u6709\u5bf9\u6570\u636e\u5e93\u66f4\u65b0\u548c\u6f5c\u5728\u7684\u66f4\u65b0\u8bed\u53e5(\u4e00\u4e2adelete\u8bed\u53e5,\u4f46\u662f\u6ca1\u6709\u5f71\u54cd\u7684\u884c),\u8bed\u53e5\u4ee5\u4e8b\u4ef6(event)\u7684\u65b9\u5f0f\u5b58\u50a8,\u540c\u65f6\u4e5f\u5305\u542b\u4e86\u66f4\u65b0\u8bed\u53e5\u6267\u884c\u7684\u65f6\u95f4\u4fe1\u606f;<\/div>\n
\u00a0 \u00a0 2.\u5b83\u4e0d\u8bb0\u5f55\u90a3\u4e9b\u4e0d\u4fee\u6539\u4efb\u4f55\u6570\u636e\u7684\u8bed\u53e5,\u5982\u679c\u60f3\u8981\u8bb0\u5f55\u6240\u6709\u7684\u8bed\u53e5,\u53ef\u4ee5\u4f7f\u7528query\u00a0log;<\/div>\n
\u00a0 \u00a0 3.\u5b83\u4e3b\u8981\u7684\u76ee\u7684\u662f\u5728\u505a\u8fd8\u539f\u64cd\u4f5c\u65f6\u5c3d\u53ef\u80fd\u5168\u7684\u66f4\u65b0\u6570\u636e\u5e93,\u56e0\u4e3a\u5b83\u5305\u542b\u5728\u4e00\u6b21\u5907\u4efd\u540e\u7684\u6240\u6709\u66f4\u65b0\u64cd\u4f5c.\u5b83\u540c\u6837\u88ab\u7528\u5728master\u00a0replication\u00a0server\u4e2d\u4f5c\u4e3a\u4e00\u4e2a\u8bb0\u5f55\u53d1\u9001\u7ed9slave\u00a0servers;<\/div>\n
\u00a0 \u00a0 4.\u6253\u5f00\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4f1a\u635f\u59311%\u7684\u6027\u80fd,\u4f46\u662f\u5b83\u5e26\u6765\u7684\u597d\u5904\u8fdc\u8fdc\u8d85\u8fc7\u8fd9\u4e9b;<\/div>\n
\u00a0 \u00a0 5.\u67e5\u770b\u4e8c\u8fdb\u5236\u65e5\u5fd7\u662f\u5426\u6253\u5f00,\u9700\u8981\u67e5\u770blog_bin\u53c2\u6570\u662f\u5426\u662fON:>show\u00a0variables\u00a0like\u00a0‘log_bin’;<\/div>\n
\u00a0 \u00a0 6.\u547d\u4ee4\u884c\u53c2\u6570<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.–log-bin=filename:\u8bb0\u5f55\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6587\u4ef6\u7684\u4f4d\u7f6e,\u5c3d\u91cf\u6307\u5b9a\u8def\u5f84\u540d,\u5982\u679c\u4e0d\u6307\u5b9a\u7684\u8bdd\u5219\u4fdd\u5b58\u5728\u6570\u636e\u76ee\u5f55;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.–log-bin-index=file:\u8bb0\u5f55\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6587\u4ef6\u7d22\u5f15\u7684\u4f4d\u7f6e,\u4fdd\u5b58\u4e86\u65e5\u5fd7\u6587\u4ef6\u540d;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.–max_binlog_size:\u5355\u4e2a\u6587\u4ef6\u6700\u5927\u591a\u5c11;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 4.–binlog-do-db=db_name:\u54ea\u4e2a\u6570\u636e\u5e93\u4f7f\u7528,\u53ea\u6709\u8fd9\u4e2a\u6570\u636e\u5e93\u4f7f\u7528;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 5.–binlog-ignore-db=db_name:\u54ea\u4e2a\u6570\u636e\u5e93\u4e0d\u4f7f\u7528,\u53ea\u6709\u8fd9\u4e2a\u6570\u636e\u5e93\u4e0d\u4f7f\u7528;<\/div>\n
\u00a0 \u00a0 7.\u7cfb\u7edf\u53d8\u91cf<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.log_bin:\u65e5\u5fd7\u7684\u4f4d\u7f6e;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.binlog_cache_size:\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7f13\u5b58\u5927\u5c0f,\u662f\u6bcf\u4e00\u4e2a\u8fde\u63a5\u8fdb\u6765\u7684\u7ebf\u7a0b\u5206\u914d\u7684\u5927\u5c0f,\u4e0d\u662f\u6574\u4e2a\u670d\u52a1\u5668\u7684\u5927\u5c0f;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.max_binlog_cache_size:\u6700\u5927\u7f13\u5b58\u5927\u5c0f;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 4.max_binlog_size:\u5355\u4e2a\u6587\u4ef6\u6700\u5927\u5927\u5c0f,\u8d85\u8fc7\u6b64\u5927\u5c0f\u5219\u518d\u5206\u914d\u4e00\u4e2a\u6587\u4ef6,\u4f46\u662f\u4e00\u4e2a\u4e8b\u52a1\u5fc5\u987b\u5728\u4e00\u4e2a\u6587\u4ef6\u4e2d,\u6240\u4ee5\u53ef\u80fd\u4f1a\u7a0d\u5927\u70b9;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 5.binlog_cache_use:\u5f53\u524d\u8fde\u63a5\u4f7f\u7528\u7684binlog\u7f13\u5b58\u7684\u4e8b\u52a1\u7684\u6570\u91cf,\u4f7f\u7528show\u00a0status\u00a0like\u00a0‘binlog_cache_use’\u67e5\u770b(show\u00a0status\u547d\u4ee4\u663e\u793a\u4e86\u6240\u6709\u8fde\u63a5\u5230mysql\u670d\u52a1\u5668\u7684\u72b6\u6001\u503c);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 6.binlog_cache_disk_use:\u5982\u679cbinlog_cache_use\u4e0d\u591f\u7528,\u5219\u5728\u78c1\u76d8\u4e0a\u7f13\u5b58,\u5e94\u8be5\u5c3d\u91cf\u907f\u514d;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 7.binlog_do_db:\u8bbe\u7f6emaster-slave\u65f6\u4f7f\u7528;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 8.binlog-ignore-db:\u8bbe\u7f6e\u54ea\u4e2a\u6570\u636e\u5e93\u4e0d\u8bb0\u5f55\u65e5\u5fd7;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 9.sync_binlog:\u7f13\u5b58\u4e0e\u786c\u76d8\u7684\u540c\u6b65\u9891\u7387(commit\u591a\u5c11\u4e0b\u540c\u6b65\u4e00\u6b21,0\u8868\u793a\u670d\u52a1\u5668\u81ea\u52a8\u63a7\u5236);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 10.binlog_format:\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7684\u683c\u5f0f;<\/div>\n
\u00a0 \u00a0 8.\u67e5\u770b\u5f53\u524d\u4e8c\u8fdb\u5236\u6587\u4ef6\u7684\u540d\u79f0\u548c\u5927\u5c0f,show\u00a0binary\/master\u00a0logs;<\/div>\n
\u00a0 \u00a0 9.\u5982\u679c\u4e0d\u6307\u5b9a\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6587\u4ef6\u7684\u4f4d\u7f6e,\u9ed8\u8ba4\u5b58\u653e\u5728data\u6587\u4ef6\u5939\u4e0b,\u65e5\u5fd7\u6587\u4ef6\u662f:mysql-bin.xxxxxx,\u7d22\u5f15\u6587\u4ef6\u662fmysql-bin.index;<\/div>\n
\u00a0 \u00a0 10.\u5982\u679c\u8981\u5207\u6362\u65e5\u5fd7\u7684\u8bdd,\u6267\u884cflush\u00a0logs\u547d\u4ee4;<\/div>\n
\u00a0 \u00a0 11.\u521d\u59cb\u5316\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7cfb\u7edf,\u4ece\u65b0\u751f\u6210:reset\u00a0master\u547d\u4ee4;<\/div>\n
\u00a0 \u00a0 12.\u5220\u9664\u67d0\u4e2a\u65e5\u5fd7\u6587\u4ef6:purge\u00a0binary\u00a0logs\u00a0[before\u00a0‘datetime’\u00a0\/\u00a0to\u00a0‘log_name’]\u00a0\u5220\u9664\u6307\u5b9a\u65e5\u671f\u4e4b\u524d\u7684\u548c\u5220\u9664\u6307\u5b9a\u6587\u4ef6\u4e4b\u524d\u7684\u65e5\u5fd7\u6587\u4ef6;<\/div>\n
\u00a0 \u00a0 13.\u8bbe\u7f6e\u65e5\u5fd7\u6587\u4ef6\u7684\u5931\u6548\u671f:\u53c2\u6570\u4e3a–expire_logs_days,set\u00a0global\u00a0expire_log_days=n,N\u5929\u524d\u7684\u65e5\u5fd7\u81ea\u52a8\u5220\u9664;<\/div>\n
\u00a0 \u00a0 14.\u4e8c\u8fdb\u5236\u65e5\u5fd7\u7684\u683c\u5f0f<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.\u67e5\u770b\u683c\u5f0f:show\u00a0[global]\u00a0variables\u00a0like\u00a0‘binlog_format’;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.\u8bbe\u7f6e\u65e5\u5fd7\u683c\u5f0f:set\u00a0[global]\u00a0binlog_format\u00a0=\u00a0statement|row|mixed;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.\u67e5\u770bbinlog\u4e2d\u7684\u4e8b\u4ef6:show\u00a0binlog\u00a0events\u00a0in\u00a0‘mysql-bin.000002’\u00a0from\u00a00;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 4.\u4f7f\u7528mysqlbinlog\u7a0b\u5e8f\u6253\u5f00;<\/div>\n
5.\u5ba1\u8ba1\u65e5\u5fd7(audit\u00a0log):<\/div>\n
\u00a0 \u00a0 1.\u7528\u4e8e\u8bb0\u5f55\u4f01\u4e1a\u7248\u57fa\u4e8e\u7b56\u7565\u7684\u5ba1\u8ba1\u4fe1\u606f;\u5ba1\u8ba1\u65e5\u5fd7\u662f\u4f5c\u4e3a\u4f01\u4e1a\u7248\u63d2\u4ef6\u63d0\u4f9b\u7684;<\/div>\n
\u00a0 \u00a0 2.\u7531–audit-log\u9009\u9879\u548caudit_log_file\u9009\u9879\u6765\u63a7\u5236;<\/div>\n
\u00a0 \u00a0 3.\u5ba1\u8ba1\u8fc7\u7a0b\u4f1a\u4e0d\u65ad\u5199\u5165\u5ba1\u8ba1\u65e5\u5fd7,\u76f4\u5230\u5c06\u8be5\u63d2\u4ef6\u5220\u9664,\u6216\u8005\u901a\u8fc7audit_log_policy=NONE\u00a0\u9009\u9879\u8bbe\u7f6e\u5173\u95ed\u5ba1\u8ba1;<\/div>\n
\u00a0 \u00a0 4.\u5728\u670d\u52a1\u5668\u542f\u52a8\u65f6\u4f7f\u7528audit_log=FORCE_PLUS_PERMANENT\u4f5c\u4e3a\u9009\u9879,\u53ef\u4ee5\u9632\u6b62\u5220\u9664\u8be5\u63d2\u4ef6;<\/div>\n
\u8865\u5145:<\/div>\n
6.InnoDB\u91cd\u505a\u65e5\u5fd7(innodb\u00a0redo\u00a0log);<\/div>\n
\u00a0 \u00a0 1.\u4e0einnodb\u6570\u636e\u5f15\u64ce\u76f8\u5173;<\/div>\n
\u00a0 \u00a0 2.\u7528\u6765\u5b9e\u73b0\u707e\u96be\u6062\u590d(crash\u00a0recovery),\u7a81\u7136\u65ad\u7535\u4f1a\u5bfc\u81f4innodb\u8868\u7a7a\u95f4\u4e2d\u7684\u6570\u636e\u6ca1\u6709\u5199\u5230\u78c1\u76d8\u4e0a,\u901a\u8fc7\u6267\u884credo\u00a0log\u80fd\u591f\u91cd\u65b0\u6267\u884c\u8fd9\u4e9b\u64cd\u4f5c\u6765\u6062\u590d\u6570\u636e;<\/div>\n
\u00a0 \u00a0 3.\u63d0\u5347innodb\u7684i\/o\u6027\u80fd,innodb\u5f15\u64ce\u628a\u6570\u636e\u548c\u7d22\u5f15\u90fd\u8f7d\u5165\u5230\u5185\u5b58\u4e2d\u7684\u7f13\u51b2\u6c60\u4e2d,\u5982\u679c\u6bcf\u6b21\u4f11\u606f\u6570\u636e\u548c\u7d22\u5f15\u90fd\u9700\u8981\u66f4\u65b0\u5230\u78c1\u76d8,\u5fc5\u5b9a\u4f1a\u589e\u52a0i\/o\u8bf7\u6c42,\u800c\u4e14\u56e0\u4e3a\u6bcf\u6b21\u66f4\u65b0\u7684\u4f4d\u7f6e\u90fd\u662f\u968f\u673a\u7684,\u78c1\u5934\u9700\u8981\u9891\u7e41\u7684\u5b9a\u4f4d\u5bfc\u81f4\u6548\u7387\u5f88\u4f4e,\u6240\u4ee5innodb\u6bcf\u5904\u7406\u5b8c\u4e00\u4e2a\u4e8b\u52a1\u540e\u53ea\u6dfb\u52a0\u4e00\u6761\u65e5\u5fd7log,\u53e6\u5916\u6709\u4e00\u4e2a\u7ebf\u7a0b\u8d1f\u8d23\u667a\u80fd\u7684\u8bfb\u53d6\u65e5\u5fd7\u6587\u4ef6\u5e76\u6279\u91cf\u66f4\u65b0\u5230\u78c1\u76d8\u4e0a,\u5b9e\u73b0\u6700\u9ad8\u6548\u7684\u78c1\u76d8\u5199\u5165;<\/div>\n
\u00a0 \u00a0 4.\u7cfb\u7edf\u53d8\u91cf:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 1.innodb_log_buffer_size:\u65e5\u5fd7\u7f13\u51b2\u533a\u7684\u5927\u5c0f;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 2.innodb_log_file_size:\u65e5\u5fd7\u6587\u4ef6\u7684\u5927\u5c0f;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 3.innodb_log_files_in_group:\u4e00\u7ec4\u65e5\u5fd7\u4e2d\u6709\u51e0\u4e2a\u6587\u4ef6:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.\u6587\u4ef6\u540d\u4e3aib_logfileX(X\u4ece0\u5f00\u59cb\u4e00\u6b21\u589e\u52a0);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.\u5148\u5173\u95ed\u6570\u636e\u5e93\u670d\u52a1:>mysqladmin\u00a0shutdown(mysql.server\u00a0stop);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3.\u628adata\u76ee\u5f55\u4e0b\u7684ib_logfile*\u6587\u4ef6\u79fb\u52a8\u8d70:>mv\u00a0ib_logfile*\u00a0\/tmp;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 4.\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6dfb\u52a0innodb_log_files_in_group=n\u7684\u53c2\u6570;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 5.\u542f\u52a8\u6570\u636e\u5e93\u670d\u52a1:>mysqld\u00a0–defaults-file=.\/my.cnf\u00a0–user=mysql(mysql.server\u00a0start);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 6.\u53ef\u4ee5\u67e5\u770berror\u00a0log\u6587\u4ef6\u89c2\u5bdf\u542f\u52a8\u8fc7\u7a0b;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 4.innodb_log_group_home_dir:\u65e5\u5fd7\u5b58\u653e\u7684\u6027\u5bf9\u8def\u5f84(\u76f8\u5bf9\u4e8e$MYSQL_HOME\/mysql\/data\u76ee\u5f55,\u5373datadir\u76ee\u5f55);<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.\u5173\u95ed\u670d\u52a1\u5668;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.\u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u6dfb\u52a0\u6b64\u53c2\u6570,\u5e76\u6307\u5b9a\u8def\u5f84;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3.\u542f\u52a8\u670d\u52a1\u5668;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 5.innodb_flush_log_at_trx_commit:\u6839\u636e\u4e0d\u540c\u7684\u6570\u636e\u5b89\u5168\u7ea7\u522b\u53bb\u8bbe\u5b9a.<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1.0:\u65e5\u5fd7\u7f13\u51b2\u6bcf\u79d2\u4e00\u6b21\u7684\u88ab\u5199\u5165\u5230\u65e5\u5fd7\u6587\u4ef6,\u5e76\u4e14\u5bf9\u65e5\u5fd7\u6587\u4ef6\u505a\u5230\u78c1\u76d8\u64cd\u4f5c\u7684\u5237\u65b0,\u4f46\u662f\u5728\u4e00\u4e2a\u4e8b\u52a1\u63d0\u4ea4\u4e0d\u505a\u4efb\u4f55\u4fee\u6539;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2.1:\u6bcf\u4e2a\u4e8b\u52a1\u63d0\u4ea4\u65f6,\u65e5\u5fd7\u7f13\u51b2\u88ab\u5199\u5230\u65e5\u5fd7\u6587\u4ef6,\u5bf9\u65e5\u5fd7\u6587\u4ef6\u505a\u5230\u78c1\u76d8\u64cd\u4f5c\u7684\u5237\u65b0;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3.2:\u6bcf\u4e2a\u4e8b\u52a1\u63d0\u4ea4\u540e,\u65e5\u5fd7\u7f13\u51b2\u88ab\u5199\u5230\u65e5\u5fd7\u6587\u4ef6,\u4f46\u4e0d\u5bf9\u65e5\u5fd7\u6587\u4ef6\u505a\u5230\u78c1\u76d8\u64cd\u4f5c\u5237\u65b0,\u5bf9\u65e5\u5fd7\u6587\u4ef6\u6bcf\u79d2\u5237\u65b0\u4e00\u6b21;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 4.\u67e5\u770b\u6b64\u53d8\u91cf:>show\u00a0variables\u00a0like\u00a0‘innodb_flush_log_at_trx_commit’;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 6.innodb_os_log_written:\u5199\u5165\u5230\u6587\u4ef6\u65e5\u5fd7\u7684\u6570\u636e\u91cf,\u4f7f\u7528show\u00a0status\u67e5\u8be2;<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 7.innodb_os_log_fsyncs:\u5199\u5165\u5230\u78c1\u76d8\u7684\u6b21\u6570,\u4f7f\u7528show\u00a0status\u67e5\u8be2;<\/div>\n
<\/div>\n
—\u00a0\u65e5\u5fd7\u6587\u4ef6\u7528\u6cd5\u5217\u8868;<\/div>\n
—\u00a0\u4e8c\u8fdb\u5236\u65e5\u5fd7\u8bb0\u5f55;<\/div>\n
1.\u4e8c\u8fdb\u5236\u65e5\u5fd7\u5305\u542b\u63cf\u8ff0\u6570\u636e\u5e93\u66f4\u6539(\u5982\u521b\u5efa\u6570\u636e\u5e93\u6216\u66f4\u6539\u8868\u6570\u636e)\u7684\u201c\u4e8b\u4ef6\u201d;\u4e8c\u8fdb\u5236\u65e5\u5fd7\u00a0\u8fd8\u5305\u542b\u53ef\u80fd\u505a\u51fa\u66f4\u6539\u7684\u8bed\u53e5\u7684\u4e8b\u4ef6(\u4f8b\u5982,\u6ca1\u6709\u5339\u914d\u884c\u7684DELETE);\u8be5\u65e5\u5fd7\u8fd8\u5305\u542b\u6709\u5173\u00a0\u6bcf\u6761\u66f4\u65b0\u8bed\u53e5\u6240\u7528\u65f6\u95f4\u7684\u4fe1\u606f;<\/div>\n
2.\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6709\u4e24\u4e2a\u91cd\u8981\u7528\u9014:\u590d\u5236\u548c\u6570\u636e\u6062\u590d;<\/div>\n
3.MySQL\u4f7f\u7528\u65e5\u5fd7\u4f20\u9001\u590d\u5236\u89e3\u51b3\u65b9\u6848;\u4f7f\u7528\u65e5\u5fd7\u4f20\u9001\u7cfb\u7edf\u65f6,\u53ef\u4ee5\u5c06\u4e3b\u7cfb\u7edf\u4e0a\u53d1\u751f\u7684\u6240\u6709\u6570\u636e\u66f4\u6539\u5b58\u50a8\u5728\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4e2d,\u7136\u540e\u901a\u8fc7\u4ece\u7cfb\u7edf\u68c0\u7d22\u8fd9\u4e9b\u6570\u636e\u66f4\u6539,\u5e76\u6839\u636e\u63a5\u6536\u5230\u7684\u8fd9\u4e9b\u65e5\u5fd7\u6587\u4ef6\u6267\u884c\u66f4\u6539;<\/div>\n
4.\u53ef\u4ee5\u5b9e\u65f6\u4e0b\u8f7d\u65e5\u5fd7\u6587\u4ef6\u5e76\u6267\u884c\u5185\u5bb9;\u5373,\u53ea\u8981\u751f\u6210\u65e5\u5fd7\u6587\u4ef6\u4e8b\u4ef6,\u5c31\u5c06\u5176\u53d1\u9001\u5230\u8fde\u63a5\u7684\u4ece\u7cfb\u7edf\u4f9b\u6267\u884c;\u7531\u4e8e\u7f51\u7edc\u4f20\u64ad\u5b58\u5728\u5ef6\u8fdf,\u4ece\u7cfb\u7edf\u53ef\u80fd\u9700\u8981\u51e0\u79d2\u5230\u51e0\u5206\u949f(\u6700\u574f\u7684\u60c5\u51b5)\u65f6\u95f4\u6765\u63a5\u6536\u66f4\u65b0;\u5728\u7406\u60f3\u7684\u60c5\u51b5\u4e0b,\u5ef6\u8fdf\u4f1a\u5728\u4e00\u79d2\u4ee5\u5185;<\/div>\n
5.\u53d1\u751f\u4ee5\u4e0b\u4e8b\u4ef6\u4e4b\u4e00\u65f6,\u4e8c\u8fdb\u5236\u65e5\u5fd7\u4f1a\u8f6e\u8f6c:<\/div>\n
\u00a0 \u00a0 1.\u91cd\u65b0\u542f\u52a8MySQL\u670d\u52a1\u5668;<\/div>\n
\u00a0 \u00a0 2.\u8fbe\u5230\u5141\u8bb8\u7684\u6700\u5927\u5927\u5c0f(max_binlog_size);<\/div>\n
\u00a0 \u00a0 3.\u53d1\u51fa\u4e86FLUSH\u00a0LOGS\u00a0SQL\u547d\u4ee4;<\/div>\n
6.\u4e8c\u8fdb\u5236\u65e5\u5fd7\u72ec\u7acb\u4e8e\u5b58\u50a8\u5f15\u64ce,\u4e0d\u7ba1\u4f7f\u7528\u7684\u5b58\u50a8\u5f15\u64ce\u662f\u54ea\u4e2a(\u5373InnoDB\u6216MyISAM),MySQL\u590d\u5236\u90fd\u4f1a\u5de5\u4f5c;<\/div>\n
<\/div>\n
—\u00a0\u4e8c\u8fdb\u5236\u65e5\u5fd7\u8bb0\u5f55\u683c\u5f0f;<\/div>\n
1.\u57fa\u4e8e\u8bed\u53e5\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u8bb0\u5f55:<\/div>\n
\u00a0 \u00a0 1.\u5305\u542b\u5b9e\u9645SQL\u8bed\u53e5<\/div>\n
\u00a0 \u00a0 2.\u5305\u62ecDDL(CREATE,DROP\u7b49)\u548cDML(UPDATE,DELETE\u7b49)\u8bed\u53e5;<\/div>\n
\u00a0 \u00a0 3.\u76f8\u5bf9\u8f83\u5c0f\u7684\u6587\u4ef6\u4fdd\u5b58\u78c1\u76d8\u7a7a\u95f4\u548c\u7f51\u7edc\u5e26\u5bbd;<\/div>\n
\u00a0 \u00a0 4.\u5e76\u975e\u6240\u6709\u590d\u5236\u7684\u8bed\u53e5\u90fd\u4f1a\u5728\u8fdc\u7a0b\u8ba1\u7b97\u673a\u4e0a\u6b63\u786e\u91cd\u653e;<\/div>\n
\u00a0 \u00a0 5.\u8981\u6c42\u4e3b\u7cfb\u7edf\u548c\u4ece\u7cfb\u7edf\u4e0a\u590d\u5236\u7684\u8868\u548c\u5217\u5b8c\u5168\u76f8\u540c(\u6216\u8005\u7b26\u5408\u591a\u4e2a\u9650\u5236\u6761\u4ef6);<\/div>\n
2.\u57fa\u4e8e\u884c\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7\u8bb0\u5f55:<\/div>\n
\u00a0 \u00a0 1.\u6307\u793a\u5bf9\u5355\u4e2a\u8868\u884c\u7684\u5f71\u54cd\u60c5\u51b5;<\/div>\n
\u00a0 \u00a0 2.\u6b63\u786e\u91cd\u653e\u6240\u6709\u8bed\u53e5,\u5373\u4f7f\u5bf9\u4e8e\u5728\u4f7f\u7528\u57fa\u4e8e\u8bed\u53e5\u7684\u65e5\u5fd7\u8bb0\u5f55\u65f6\u672a\u6b63\u786e\u590d\u5236\u7684\u529f\u80fd\u5bfc\u81f4\u7684\u66f4\u6539\u4e5f\u662f\u5982\u6b64;<\/div>\n
3.\u6309\u5982\u4e0b\u65b9\u5f0f\u8bbe\u7f6e\u683c\u5f0f:SET\u00a0[GLOBAL|SESSION]\u00a0BINLOG_FORMAT=[row|statement|mixed|default];<\/div>\n
\u6ce8:\u4f7f\u7528mixed\u9009\u9879\u53ef\u8ba9MySQL\u9009\u53d6\u6700\u9002\u5408\u5355\u4e2a\u4e8b\u4ef6\u7684\u683c\u5f0f,MySQL\u901a\u5e38\u4f1a\u4f7f\u7528\u57fa\u4e8e\u8bed\u53e5\u7684\u4e8c\u8fdb\u5236\u65e5\u5fd7,\u4f46\u5728\u9700\u8981\u65f6\u53ef\u6062\u590d\u5230\u57fa\u4e8e\u884c\u7684\u590d\u5236;<\/div>\n
<\/div>\n
—\u00a0\u5217\u51fa\u4e8c\u8fdb\u5236\u65e5\u5fd7\u6587\u4ef6;<\/div>\n
1.SHOW\u00a0BINARY\u00a0LOGS\u8bed\u53e5\u53ef\u4ee5\u5217\u51fa\u5f53\u524d\u65e5\u5fd7\u6587\u4ef6\u548c\u6587\u4ef6\u5927\u5c0f;<\/div>\n
2.SHOW\u00a0MASTER\u00a0STATUS\u8bed\u53e5\u53ef\u4ee5\u663e\u793a\u4e0b\u4e00\u4e2a\u4e8b\u4ef6\u7684\u4e3b\u72b6\u6001;\u9700\u8981SUPER\u6216REPLICATION\u00a0CLIENT\u7279\u6743;<\/div>\n
<\/div>\n
—\u00a0\u67e5\u770b\u4e8c\u8fdb\u5236\u65e5\u5fd7\u5185\u5bb9;<\/div>\n
1.\u65b9\u5f0f1:show\u00a0binlog\u00a0events\u00a0in\u00a0‘mysql-bin.000002’\u00a0from\u00a00;<\/div>\n
2.\u65b9\u6cd52:mysqlbinlog\u00a0mysql-bin.xxxxxx;<\/div>\n
<\/div>\n
—\u00a0\u5220\u9664\u4e8c\u8fdb\u5236\u65e5\u5fd7;<\/div>\n
1.\u9ed8\u8ba4\u60c5\u51b5\u4e0b,\u4e0d\u4f1a\u5220\u9664\u65e7\u7684\u65e5\u5fd7\u6587\u4ef6;<\/div>\n
2.\u6839\u636e\u5b58\u5728\u65f6\u95f4\u5220\u9664\u65e5\u5fd7:<\/div>\n
\u00a0 \u00a0 1.\u8981\u5728\u4e8c\u8fdb\u5236\u65e5\u5fd7\u8f6e\u8f6c\u8fc7\u7a0b\u4e2d\u81ea\u52a8\u5220\u9664\u5b58\u5728\u65f6\u95f4\u591a\u4e8e\u6307\u5b9a\u5929\u6570\u7684\u4efb\u4f55\u4e8c\u8fdb\u5236\u65e5\u5fd7,\u53ef\u4f7f\u7528expire_logs_days\u8bbe\u7f6e;<\/div>\n
\u00a0 \u00a0 2..\u4e5f\u53ef\u4ee5\u5728\u9009\u9879\u6587\u4ef6\u4e2d\u914d\u7f6eexpire_logs_days:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 [mysqld]<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 expire_logs_days=7<\/div>\n
\u00a0 \u00a0 3.PURGE\u00a0BINARY\u00a0LOGS\u00a0BEFORE\u00a0now()\u00a0–\u00a0INTERVAL\u00a03\u00a0day;<\/div>\n
4.\u6839\u636e\u6587\u4ef6\u540d\u5220\u9664\u65e5\u5fd7:PURGE\u00a0BINARY\u00a0LOGS\u00a0TO\u00a0‘mysql-bin.000010’;<\/div>\n
<\/div>\n
—\u00a0\u914d\u7f6e\u4f01\u4e1a\u5ba1\u8ba1;<\/div>\n
1.\u8981\u5b89\u88c5audit_log\u63d2\u4ef6:<\/div>\n
\u00a0 \u00a0 1.\u65b9\u6cd51:\u4f7f\u7528INSTALL\u00a0PLUGIN\u8bed\u6cd5:INSTALL\u00a0PLUGIN\u00a0audit_log\u00a0SONAME\u00a0‘audit_log.so’;<\/div>\n
\u00a0 \u00a0 2.\u65b9\u6cd52:\u5728\u670d\u52a1\u5668\u542f\u52a8\u65f6\u8bbe\u7f6eplugin-load\u9009\u9879:<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 [mysqld]<\/div>\n
\u00a0 \u00a0 \u00a0 \u00a0 plugin-load=audit_log.so<\/div>\n
2.\u9ed8\u8ba4\u60c5\u51b5\u4e0b,\u88c5\u5165\u8be5\u63d2\u4ef6\u5c31\u4f1a\u542f\u7528\u65e5\u5fd7\u8bb0\u5f55;\u5c06\u9009\u9879audit-log\u8bbe\u7f6e\u4e3aOFF\u53ef\u7981\u7528\u65e5\u5fd7\u8bb0\u5f55;<\/div>\n
3.\u8981\u9632\u6b62\u5728\u8fd0\u884c\u65f6\u5220\u9664\u8be5\u63d2\u4ef6,\u53ef\u8bbe\u7f6e\u4ee5\u4e0b\u9009\u9879:audit-log=FORCE_PLUS_PERMANENT;<\/div>\n
4.\u65e5\u5fd7\u6587\u4ef6\u547d\u540d\u4e3aaudit.log,\u9ed8\u8ba4\u60c5\u51b5\u4e0b\u4f4d\u4e8e\u670d\u52a1\u5668\u6570\u636e\u76ee\u5f55\u4e2d;\u8981\u66f4\u6539\u8be5\u6587\u4ef6\u7684\u540d\u79f0\u6216\u4f4d\u7f6e,\u53ef\u5728\u670d\u52a1\u5668\u542f\u52a8\u65f6\u8bbe\u7f6e\u00a0audit_log_file\u7cfb\u7edf\u53d8\u91cf;<\/div>\n
5.\u8981\u5e73\u8861\u9075\u4ece\u6027\u548c\u6027\u80fd,\u53ef\u4f7f\u7528audit_log_strategy\u9009\u9879\u5728SYNCHRONOUS,ASYNCHRONOUS,SEMISYNCHRONOUS\u548c\u00a0PERFORMANCE\u4e4b\u95f4\u8fdb\u884c\u9009\u62e9;<\/div>\n
6.\u5982\u679c\u5c06audit_log_rotate_on_size\u8bbe\u7f6e\u4e3a\u67d0\u4e2a\u5927\u4e8e0\u7684\u6570\u5b57,\u5219\u5f53\u65e5\u5fd7\u6587\u4ef6\u5927\u5c0f\u8d85\u51fa\u4e86\u8be5\u6570\u91cf\u76844KB\u6570\u636e\u5757\u5927\u5c0f\u65f6,\u5c06\u8f6e\u8f6c\u65e5\u5fd7\u6587\u4ef6;<\/div>\n
<\/div>\n
—\u00a0\u5ba1\u8ba1\u65e5\u5fd7\u6587\u4ef6;<\/div>\n
1.\u6bcf\u4e2a\u5ba1\u8ba1\u8bb0\u5f55\u7684TIMESTAMP\u91c7\u7528UTC\u683c\u5f0f;<\/div>\n
2.NAME\u5c5e\u6027\u4ee3\u8868\u4e8b\u4ef6\u7c7b\u578b;\u4f8b\u5982,\u201cConnect\u201d\u8868\u793a\u767b\u5f55\u4e8b\u4ef6,\u201cQuit\u201d\u8868\u793a\u5ba2\u6237\u673a\u65ad\u5f00\u8fde\u63a5,\u201cShutdown\u201d\u8868\u793a\u670d\u52a1\u5668\u5173\u95ed;<\/div>\n
3.\u201cAudit\u201d\u548c\u201cNoAudit\u201d\u8868\u793a\u5ba1\u8ba1\u5f00\u59cb\u548c\u505c\u6b62\u7684\u70b9;<\/div>\n
4.STATUS\u5c5e\u6027\u63d0\u4f9b\u547d\u4ee4\u72b6\u6001;\u8fd9\u4e0eMySQL\u547d\u4ee4SHOW\u00a0ERRORS\u663e\u793a\u7684Code\u503c\u76f8\u540c;<\/div>\n
5.\u6709\u4e9b\u5c5e\u6027\u4ec5\u5728\u7279\u5b9a\u7684\u4e8b\u4ef6\u7c7b\u578b\u4e2d\u51fa\u73b0;\u4f8b\u5982,\u201cConnect\u201d\u4e8b\u4ef6\u5305\u62ec\u8bf8\u5982HOST,DB,IP\u548cUSER\u4e4b\u7c7b\u7684\u5c5e\u6027;\u201cQuery\u201d\u4e8b\u4ef6\u5305\u62ecSQLTEXT\u5c5e\u6027;<\/div>\n
<\/div>\n
\u8865\u5145:\u5ba1\u8ba1\u8fc7\u6ee4\u5de5\u5177;<\/div>\n
mysqlauditgrep\u00a0–users=root\u00a0–query-type=SELECT\u00a0 –status=0\u00a0\/var\/lib\/mysql\/audit.log<\/div>\n
<\/div>\n
—\u00a0\u7ec3\u4e60\u4efb\u52a1;<\/div>\n
1.\u4fee\u6539\u8bbf\u95ee\u7aef\u53e3\u4e3a3309;<\/div>\n
\u00a0 \u00a0 [mysqld]<\/div>\n
\u00a0 \u00a0 datadir=\/var\/lib\/mysql<\/div>\n
\u00a0 \u00a0 socket=\/var\/lib\/mysql\/mysql.sock<\/div>\n
\u00a0 \u00a0 port=3309<\/div>\n
\u00a0 \u00a0 user=mysql<\/div>\n
\u00a0 \u00a0 …<\/div>\n
\u00a0 \u00a0 [client]<\/div>\n
\u00a0 \u00a0 port=3309<\/div>\n
2.\u67e5\u770b\u5f53\u524d\u5ba2\u6237\u4f1a\u8bdd\u6b63\u5728\u4f7f\u7528\u7684\u9009\u9879\u72b6\u6001;<\/div>\n
\u00a0 \u00a0 mysql>\u00a0status;<\/div>\n","protected":false},"excerpt":{"rendered":"

—\u00a0MySQL\u914d\u7f6e\u9009\u9879; 1.\u9884\u7f16\u8bd1\u7684\u9009\u9879: \u00a0 \u00a0 1.\u5728\u751f\u6210RPM\u5305\u65f6\u6307\u5b9a\u7684\u9009\u9879; \u00a0 \u00a0 2 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[27,31],"class_list":["post-1293","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql","tag-mysql_ocp"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1293"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1293\/revisions"}],"predecessor-version":[{"id":1294,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1293\/revisions\/1294"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1293"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}