From: Vladislav Shpilevoy <v.shpilevoy@tarantool.org> To: "n.pettik" <korablev@tarantool.org>, tarantool-patches@freelists.org Cc: Imeev Mergen <imeevma@tarantool.org> Subject: [tarantool-patches] Re: [PATCH v8 1/3] box: factor fiber_gc out of txn_commit Date: Wed, 31 Oct 2018 00:32:38 +0300 [thread overview] Message-ID: <87a13566-e414-1527-24a7-31a5d6402170@tarantool.org> (raw) In-Reply-To: <e11f5834-b3dc-4048-170b-7abe2dcbe571@tarantool.org> On 30/10/2018 23:06, Vladislav Shpilevoy wrote: > > > On 30/10/2018 23:03, Vladislav Shpilevoy wrote: >> Thanks for the review! >> >> On 30/10/2018 17:30, n.pettik wrote: >>> >>> >>>> On 29 Oct 2018, at 20:33, imeevma@tarantool.org wrote: >>>> >>>> Now txn_commit is judge, jury and executioner. It both >>>> commits or rollbacks data, and collects it calling fiber_gc, >>>> which destroys the region. >>> >>> Nit: both commits and rollbacks. >> >> Fixed. >> >>> >>>> >>>> But SQL wants to use some transactional data after commit. It is >>>> autogenerated identifiers - a list of sequence values generated >>>> for autoincrement columns and explicit sequence:next() calls. >>>> >>>> It is possible to store the list on malloced mem inside Vdbe, but >>>> it complicates deallocation. >>> >>> What is the problem with deallocation? AFAIU it is enough to >>> simply iterate over the list and release each element - not big deal. >>> >>> If you want to use region, mb it is worth to store separate region >>> specially for VDBE? We already have it in parser, so what prevents >>> us for adding the same thing to VDBE? I guess we can store many >>> things there, not only list of ids. I understand that parser in its turn >>> has nothing in common (at least it should, except for analyze machinery) >>> with transaction routines, so separate region is likely to be more >>> reasonable for parser, but anyway... >>> >> >> I've decided to say more details. Parser never yields. This is why we can >> waste here any resources, rack and ruin everything, but at the end of >> parsing it should be returned back. >> >> Vdbe, on the contrary, yields. So it holds some system resources while >> other fibers can not use them. If we added a special region to Vdbe, it >> would steal slabs from the thread's slab cache, while other fibers may >> want to use it. Hence, when we use one region for all transactional data, >> including language specific, allocations are much less fragmented over >> different slabs. >> >> Is this explanation decent? >> >> Also, I do not agree, that 'deallocation is just iteration and it is >> ok'. It is O(n) iteration and freeing of heap objects. If a one inserted >> 10k rows with autogenerated ids, it would waste 10k heap fragments, >> 10k calls of malloc/free - in my opinion it is an abysmal overhead, but >> what is more, it can be avoided for free. Instead of 10k free() it boils >> down to deallocation of N slabs, where N = slab_size / (10k * 8); 8 - size >> of autogenerated it; slab size is at least 64Kb, so N = 64*1024/80000 < 1. >> It takes 1 deallocation vs 10k deallocations. So I think this refactoring >> is worth. > > Sorry, an error. N = 10Kb * 8 / slab_size ~= 2. Versus 10k still is > significant. > >> >> 10Kb -> 10k, sorry again. I should go sleep ... >
next prev parent reply other threads:[~2018-10-30 21:32 UTC|newest] Thread overview: 18+ messages / expand[flat|nested] mbox.gz Atom feed top 2018-10-29 17:33 [tarantool-patches] [PATCH v8 0/3] sql: return all generated ids via IPROTO imeevma 2018-10-29 17:33 ` [tarantool-patches] [PATCH v8 1/3] box: factor fiber_gc out of txn_commit imeevma 2018-10-30 14:30 ` [tarantool-patches] " n.pettik 2018-10-30 19:15 ` Vladislav Shpilevoy 2018-10-30 20:03 ` Vladislav Shpilevoy 2018-10-30 20:06 ` Vladislav Shpilevoy 2018-10-30 21:32 ` Vladislav Shpilevoy [this message] 2018-10-30 23:08 ` n.pettik 2018-10-31 9:18 ` Vladislav Shpilevoy 2018-10-31 9:30 ` n.pettik 2018-10-29 17:33 ` [tarantool-patches] [PATCH v8 2/3] sql: return all generated ids via IPROTO imeevma 2018-10-30 14:30 ` [tarantool-patches] " n.pettik 2018-11-02 18:52 ` Imeev Mergen 2018-11-09 7:51 ` n.pettik 2018-10-29 17:33 ` [tarantool-patches] [PATCH v8 3/3] sql: remove psql_txn from Vdbe imeevma 2018-10-30 14:30 ` [tarantool-patches] " n.pettik 2018-10-30 19:41 ` Vladislav Shpilevoy 2018-11-09 8:02 ` [tarantool-patches] Re: [PATCH v8 0/3] sql: return all generated ids via IPROTO Kirill Yukhin
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --in-reply-to=87a13566-e414-1527-24a7-31a5d6402170@tarantool.org \ --to=v.shpilevoy@tarantool.org \ --cc=imeevma@tarantool.org \ --cc=korablev@tarantool.org \ --cc=tarantool-patches@freelists.org \ --subject='[tarantool-patches] Re: [PATCH v8 1/3] box: factor fiber_gc out of txn_commit' \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox