On Thu, Apr 17, 2014 at 2:28 PM, Reindl Harald <h.rei...@thelounge.net>wrote:
> > > Am 17.04.2014 10:55, schrieb Ajay Garg: > > I do understand the meaning of Unix "sync" function. > > > > So, you mean to say that "flushing" and "syncing" are same, in the > context of MySQL? > > please get rid of top-posting and reply-all > > a flush without a sync is "dear operating system, may i ask you to write > that to disk if you find the time to do so" while a sync is "write that > to disk" without a nice asking > Thanks Reindl, that clears it up !! > > > On Thu, Apr 17, 2014 at 2:15 PM, Reindl Harald > > <h.rei...@thelounge.net<mailto: > h.rei...@thelounge.net>> wrote: > > > > > > Am 17.04.2014 10:37, schrieb Ajay Garg: > > > I am a newbie to MySQL, and have been going through several online > > > resources. > > > > > > I usually come across the terms - "flushing" and "syncing" the > log-buffer. > > > In particular, these two terms hold great significance while > selecting the > > > value of > > "innodb_flush_log_at_trx_commit< > http://dev.mysql.com/doc/refman/4.1/en/innodb-parameters.html#sysvar_innodb_flush_log_at_trx_commit > > > > > ". > > > > > > So, I will be grateful if I could gain some light on the > differences > > > between the two terms > > > > > > SYNC(1) User Commands > > SYNC(1) > > > > NAME > > sync - flush file system buffers > > > > SYNOPSIS > > sync [OPTION] > > > > DESCRIPTION > > Force changed blocks to disk, update the super block > > -- Regards, Ajay