Jeremy, do we have the control as to WHEN to update the actual tables??? Thanx.. Ritu Singla
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > On Mon, Jun 03, 2002 at 07:07:29AM +0100, ritu > singla wrote: > > Hello, > > > > in InnoDB tables in MySQL, if > > innodb_flush_log_at_trx_commit is set to 1, then > on > > COMMIT, the buffer log is flushed to disk log... > > Right. > > > or the changes are reflected in the disk copy of > the database??? i > > mean what is flushed, the buffer-pool that > contains data and indexes > > or the log-buffer?? > > Log buffer. > > Once the transaction is in the on-disk log, it's > durable. InnoDB can > choose to update the actual tables later. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: > (408) 685-5936 > > MySQL 3.23.51: up 4 days, processed 97,368,631 > queries (264/sec. avg) ________________________________________________________________________ Everything you always wanted to know about cars and bikes,now at: http://in.autos.yahoo.com/cricket/tracker.html --------------------------------------------------------------------- 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