{"id":2049,"date":"2020-07-29T23:27:11","date_gmt":"2020-07-29T15:27:11","guid":{"rendered":"http:\/\/39.97.231.10\/?p=2049"},"modified":"2020-07-29T23:27:11","modified_gmt":"2020-07-29T15:27:11","slug":"mysql%e9%85%8d%e7%bd%ae%e5%8f%82%e6%95%b0core-file","status":"publish","type":"post","link":"http:\/\/www.weijing.co\/?p=2049","title":{"rendered":"MySQL\u914d\u7f6e\u53c2\u6570core-file"},"content":{"rendered":"
\n
\n1. MySQL core-file \u53c2\u6570\n<\/div>\n<\/div>\n
\n
\n
<\/div>\n
Linux\u73af\u5883\u4e0b\uff0c\u8fdb\u7a0b\u5d29\u6e83\u751f\u6210core\u6587\u4ef6\u4ee5\u4fbf\u4e8e\u7a0b\u5e8f\u8c03\u8bd5\u548c\u95ee\u9898\u6392\u67e5\u3002\u8fdb\u7a0b\u5728\u542f\u52a8\u524d\uff0c\u8bbe\u7f6ecore file size \u5927\u4e8e0\uff0c\u8fdb\u7a0b\u5d29\u6e83\u901a\u5e38\u5c31\u4f1a\u751f\u6210core file dump\u6587\u4ef6\u3002MySQL\u5728\u7cfb\u7edf\u63d0\u4f9b\u7684core file\u751f\u6210\u673a\u5236\u4e4b\u5916\uff0c\u989d\u5916\u6dfb\u52a0\u4e86\u4e00\u4e2a\u53c2\u6570–core-file\uff0c\u6765\u63a7\u5236\u662f\u5426\u751f\u6210core\u6587\u4ef6\u3002<\/div>\n
<\/div>\n
\n
\n
\/\/ mysqld.cc<\/div>\n
{\\”core-file\\”,\u00a0OPT_WANT_CORE, \\”Write core on errors.\\”, 0, 0, 0, GET_NO_ARG,NO_ARG, 0, 0, 0, 0, 0, 0},<\/div>\n
<\/div>\n
…<\/div>\n
<\/div>\n
case (int) OPT_WANT_CORE:<\/div>\n
\u00a0\u00a0\u00a0\u00a0test_flags |= TEST_CORE_ON_SIGNAL;<\/div>\n
\u00a0\u00a0\u00a0\u00a0break;<\/div>\n
<\/div>\n
…<\/div>\n
<\/div>\n
\/\/ my_init_signals()<\/div>\n
if (test_flags & TEST_CORE_ON_SIGNAL)<\/div>\n
\u00a0\u00a0\u00a0\u00a0{<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\/\/ Change limits so that we will get a core file.<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0struct rlimit rl;<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0rl.rlim_cur= rl.rlim_max= RLIM_INFINITY;<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0if (setrlimit(RLIMIT_CORE, &rl))<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0sql_print_warning(\\”setrlimit could not change the size of core\u00a0\u00a0files to\\”<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\\” \\’infinity\\’;\u00a0\u00a0We may not be able to generate a\\”<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\\” core file on signals\\”);<\/div>\n
\u00a0\u00a0\u00a0\u00a0}<\/div>\n<\/div>\n<\/div>\n
<\/div>\n
\u4ee3\u7801\u7248\u672c\uff1a5.7.19<\/div>\n
<\/div>\n
\u4ece\u4ee5\u4e0a\u4ee3\u7801\u53ef\u4ee5\u770b\u51fa\uff0c\u542f\u52a8MySQL\u8fdb\u7a0b\u65f6\uff0c\u52a0\u4e0a–core-file\u53c2\u6570\uff0c\u5373\u4f7flinux\u7cfb\u7edf\u6ca1\u6709\u914d\u7f6e\u751f\u6210core file\uff0cMySQL\u4e5f\u80fd\u901a\u8fc7\u81ea\u5df1\u5728\u4ee3\u7801\u4e2d\u8c03\u7528\u7cfb\u7edf\u51fd\u6570\u6765\u8ba9\u81ea\u5df1\u8fdb\u7a0b\u5728\u5d29\u6e83\u65f6\u751f\u6210core file\u3002<\/div>\n
<\/div>\n
2. core\u00a0file \u64cd\u4f5c\u7cfb\u7edf\u76f8\u5173\u53c2\u6570\u8bbe\u7f6e<\/div>\n
<\/div>\n
\n
echo 2 >\/proc\/sys\/fs\/suid_dumpable<\/div>\n
chmod 0777 \/mysql\/crash<\/div>\n
echo \/mysql\/crash\/core.%e.%t.%p > \/proc\/sys\/kernel\/core_pattern<\/div>\n
echo 1 >\/proc\/sys\/kernel\/core_uses_pid<\/div>\n<\/div>\n
<\/div>\n
\/proc\/sys\/fs\/suid_dumpable \u53d6\u503c\u4e3a0\uff0c1\uff0c2\uff0c\u5177\u4f53\u610f\u4e49\u5982\u4e0b\uff1a<\/div>\n