converting tables from MyISAM to InnoDB

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
deadpoeticstar
Regular
Posts: 56
Joined: Tue Apr 18, 2006 3:10 pm

converting tables from MyISAM to InnoDB

Post by deadpoeticstar »

what is your thoughts about converting the current set up of the mySQL tables from MyISAM to InnoDB?

Benefits? and Drawbacks of this?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: converting tables from MyISAM to InnoDB

Post by garvinhicking »

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
# 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/
deadpoeticstar
Regular
Posts: 56
Joined: Tue Apr 18, 2006 3:10 pm

Post by deadpoeticstar »

OH ok...gotcha...its cool...ill just leave it as is
Post Reply