Where am I wasting resources? How to fix this problem?

[Peter]

VeeJay wrote:
> Thanks Wojciech
> 
> How can I find out the process count limit and how can I change it?
> 
> And what is the maximum limit I can give with this hardware?
> 
> 


Hello Veejay,

Add thise to your loader.conf

mysql# cat /boot/loader.conf
kern.maxdsiz="4096M"
kern.dfldsiz="2048M"
kern.maxssiz="1024MB"


and reboot the system. This should help.

These are values from one my  mysql boxes.

It is also also in mysql notes for freebsd(see bottom)

http://dev.mysql.com/doc/refman/5.1/en/freebsd.html


Peter