Re: Connection related SIG 11 crash in 3.23

2001-03-23 Thread vinod p
hey, i've been observing a similar kind of a problem with mysql 3.23.32 on a Linux 2.4.2 kernel. The backtrace that i'm getting is different, but even that fails a sanity check. When i resolved the incomplete backtrace, it showed me thread creation functions and something of that sort. The

Re: Mysql restarts at 100% CPU

2001-03-20 Thread vinod p
a 100-150 queries at that time. Tx. Vinod --- "Gerald L. Clark" <[EMAIL PROTECTED]> wrote: > 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

Re: Mysql restarts at 100% CPU

2001-03-18 Thread vinod p
=1 set-variable= back_log=2900 set-variable= connect_timeout=15 set-variable= wait_timeout=57600 set-variable= interactive_timeout=57600 Tx. Vinod. --- "Jeremy D. Zawodny" <[EMAIL PROTECTED]> wrote: > On Mon, Mar 19, 2001 at 12:34:30AM +, vinod p > wr

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 --

Re: am I alone? (scale)

2001-03-18 Thread vinod p
hey.. thanks for the info... This is the my.cnf file that i'm using - [mysqld] skip-locking set-variable= key_buffer=640M set-variable= max_allowed_packet=10M set-variable= table_cache=640 set-variable= sort_buffer=6M set-variable= record_buffer=6M set-variable= t

Heavy Load

2001-03-17 Thread vinod p
hey, i'm running serveral mysql servers on powerful machines - dual processor, 2 GB memory, etc... Most of the databases store temporary data only. I need the maximum performance from these servers and have a lot of connections to the database. My problem is this - whenever the number of qu