{"id":393,"date":"2026-02-04T15:16:58","date_gmt":"2026-02-04T07:16:58","guid":{"rendered":"http:\/\/47.100.165.17\/wordpress\/?p=393"},"modified":"2026-02-04T15:16:58","modified_gmt":"2026-02-04T07:16:58","slug":"%e3%80%90mysql%e3%80%91%e9%94%99%e8%af%af%e6%97%a5%e5%bf%97-error-log-%e5%ae%8c%e5%85%a8%e6%8c%87%e5%8d%97%ef%bc%9a%e4%bb%8e%e9%85%8d%e7%bd%ae%e5%88%b0%e6%95%85%e9%9a%9c%e6%8e%92%e6%9f%a5%e5%ae%9e","status":"publish","type":"post","link":"https:\/\/yunyanglib.cn\/?p=393","title":{"rendered":"\u3010MySQL\u3011\u9519\u8bef\u65e5\u5fd7 Error Log \u5b8c\u5168\u6307\u5357\uff1a\u4ece\u914d\u7f6e\u5230\u6545\u969c\u6392\u67e5\u5b9e\u6218"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\" id=\"u735c5c5f\">\u5728 MySQL \u6570\u636e\u5e93\u8fd0\u7ef4\u4e2d\uff0c\u9047\u5230\u670d\u52a1\u542f\u52a8\u5931\u8d25\u3001\u8fde\u63a5\u5f02\u5e38\u3001\u6b7b\u9501\u7b49\u95ee\u9898\u65f6\uff0c\u9519\u8bef\u65e5\u5fd7\uff08Error Log\uff09\u7edd\u5bf9\u662f\u4f60\u7684 \u201c\u6392\u969c\u5229\u5668\u201d\u3002\u5b83\u9ed8\u8ba4\u5f00\u542f\uff0c\u8bb0\u5f55\u7740 MySQL \u542f\u52a8\u3001\u5173\u95ed\u53ca\u8fd0\u884c\u8fc7\u7a0b\u4e2d\u7684\u9519\u8bef\u3001\u8b66\u544a\u4e0e\u8c03\u8bd5\u4fe1\u606f\uff0c\u662f\u5b9a\u4f4d\u95ee\u9898\u6839\u6e90\u7684\u6838\u5fc3\u4f9d\u636e\u3002\u672c\u6587\u5c06\u4ece\u914d\u7f6e\u67e5\u770b\u3001\u6838\u5fc3\u4f5c\u7528\u3001\u8fdb\u9636\u529f\u80fd\u4e09\u4e2a\u7ef4\u5ea6\uff0c\u5e26\u4f60\u5168\u9762\u638c\u63e1 Error Log \u7684\u4f7f\u7528\u6280\u5de7\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"xjfAV\">\u4e00\u3001Error Log \u57fa\u7840\u914d\u7f6e\u4e0e\u67e5\u770b<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"SicOw\">1. \u67e5\u770b\u4e0e\u914d\u7f6e\u65e5\u5fd7\u8def\u5f84<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Error Log \u7684\u9ed8\u8ba4\u5b58\u50a8\u8def\u5f84\u53ef\u901a\u8fc7 SQL \u547d\u4ee4\u76f4\u63a5\u67e5\u8be2\uff1a<\/p>\n\n\n\n<pre id=\"bAGqr\" class=\"wp-block-code\"><code>-- \u67e5\u770b\u9519\u8bef\u65e5\u5fd7\u5b58\u50a8\u8def\u5f84\nshow global variables like \"log_error\";<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1010\" height=\"204\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-53.png\" alt=\"\" class=\"wp-image-398\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-53.png 1010w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-53-300x61.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-53-768x155.png 768w\" sizes=\"(max-width: 1010px) 100vw, 1010px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u8031d099\">\u9ed8\u8ba4\u8def\u5f84\u901a\u5e38\u4e3a<code>data\/mysql\/hostname.err<\/code>\uff08\u4f8b\u5982<code>\/data\/mysql\/localhost.err<\/code>\uff09\u3002\u82e5\u9700\u81ea\u5b9a\u4e49\u5b58\u50a8\u8def\u5f84\uff0c\u53ef\u901a\u8fc7\u4fee\u6539\u914d\u7f6e\u6587\u4ef6\u5b9e\u73b0\u6c38\u4e45\u751f\u6548\uff1a<\/p>\n\n\n\n<pre id=\"RSFgO\" class=\"wp-block-code\"><code># \u7f16\u8f91MySQL\u914d\u7f6e\u6587\u4ef6\nvim \/data\/mysql\/conf\/my.cnf\n# \u6dfb\u52a0\u914d\u7f6e\u9879\uff1a\u6307\u5b9a\u65e5\u5fd7\u5b58\u50a8\u8def\u5f84\nlog-error = \/data\/mysql\/log\/mysql.err\n# \u91cd\u542fMySQL\u670d\u52a1\u4f7f\u914d\u7f6e\u751f\u6548\n\/etc\/init.d\/mysql.server restart<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"WgJyi\">2. \u914d\u7f6e\u65e5\u5fd7\u8bb0\u5f55\u7ea7\u522b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ue2403622\">\u901a\u8fc7<code>log_error_verbosity<\/code>\u53c2\u6570\u53ef\u63a7\u5236\u65e5\u5fd7\u8bb0\u5f55\u7684\u8be6\u7ec6\u7a0b\u5ea6\uff0c\u6ee1\u8db3\u4e0d\u540c\u6392\u969c\u9700\u6c42\uff1a<\/p>\n\n\n\n<pre id=\"ty7Lj\" class=\"wp-block-code\"><code>-- \u67e5\u770b\u5f53\u524d\u65e5\u5fd7\u7ea7\u522b\nshow global variables like \"log_error_verbosity\";<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"880\" height=\"202\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-54.png\" alt=\"\" class=\"wp-image-400\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-54.png 880w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-54-300x69.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-54-768x176.png 768w\" sizes=\"(max-width: 880px) 100vw, 880px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u53c2\u6570\u53d6\u503c\u53ca\u5bf9\u5e94\u542b\u4e49\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>1<\/strong>\uff1a\u4ec5\u8bb0\u5f55\u9519\u8bef\u4fe1\u606f\uff08Error\uff09\uff0c\u65e5\u5fd7\u6700\u7b80\u6d01\uff1b<\/li>\n\n\n\n<li><strong>2<\/strong>\uff1a\u8bb0\u5f55\u9519\u8bef + \u8b66\u544a\u4fe1\u606f\uff08Error + Warning\uff09\uff0c\u9ed8\u8ba4\u7ea7\u522b\uff1b<\/li>\n\n\n\n<li><strong>3<\/strong>\uff1a\u8bb0\u5f55\u6240\u6709\u4fe1\u606f\uff08Error + Warning + Note + \u8c03\u8bd5\u4fe1\u606f\uff09\uff0c\u9002\u5408\u6df1\u5ea6\u6392\u969c\u3002<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"CCdxY\">3. \u67e5\u770b Error Log \u7684\u5b9e\u7528\u547d\u4ee4<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u65e5\u5e38\u8fd0\u7ef4\u4e2d\uff0c\u5e38\u7528\u4ee5\u4e0b\u547d\u4ee4\u5feb\u901f\u67e5\u770b\u65e5\u5fd7\u5185\u5bb9\uff1a<\/p>\n\n\n\n<pre id=\"JV15D\" class=\"wp-block-code\"><code># \u67e5\u770b\u6700\u540e50\u884c\u65e5\u5fd7\uff08\u5b9a\u4f4d\u6700\u65b0\u9519\u8bef\uff09\ntail -n 50 \/data\/mysql\/log\/mysql.err\n\n# \u5b9e\u65f6\u8ddf\u8e2a\u65e5\u5fd7\uff08\u76d1\u63a7\u670d\u52a1\u8fd0\u884c\u72b6\u6001\uff09\ntail -f \/data\/mysql\/log\/mysql.err<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"130\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-55-1024x130.png\" alt=\"\" class=\"wp-image-401\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-55-1024x130.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-55-300x38.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-55-768x98.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-55-1536x195.png 1536w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-55.png 1897w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e8c\u3001Error Log \u6838\u5fc3\u6392\u969c\u573a\u666f\u5b9e\u6218<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u573a\u666f 1\uff1a\u5b9a\u4f4d\u670d\u52a1\u542f\u52a8\u5f02\u5e38<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL \u542f\u52a8\u5931\u8d25\u662f\u5e38\u89c1\u6545\u969c\uff0cError Log \u80fd\u7cbe\u51c6\u5b9a\u4f4d\u539f\u56e0\u3002\u4ee5\u4e0b\u4e3a\u6a21\u62df\u6545\u969c\u4e0e\u6392\u67e5\u8fc7\u7a0b\uff08<strong>\u4ec5\u9650\u6d4b\u8bd5\u73af\u5883\u64cd\u4f5c\uff01<\/strong>\uff09\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u6a21\u62df\u542f\u52a8\u5f02\u5e38\uff1a\u6545\u610f\u4fee\u6539 redo log \u6587\u4ef6\u5c5e\u4e3b\uff0c\u5bfc\u81f4\u6743\u9650\u4e0d\u8db3<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code># \u4fee\u6539ib_logfile0\u6587\u4ef6\u5c5e\u4e3b\u4e3aroot\uff08\u9ad8\u5371\u64cd\u4f5c\uff0c\u6d4b\u8bd5\u73af\u5883\u4e13\u7528\uff09\nchown root.root \/data\/mysql\/data\/ib_logfile0\n# \u5c1d\u8bd5\u542f\u52a8MySQL\uff0c\u6b64\u65f6\u4f1a\u542f\u52a8\u5931\u8d25\n\/etc\/init.d\/mysql.server restart<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"664\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-56-1024x664.png\" alt=\"\" class=\"wp-image-403\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-56-1024x664.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-56-300x195.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-56-768x498.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-56.png 1055w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">    2. \u67e5\u770b\u65e5\u5fd7\u5b9a\u4f4d\u539f\u56e0\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>tail -f \/data\/mysql\/log\/mysql.err<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u65e5\u5fd7\u5c06\u663e\u793a\u660e\u786e\u9519\u8bef\uff1a<code>[ERROR] [MY-012884] [InnoDB] \/data\/mysql\/data\/ib_logfile0 can't be opened in read-write mode.<\/code>\uff08\u6587\u4ef6\u65e0\u6cd5\u4ee5\u8bfb\u5199\u6a21\u5f0f\u6253\u5f00\uff09<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"269\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-57-1024x269.png\" alt=\"\" class=\"wp-image-404\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-57-1024x269.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-57-300x79.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-57-768x201.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-57-1536x403.png 1536w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-57.png 1891w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">    3. \u4fee\u590d\u95ee\u9898\u5e76\u91cd\u542f\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u6062\u590d\u6587\u4ef6\u5c5e\u4e3b\u4e3amysql\u7528\u6237\nchown mysql.mysql \/data\/mysql\/data\/ib_logfile0\n# \u91cd\u65b0\u542f\u52a8\u670d\u52a1\uff0c\u542f\u52a8\u6210\u529f\n\/etc\/init.d\/mysql.server start<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"418\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-58-1024x418.png\" alt=\"\" class=\"wp-image-405\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-58-1024x418.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-58-300x122.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-58-768x313.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-58-1536x627.png 1536w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-58.png 1892w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"eLpKw\">\u573a\u666f 2\uff1a\u8bca\u65ad\u6570\u636e\u5e93\u8fde\u63a5\u5f02\u5e38<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u7750d34f\">\u5f53\u7528\u6237\u65e0\u6cd5\u8fde\u63a5 MySQL \u65f6\uff0cError Log \u4f1a\u8bb0\u5f55\u8fde\u63a5\u5931\u8d25\u7ec6\u8282\uff08\u5982\u5bc6\u7801\u9519\u8bef\u3001\u8d26\u6237\u9501\u5b9a\uff09\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u51c6\u5907\u6d4b\u8bd5\u73af\u5883\uff1a\u521b\u5efa\u5e26\u9501\u5b9a\u89c4\u5219\u7684\u6d4b\u8bd5\u7528\u6237<\/li>\n<\/ol>\n\n\n\n<pre id=\"MKw1j\" class=\"wp-block-code\"><code>-- \u521b\u5efa\u7528\u6237\uff1a\u5bc6\u7801\u9519\u8bef4\u6b21\u540e\u9501\u5b9a3\u5929\ncreate user 'test_pass'@'localhost' identified by '123456' \nfailed_login_attempts 4 password_lock_time 3;\n-- \u6388\u4e88\u67e5\u8be2\u6743\u9650\ngrant select on *.* to 'test_pass'@'localhost';\n-- \u5f00\u542f\u8be6\u7ec6\u65e5\u5fd7\uff0c\u8bb0\u5f55\u8fde\u63a5\u5931\u8d25\u4fe1\u606f\nset global log_error_verbosity = 3;<\/code><\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u6a21\u62df\u8fde\u63a5\u5931\u8d25\uff1a\u4f7f\u7528\u9519\u8bef\u5bc6\u7801\u767b\u5f55<\/li>\n<\/ol>\n\n\n\n<pre id=\"oznrj\" class=\"wp-block-code\"><code>mysql -utest_pass -p'wrong_pass'  # \u8fde\u63a5\u5931\u8d25<\/code><\/pre>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li>\u67e5\u770b\u65e5\u5fd7\u83b7\u53d6\u539f\u56e0\uff1a<\/li>\n<\/ol>\n\n\n\n<pre id=\"IumEh\" class=\"wp-block-code\"><code>tail -f \/data\/mysql\/log\/mysql.err<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ud61f16a9\">\u65e5\u5fd7\u5c06\u663e\u793a\uff1a<code>[Note] [MY-010926] [Server] Access denied for user 'test_pass'@'localhost' (using password: YES)<\/code>\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"135\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-59-1024x135.png\" alt=\"\" class=\"wp-image-407\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-59-1024x135.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-59-300x40.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-59-768x101.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-59-1536x203.png 1536w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-59.png 1893w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"mlSjP\">\u573a\u666f 3\uff1a\u8bb0\u5f55\u4e0e\u5206\u6790\u6b7b\u9501\u4fe1\u606f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ub22a8b39\">InnoDB \u5f15\u64ce\u51fa\u73b0\u6b7b\u9501\u65f6\uff0cError Log \u4f1a\u5b8c\u6574\u8bb0\u5f55\u6b7b\u9501\u4e8b\u52a1\u7684 SQL\u3001\u9501\u7c7b\u578b\u53ca\u7b49\u5f85\u5173\u7cfb\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u6a21\u62df\u6b7b\u9501\uff08\u9700\u4e24\u4e2a\u4f1a\u8bdd\u914d\u5408\uff09\uff1a<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u5148\u521b\u5efa\u6d4b\u8bd5\u8868\u5e76\u63d2\u5165\u6570\u636e\uff1a<\/li>\n<\/ul>\n\n\n\n<pre id=\"xK1YT\" class=\"wp-block-code\"><code>use maria;\ncreate table errlog_t1(id int primary key, a varchar(10)) engine=InnoDB;\ninsert into errlog_t1 values (1,'a'),(2,'b');<\/code><\/pre>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<ul class=\"wp-block-list\">\n<li>\u4e24\u4e2a\u4f1a\u8bdd\u6267\u884c\u4ee5\u4e0b\u64cd\u4f5c\u89e6\u53d1\u6b7b\u9501\uff1a<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table class=\"has-fixed-layout\"><tbody><tr><td>session1<\/td><td>session2<\/td><\/tr><tr><td>begin;<\/td><td>begin;<\/td><\/tr><tr><td>delete from errlog_t1 where id=1;<\/td><td>delete from errlog_t1 where id=2;<\/td><\/tr><tr><td>delete from errlog_t1 where id=2;<\/td><td>delete from errlog_t1 where id=1;<\/td><\/tr><tr><td>commit;<\/td><td>commit;<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u67e5\u770b\u6b7b\u9501\u65e5\u5fd7\uff1a<\/li>\n<\/ol>\n\n\n\n<pre id=\"nCMoO\" class=\"wp-block-code\"><code>tail -n 100 \/data\/mysql\/log\/mysql.err<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u65e5\u5fd7\u5c06\u8be6\u7ec6\u5c55\u793a\u4e24\u4e2a\u4e8b\u52a1\u7684<code>TRANSACTION<\/code>\u4fe1\u606f\u53ca\u9501\u7b49\u5f85\u5173\u7cfb\uff08\u5982<code>WAITING FOR THIS LOCK TO BE GRANTED<\/code>\uff09\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"405\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-60-1024x405.png\" alt=\"\" class=\"wp-image-408\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-60-1024x405.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-60-300x119.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-60-768x304.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-60-1536x607.png 1536w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-60.png 1902w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"mORi3\">\u4e09\u3001MySQL 8.0+ \u8fdb\u9636\u529f\u80fd\uff1a\u65e5\u5fd7\u8fc7\u6ee4<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u633a565b\">MySQL 8.0 \u53ca\u4ee5\u4e0a\u7248\u672c\u652f\u6301\u901a\u8fc7<code>dragnet<\/code>\u7ec4\u4ef6\u8fc7\u6ee4\u65e5\u5fd7\uff0c\u907f\u514d\u65e0\u7528\u4fe1\u606f\u5237\u5c4f\uff08\u5982\u9891\u7e41\u7684\u8fde\u63a5\u5931\u8d25\u65e5\u5fd7\uff09\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"xtGOn\">\u6b65\u9aa4 1\uff1a\u5f00\u542f\u65e5\u5fd7\u8fc7\u6ee4<\/h3>\n\n\n\n<pre id=\"Js2Vr\" class=\"wp-block-code\"><code>-- 1. \u52a0\u8f7ddragnet\u8fc7\u6ee4\u7ec4\u4ef6\nINSTALL COMPONENT 'file:\/\/component_log_filter_dragnet';\n\n-- 2. \u914d\u7f6e\u65e5\u5fd7\u670d\u52a1\uff1a\u5148\u8fc7\u6ee4\u518d\u8f93\u51fa\nSET GLOBAL log_error_services = 'log_filter_dragnet; log_sink_internal';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"CESvV\">\u6b65\u9aa4 2\uff1a\u914d\u7f6e\u8fc7\u6ee4\u89c4\u5219\uff08\u793a\u4f8b\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"ue4122f76\">\u9700\u6c42\uff1a\u9650\u5236\u300c\u4fe1\u606f\u7c7b\u65e5\u5fd7\uff08Note\uff09\u300d\u6bcf\u5206\u949f\u6700\u591a\u8bb0\u5f55 1 \u6761\uff0c\u907f\u514d\u5237\u5c4f\uff1a<\/p>\n\n\n\n<pre id=\"zN6Sd\" class=\"wp-block-code\"><code># \u8bbe\u7f6e\u8fc7\u6ee4\u89c4\u5219\uff1a\u4fe1\u606f\u7c7b\u65e5\u5fd7\u6bcf\u5206\u949f\u4e0d\u8d85\u8fc7 1 \u6761\nSET GLOBAL dragnet.log_error_filter_rules = 'IF prio>=INFORMATION THEN throttle 1\/60.';<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>prio>=INFORMATION<\/code>\uff1a\u5339\u914d\u4fe1\u606f\u7c7b\u53ca\u4ee5\u4e0a\u7ea7\u522b\u7684\u65e5\u5fd7\uff08Note\u3001Warning\u3001Error\uff09\uff1b<\/li>\n\n\n\n<li><code>throttle 1\/60<\/code>\uff1a\u6bcf\u5206\u949f\u6700\u591a\u8bb0\u5f55 1 \u6761\u3002<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"193\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-61-1024x193.png\" alt=\"\" class=\"wp-image-410\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-61-1024x193.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-61-300x56.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-61-768x144.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-61.png 1170w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"NO8hf\">\u6b65\u9aa4 3\uff1a\u9a8c\u8bc1\u8fc7\u6ee4\u6548\u679c<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u77ed\u65f6\u95f4\u5185\u591a\u6b21\u89e6\u53d1\u4fe1\u606f\u7c7b\u65e5\u5fd7\uff08\u5982\u91cd\u590d\u7528\u9519\u8bef\u5bc6\u7801\u767b\u5f55\uff09\uff1a\uff1a<\/li>\n<\/ol>\n\n\n\n<pre id=\"Dvsrh\" class=\"wp-block-code\"><code>mysql -utest_pass -p'wrong_pass'  # \u7b2c1\u6b21\uff1a\u65e5\u5fd7\u8bb0\u5f55\nmysql -utest_pass -p'wrong_pass'  # \u7b2c2\u6b21\uff081\u5206\u949f\u5185\uff09\uff1a\u65e5\u5fd7\u4e0d\u8bb0\u5f55<\/code><\/pre>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li>\u67e5\u770b Error Log\uff0c\u4ec5\u80fd\u770b\u5230\u7b2c 1 \u6b21\u8fde\u63a5\u5931\u8d25\u7684\u8bb0\u5f55\u3002<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"182\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-62-1024x182.png\" alt=\"\" class=\"wp-image-411\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-62-1024x182.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-62-300x53.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-62-768x137.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-62.png 1246w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"u2esn\">\u6b65\u9aa4 4\uff1a\u5173\u95ed\u65e5\u5fd7\u8fc7\u6ee4<\/h3>\n\n\n\n<pre id=\"XmVyI\" class=\"wp-block-code\"><code>-- 1. \u6062\u590d\u65e5\u5fd7\u670d\u52a1\uff1a\u76f4\u63a5\u8f93\u51fa\uff0c\u4e0d\u7ecf\u8fc7\u6ee4\nSET GLOBAL log_error_services = 'log_sink_internal';\n\n-- 2. \u5378\u8f7ddragnet\u7ec4\u4ef6\nUNINSTALL COMPONENT 'file:\/\/component_log_filter_dragnet';\n\n-- 3. \u6062\u590d\u9ed8\u8ba4\u65e5\u5fd7\u7ea7\u522b\nset global log_error_verbosity = 2;<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"208\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-63-1024x208.png\" alt=\"\" class=\"wp-image-412\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-63-1024x208.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-63-300x61.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-63-768x156.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-63.png 1096w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"Hx2K6\">\u56db\u3001MySQL 8.0.22+ \u65b0\u7279\u6027\uff1a\u4ece\u8868\u4e2d\u67e5\u8be2\u65e5\u5fd7<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\" id=\"u3cd28272\">MySQL 8.0.22 \u53ca\u4ee5\u4e0a\u7248\u672c\u652f\u6301\u5c06 Error Log \u5b58\u50a8\u5230<code>performance_schema.error_log<\/code>\u7cfb\u7edf\u8868\u4e2d\uff0c\u53ef\u901a\u8fc7 SQL \u76f4\u63a5\u67e5\u8be2\uff0c\u65e0\u9700\u64cd\u4f5c\u65e5\u5fd7\u6587\u4ef6\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"P0YiF\">1. \u5e38\u7528\u67e5\u8be2\u793a\u4f8b<\/h3>\n\n\n\n<pre id=\"MXFw3\" class=\"wp-block-code\"><code>-- \u67e5\u770b\u6700\u65b010\u6761\u9519\u8bef\u65e5\u5fd7\nselect * from performance_schema.error_log order by LOGGED desc limit 10;\n\n-- \u67e5\u770b\u6240\u6709ERROR\u7ea7\u522b\u7684\u65e5\u5fd7\uff08\u683c\u5f0f\u5316\u8f93\u51fa\uff09\nselect * from performance_schema.error_log where PRIO = 'ERROR'\\G;\n\n-- \u67e5\u8be2\u6307\u5b9a\u65f6\u95f4\u8303\u56f4\u7684\u65e5\u5fd7\nselect * from performance_schema.error_log \nwhere LOGGED between '2026-02-04 15:00:00' and '2026-02-04 15:05:00';<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"176\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-64-1024x176.png\" alt=\"\" class=\"wp-image-413\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-64-1024x176.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-64-300x52.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-64-768x132.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-64-1536x264.png 1536w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-64.png 1898w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"243\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-65-1024x243.png\" alt=\"\" class=\"wp-image-414\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-65-1024x243.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-65-300x71.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-65-768x182.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-65-1536x364.png 1536w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-65.png 1848w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"120\" src=\"http:\/\/47.100.165.17\/wordpress\/wp-content\/uploads\/2026\/02\/image-66-1024x120.png\" alt=\"\" class=\"wp-image-415\" srcset=\"https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-66-1024x120.png 1024w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-66-300x35.png 300w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-66-768x90.png 768w, https:\/\/yunyanglib.cn\/wp-content\/uploads\/2026\/02\/image-66.png 1412w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"Ysv9a\">2. \u6ce8\u610f\u4e8b\u9879<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>performance_schema.error_log<\/code>\u4ec5\u652f\u6301\u67e5\u8be2\uff0c\u4e0d\u5141\u8bb8<code>INSERT\/UPDATE\/DELETE<\/code>\u64cd\u4f5c\uff1b<\/li>\n\n\n\n<li> \u8868\u4e2d\u65e5\u5fd7\u4e0e\u6587\u4ef6\u65e5\u5fd7\u5185\u5bb9\u5b8c\u5168\u4e00\u81f4\uff0c\u6587\u4ef6\u9002\u5408\u5b9e\u65f6\u8ddf\u8e2a\uff0c\u8868\u9002\u5408\u590d\u6742\u6761\u4ef6\u8fc7\u6ee4\uff1b <\/li>\n\n\n\n<li>\u65e0\u6cd5\u901a\u8fc7<code>TRUNCATE<\/code>\u6e05\u7a7a\u8868\uff0c\u9700\u901a\u8fc7\u4fee\u6539<code>log_error_services<\/code>\u91cd\u7f6e\u65e5\u5fd7\u3002<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u603b\u7ed3<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">MySQL Error Log \u4f5c\u4e3a\u6570\u636e\u5e93\u8fd0\u7ef4\u7684 \u201c\u6838\u5fc3\u6392\u969c\u5de5\u5177\u201d\uff0c\u5176\u4ef7\u503c\u4e0d\u4ec5\u5728\u4e8e\u8bb0\u5f55\u65e5\u5fd7\uff0c\u66f4\u5728\u4e8e\u5e2e\u52a9\u6211\u4eec\u5feb\u901f\u5b9a\u4f4d\u542f\u52a8\u5f02\u5e38\u3001\u8fde\u63a5\u5931\u8d25\u3001\u6b7b\u9501\u7b49\u95ee\u9898\u3002\u901a\u8fc7\u672c\u6587\u7684\u914d\u7f6e\u6307\u5357\u3001\u5b9e\u6218\u573a\u666f\u4e0e\u8fdb\u9636\u529f\u80fd\uff0c\u76f8\u4fe1\u4f60\u5df2\u80fd\u719f\u7ec3\u8fd0\u7528 Error Log \u89e3\u51b3\u65e5\u5e38\u8fd0\u7ef4\u4e2d\u7684\u5927\u90e8\u5206\u95ee\u9898\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u5bf9\u4e8e MySQL 8.0 + \u7528\u6237\uff0c\u5efa\u8bae\u5c1d\u8bd5\u65e5\u5fd7\u8fc7\u6ee4\u4e0e\u8868\u67e5\u8be2\u529f\u80fd\uff0c\u63d0\u5347\u6392\u969c\u6548\u7387\uff1b\u800c\u57fa\u7840\u914d\u7f6e\u4e0e\u6838\u5fc3\u6392\u969c\u573a\u666f\u5219\u9002\u7528\u4e8e\u6240\u6709\u7248\u672c\uff0c\u662f\u5fc5\u5907\u7684\u8fd0\u7ef4\u6280\u80fd\u3002\u5982\u679c\u9047\u5230\u590d\u6742\u95ee\u9898\uff0c\u4e0d\u59a8\u5148\u67e5\u770b Error Log\u2014\u2014 \u7b54\u6848\u5f80\u5f80\u5c31\u5728\u5176\u4e2d\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5728 MySQL \u6570\u636e\u5e93\u8fd0\u7ef4\u4e2d\uff0c\u9047\u5230\u670d\u52a1\u542f\u52a8\u5931\u8d25\u3001\u8fde\u63a5\u5f02\u5e38\u3001\u6b7b\u9501\u7b49\u95ee\u9898\u65f6\uff0c\u9519\u8bef\u65e5\u5fd7\uff08Error Log\uff09\u7edd\u5bf9\u662f\u4f60<\/p>\n<div class=\"more-link\">\n\t\t\t\t <a href=\"https:\/\/yunyanglib.cn\/?p=393\" class=\"link-btn theme-btn\"><span>Read More <\/span> <i class=\"fa fa-caret-right\"><\/i><\/a>\n\t\t\t<\/div>\n","protected":false},"author":1,"featured_media":416,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[16],"class_list":["post-393","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-mysql"],"_links":{"self":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/393","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=393"}],"version-history":[{"count":9,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/393\/revisions"}],"predecessor-version":[{"id":417,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/posts\/393\/revisions\/417"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=\/wp\/v2\/media\/416"}],"wp:attachment":[{"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=393"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=393"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yunyanglib.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=393"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}