Looking at http://www.opencart.com/index.php?route ... n_id=18348 and https://github.com/atomixdesign/opencar ... /turbo.php, both provide the impression that moving from MyISAM to InnoDB will offer a performance improvement. I'm not sure I buy it. But would like to hear the opinions of those smarter than I. Don't care about transactional functionality of InnoDB over MyISAM. Doing about 40,000 unique sessions per month on a well-built dedicated linux box, so basically next to nothing. Strictly interested in pure, sweet, performance.
Thoughts?
You don't have to buy anything, just download the ATOMIX turbo.php and upload it, call it's link by the browser, change the DB-Engine to innodb, and re-index the whole works. THEN, look for yourself and find out about the difference.
I have the links to free performance on the frontpage of this:
http://www.bigmax.ch/shop/
Good Luck!
Ernie
I have the links to free performance on the frontpage of this:
http://www.bigmax.ch/shop/
Good Luck!
Ernie
Last edited by IP_CAM on Sat Apr 25, 2015 5:35 am, edited 2 times in total.
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
I do not perform any action without first understanding the ramifications. This is a production server, with no testing environment... just need to know before adding the mod, if this is going to make our website faster, or slower... keeping mind, we are on a very powerful dedicated box.look for yourself and find out about the difference.
Speed isn't the main consideration when using InnoDB. It's the features it has like row locking, transactions, and foreign keys. As far as performance comparison vs. MyISAM, I've seen it go both ways. Benchmarking is complicated and can depend on things from the operating system cache to the type of operation being performed (read or write).
Generally speaking InnoDB has already won out as storage engine (it replaced MyISAM as the default in MySQL) so there isn't going to be much testing anyway. As far as the turbo script goes the important thing for big speed improvements is the indexing it does.
Generally speaking InnoDB has already won out as storage engine (it replaced MyISAM as the default in MySQL) so there isn't going to be much testing anyway. As far as the turbo script goes the important thing for big speed improvements is the indexing it does.
-Ryan
There is even a free Mod, available, in the extension section, to 'move' from one to the other 'Engine', if one really want's to make tests. The Problem, remaining, is, the frequent need to 're-INNODB+Re-Index' the DB, to make sure, it ALL is in INNODB- format, as well as indexed correctly, because some OC Extension Add-On's modify/add-to DB's, and so implementing MyISAM 'Routine/Commands' into existing full INNODB -driven DB's, when newly installed and/or possibly used the first time. According to my knowledge, found on the web, to this, such Doings would have a substantial negative performance effect, due to switching from one active engine to the other, to fullfill the task, on every instance, occurring.
DB Engine Switcher:
http://www.opencart.com/index.php?route ... n_id=18348
Atomix Full DB Indexing + MyISAM to InnoDB Engine Switcher PHP Page: (Link updated in January 2020)
https://github.com/IP-CAM/opencart-turbo
Just to mention it!
Ernie
DB Engine Switcher:
http://www.opencart.com/index.php?route ... n_id=18348
Atomix Full DB Indexing + MyISAM to InnoDB Engine Switcher PHP Page: (Link updated in January 2020)
https://github.com/IP-CAM/opencart-turbo
Just to mention it!
Ernie
Last edited by IP_CAM on Sat Jan 25, 2020 6:17 am, edited 17 times in total.
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Thanks, Ernie. I think we will hold off on moving from MyISAM to InnoDB based on the above comments. I suppose if it ain't broke, don't fix it.
It's your decision, but you can't break anything, either...furrywombat wrote:Thanks, Ernie. I think we will hold off on moving from MyISAM to InnoDB based on the above comments. I suppose if it ain't broke, don't fix it.
BUT: Whatever you do, Re-Index your DB, in ANY Case, by use of turbo.php !
Good Luck
Ernie
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Ernie, we did end up implementing the MyISAM to InnoDB conversion and also added indexes to all foreign key constraints. I'm glad we did, because it just seriously improved the response time throughout the entire website. To be clear, Atomix was used. We also have our DB settings tweaked heavily in favor of extreme performance for InnoDB specifically. So, this may not apply to all who attempt, but in our case, two thumbs up!
Very pleased!!
Very pleased!!
Good for You, I figured...furrywombat wrote:Very pleased!!
Ernie
My Github OC Site: https://github.com/IP-CAM
5'600 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Who is online
Users browsing this forum: Bing [Bot] and 6 guests
