Bug #49835 | sometime, 5.0.77 crash. | ||
---|---|---|---|
Submitted: | 21 Dec 2009 2:15 | Modified: | 5 Mar 2010 6:42 |
Reporter: | wang xu | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 5.0.77 | OS: | Linux (64) |
Assigned to: | CPU Architecture: | Any | |
Tags: | crash, mysqlserver |
[21 Dec 2009 2:15]
wang xu
[21 Dec 2009 2:20]
wang xu
My my.cnf: key_buffer_size = 1024M max_allowed_packet = 1024M table_cache = 2048 net_read_timeout=120 sort_buffer_size = 8M read_buffer_size = 2M read_rnd_buffer_size = 2M myisam_sort_buffer_size = 128M thread_cache_size = 500 tmp_table_size=384M tmpdir=/home/mysqldata/tmp thread_stack=384K query_cache_size= 128M query_cache_limit= 2M join_buffer_size=8M interactive_timeout=86400 wait_timeout=86400 max_connect_errors = 10000000 # Try number of CPU's*2 for thread_concurrency thread_concurrency = 8 set-variable=max_connections=400
[21 Dec 2009 2:24]
wang xu
OS:CentOS release 5.2 (Final) Cpu Cores:4 Memory:16G
[21 Dec 2009 4:23]
Valeriy Kravchuk
If crash always happen on the same/similar SELECT, please, identify its entire text and send EXPLAIN results for it.
[21 Dec 2009 5:48]
wang xu
explain select * from note_01_info as n ,NOTE_RECEIVER_15_INFO as r where n.note_id = r.note_id and ( (r.receiver_id = '137415' ) or (r.SEND_ID in ('1279418','2311118','2254924','160801','164710','2267727','2275320','1252806',......'135610','169818','197009','141018','158403','203125','155615','167917','167920','177920','195728','200304','201906','138220','147623','137811','184410','132924','140018','131611','147019','151714','148621','135024','154118','133122','1227025','1191420','101825','218415','152708','190623','1267127','187629','185926','2254006','2223413','1267306','2246304','200905','190109','1244215','100409','174126','183605','240914','1220428','152205','2247410','101925','1197021','2248917','190813','156917','156417','151518','103024','1201921','155114','105624','144325','204511','2218029','155918','1284018','102125','129431','102726','2217128','177726','145610','1254424','2235423','143702','1241017','154510','1210209','1266806','137415' ) and r.RECEIVER_TYPE = 6) ) order by n.PUBLISH_TIME desc LIMIT 0 , 21; +----+-------------+-------+-------------+-----------------------------------------------+---------------------------------+---------+--------------------+--------+-------------------------------------------------------------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------+-------------+-----------------------------------------------+---------------------------------+---------+--------------------+--------+-------------------------------------------------------------------------------------------------+ | 1 | SIMPLE | r | index_merge | INDEX_NOTE_ID,INDEX_SEND_ID,INDEX_RECEIVER_ID | INDEX_RECEIVER_ID,INDEX_SEND_ID | 9,9 | NULL | 187044 | Using sort_union(INDEX_RECEIVER_ID,INDEX_SEND_ID); Using where; Using temporary; Using filesort | | 1 | SIMPLE | n | eq_ref | PRIMARY | PRIMARY | 8 | followme.r.NOTE_ID | 1 | | +----+-------------+-------+-------------+-----------------------------------------------+---------------------------------+---------+--------------------+--------+-------------------------------------------------------------------------------------------------+ 2 rows in set (0.08 sec)
[21 Dec 2009 5:49]
wang xu
logs for explain results.
Attachment: explain_results.txt (text/plain), 11.10 KiB.
[21 Dec 2009 5:50]
wang xu
The sql is too long, so please get the sql and the explain resutls from the att files.
[21 Dec 2009 7:09]
Valeriy Kravchuk
OK, so temporary table is used. Please, send the results of free Linux command and the results of show global status; show global variables like '%heap%';
[21 Dec 2009 7:29]
wang xu
>free >Linux command and the results of >show global status; >show global variables like '%heap%'; thank for your help . The comment is too long. please get the results from attach file(variables.txt).
[21 Dec 2009 7:31]
wang xu
free & global status
Attachment: variables.txt (text/plain), 13.39 KiB.
[19 Jan 2010 8:19]
wang xu
I am waiting ...
[5 Feb 2010 6:42]
Sveta Smirnova
Thank you for the feedback. Please also send output of SHOW CREATE TABLE note_01_info, SHOW CREATE TABLE NOTE_RECEIVER_15_INFO and SHOW TABLE STATUS for both tables.
[6 Mar 2010 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".