Re: MYSQL CRASHING FREQUENTLY
> After changing logfile size and log buffer size, when i run bulk insert it crashes in approximate 3 hours.
Is that better or worse than before you changed log file size?
The bulk insert runs for three hours then crashes? Or multiple bulk inserts run and the Nth crashes? If the latter, what is N?
> When i am not running bulk insert it crashes after 10-12 hours.
Mostly OLTP or OLAP in those periods? Is error log from such crashes significantlly different from bulk insert crashes?
From the error log ...
> 2017-06-29 13:06:05 7f4358cf4740 InnoDB: Transaction contains changes to 3890 rows
The smaller a transaction, the better. Let's see the SQL for such transactions.
While I look at the latest readouts ...
Why do you need the general log?
Why not move innodb_log_group_home_dir to another HD?
Edited 1 time(s). Last edit at 06/29/2017 11:05AM by Peter Brawley.
Subject
Written By
Posted
Re: MYSQL CRASHING FREQUENTLY
June 29, 2017 10:52AM
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.