Adding a file in innodb
From Wikitech
edit /etc/my.cnf
at line innodb_data_file_path = /usr/local/mysql/data/ibdata1:20000M:autoextend
add the second file like this :
innodb_data_file_path = /usr/local/mysql/data/raid1/ibdata2:60000M;/usr/local/mysql/data/ibdata1:20000M:autoextend
Nota : the autoextend file must be the last on the line
- stop mysql : mysqladmin -u root -p shutdown
- start mysql : mysqld_safe
It could take some time, time to rebuild the innodb space. You can follow the process in .err file
