MySQL Debug information via Stack Trace.

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 ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 12-20-2006
Wang Penghui
 
Posts: n/a
Default MySQL Debug information via Stack Trace.

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

Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 08:39 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0