asked on

OXID Shop: Can I just change table type from InnoDB to MyISAM?

Hi,

I run the OXID onlineshop on my server. To synchronize with the inventory control system, I use a plugin called "eShopConnector". It is a Windows Software, that synchronizes the inventory to the shop.

During the synchronisation, verry often I got a process with the state "freeing items" and during the time, the process was in the state (about 2-5 minutes), the update of the inventory get stalled. Now I changed the type of the "articles" table from InnoDB to MyISAM and everything works fine for me now.

My Question is now: Can I simply redeclare the type of the table or do I have to expect some negative consequences?

stojanovicigi

The biggest difference between innoDB and MyISAM engines is that innoDB engine allow relations between table.
If the "articles" table is not related with any of table then you can change the table engine without consequences, but if the table has relation to some other table, than you can expect that something wan't work good or wan't work at all.

If the table was innoDB that was because 2 reasons:
1) The table must be innoDB because it's related with some other tables
2) Your default DB engine is InnoDB and your MySQL server creates innoDB tables by default.

So, be careful and check does Insert, update and delete statements work.
With other words, if you delete some article check are all data deleted from all tables related to that article.

ASKER CERTIFIED SOLUTION

virmaior

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial