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) --------------------------------------------------------------------- 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
