Mysql issue: growing ibdata1 file

This file is growing pretty fast in my stack (6.3). I wonder how I can prevent it from auto-extending? Editing the my.cnf file and inserting “skip-innodb” doesn’t do the trick, I get a start up error.

I have little knowledge of mysql but apparently it can be set up so that this does not occur. I wonder how that would work on Drupal?

All best,
Gerben

Hi,

Honestly, I don’t know the solution for this issue, but I have found some links that may prove useful

http://paradigma.pt/ja/slog/index.php/2007/03/mysql-ibdata1-doesnt-reduce-its-size.html
http://forums.mysql.com/read.php?22,73086,73086#msg-73086

Tell us if it worked!

Cheers

Thanks, I’ll check it out!

G