Re: mysql got signal 6 and restarted twice in last 2 days

[Peter Brawley]

> where column41 in(select c_id from tbl_e where c_b_s !='xys') and c_time between 'timestamp' and 'timestamp' limit 50000;

Limit does not optimise well. That query will perform much better if you precompute timestamp boundaries of the desired chunk. If it still behaves like a pig, also precompute the ...!=tbl_c.id... condition.

And tbl_e is somewhat like this table? Consider carefully monitoring how much swapping these queries elicit. Everything about this problem says you need more RAM for what you're trying to do.