Any help appreciated. My MYSQL Server is dying with:
key_buffer_size=16777216 read_buffer_size=262144 max_used_connections=14 max_threads=151 threads_connected=5 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133314 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd: 0xb0020170 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 0xb2c5b36c thread_stack 0x30000 /usr/lib/mysql/libmysys.so.0(my_print_stacktrace+0x2d) [0xb7f132ad] /usr/sbin/mysqld(handle_segfault+0x474) [0x81c5ad4] [0xb7f64400] /usr/sbin/mysqld(dict_table_get+0x158) [0x8355738] /usr/sbin/mysqld(ha_innobase::open(char const*, int, unsigned int)+0x18b) [0x833073b] /usr/sbin/mysqld(handler::ha_open(st_table*, char const*, int, int)+0x38) [0x829aad8] /usr/sbin/mysqld(open_table_from_share(THD*, st_table_share*, char const*, unsigned int, unsigned int, unsigned int, st_table*, bool)+0x51b) [0x8212d0b] /usr/sbin/mysqld() [0x820a71f] /usr/sbin/mysqld(open_table(THD*, TABLE_LIST*, st_mem_root*, bool*, unsigned int)+0x71d) [0x820e07d] /usr/sbin/mysqld(open_tables(THD*, TABLE_LIST**, unsigned int*, unsigned int)+0x526) [0x820eb96] /usr/sbin/mysqld(open_and_lock_tables_derived(THD*, TABLE_LIST*, bool)+0x6b) [0x820ee2b] /usr/sbin/mysqld() [0x81cfbf2] /usr/sbin/mysqld(mysql_execute_command(THD*)+0x4d6) [0x81d2146] /usr/sbin/mysqld(mysql_parse(THD*, char*, unsigned int, char const**)+0x28f) [0x81d869f] /usr/sbin/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x4de) [0x81d8fde] /usr/sbin/mysqld(do_command(THD*)+0xb5) [0x81da235] /usr/sbin/mysqld(handle_one_connection+0x238) [0x81cc258] /lib/libpthread.so.0(+0x57d9) [0xb7f2c7d9] /lib/libc.so.6(clone+0x5e) [0xb79f528e] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x8c23828 = SELECT 1 FROM cache_admin_menu LIMIT 0, 1 thd->thread_id=1095 thd->killed=NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Trying google and thought here too. Any hints appreciated. Kindest Regards, Ashley -- Ashley Maher Director Didymo Designs Phone: 1300 762 599 (+61 2) 8090 2847 (+61 2) 4203 2716 Mob: 0412 351 451 Fax: (+61 2) 8002 0071 Web: http://www.didymodesigns.com.au P.O. Box 410 North Sydney NSW 2059 P.O. Box 1122 Wollongong NSW 2500 -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
