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