MySQL crashes with InnoDB error

[gatobait3]

I found that MySQL would crash after a few days with InnoDB errors in the mysql error log. The InnoDB settings were off in the my.cnf file, and my DBs/Tables were created as MyISAM.

And, according to most MySQL documentation/Google searches, MyISAM is supposed to be the default engine setting.

But running "show engines\G;" from a mysql prompt showed that InnoDB was set as the DEFAULT DB engine. I stopped mysql and added this to my my.cnf file and restarted mysql:

default-storage-engine = MyISAM

Running "show engines\G;" now shows MyISAM as the DEFAULT engine type in MySQL, and I'm monitoring to see if this has corrected the issue.

Anyone else seen this issue?

[gatobait3]

UPDATE: no mysql crashes since changing the engine to MyISAM ...

[tomcheng76]

May be you need to set something for the low memory machine
http://bit.ly/tDDYR2