Hi! ----- Original Message ----- From: ""Anthony R. J. Ball"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Monday, September 09, 2002 7:52 PM Subject: Re: SHOW VARIABLES bug in 4.0.3 on solaris 2.7?
> > > Just out of interest, do you see the equivalent of a core file when this > > happens? Or anything in the mysql logs? > > Don't see any cores... here is the error log entry > > mysqld got signal 10; I think that in the manual, in the changelog of 4.0.4, it says that this bug is fixed. Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB > This could be because you hit a bug. It is also possible that this binary > or one of the libraries it was linked against is corrupt, improperly built, > or misconfigured. This error can also be caused by malfunctioning hardware. > We will try our best to scrape up some info that will hopefully help diagnose > the problem, but since we have already crashed, something is definitely wrong > and this may fail. > > key_buffer_size=201322496 > read_buffer_size=8192 > sort_buffer_size=33554424 > max_used_connections=11 > max_connections=100 > threads_connected=12 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3474203 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > 020909 11:30:54 mysqld restarted > 020909 11:30:55 InnoDB: Out of memory in additional memory pool. > InnoDB: InnoDB will start allocating memory from the OS. > InnoDB: You may get better performance if you configure a bigger > InnoDB: value in the MySQL my.cnf file for > InnoDB: innodb_additional_mem_pool_size. > 020909 11:30:55 InnoDB: Started > /idcom/mysql-max-4.0.3/bin/mysqld: ready for connections > > > -- > ___ __ __ __ _ _ ____ _ _ ____ ____ > / __)( )( ) /__\( \/ )( ___) ( \( )( ___)(_ _) > \__ \ )(__)( /(__)\\ / )__) ) ( )__) )( > (___/(______)(__)(__)\/ (____)()(_)\_)(____) (__) > The mind boggles...the taste buds shudder. > > > --------------------------------------------------------------------- > 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
