V4.0.9 How can I use the mysqld.sym file via gdb? It doesn't like the format. Copying the stacktrace into another file where I have to edit out a bunch of junk from gdb for resolve_stack_dump is a bit slow.
It seems that two processes have hung for a while. All the slots have filled up even though I have set up the my.cnf file with: set-variable = max_connections=83 set-variable = max_user_connections=80 The extra three connections for me does not seem to work. :( So I can look inside. Here is a quick look at ps: ... 23436 ? S 0:03 /root/mysql-standard-4.0.9-gamma-pc-linux-i686/bin/mysqld --defaults-extra-file=/root/mysql-standar 23442 ? S 0:03 /root/mysql-standard-4.0.9-gamma-pc-linux-i686/bin/mysqld --defaults-extra-file=/root/mysql-standar 23443 ? S 0:02 /root/mysql-standard-4.0.9-gamma-pc-linux-i686/bin/mysqld --defaults-extra-file=/root/mysql-standar 22623 ? R 311:57 /root/mysql-standard-4.0.9-gamma-pc-linux-i686/bin/mysqld --defaults-extra-file=/root/mysql-standar 15068 ? R 324:51 /root/mysql-standard-4.0.9-gamma-pc-linux-i686/bin/mysqld --defaults-extra-file=/root/mysql-standar Here are details on the two in runable state: # resolve_stack_dump -s bin/mysqld.sym -n stack22623 0x8245857 _ftb_climb_the_tree + 295 0x8245e1d ft_boolean_find_relevance + 521 0x8245b97 ft_boolean_read_next + 695 0x80c439d ft_read__9ha_myisamPc + 53 0x82fa9e8 get_next__9FT_SELECT + 32 0x80bebf9 find_all_keys__FP13st_sort_paramP10SQL_SELECTPPUcP11st_io_cacheN23 + 989 0x80be480 filesort__FP8st_tableP13st_sort_fieldUiP10SQL_SELECTUlUlPUl + 736 0x809cb88 create_sort_index__FP13st_join_tableP8st_orderUlUl + 304 0x8092e4a mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4 UlP13select_result + 6714 0x80913d6 handle_select__FP3THDP6st_lexP13select_result + 102 0x807942a mysql_execute_command__Fv + 950 0x807ce26 mysql_parse__FP3THDPcUi + 146 0x807853b dispatch_command__F19enum_server_commandP3THDPcUi + 1475 0x8077f6d do_command__FP3THD + 149 0x80777af handle_one_connection + 635 0x826726c pthread_start_thread + 220 # resolve_stack_dump -s bin/mysqld.sym -n stack15068 0x8245854 _ftb_climb_the_tree + 292 0x8245e1d ft_boolean_find_relevance + 521 0x8245b97 ft_boolean_read_next + 695 0x80c439d ft_read__9ha_myisamPc + 53 0x82fa9e8 get_next__9FT_SELECT + 32 0x80bebf9 find_all_keys__FP13st_sort_paramP10SQL_SELECTPPUcP11st_io_cacheN23 + 989 0x80be480 filesort__FP8st_tableP13st_sort_fieldUiP10SQL_SELECTUlUlPUl + 736 0x809cb88 create_sort_index__FP13st_join_tableP8st_orderUlUl + 304 0x8092e4a mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4 UlP13select_result + 6714 0x80913d6 handle_select__FP3THDP6st_lexP13select_result + 102 0x807942a mysql_execute_command__Fv + 950 0x807ce26 mysql_parse__FP3THDPcUi + 146 0x807853b dispatch_command__F19enum_server_commandP3THDPcUi + 1475 0x8077f6d do_command__FP3THD + 149 0x80777af handle_one_connection + 635 0x826726c pthread_start_thread + 220 This server is doing FTS exclusively. (IN BOOLEAN MODE). Before killing everything, is there a way to see what it is waiting on? -steve- sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php