Hello.
> = 77591546 K Really - something is wrong with your memory settings - MySQL is using about 77G of memory (or you have such a cool server :)! Please send the output of 'SHOW VARIABLES' statement, 'SHOW STATUS' statement and your configuration file. Include the amount of physical memory. David Sparks wrote: > mysql usually crashes when being shutdown. The machine is a dual AMD64 > w 8GB RAM running mysql-4.1.14 on Gentoo linux with a ~40GB database. I > had similar crashes running 4.0.24 on an x86 running a ~275GB database. > > I always use `mysqladmin shutdown` rather than the init scripts to > shutdown the daemon. > > Are there any known problems with shutting down large databases? > > Thanks, > > ds > > 050923 10:41:58 InnoDB: Starting shutdown... > 050923 10:44:00InnoDB: Assertion failure in thread 1174235488 in file > os0sync.c line 634 > InnoDB: Failing assertion: 0 == pthread_mutex_destroy(fast_mutex) > InnoDB: We intentionally generate a memory trap. > InnoDB: Submit a detailed bug report to http://bugs.mysql.com. > InnoDB: If you get repeated assertion failures or crashes, even > InnoDB: immediately after the mysqld startup, there may be > InnoDB: corruption in the InnoDB tablespace. Please refer to > InnoDB: http://dev.mysql.com/doc/mysql/en/Forcing_recovery.html > InnoDB: about forcing recovery. > mysqld got signal 11; > 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=2147483648 > read_buffer_size=33550336 > max_used_connections=217 > max_connections=768 > threads_connected=0 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections > = 77591546 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
