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

On Thursday 30 April 2009 21:49:13 Chuck Swiger wrote: Hi, VeeJay-- On Apr 30, 2009, at 12:02 PM, VeeJay wrote: Guys, I am not very good on freebsd, its you guys who help me to keeping my server up... I hope you can spare a few minutes to sort this problem... last pid: 19656; load

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

Hi Mel I tried your suggestions by giving values vm.kmem_size_max=1024M vm.kmem_size=1024M but still got mysql hung without any luck here is the top output: even though there is plenty of free memory Guys, I am not very good on freebsd, its you guys who help me to

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

Hi, VeeJay-- On Apr 30, 2009, at 12:02 PM, VeeJay wrote: Guys, I am not very good on freebsd, its you guys who help me to keeping my server up... I hope you can spare a few minutes to sort this problem... last pid: 19656; load averages: 1.00, 1.00, 1.00 up 2+05:00:12 19:18:47 3049

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

Hi, VeeJay-- On Apr 30, 2009, at 12:02 PM, VeeJay wrote: Guys, I am not very good on freebsd, its you guys who help me to keeping my server up... I hope you can spare a few minutes to sort this problem... last pid: 19656; load averages: 1.00, 1.00, 1.00 up 2+05:00:12 19:18:47 3049

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

Hello guys and gurus I am keep getting this error after a while *1135: Can't create a new thread (errno 35); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug* Even though, I have 16GB memory and 32GB swap. But mysqlserver stops answering. Could

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

Hi folks then if I check with the process: I get following output: # ps ax | grep mysqld 797 con- I 0:00.00 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var/db/mysql/my.cnf --user=mysql --datadir=/var/db/mysql --pid-file=/var/db/mysql/localhost.server1.pid 835 con- S

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

#define EAGAIN 35 /* Resource temporarily unavailable */ check your process count limit. On Tue, 28 Apr 2009, VeeJay wrote: Sorry Folks, I should have provided complete information in order to get help... I am running DB: Server version: 5.0.77-log FreeBSD

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

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

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

Hello Peter Thanks... I have tried the values but even after rebooting, I am still getting the same old values as: server1# sysctl -a | grep maxdsiz compat.ia32.maxdsiz: 536870912 server1# sysctl -a | grep maxssiz compat.ia32.maxssiz:

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

Sorry Folks, I should have provided complete information in order to get help... I am running DB: Server version: 5.0.77-log FreeBSD port: mysql-server-5.0.77_1 OS: FreeBSD 7.1 And I am keep getting this error after a while *1135: Can't create a new thread (errno 35); if you are not

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

[r...@wojtek ~]# sysctl -a |grep maxpr kern.maxproc: 5266 kern.maxprocperuid: 4739 i don't know if there is limit ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail

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

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? -- Thanks! BR / vj ___ freebsd-questions@freebsd.org mailing list

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

On Tuesday 28 April 2009 14:29:42 Wojciech Puchar wrote: [r...@wojtek ~]# sysctl -a |grep maxpr kern.maxproc: 5266 kern.maxprocperuid: 4739 i don't know if there is limit Not relevant. See pthread_create(): EAGAIN is returned for lack of kernel memory or going over PHTREAD_THREADS_MAX

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

On Tuesday 28 April 2009 14:21:45 VeeJay wrote: Hello Peter Thanks... I have tried the values but even after rebooting, I am still getting the same old values as: server1# sysctl -a | grep maxdsiz compat.ia32.maxdsiz: 536870912 server1# sysctl -a | grep maxssiz

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

Hej Mel Well, I have removed these values kern.maxdsiz=4096M kern.dfldsiz=2048M kern.maxssiz=1024MB and have added: vm.kmem_size_max=1024M vm.kmem_size=1024M having crossed my fingers and hoping, I don't get this