Re: MYSQL CRASHING FREQUENTLY
Posted by: Peter Brawley
Date: June 29, 2017 10:52AM

> 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.

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.