Normal
i have found this : https://forum.team-mediaportal.com/threads/suggestion-for-mysql-to-switch-to-innodb-from-myisam.88493/[code]ALTER TABLE canceledschedule ENGINE=InnoDB;ALTER TABLE card ENGINE=InnoDB;ALTER TABLE cardgroup ENGINE=InnoDB;ALTER TABLE cardgroupmap ENGINE=InnoDB;ALTER TABLE channel ENGINE=InnoDB;ALTER TABLE channelgroup ENGINE=InnoDB;ALTER TABLE channellinkagemap ENGINE=InnoDB;ALTER TABLE channelmap ENGINE=InnoDB;ALTER TABLE conflict ENGINE=InnoDB;ALTER TABLE diseqcmotor ENGINE=InnoDB;ALTER TABLE favorite ENGINE=InnoDB;ALTER TABLE groupmap ENGINE=InnoDB;ALTER TABLE history ENGINE=InnoDB;ALTER TABLE keyword ENGINE=InnoDB;ALTER TABLE keywordmap ENGINE=InnoDB;ALTER TABLE personaltvguidemap ENGINE=InnoDB;ALTER TABLE program ENGINE=InnoDB;ALTER TABLE radiochannelgroup ENGINE=InnoDB;ALTER TABLE radiogroupmap ENGINE=InnoDB;ALTER TABLE recording ENGINE=InnoDB;ALTER TABLE satellite ENGINE=InnoDB;ALTER TABLE schedule ENGINE=InnoDB;ALTER TABLE server ENGINE=InnoDB;ALTER TABLE setting ENGINE=InnoDB;ALTER TABLE timespan ENGINE=InnoDB;ALTER TABLE tuningdetail ENGINE=InnoDB;ALTER TABLE tvmoviemapping ENGINE=InnoDB;ALTER TABLE version ENGINE=InnoDB;[/code] [code]repair table canceledschedule; ALTER TABLE canceledschedule ENGINE=InnoDB;repair table card; ALTER TABLE card ENGINE=InnoDB;repair table cardgroup; ALTER TABLE cardgroup ENGINE=InnoDB;repair table cardgroupmap; ALTER TABLE cardgroupmap ENGINE=InnoDB;repair table channel; ALTER TABLE channel ENGINE=InnoDB;repair table channelgroup; ALTER TABLE channelgroup ENGINE=InnoDB;repair table channellinkagemap; ALTER TABLE channellinkagemap ENGINE=InnoDB;repair table channelmap; ALTER TABLE channelmap ENGINE=InnoDB;repair table conflict; ALTER TABLE conflict ENGINE=InnoDB;repair table diseqcmotor; ALTER TABLE diseqcmotor ENGINE=InnoDB;repair table favorite; ALTER TABLE favorite ENGINE=InnoDB;repair table groupmap; ALTER TABLE groupmap ENGINE=InnoDB;repair table history; ALTER TABLE history ENGINE=InnoDB;repair table keyword; ALTER TABLE keyword ENGINE=InnoDB;repair table keywordmap; ALTER TABLE keywordmap ENGINE=InnoDB;repair table pendingdeletion; ALTER TABLE pendingdeletion ENGINE=InnoDB;repair table personaltvguidemap; ALTER TABLE personaltvguidemap ENGINE=InnoDB;repair table program; ALTER TABLE program ENGINE=InnoDB;repair table radiochannelgroup; ALTER TABLE radiochannelgroup ENGINE=InnoDB;repair table radiogroupmap; ALTER TABLE radiogroupmap ENGINE=InnoDB;repair table recording; ALTER TABLE recording ENGINE=InnoDB;repair table satellite; ALTER TABLE satellite ENGINE=InnoDB;repair table schedule; ALTER TABLE schedule ENGINE=InnoDB;repair table server; ALTER TABLE server ENGINE=InnoDB;repair table setting; ALTER TABLE setting ENGINE=InnoDB;repair table softwareencoder; ALTER TABLE softwareencoder ENGINE=InnoDB;repair table timespan; ALTER TABLE timespan ENGINE=InnoDB;repair table tuningdetail; ALTER TABLE tuningdetail ENGINE=InnoDB;repair table tvmoviemapping; ALTER TABLE tvmoviemapping ENGINE=InnoDB;repair table version; ALTER TABLE version ENGINE=InnoDB;[/code] An other Topic :link of this code : by @Vasilich[code]ALTER TABLE version ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE tvmoviemapping ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE tuningdetail ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE timespan ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE softwareencoder ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE setting ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE server ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE schedule ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE satellite ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE recording ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE radiogroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE radiochannelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE program ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE personaltvguidemap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE pendingdeletion ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE keywordmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE keyword ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE history ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE groupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE favorite ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE diseqcmotor ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE conflict ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channelmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channellinkagemap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE channel ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE cardgroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE cardgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE card ENGINE=InnoDB ROW_FORMAT=COMPACT;ALTER TABLE canceledschedule ENGINE=InnoDB ROW_FORMAT=COMPACT;[/code]
i have found this : https://forum.team-mediaportal.com/threads/suggestion-for-mysql-to-switch-to-innodb-from-myisam.88493/
[code]ALTER TABLE canceledschedule ENGINE=InnoDB;
ALTER TABLE card ENGINE=InnoDB;
ALTER TABLE cardgroup ENGINE=InnoDB;
ALTER TABLE cardgroupmap ENGINE=InnoDB;
ALTER TABLE channel ENGINE=InnoDB;
ALTER TABLE channelgroup ENGINE=InnoDB;
ALTER TABLE channellinkagemap ENGINE=InnoDB;
ALTER TABLE channelmap ENGINE=InnoDB;
ALTER TABLE conflict ENGINE=InnoDB;
ALTER TABLE diseqcmotor ENGINE=InnoDB;
ALTER TABLE favorite ENGINE=InnoDB;
ALTER TABLE groupmap ENGINE=InnoDB;
ALTER TABLE history ENGINE=InnoDB;
ALTER TABLE keyword ENGINE=InnoDB;
ALTER TABLE keywordmap ENGINE=InnoDB;
ALTER TABLE personaltvguidemap ENGINE=InnoDB;
ALTER TABLE program ENGINE=InnoDB;
ALTER TABLE radiochannelgroup ENGINE=InnoDB;
ALTER TABLE radiogroupmap ENGINE=InnoDB;
ALTER TABLE recording ENGINE=InnoDB;
ALTER TABLE satellite ENGINE=InnoDB;
ALTER TABLE schedule ENGINE=InnoDB;
ALTER TABLE server ENGINE=InnoDB;
ALTER TABLE setting ENGINE=InnoDB;
ALTER TABLE timespan ENGINE=InnoDB;
ALTER TABLE tuningdetail ENGINE=InnoDB;
ALTER TABLE tvmoviemapping ENGINE=InnoDB;
ALTER TABLE version ENGINE=InnoDB;[/code]
[code]repair table canceledschedule; ALTER TABLE canceledschedule ENGINE=InnoDB;
repair table card; ALTER TABLE card ENGINE=InnoDB;
repair table cardgroup; ALTER TABLE cardgroup ENGINE=InnoDB;
repair table cardgroupmap; ALTER TABLE cardgroupmap ENGINE=InnoDB;
repair table channel; ALTER TABLE channel ENGINE=InnoDB;
repair table channelgroup; ALTER TABLE channelgroup ENGINE=InnoDB;
repair table channellinkagemap; ALTER TABLE channellinkagemap ENGINE=InnoDB;
repair table channelmap; ALTER TABLE channelmap ENGINE=InnoDB;
repair table conflict; ALTER TABLE conflict ENGINE=InnoDB;
repair table diseqcmotor; ALTER TABLE diseqcmotor ENGINE=InnoDB;
repair table favorite; ALTER TABLE favorite ENGINE=InnoDB;
repair table groupmap; ALTER TABLE groupmap ENGINE=InnoDB;
repair table history; ALTER TABLE history ENGINE=InnoDB;
repair table keyword; ALTER TABLE keyword ENGINE=InnoDB;
repair table keywordmap; ALTER TABLE keywordmap ENGINE=InnoDB;
repair table pendingdeletion; ALTER TABLE pendingdeletion ENGINE=InnoDB;
repair table personaltvguidemap; ALTER TABLE personaltvguidemap ENGINE=InnoDB;
repair table program; ALTER TABLE program ENGINE=InnoDB;
repair table radiochannelgroup; ALTER TABLE radiochannelgroup ENGINE=InnoDB;
repair table radiogroupmap; ALTER TABLE radiogroupmap ENGINE=InnoDB;
repair table recording; ALTER TABLE recording ENGINE=InnoDB;
repair table satellite; ALTER TABLE satellite ENGINE=InnoDB;
repair table schedule; ALTER TABLE schedule ENGINE=InnoDB;
repair table server; ALTER TABLE server ENGINE=InnoDB;
repair table setting; ALTER TABLE setting ENGINE=InnoDB;
repair table softwareencoder; ALTER TABLE softwareencoder ENGINE=InnoDB;
repair table timespan; ALTER TABLE timespan ENGINE=InnoDB;
repair table tuningdetail; ALTER TABLE tuningdetail ENGINE=InnoDB;
repair table tvmoviemapping; ALTER TABLE tvmoviemapping ENGINE=InnoDB;
repair table version; ALTER TABLE version ENGINE=InnoDB;[/code]
An other Topic :
link of this code : by @Vasilich
[code]ALTER TABLE version ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE tvmoviemapping ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE tuningdetail ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE timespan ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE softwareencoder ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE setting ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE server ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE schedule ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE satellite ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE recording ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE radiogroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE radiochannelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE program ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE personaltvguidemap ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE pendingdeletion ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE keywordmap ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE keyword ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE history ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE groupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE favorite ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE diseqcmotor ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE conflict ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE channelmap ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE channellinkagemap ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE channelgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE channel ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE cardgroupmap ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE cardgroup ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE card ENGINE=InnoDB ROW_FORMAT=COMPACT;
ALTER TABLE canceledschedule ENGINE=InnoDB ROW_FORMAT=COMPACT;[/code]