innodb crash - 4.1.12
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
Subject
Views
Written By
Posted
innodb crash - 4.1.12
2885
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.