I believe it should be in the [mysqld] section. That being said, it didn't fix the problem for me. I had to add the "noatime" flag to the fstab entry for the partition the DB was on. Once I did that, it was pretty fast.
On Tue, Feb 18, 2014 at 5:47 PM, Pedro Picoto <[email protected]>wrote: > I've been running Rivendell in a 24/24 basis for about a week. Today I > stopped it to record some Vts. > > I getting the same problem that I stated here a few months ago: > > - > > It takes about 50'' to save VT, another to Do Over, ie, any operation > regarding VT is taking about 50''. > > I've backup the database and noticed that it grew from 1.2mb to 3mb in a > week, wich corresponds roughly to the period that RD was running 24/24. > > > My setup is a single pc. No network, audio files in the same HD as the > DB. > > > Someone answered me the last time giving this possible fix: > *Added : innodb-flush-log-at-trx-commit=2 to my.cnf**Now the voicetracker > responds in less than a second to the save button.* > Question: where in the my.cnf file should I paste this? I've pasted it as the > last line and had no effect. > > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev > >
_______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
