what is your thoughts about converting the current set up of the mySQL tables from MyISAM to InnoDB?
Benefits? and Drawbacks of this?
converting tables from MyISAM to InnoDB
-
deadpoeticstar
- Regular
- Posts: 56
- Joined: Tue Apr 18, 2006 3:10 pm
-
garvinhicking
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: converting tables from MyISAM to InnoDB
Serendipity does not require transactional safety. InnoDB has no benefits over MyISAM, only drawbacks that fulltext search cannot be used.
Since s9y strives for DB abstraction, it will not be optimized for a specific Table handler. Serendipity does not use MyISAM, it uses the default tables of the MySQL server - so s9y will basically work with both engines and utilize only the basic functions plus fulltext search.
Best regards,
Garvin
Since s9y strives for DB abstraction, it will not be optimized for a specific Table handler. Serendipity does not use MyISAM, it uses the default tables of the MySQL server - so s9y will basically work with both engines and utilize only the basic functions plus fulltext search.
Best regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
-
deadpoeticstar
- Regular
- Posts: 56
- Joined: Tue Apr 18, 2006 3:10 pm