Hello Christian,
Sunday, March 18, 2001, 12:22:44 PM, you wrote:
>>
>>If you are going to be committing on every record, you'll want your
>>tablespace and logfile directories on separate disks to avoid
>>thrashing. If you only have one disk and don't care if you lose the
>>last few transactions if your system crashes, try setting
>>innobase_flush_log_at_trx_commit=0 in my.cnf.
CJ> Wow, thanks. With innobase_flush_log_at_trx_commit=0, the benchmark now shows:
CJ> autocommit=0, rollback after each insert: 1587 inserts+rollbacks/sec
CJ> autocommit=1: 2764 inserts/sec.
CJ> That's even faster than myisam (2487 inserts/sec today)!!!
In this case you should compare it to myisam created with
delay_key_write=1, also the size of key_buffer matter.
Also the problem with innobase_flush_log_at_trx_commit=0 should be
there is no guarantie the last transaction commited will be on it's
place if the power would be lost. Also I don't know is it possible in
this case for database to be corrupted as some transactions may modify
database but are not in a logfile (Let's ask Heikki about this).
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
