ITPub博客

首页 > 数据库 > MySQL > Configure innodb 表空间

Configure innodb 表空间

原创 MySQL 作者:yuanqc 时间:2018-08-03 14:59:40 0 删除 编辑

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] root@jptkytcdh01vl /var/lib/mysql # service mysqld start
Starting mysqld:   

 


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10973950/viewspace-2175603/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-11-23

  • 博文量
    47
  • 访问量
    102575