mysql is stopping because of ibdata1 file size

on mysql /var/lib/mysql

there is one file called 'ibdata1' which is very large and it took large space from my server and the mysql didn't start

how can I stop growing ibdata1 file size please help me

many thanks

1 Answer

It's a common question since mysql 5.5.

common way to resolve this issue:

1. Dump all databases
2. Stop MySQL server
3. Add "innodb_file_per_table" option to your my.cnf
4. import your databases

I found a shell script here. for your reference.

Reference:

• [1]
• [2]
• [3]
• [4]