thd=0x8711568 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... Cannot determine thread, fp=0xb5693c98, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x819fbed String::set_ascii(char const*, unsigned int) + 125 0x834508f __bam_dpages + 223 0x824e984 simple_pred(Item_func*, Item**, bool*) + 420 0x8277437 READ_INFO::find_start_of_fields() + 87 0x82761d2 mysql_recreate_table(THD*, TABLE_LIST*) + 3506 0x8200ef3 JOIN::optimize() + 6435 0x8202a5d JOIN::optimize() + 13453 0x82032e1 JOIN::optimize() + 15633 0x81b8235 mysql_new_select(st_lex*, bool) + 229 0x81bb450 mysql_execute_command(THD*) + 12080 0x81bb92c mysql_execute_command(THD*) + 13324 0x81bcc4b mysql_execute_command(THD*) + 18219 0x81bd684 mysql_execute_command(THD*) + 20836 0xb7e1818b _end + -1351060397 0xb7c4304e _end + -1352981738 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://dev.mysql.com/doc/mysql/en/using-stack-trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at 0x895a4b8 = show status thd->thread_id=14430 The manual page at http://www.mysql.com/doc/en/Crashing.html contains information that should help you find out what is causing the crash.