InnoDB vs MyISAM tables

Rex Dieter rdieter at math.unl.edu
Sat Mar 14 18:48:14 UTC 2009


Prompted by the comment,
https://bugs.kde.org/show_bug.cgi?id=187085#c3
"Amarok's embedded mysql database does _not_ support the InnoDB backend, 
only MyISAM. The cause of this is most likely an incorrectly compiled mysql 
package, so please ask your distribution."

I'd like to explore this issue further.  I contacted our mysql maintainer, 
and our builds are (supposed to) default to MyISAM tables, but for whatever 
reason amarok is creating InnoDB ones.  I assume this is leading a whole lot 
of bad.

In the bug, I made a mostly naive comment:
does amarok have any buildtime or runtime checks for MyISAM functionality?  
If not, why not?  It would also appear amarok doesn't explicitly specify 
MyISAM tables, again, why not?

All tested here using mysql-5.0.77. 

So, where do we go from here?  Am I missing anything (obvious or otherwise)?

-- Rex





More information about the Amarok mailing list