Re: Benchmarking innobase tables

2001-03-19 Thread Heikki Tuuri
Hi Peter and Christian! >>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 >>innoba

Re: Benchmarking innobase tables

2001-03-18 Thread Christian Jaeger
At 20:43 Uhr -0600 17.3.2001, Dan Nelson wrote: >In the last episode (Mar 17), Christian Jaeger said: >> innobase table: > > autocommit=0, rollback after each insert: 59 insert+rollback/sec. >> autocommit=0, one rollback at the end: 2926 inserts/sec. >> autocommit=0, one commit at the e