Обсуждение: can we optimize STACK_DEPTH_SLOP

Поиск
Список
Период
Сортировка

can we optimize STACK_DEPTH_SLOP

От
"terry"
Дата:
hi,
STACK_DEPTH_SLOP stands for Required daylight between max_stack_depth and the kernel limit, in bytes.
Why we need so much memory? MySql need only no more than 100K. Where these memory allocated for?
Can we do something to decrease this variable? Thanks.

Re: can we optimize STACK_DEPTH_SLOP

От
Tom Lane
Дата:
"=?ISO-8859-1?B?dGVycnk=?=" <94487509@qq.com> writes:
> STACK_DEPTH_SLOP stands for Required daylight between max_stack_depth and the kernel limit, in bytes.
> Why we need so much memory? MySql need only no more than 100K. Where these memory allocated for?

That's not memory, that's just address space.  Cutting it will not
really buy you anything; it'll just increase your risk of stack-overflow
crashes.

            regards, tom lane

Re: can we optimize STACK_DEPTH_SLOP

От
"terry"
Дата:
Thanks for your help!
But why we set STACK_DEPTH_SLOP to 512K, not 128K?
What it according to?