Re: Mysql restarts at 100% CPU

2001-03-20 Thread Bill Marrs
OH! You're running Apache. Why didn't you say so? Can I also assume that the Apache processes are the clients of Mysql? You can throttle back Apache to prevent a system crash much easier than you can throttle Mysql (IMHO). Use a line like this in Apache's httpd.conf file: MaxClients 50 Thi

Re: Mysql restarts at 100% CPU

2001-03-20 Thread vinod p
hi, i've not reconfigured linuxthreads. /proc/sys/kernel/threads-max has 57344. At the time when the machine hits 100% CPU, apache processes are taking most of the CPU time, and i have around 250 processes on the entire system, with around 10-15 running processes. mysqladmin status shows me a

Re: Mysql restarts at 100% CPU

2001-03-19 Thread Gerald L. Clark
You have mysqld set for 2000 connections. How many threads do you have Linux configured for, and how many are open when Mysqld crashs? vinod p wrote: > > hi, >thanks for the interest. The error log just prints > an incomplete backtrace that is exactly the same after > every crash. I ran

Re: Mysql restarts at 100% CPU

2001-03-18 Thread vinod p
hi, thanks for the interest. The error log just prints an incomplete backtrace that is exactly the same after every crash. I ran the incomplete backtrace through resolve, and it showed me functions such as thread start... etc... This is the backtrace that i've been getting for all the crashe

Re: Mysql restarts at 100% CPU

2001-03-18 Thread Jeremy D. Zawodny
On Mon, Mar 19, 2001 at 12:34:30AM +, vinod p wrote: > > my mysql server restarts automatically when the > machine touches 100% CPU usage. any ideas why? What does the error log say? Anything? -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 328-7878

Mysql restarts at 100% CPU

2001-03-18 Thread vinod p
hi, my mysql server restarts automatically when the machine touches 100% CPU usage. any ideas why? tx. vinod. Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in --