You want to change the storage engine in one or more of your MySQL tables, for example when you want to use a FULLTEXT index, that is not supported in INNODB tables in MySQL versions before 5.6.
Use the following to change the storage engine
ALTER TABLE table_name ENGINE = MyISAM;
You would like to check the storage engine in a MySQL database.
Use the following query after logging in to the server:
WHERE TABLE_SCHEMA = 'your_db_name';
Taken from here
Trying to access your rails application in your development pc, you get the error:
Mysql::Error: Got error 28 from storage engine
in your console.
It turns out that this specific error is a MySQL error, indicating that you have run out of space in the partition that the MySQL server stores its files (/var/lib/mysql).
Looking at the folder there, you can see a very large file called ibdata1.
This file holds all the information about your InnoDB tables and transactions in your MySQL. According to other posts after a Google search, it seems that this file cannot be reduced in size either by removing/truncating your tables or deleting databases that you don’t need. There are quite a few solutions out there if you really need to keep a backup of your databases, but if you only using your database for development and you DON’T NEED (!!) your data or tables, you can move this big ibdata1 to another partition for backup and restart your mysql, that will create a new file.