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: