Re: delay_key_write
Hello,
If you are using non-transactional Maria tables (CREATE TABLE... ENGINE=MARIA TRANSACTIONAL=0), which are pretty similar to MyISAM, yes DELAY_KEY_WRITE works as you expect.
If you are using transactional Maria tables (the default), then DELAY_KEY_WRITE is somehow always enabled. Let me explain.
In MyISAM and non-transactional Maria tables (which have no logging), by default all the table's key pages are flushed to the OS at the end of each statement, to guarantee some durability; and DELAY_KEY_WRITE removes this flush, giving less durability. In transactional Maria tables, key pages are flushed by a background job, regularly, not necessarily at the end of each statement, and durability is guaranteed thanks to logging.
Subject
Written By
Posted
February 24, 2008 05:30AM
Re: delay_key_write
February 25, 2008 09:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.