Reindl, 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? On Thu, Apr 17, 2014 at 2:15 PM, Reindl Harald <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