hi, our mysql database has a growing ibdata1 file that is starting to fill the /var partition. STFW recommends dumping the opsview database and recreating it.
I have read the opsview recommendations http://docs.opsview.org/doku.php?id=opsview3.0:prereqs#mysql and used the options. innodb_file_per_table=1 innodb_flush_log_at_trx_commit=2 I have applied them (debian lenny mysql server) and restarted the mysql daemon. Should I now backup the opsview database, drop it, and recreate it while the opsview daemons are stopped? How can I prevent this file from growning again? -- Groeten, natxo _______________________________________________ Opsview-users mailing list [email protected] http://lists.opsview.org/lists/listinfo/opsview-users
