Lixora's DB Home

Focus, Fast, Efficent!

mysql 杂记 *dir 目录的理解

The innodb_data_home_dir default value is the MySQL data directory (datadir).

innodb_data_home_dir The common part of the directory path for InnoDB system tablespace data files.

innodb_data_file_path  :Defines the path and file size for individual InnoDB system tablespace data files. The full directory path for system tablespace data files is formed by concatenating path defined by innodb_data_home_dir and innodb_data_file_pathIf you specify the value as an empty string, you can specify an absolute file paths for innodb_data_file_path. 

datadir:The path to the MySQL data directory

eg:

[mysqld]
innodb_data_home_dir =
innodb_data_file_path=/path/to/myibdata/ibdata1:50M;/path/to/myibdata/ibdata2:50M:autoextend
















阅读更多
版权声明:本文为博主原创文章,未经博主允许不得转载。 https://blog.csdn.net/royjj/article/details/80690366
个人分类: MySql
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

加入CSDN,享受更精准的内容推荐,与500万程序员共同成长!
关闭
关闭