Re^2: Perl solution for storage of large number of small files

in reply to Re: Perl solution for storage of large number of small files
in thread Perl solution for storage of large number of small files

InnoDB must flush the log to disk at each transaction commit if that transaction made modifications to the database. ... constrains the number of commits to the same 167th of a second

unless you set innodb_flush_log_at_trx_commit to 0, which switches it to flush once a second.
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html

HTH, andye

Comment on Re^2: Perl solution for storage of large number of small files Download Code

Replies are listed 'Best First'.
Re^3: Perl solution for storage of large number of small files by mattr (Curate) on May 02, 2007 at 22:14 UTC
Thanks, that is the page I was looking at, why I mentioned "1 second or so". It seemed he was unwilling to wait that long but buffering it would it seems increase efficiency.	[reply]

In Section Seekers of Perl Wisdom