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

[Vaibhav Upadhyay]

egarding partition
===================
Yes coz data is huge and requires frequent delete (archive and purge).

We have most of the data relying on one partition and we have to update most of the data for this table (partitioned column).

To do this we are trying to delete the data first (to reduce the volume) and further to update in chunks.

Queries
=========
select

mysqldump -uroot -p --single-transaction schema_name tbl_c --where="`column41` in (select c_id from tbl_e data where c_b_s != 'xyz') and c_time between 'timestamp' and 'timestamp'" | gzip > filename.sql.gz

also same query to delete the backed up data

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

same has been experienced when we try to run optimize table also to other big table.


Summary:-
=========
when ever trying to optimize huge table or fetch the data for backup or delete we are experiencing this.

Innodb_buffer_pool reduce to 50 G

Thank you.