Post by davidbfranks » Fri Apr 08, 2016 2:41 pm

Hi,

Is there a speed benefit to using InnoDB over MyISAM?

Would it also be safe to convert all existing MyISAM tables to InnoDB using this tool - https://github.com/lilalaunesau/opencart-turbo

I'm currently on 1.5.6.4

Thanks

David

Active Member

Posts

Joined
Mon Mar 04, 2013 10:31 pm
Location - London

Post by victorj » Fri Apr 08, 2016 7:07 pm

Yes the speed difference is huge, its is highly recommended.
The change to innodb dus not add much speed, but the second option adding indextables makes a huge difference.
Mind you go through your website, as indextables need to be build first, and notice it getting faster and faster each time you load a page.

But as always it is wise to make a backup by exporting your database using phpmyadmin prior to optimizing it.

just try and be amazed.

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
Expert Member
Online

Posts

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

Post by davidbfranks » Fri Apr 08, 2016 7:25 pm

victorj wrote:Yes the speed difference is huge, its is highly recommended.
The change to innodb dus not add much speed, but the second option adding indextables makes a huge difference.
Mind you go through your website, as indextables need to be build first, and notice it getting faster and faster each time you load a page.

But as always it is wise to make a backup by exporting your database using phpmyadmin prior to optimizing it.

just try and be amazed.
So there is no chance of breaking anything, 3rd party mods that are not compatible with InnoDB or anything like that?

I have already indexed my MyISAM tables, so would you still recommend it?

Active Member

Posts

Joined
Mon Mar 04, 2013 10:31 pm
Location - London

Post by victorj » Fri Apr 08, 2016 7:37 pm

I use it on all of my sites to speed up the site, it has never failed me, but it is always better to be safe than sorry especially when it concerns the database.

i would recommend it, just check my sites and see how they function

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
Expert Member
Online

Posts

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

Post by IP_CAM » Sat Apr 09, 2016 9:22 am

and just to mention it, it always pays out, to regularely check the DB anyway, i.E., by use of the legendary ATOMIX Turbo-PHP InnoDB Changer/Full Indexer, after and because, if one add Extensions to the Software, some of those extensions define InnoDB-driven Tables, and others set them to MyISAM Standards.

What this means is, that during DB-Tasks, possibly 2 DB Engines are required, to individually 'handle' the Tasks, and such would not really add to Performance, at least for those, looking for the most efficient Solutions on such... ;)

Ernie
---
Link to download the latest Atomix Turbo, just unzip the File, and upload it to your Server Root.
It has been on Github, but the Author is not longer active there...
It works on all Versions from OC v.1.5 up to v.2.2 , as I am aware of, because it's a simple PHP File, called directly by Link.
http://ipc.li/os/opencart-turbo-master.zip
---

Attachments

atomix.jpg

Atomix Turbo PHP in Action - atomix.jpg (297.2 KiB) Viewed 1970 times


I don't use Forum Mail, to reach me, contact: jti@jacob.ch
-
Server Q & A Basic Information on Code + Settings
http://www.everyauction.info/serverinfo.html
Demoversion OpenCart LIGHT v.1.5.6.5
http://www.jti.li/shop/
1'400+ FREE OC Extensions - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
-
Image


User avatar
Legendary Member

Posts

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

Post by zaiban » Wed Jan 31, 2018 9:46 am

Does Atomix turbo php works with the opencart 3.x version?

Newbie

Posts

Joined
Mon Feb 09, 2015 10:50 pm

Post by IP_CAM » Wed Jan 31, 2018 10:01 am

Well, create a copy of your existing Database, by use of the Server MySql Admin
Tool, then, rename the DB-Name in your both Shop+Admin config.php files, to
match the new DB, and then, call the fabolous Atomix PHP file, and press the two buttons,
one, after the other routine is finished. It will then tell you, what it has done, and you will find out,
if your Shop still works.

And if it does, it might still increase your Performance to some extend, but
compared to the old mysql - based performance, the difference now is not so
dramatic anymore, since the change to myqli in later OC Versions itself already added
a lot to overall performance.

But if you break the DB, for what reason ever, what the heck, it was only a copy anyway. :D
Ernie

I don't use Forum Mail, to reach me, contact: jti@jacob.ch
-
Server Q & A Basic Information on Code + Settings
http://www.everyauction.info/serverinfo.html
Demoversion OpenCart LIGHT v.1.5.6.5
http://www.jti.li/shop/
1'400+ FREE OC Extensions - from OC v.1.5.x up,
on the world's largest OC-related Github Site: https://github.com/IP-CAM
-
Image


User avatar
Legendary Member

Posts

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

Users browsing this forum: No registered users and 52 guests