{"id":575,"date":"2009-08-12T10:29:13","date_gmt":"2009-08-12T02:29:13","guid":{"rendered":"http:\/\/orczhou.com\/?p=575"},"modified":"2010-04-14T11:39:00","modified_gmt":"2010-04-14T03:39:00","slug":"image-innodb-tablespace","status":"publish","type":"post","link":"https:\/\/www.orczhou.com\/index.php\/2009\/08\/image-innodb-tablespace\/","title":{"rendered":"\u56fe\u8bf4\uff1aInnoDB\u4e4b\u8868\u7a7a\u95f4"},"content":{"rendered":"

InnoDB\u662fMySQL\u7684\u91cd\u8981\u5b58\u50a8\u5f15\u64ce\uff0c\u4e3a\u6570\u636e\u63d0\u4f9b\u4e86\u5f88\u597d\u7684\u7a33\u5b9a\u6027\u3002\u4e00\u65b9\u9762\uff0c\u5b83\u501f\u9274\u4e86\u5f88\u591aORACLE\u7279\u6027\uff0c\u53e6\u4e00\u65b9\u9762InnoDB\u4e5f\u6709\u5f88\u591a\u81ea\u5df1\u7684\u7279\u70b9\u8bf8\u5982Insert buffering\u3001Double write\u7b49[2]<\/sup>\u3002\u4e86\u89e3InnoDB\u7684\u5185\u90e8\u673a\u5236\uff0c\u53ef\u4ee5\u5e2e\u52a9\u6211\u4eec\u66f4\u597d\u7684\u914d\u7f6e\u548c\u4f18\u5316\u5b83\u3002\u672c\u6587\u6982\u8ff0\u4e86InnoDB\u7684\u8868\u7a7a\u95f4\u7684\u7ed3\u6784\uff0c\u7b97\u662f\u6df1\u5165\u4e86\u89e3\u7684\u7b2c\u4e00\u6b65\u3002\u4e0a\u56fe\u5148\uff1a<\/p>\n

\"TableSpaceInnoDB\"<\/a><\/p>\n

    \n
  1. \u5728\u914d\u7f6e\u6587\u4ef6\u4e2d\u53ef\u4ee5\u914d\u7f6eInnoDB\u7684\u8868\u7a7a\u95f4[1]<\/sup>\uff0c\u4e00\u822c\u683c\u5f0f\u5982\u4e0b(\u5171\u4eab\u8868\u7a7a\u95f4)\uff1a
    \ndatadir = \/opt\/mysql\/data
    \ninnodb_data_file_path=ibdata1:1G;ibdata2:1G;ibdata3:1G;ibdata4:1G;ibdata5:1G<\/li>\n
  2. \u5b8c\u6574\u7684\u8868\u7a7a\u95f4\uff0c\u4f1a\u88ab\u5206\u6210\u5982\u4e0b\u7ed3\u6784\u4f9b\u7ed9InnoDB\u4f7f\u7528\u3002\u6700\u5c0f\u5355\u4f4d\u662fpage\uff0c\u6bcf\u4e2apage\u4e3a16K\uff1b64\u4e2a\u8fde\u7eed\u7684page\u7ec4\u6210\u4e00\u4e2aextent\uff1b\u591a\u4e2aextent\u548cpage\u6784\u6210\u4e00\u4e2asegment\u3002Segment\u521d\u59cb\u65f6InnoDB\u4f1a\u4e3a\u5b83\u5206\u914d32\u4e2apages\uff0c\u4e4b\u540e\u6839\u636e\u9700\u8981\u4f1a\u5c06extent\u5206\u914d\u7ed9segment\uff0c\u5355\u6b21\u6700\u591a\u4f1a\u5206\u914d4\u4e2aextends\u7ed9segment\u3002[1]<\/sup><\/li>\n
  3. \u5177\u4f53\u7684\uff0cInnoDB\u4e2d\u4e00\u4e2a\u7d22\u5f15\uff08B-tree\uff09\u7531\u4e24\u4e2asegment\u7ec4\u6210\u3002\u5176\u4e2d\uff0c\u6240\u6709\u7684\u53f6\u5b50\u8282\u70b9\uff08leaf nodes\uff09\u5b58\u653e\u5728\u4e00\u4e2asegment\u4e2d\uff0c\u6240\u6709\u7684\u975e\u53f6\u5b50\u8282\u70b9\uff08nonleaf nodes\uff09\u5b58\u653e\u5728\u4e00\u4e2asegment\u4e2d\u3002[1]<\/sup><\/li>\n
  4. \u4e00\u4e2a\u5b58\u653e\u8bb0\u5f55(row)\u7684page\uff0c\u7531page header\u3001page trailer\u3001page body\u7ec4\u6210\u3002\u5982\u4e0b\u56fe:[2]<\/sup>
    \n    \"page_with_rows\"<\/a><\/li>\n
  5. \u76f8\u5173\u7684InnoDB\u7684\u53c2\u6570:innodb_data_file_path\u3002<\/li>\n<\/ol>\n

    \u53c2\u8003\u6587\u732e:<\/p>\n

      \n
    1. http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/innodb-file-space.html<\/a><\/li>\n
    2. InnoDB Internals: InnoDB File Formats and Source Code Structure,MySQL Conference, April 2009, Heikki Tuuri CEO Innobase, Calvin Sun Principal Engineer, Oracle Corporation<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

      InnoDB\u662fMySQL\u7684\u91cd\u8981\u5b58\u50a8\u5f15\u64ce\uff0c\u4e3a\u6570\u636e\u63d0\u4f9b\u4e86\u5f88\u597d\u7684\u7a33\u5b9a\u6027\u3002\u4e00\u65b9\u9762\uff0c\u5b83\u501f\u9274\u4e86\u5f88\u591aORACLE\u7279\u6027\uff0c\u53e6\u4e00\u65b9\u9762InnoDB\u4e5f\u6709\u5f88\u591a\u81ea\u5df1\u7684\u7279\u70b9\u8bf8\u5982Insert buffering\u3001Double write\u7b49[2]\u3002\u4e86\u89e3InnoDB\u7684\u5185\u90e8\u673a\u5236\uff0c\u53ef\u4ee5\u5e2e\u52a9\u6211\u4eec\u66f4\u597d\u7684\u914d\u7f6e\u548c\u4f18\u5316\u5b83\u3002\u672c\u6587\u6982\u8ff0\u4e86InnoDB\u7684\u8868\u7a7a\u95f4\u7684\u7ed3\u6784\uff0c\u7b97\u662f\u6df1\u5165\u4e86\u89e3\u7684\u7b2c\u4e00\u6b65\u3002\u4e0a\u56fe\u5148\uff1a<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_eb_attr":"","inline_featured_image":false,"_tocer_settings":[],"footnotes":""},"categories":[6],"tags":[120,16,45],"class_list":["post-575","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-innodb","tag-mysql-innodb-tablespace","tag-45"],"_links":{"self":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/575","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/comments?post=575"}],"version-history":[{"count":17,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/575\/revisions"}],"predecessor-version":[{"id":1812,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/posts\/575\/revisions\/1812"}],"wp:attachment":[{"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/media?parent=575"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/categories?post=575"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orczhou.com\/index.php\/wp-json\/wp\/v2\/tags?post=575"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}