MySQL 5.7版本的6种Tablespace

《MySQL 5.7版本的6种Tablespace》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、5.7拥有的6种Tablespaces1.systemtablespaceTheInnoDBsystemtablespacecontainstheInnoDBdatadictionary(metadataforInnoDB-relatedobjects)andisthestorageareaforthedoublewritebuffer,thechangebuffer,andundologs.Thesystemtablespacealsocontainstableandindexdataforanyuser-createdtablesthatarecreatedin

2、thesystemtablespace.Thesystemtablespaceisconsideredasharedtablespacesinceitissharedbymultipletables.Thesystemtablespaceisrepresentedbyoneormoredatafiles.Bydefault,onesystemdatafile,namedibdata1,iscreatedintheMySQLdatadirectory.Thesizeandnumberofsystemdatafilesiscontrolledbytheinnodb_da

3、ta_file_pathstartupoption.增大系统表空间TheeasiestwaytoincreasethesizeoftheInnoDBsystemtablespaceistoconfigureitfromthebeginningtobeauto-extending.Specifytheautoextendattributeforthelastdatafileinthetablespacedefinition.ThenInnoDBincreasesthesizeofthatfileautomaticallyin64MBincrementswhenitru

4、nsoutofspace.Theincrementsizecanbechangedbysettingthevalueoftheinnodb_autoextend_incrementsystemvariable,whichismeasuredinmegabytesYoucanexpandthesystemtablespacebyadefinedamountbyaddinganotherdatafile:1.ShutdowntheMySQLserver.2.Ifthepreviouslastdatafileisdefinedwiththekeywordautoexten

5、d,changeitsdefinitiontouseafixedsize,basedonhowlargeithasactuallygrown.Checkthesizeofthedatafile,rounditdowntotheclosestmultipleof1024×1024bytes(=1MB),andspecifythisroundedsizeexplicitlyininnodb_data_file_path.3.Addanewdatafiletotheendofinnodb_data_file_path,optionallymakingthatfileaut

6、oextending.Onlythelastdatafileintheinnodb_data_file_pathcanbespecifiedasautoextending.4.StarttheMySQLserveragain.Forexample,thistablespacehasjustoneauto-extendingdatafileibdata1:innodb_data_home_dir=innodb_data_file_path=/ibdata/ibdata1:10M:autoextendSupposethatthisdatafile,overtime,ha

7、sgrownto988MB.Hereistheconfigurationlineaftermodifyingtheoriginaldatafiletouseafixedsizeandaddinganewauto-extendingdatafile:innodb_data_home_dir=innodb_data_file_path=/ibdata/ibdata1:988M;/disk2/ibdata2:50M:autoextendWhenyouaddanewdatafiletothesystemtablespaceconfiguration,makesureth