Re: [PERFORM] can we optimize STACK_DEPTH_SLOP

2010-02-20 Thread terry
Thanks for your help! But why we set STACK_DEPTH_SLOP to 512K, not 128K? What it according to?

Re: [PERFORM] can we optimize STACK_DEPTH_SLOP

2010-02-20 Thread Tom Lane
"=?ISO-8859-1?B?dGVycnk=?=" <94487...@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 ad

[PERFORM] can we optimize STACK_DEPTH_SLOP

2010-02-20 Thread 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.

[PERFORM] can we optimize STACK_DEPTH_SLOP

2010-02-20 Thread 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.