Osclass forums

Support forums => General help => 3.7.x => Topic started by: Aficionado on October 09, 2017, 12:11:47 am

Title: oc_t_item_description is MyISAM ?
Post by: Aficionado on October 09, 2017, 12:11:47 am

I see than while everything else in my db is innoDB, oc_t_item_description is MyISAM.

Any ideas why that happens and what it means ? And should i switch it also to innoDB ?

Thanks

Title: Re: oc_t_item_description is MyISAM ?
Post by: marius-ciclistu on October 09, 2017, 12:18:12 am

I don't have any idea but maybe this could help https://stackoverflow.com/questions/12614541/whats-the-difference-between-myisam-and-innodb

Title: Re: oc_t_item_description is MyISAM ?
Post by: Aficionado on October 09, 2017, 12:19:10 am

Yes, thanks. I know the difference. The question is why ONE only table is MyISAM ?

Should be like that ?

Title: Re: oc_t_item_description is MyISAM ?
Post by: marius-ciclistu on October 09, 2017, 12:22:55 am

In my case is the same as you described it. Only this is MyISAM.

Maybe because the description is "the biggest" so this type is smaller in size...

Title: Re: oc_t_item_description is MyISAM ?
Post by: teseo on October 09, 2017, 12:27:10 am

Hi,

Code: [Select]

MYISAM supports fulltext search
It's a table originally built to optimize searches to a maximum. (Until MySQL 5.6 only MyISAM supported FULLTEXT).

Regards

Title: Re: oc_t_item_description is MyISAM ?
Post by: Aficionado on October 09, 2017, 12:40:17 am

Ok, got it. Nothing wrong i guess, i was a bit worried.

Thanks !