首页 > 数据库 > MySQL > Configure innodb 表空间
1. Stop mysql service
[LAB] root@jptkytcdh01vl ~ # service mysqld stop
Stopping mysqld: [ OK ]
2. Remove innodb related files
[LAB] root@jptkytcdh01vl /var/lib/mysql # mkdir bak
[LAB] root@jptkytcdh01vl /var/lib/mysql # mv ib_logfile1 bak
[LAB] root@jptkytcdh01vl /var/lib/mysql # mv ib_buffer_pool bak
[LAB] root@jptkytcdh01vl /var/lib/mysql # mv ib_logfile0 bak
[LAB] root@jptkytcdh01vl /var/lib/mysql # mv ibdata1 bak
3. Add below lines.
[LAB] root@jptkytcdh01vl /var/lib/mysql # diff /etc/my.cnf /etc/my.cnf.20180803
9,10d8
< innodb_data_home_dir=/var/lib/mysql
< innodb_data_file_path=ibdata1:500m;ibdata2:500m
4. Start mysql service
[LAB]
/var/lib/mysql # service mysqld start
Starting mysqld:
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10973950/viewspace-2175603/,如需转载,请注明出处,否则将追究法律责任。