Re: MYSQL CRASHING FREQUENTLY

[Sam Mathews]

"Is that better or worse than before you changed log file size? "
Yes, Insertion is very fast but after 3hrs database gets crash.


"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 significantly different from bulk insert crashes?"

No, During this time there no load on database (NO OLTP NO OLAP).
Logs are same as when it gets crash while bulk insert.

Table structure
CREATE TABLE test1 (
id int(255) NOT NULL AUTO_INCREMENT,,
fname varchar(255) NOT NULL,
lanme varchar(255) NOT NULL,
doj timestamp NOT NULL default '0000-00-00 00:00:00',
hash varchar(255) NOT NULL,
PRIMARY KEY (ID )
INDEX IND_fname(fname ),
INDEX IND_lname(lname ),
INDEX IND_hash(hash)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


INSERT INTO TABLE test1 (fname ,lname,doj,hash)
values('sam','mathews','2017-06-01','abc1234abc'),
('sam','mathews','2017-06-01','abc1234abc'),
('sam','mathews','2017-06-01','abc1234abc'),
('sam','mathews','2017-06-01','abc1234abc'),
.
.
.
.
.
till 100000 (.1M)
('sam','mathews','2017-06-01','abc1234abc');



"Why do you need the general log? "
I have disables general logs;


"Why not move innodb_log_group_home_dir to another HD?"
Ok we will do this. This will help in improving insert DML operations ?


And sometimes two insert queries are running on same table . And in this case one query goes in lock. is there any possibility that this locking is responsible for database crash?