Re: Flush_time question and related item

2004-12-17 Thread Terry Riley
Gleb - Original Message - > Hello. > > > >Does that imply that if we set this flush_time value to zero (ie no > >periodic flush to disk), then some of the data will not be committed to > >disk, and if we had a subsequent power failure, then any data since the > >last flush would be lost

Re: Flush_time question and related item

2004-12-17 Thread Gleb Paharenko
Hello. >Does that imply that if we set this flush_time value to zero (ie no >periodic flush to disk), then some of the data will not be committed to >disk, and if we had a subsequent power failure, then any data since the >last flush would be lost? We have innodb_flush_log_at_trx_commit set

Flush_time question and related item

2004-12-16 Thread Terry Riley
We're running mostly with InnoDB tables, about 5% updates/inserts/deletes, the rest selects, on Windows NT. In setting table_cache to 256 from the default 64, we hoped to improve performance a little, by not having to continually close/open tables. Then we noticed that the opened table count d