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
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.
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
So there is no chance of breaking anything, 3rd party mods that are not compatible with InnoDB or anything like that?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.
I have already indexed my MyISAM tables, so would you still recommend it?
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
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
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.
viewtopic.php?f=199&t=221103&p=805841#p805841
---
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.
viewtopic.php?f=199&t=221103&p=805841#p805841
---
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.
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.
Ernie
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.
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: No registered users and 14 guests
