Post by discoverytdi » Wed Jan 18, 2017 12:53 am

Upgrading my site from opencart-1.5.6.4 to opencart- 2.3.0.2 and noticed that in the database all the tables are MyISAM engineexcept for the cart table which is InnoDB Engine. I checked the sql file in the original install package in case it was an upgrade error but found this
Table structure for table `oc_cart`
--

DROP TABLE IF EXISTS `oc_cart`;
CREATE TABLE `oc_cart` (
`cart_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`api_id` int(11) NOT NULL,
`customer_id` int(11) NOT NULL,
`session_id` varchar(32) NOT NULL,
`product_id` int(11) NOT NULL,
`recurring_id` int(11) NOT NULL,
`option` text NOT NULL,
`quantity` int(5) NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`cart_id`),
KEY `cart_id` (`api_id`,`customer_id`,`session_id`,`product_id`,`recurring_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
is there a reason that oc is using 2 different Engines in the database.
Cheers
Peter

https://www.rvsolar.co.uk/


User avatar
Newbie

Posts

Joined
Fri Feb 17, 2012 6:43 am
Location - sunny lancashire UK

Post by IP_CAM » Wed Jan 18, 2017 2:48 am

Some Extension Creators use MyISAM, and some InnoDB, but as you wrote, it makes not much sense, to have both Engines doing their Job in one DB. And by use of this file Tool,
you can make your entire DB working under InnoDB, and in addition, you can FULL INDEX your DB as well, to get the best possible performance, It works wich all OC Versions.
---
Atomix INNO_DB Changer and DB Indexer Power Tool
The probably most efficient OC PHP File Tool Mod ever created!
http://www.ipc.li/os/opencart-turbo-master.zip

Good Luck ;)
Ernie
PX: And be aware, SOME (fulltext) MyISAM-driven Tables cannot be changed,
engine-wise, so, if you have one of them in your DB, just accept it!

Attachments

atomix.jpg

Atomix Turbo, the probably most efficient OC PHP File Tool Mod ever created! - atomix.jpg (297.2 KiB) Viewed 500 times


Ernie's OpenShop 1.75 with responsive Bootstrap Themes:
http://www.bigmax.ch - http://www.ocshop.li
Image


User avatar
Newbie

Posts

Joined
Tue Mar 04, 2014 1:37 am
Location - Switzerland

Post by discoverytdi » Wed Jan 18, 2017 4:47 am

IP_CAM wrote:Some Extension Creators use MyISAM, and some InnoDB, but as you wrote, it makes not much sense, to have both Engines doing their Job in one DB. And by use of this file Tool,
you can make your entire DB working under InnoDB, and in addition, you can FULL INDEX your DB as well, to get the best possible performance, It works wich all OC Versions.
---
Atomix INNO_DB Changer and DB Indexer Power Tool
The probably most efficient OC PHP File Tool Mod ever created!
http://www.ipc.li/os/opencart-turbo-master.zip

Good Luck ;)
Ernie
PX: And be aware, SOME (fulltext) MyISAM-driven Tables cannot be changed,
engine-wise, so, if you have one of them in your DB, just accept it!
Read about Atomix a while back, but what I don't understand is why there should be that InnoDB engine in the stock oc download ???

https://www.rvsolar.co.uk/


User avatar
Newbie

Posts

Joined
Fri Feb 17, 2012 6:43 am
Location - sunny lancashire UK

Post by thekrotek » Wed Jan 18, 2017 5:23 am

discoverytdi wrote:Read about Atomix a while back, but what I don't understand is why there should be that InnoDB engine in the stock oc download ???
Probably, they were just doing some testing and left it as is. It doesn't hurt, doesn't make much sense either. So just ignore it :-)

Professional OpenCart extensions, support and custom work.
Contact me via email support@thekrotek.com


User avatar
Newbie
Online

Posts

Joined
Sun Jul 03, 2016 12:24 am


Post by qtwrk » Sun May 14, 2017 6:45 am

IP_CAM wrote:
Wed Jan 18, 2017 2:48 am
Some Extension Creators use MyISAM, and some InnoDB, but as you wrote, it makes not much sense, to have both Engines doing their Job in one DB. And by use of this file Tool,
you can make your entire DB working under InnoDB, and in addition, you can FULL INDEX your DB as well, to get the best possible performance, It works wich all OC Versions.
---
Atomix INNO_DB Changer and DB Indexer Power Tool
The probably most efficient OC PHP File Tool Mod ever created!
http://www.ipc.li/os/opencart-turbo-master.zip

Good Luck ;)
Ernie
PX: And be aware, SOME (fulltext) MyISAM-driven Tables cannot be changed,
engine-wise, so, if you have one of them in your DB, just accept it!
is it supposed to be normal I have few table shows ERROR while converting from myisam to innodb ?

Newbie

Posts

Joined
Tue Dec 09, 2014 5:21 am

Post by victorj » Sun May 14, 2017 3:05 pm

MySQL and mariadata base that the main database engine oc uses, has different Engines under the Hood each with their own advantages and disadvantages.

Myisam is used on tables with large bits of data like product descriptions.
It is able to handle large chunks of data in a effecient way, and is able to get bits off information from inside these fields to, handy for in$ search in product descriptions,used for search in websites, but it operates a bit slower.
Innodb is used on tables with short information in fields like the option tablet, its writen To handle this information fast and efficiënt, but can not get data from information inside a field, so it will only parse entire field to a search querie

In order to get the best resultaten when gathering data from a database each table should be looked at and proper engine should be applied to that table for optimal result.
So if you can apply innodb it Will speedup overall database performance resulting in a faster website.
Some tables however do have long text fields, innodb cant handle, so they need to be myisam.
During conversion these tables are not altered.
Having more Engines in a database is no problem, they Both do their job in the most efficiënt way to handle that specific data.

When on large shops database is converted and index tables are added, you will notice a significant increase in overall speed.

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Alle niet stekplichtige onderdelen zoals scharnieren, sloten, randverwarming en verlichting voor alle typen koelingen en vriezers.
https://koelcel-onderdelen.com

Koeltechnische deurrubbers eenvoudig online op maat bestellen.
Eigen productie en snelle levering.
https://123-deurrubbers.com


User avatar
Newbie

Posts

Joined
Sat Jun 25, 2011 4:09 am
Location - Alkmaar Holland
Who is online

Users browsing this forum: No registered users and 17 guests