MySQL Forums
Forum List  »  InnoDB

Re: mysql got signal 6 and restarted twice in last 2 days
Posted by: Vaibhav Upadhyay
Date: February 27, 2017 06:35AM

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.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.