mysql and system/nice cpu usage

2004-10-31 Thread Omer Faruk Sen
Hi, I have web server which uses php+mysql. As far as I have searched the best thing to use mysql on FreeBSD is to use linuxthreads. For the performance and stability I have done following things on my FreeBSD-4.X Stable system: Compile mysql with linuxthreads and as static binary. I have

Re: mysql and system/nice cpu usage

2004-10-31 Thread Chuck Swiger
Omer Faruk Sen wrote: I have web server which uses php+mysql. As far as I have searched the best thing to use mysql on FreeBSD is to use linuxthreads. [ ... ] 240 processes: 7 running, 233 sleeping CPU states: 10.9% user, 73.9% nice, 12.5% system, 2.7% interrupt, 0.0% idle Mem: 244M Active,

Re: mysql and system/nice cpu usage

2004-10-31 Thread Omer Faruk Sen
Everything that is stated in tuning man page was done. What is interesting that this site was running more than 8 months without problem. But a few weeks ago system was started to behave like that. By the way isn't it interesting that mysql creates load on system and nice? I think mysql

Re: mysql and system/nice cpu usage

2004-10-31 Thread TM4525
In a message dated 10/31/04 11:03:12 AM Eastern Standard Time, [EMAIL PROTECTED] writes: but never come across with a problem like that. I am thinking to use Zend Optimizer. Maybe that helps me .. If that doesn't help I was thinking to run sql on a seperate machine. You might try tuning

Re: mysql and system/nice cpu usage

2004-10-31 Thread Omer Faruk Sen
Hi The oid you are talking about is not valid in FreeBSD-4. Maybe you are talking about FreeBSD-5 sysctl oids? But it does worth to try but I am not sure which oid it is in FreeBSD 4.. REGARDS PS: I have found vm.kvm_size. I think it is the one that corresponds in your email? [EMAIL

Re: mysql and system/nice cpu usage

2004-10-31 Thread Omer Faruk Sen
By the way here is my vmstat -m output: Memory statistics by bucket size Size In Use Free Requests HighWater Couldfree 16 105747917787211280 0 32 653 16512086878 640 19 64 130358 18122 19867705 320 27489 128 3120 2032

Re: mysql and system/nice cpu usage

2004-10-31 Thread TM4525
In a message dated 10/31/04 12:35:23 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Hi The oid you are talking about is not valid in FreeBSD-4. Maybe you are talking about FreeBSD-5 sysctl oids? But it does worth to try but I am not sure which oid it is in FreeBSD 4.. REGARDS PS: I