Group commit in innodb?

2002-04-05 Thread Magnus Enbom
Hi, Does InnoDB use some form of "group commit" like BerkeleyDB and Postgresql? In Postgresql you can specify a "COMMIT_DELAY" to force a wait before the commit returns. Disk IO to the log files can be reduced quite alot if you tweak this setting, and it can be very useful when tuning batch-like

Query cache and InnoDB tables?

2001-12-16 Thread Magnus Enbom
Hi, I'm trying out the new query cache features in mysql4. Are the cache supposed to work with innodb tables? It's not according to the output of show status, works fine with myisam tables. I'm ran a 'bk pull -l' this morning and compiled with Suns cc on a Solaris-x86 box. It looks like this: