This is a discussion on MySQL Debug information via Stack Trace. within the MySQL Database forums, part of the Database Forums category; Hello, Everybody, My MySQL installation is version 4.0.22 in a Redhat Enterprise Linux 4. And the rpm package ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
Hello, Everybody,
My MySQL installation is version 4.0.22 in a Redhat Enterprise Linux 4. And the rpm package is downloaded from the official MySQL website. One day, the MySQL daemon died unexpected. And i follow the guide in http://dev.mysql.com/doc/refman/5.0/...ack-trace.html to dump the error message. But i could not understand what it said. Could someone pick me up. Here is the infomration: [root@mysql tmp]# resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack 0x8072da4 handle_segfault + 420 0x826d468 pthread_sighandler + 184 0x82684d4 my_like_range_gbk + 260 0x80c15f0 get_mm_leaf__FP13st_qsel_paramP5FieldP11st_key_par tQ29Item_func8FunctypeP4Item + 592 0x80c1308 get_mm_parts__FP13st_qsel_paramP5FieldQ29Item_func 8FunctypeP4Item11Item_result + 248 0x80c1178 get_mm_tree__FP13st_qsel_paramP4Item + 1096 0x80c0a5d test_quick_select__10SQL_SELECTP3THDUlUlUlb + 925 0x8098ff9 get_quick_record_count__FP3THDP10SQL_SELECTP8st_ta bleUlUl + 57 0x80999e8 make_join_statistics__FP4JOINP13st_table_listP4Ite mP16st_dynamic_array + 2488 0x8097ac9 mysql_select__FP3THDP13st_table_listRt4List1Z4Item P4ItemP8st_orderT4T3T4UlP13select_result + 2265 0x80971b6 handle_select__FP3THDP6st_lexP13select_result + 102 0x807e182 mysql_execute_command__Fv + 1154 0x8081be5 mysql_parse__FP3THDPcUi + 149 0x807d1a3 dispatch_command__F19enum_server_commandP3THDPcUi + 1427 0x807cbfe do_command__FP3THD + 158 0x807c428 handle_one_connection + 648 0x826ac1c pthread_start_thread + 220 0x82a0aca thread_start + 4 And here is the my.cnf configuration file: [root@mysql ~]# cat /etc/my.cnf [client] #password = your_password port = 3306 socket = /home/xmfishdata/mysql.sock [mysqld] port = 3306 socket = /home/xmfishdata/mysql.sock skip-innodb skip-bdb skip-locking key_buffer = 256M myisam_sort_buffer_size = 48M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 3M table_cache = 1028 thread_cache_size = 256 query_cache_limit = 4M query_cache_size = 256M query_cache_type = 1 max_connections = 1000 max_allowed_packet = 16M open_files_limit = 432537 long_query_time = 100 max_tmp_tables = 128 max_write_lock_count = 1 log-bin=mysql-bin skip-name-resolve default-character-set=gbk #skip-networking server-id=1 binlog-do-db=xxxxxx binlog-do-db=xxxxxx |