MySQL Forums :: InnoDB :: mysql got signal 6 and restarted twice in last 2 days


Advanced Search

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


Subject Views Written By Posted
mysql got signal 6 and restarted twice in last 2 days 178 Vaibhav Upadhyay 02/22/2017 04:24AM
Re: mysql got signal 6 and restarted twice in last 2 days 74 Jon Stephens 02/22/2017 05:01PM
Re: mysql got signal 6 and restarted twice in last 2 days 62 Vaibhav Upadhyay 02/23/2017 08:28AM
Re: mysql got signal 6 and restarted twice in last 2 days 52 Vaibhav Upadhyay 02/24/2017 03:27AM
Re: mysql got signal 6 and restarted twice in last 2 days 64 Peter Brawley 02/24/2017 11:11AM
Re: mysql got signal 6 and restarted twice in last 2 days 51 Vaibhav Upadhyay 02/25/2017 02:38PM
Re: mysql got signal 6 and restarted twice in last 2 days 52 Peter Brawley 02/25/2017 09:05PM
Re: mysql got signal 6 and restarted twice in last 2 days 82 Vaibhav Upadhyay 02/26/2017 07:19AM
Re: mysql got signal 6 and restarted twice in last 2 days 58 Peter Brawley 02/26/2017 11:56AM
Re: mysql got signal 6 and restarted twice in last 2 days 68 Vaibhav Upadhyay 02/27/2017 06:35AM
Re: mysql got signal 6 and restarted twice in last 2 days 44 Peter Brawley 02/27/2017 11:00AM
Re: mysql got signal 6 and restarted twice in last 2 days 63 Vaibhav Upadhyay 02/27/2017 12:42PM


Sorry, only registered users may post in this forum.

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.