Re: [Maria-developers] [Commits] 13b5098: MDEV-9531: GROUP_CONCAT with ORDER BY inside takes a lot of memory while it's executed

2016-09-26 Thread Oleksandr Byelkin
On 26.09.2016 19:03, Sergei Golubchik wrote: Hi, Oleksandr! On Sep 26, Oleksandr Byelkin wrote: A hackish workaround could be to adjust tree->elements_limit (in Item_func_group_concat::add) after each insertion. But in this case it would be simpler to limit the tree by size (in bytes) and

Re: [Maria-developers] [Commits] 13b5098: MDEV-9531: GROUP_CONCAT with ORDER BY inside takes a lot of memory while it's executed

2016-09-26 Thread Sergei Golubchik
Hi, Oleksandr! On Sep 26, Oleksandr Byelkin wrote: > > > > A hackish workaround could be to adjust tree->elements_limit (in > > Item_func_group_concat::add) after each insertion. But in this case > > it would be simpler to limit the tree by size (in bytes) and adjust > > tree size after each

Re: [Maria-developers] [Commits] 13b5098: MDEV-9531: GROUP_CONCAT with ORDER BY inside takes a lot of memory while it's executed

2016-09-26 Thread Oleksandr Byelkin
On 22.09.2016 17:10, Sergei Golubchik wrote: Hi, Oleksandr! On Jun 28, Oleksandr Byelkin wrote: revision-id: 13b5098fcaa888173472d255e29aff22bcc5baae (mariadb-10.1.13-18-g13b5098) parent(s): 732adec0a4c75d99389230feeb0deca0ad668de7 committer: Oleksandr Byelkin timestamp: 2016-06-28 10:59:59

Re: [Maria-developers] [Commits] 13b5098: MDEV-9531: GROUP_CONCAT with ORDER BY inside takes a lot of memory while it's executed

2016-09-22 Thread Sergei Golubchik
Hi, Oleksandr! On Jun 28, Oleksandr Byelkin wrote: > revision-id: 13b5098fcaa888173472d255e29aff22bcc5baae > (mariadb-10.1.13-18-g13b5098) > parent(s): 732adec0a4c75d99389230feeb0deca0ad668de7 > committer: Oleksandr Byelkin > timestamp: 2016-06-28 10:59:59 +0200 > message: > > MDEV-9531: