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 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 crashes -
> -----------------------------------
> Cannot determine thread, ebp=0xbffff24c, backtrace may
> not be correct
> stack range sanity check, ok, backtrace follows
> 0x40077552
> 0x40076f0f
> 0x80bdb6a
> 0x80bdfdf
> 0x80bd75d
> 0x400f99cb
> 0x80884b1
> New value of ebp failed sanity check terminating
> backtrace
> --------------------------------
> We have been doing testing of our software and in
> all the runs, with all the mysql servers, this problem
> has been experienced. As soon as the server reaches
> 100% CPU, the mysql server restarts. Without a single
> exception till now.
> The servers are RedHat Linux 6.2 with kernel 2.4.2,
> PHP 4.0.4pl1, apache 1.3.14 and mysql 3.23.32. The
> my.cnf file i'm using is this -
>
> [mysqld]
> port = 3306
> socket = /tmp/mysql.sock
> 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 = thread_cache=16
> set-variable = thread_concurrency=16
> set-variable = myisam_sort_buffer_size=64M
> log-bin
> server-id = 1
> set-variable = max_connections=2000
> set-variable = max_connect_errors=10000
> 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 +0000, 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 Fax: (408) 530-5454
> > Cell: (408) 439-9951
>
> ____________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.co.in address at http://mail.yahoo.co.in
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
