MySQL Forums
Forum List  »  InnoDB

innodb crash - 4.1.12
Posted by: Gorazd Golob
Date: May 25, 2005 03:41PM

I got interesting problems with innodb -
I'm running it on raw device with no special settings, except for log and buffers:
--innodb_buffer_pool_size=128M --innodb_log_file_size=32M --innodb_log_buffer_size=8M

I have only one table in innodb, which is under frequent load (select, insert, update) with few rows and one of them is blob, which size can grow up to 2mb. When hard disk (where innodb log file takes a place) is under load from some coping etc. (not done with mysql), querys started to queue (can be seen with processlist or innodb status) and when the time running querys is 900s, the mysql stops itself - with long debug message in mysql's log (also show innodb status is there).

we don't use any transactions or simillar.

gorazd

Options: ReplyQuote


Subject
Views
Written By
Posted
innodb crash - 4.1.12
2963
May 25, 2005 03:41PM


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.