{"id":92,"date":"2026-09-01T01:24:15","date_gmt":"2026-08-31T17:24:15","guid":{"rendered":"https:\/\/www.ziliaochi.cn\/index.php\/2026\/09\/01\/interview-mysql-redis-cache\/"},"modified":"2026-09-06T01:30:10","modified_gmt":"2026-09-05T17:30:10","slug":"interview-mysql-redis-cache","status":"publish","type":"post","link":"https:\/\/www.ziliaochi.cn\/index.php\/2026\/09\/01\/interview-mysql-redis-cache\/","title":{"rendered":"MySQL \u4e0e Redis \u9762\u8bd5\u653b\u575a\uff1a\u7d22\u5f15\u3001\u9501\u3001\u7f13\u5b58\u4e00\u81f4\u6027"},"content":{"rendered":"
\n
\u5173\u952e\u8bcd<\/span>MySQL\u7d22\u5f15\u3001B+Tree\u3001\u95f4\u9699\u9501\u3001\u9694\u79bb\u7ea7\u522b\u3001Redis\u3001\u7f13\u5b58\u4e00\u81f4\u6027\u3001\u7f13\u5b58\u7a7f\u900f<\/div>\n
\n
\u76ee\u5f55<\/div>\n
    \n
  1. \u4e00\u3001\u7d22\u5f15\uff1a\u4ece\u6570\u636e\u7ed3\u6784\u95ee\u5230\u4f18\u5316<\/a><\/li>\n
  2. \u4e8c\u3001\u9501\u4e0e\u4e8b\u52a1\u9694\u79bb<\/a><\/li>\n
  3. \u4e09\u3001Redis\uff1a\u6570\u636e\u7ed3\u6784\u4e0e\u8fc7\u671f<\/a><\/li>\n
  4. \u56db\u3001\u7f13\u5b58\u4e00\u81f4\u6027\uff1a\u6838\u5fc3\u96be\u9898<\/a><\/li>\n
  5. \u4e94\u3001\u5c0f\u7ed3<\/a><\/li>\n<\/ol>\n<\/div>\n

    MySQL \u4e0e Redis \u51e0\u4e4e\u662f\u540e\u7aef\u9762\u8bd5\u7684\u5fc5\u8003\u7ec4\u5408\uff1a\u524d\u8005\u8003\u5bdf\u4f60\u5bf9\u5b58\u50a8\u5f15\u64ce\u4e0e\u5e76\u53d1\u63a7\u5236<\/strong>\u7684\u7406\u89e3\uff0c\u540e\u8005\u8003\u5bdf\u4f60\u5bf9\u7f13\u5b58\u8bbe\u8ba1\u4e0e\u4e00\u81f4\u6027<\/strong>\u7684\u628a\u63e1\u3002\u4e24\u8005\u7ed3\u5408\u7684\u90a3\u9053”\u7f13\u5b58\u4e00\u81f4\u6027”\u9898\uff0c\u66f4\u662f\u533a\u5206\u521d\u4e2d\u9ad8\u7ea7\u7684\u5206\u6c34\u5cad\u3002<\/p>\n

    \u672c\u6587\u6309\u9ad8\u9891\u771f\u9898\u7ec4\u7ec7\uff0c\u6bcf\u9898\u7ed9\u51fa\u6807\u51c6\u7b54\u6cd5\u4e0e\u8ffd\u95ee\u9677\u9631\u3002<\/p>\n

    \u4e00\u3001\u7d22\u5f15\uff1a\u4ece\u6570\u636e\u7ed3\u6784\u95ee\u5230\u4f18\u5316<\/h2>\n
    \"B+Tree
    B+Tree \u7ed3\u6784\uff1a\u975e\u53f6\u5b50\u8282\u70b9\u53ea\u5b58\u952e\u503c\uff0c\u53f6\u5b50\u8282\u70b9\u5b58\u6570\u636e\u5e76\u94fe\u8868\u76f8\u8fde<\/figcaption><\/figure>\n

    Q1\uff1a\u4e3a\u4ec0\u4e48 MySQL \u7528 B+Tree \u800c\u4e0d\u662f BTree \u6216\u54c8\u5e0c\uff1f<\/strong><\/p>\n

      \n
    • \u5bf9\u6bd4\u54c8\u5e0c<\/strong>\uff1a\u54c8\u5e0c\u53ea\u652f\u6301\u7b49\u503c\u67e5\u8be2\uff0c\u4e0d\u652f\u6301\u8303\u56f4\u67e5\u8be2\u4e0e\u6392\u5e8f<\/strong>\uff0c\u800c\u4e1a\u52a1\u91cc BETWEEN<\/code>\u3001ORDER BY<\/code> \u6781\u5176\u5e38\u89c1\uff1b<\/li>\n
    • \u5bf9\u6bd4 BTree<\/strong>\uff1aB+Tree \u7684\u975e\u53f6\u5b50\u8282\u70b9\u53ea\u5b58\u952e\u503c\u4e0d\u5b58\u6570\u636e<\/strong>\uff0c\u56e0\u6b64\u5355\u4e2a\u8282\u70b9\u80fd\u5bb9\u7eb3\u66f4\u591a\u952e\uff0c\u6811\u9ad8\u66f4\u4f4e\u3001\u78c1\u76d8 I\/O \u6b21\u6570\u66f4\u5c11<\/strong>\uff1b<\/li>\n
    • B+Tree \u7684\u53f6\u5b50\u8282\u70b9\u7528\u94fe\u8868\u76f8\u8fde<\/strong>\uff0c\u8303\u56f4\u626b\u63cf\u53ea\u9700\u987a\u5e8f\u904d\u5386\u53f6\u5b50\u8282\u70b9\uff0c\u6548\u7387\u6781\u9ad8\u3002<\/li>\n<\/ul>\n

      Q2\uff1a\u805a\u7c07\u7d22\u5f15\u548c\u4e8c\u7ea7\u7d22\u5f15\u7684\u533a\u522b\uff1f\u4ec0\u4e48\u662f\u56de\u8868\uff1f<\/strong>
      \nInnoDB \u4e2d\uff0c\u805a\u7c07\u7d22\u5f15\u7684\u53f6\u5b50\u8282\u70b9\u5b58\u6574\u884c\u6570\u636e<\/strong>\uff08\u6309\u4e3b\u952e\u7ec4\u7ec7\uff09\uff1b\u4e8c\u7ea7\u7d22\u5f15\u7684\u53f6\u5b50\u8282\u70b9\u5b58\u4e3b\u952e\u503c<\/strong>\u3002\u901a\u8fc7\u4e8c\u7ea7\u7d22\u5f15\u67e5\u5230\u4e3b\u952e\u540e\uff0c\u518d\u5230\u805a\u7c07\u7d22\u5f15\u53d6\u5b8c\u6574\u884c\uff0c\u8fd9\u4e2a\u8fc7\u7a0b\u53eb\u56de\u8868<\/strong>\u3002<\/p>\n

      \u8ffd\u95ee\uff1a<\/strong>“\u600e\u4e48\u907f\u514d\u56de\u8868\uff1f” \u2192 \u8986\u76d6\u7d22\u5f15<\/strong>\uff1a\u8ba9\u67e5\u8be2\u7684\u5b57\u6bb5\u90fd\u5305\u542b\u5728\u7d22\u5f15\u91cc\uff0cEXPLAIN<\/code> \u4e2d\u4f1a\u51fa\u73b0 Using index<\/code>\u3002<\/p>\n

      Q3\uff1a\u6700\u5de6\u524d\u7f00\u539f\u5219\u662f\u4ec0\u4e48\uff1f<\/strong>
      \n\u5bf9\u8054\u5408\u7d22\u5f15 (a, b, c)<\/code>\uff0c\u67e5\u8be2\u6761\u4ef6\u5fc5\u987b\u4ece\u6700\u5de6\u5217\u5f00\u59cb\u8fde\u7eed\u5339\u914d<\/strong>\u624d\u80fd\u7528\u4e0a\u7d22\u5f15\u3002a=1 AND b=2<\/code> \u53ef\u7528\uff1bb=2<\/code> \u4e0d\u53ef\u7528\uff1ba=1 AND c=3<\/code> \u53ea\u80fd\u7528\u5230 a<\/code> \u90e8\u5206\u3002\u6ce8\u610f\uff1a\u8303\u56f4\u67e5\u8be2\u4e4b\u540e\u7684\u5217\u65e0\u6cd5\u7ee7\u7eed\u8d70\u7d22\u5f15<\/strong>\u3002<\/p>\n

      Q4\uff1a\u54ea\u4e9b\u60c5\u51b5\u7d22\u5f15\u4f1a\u5931\u6548\uff1f<\/strong><\/p>\n