Atomix InnoDB + Full Indexing Opencart DB Performance MOD!
High Performance, NO PROBLEM, NO RISK, to use it!
Latest Version download here:
viewtopic.php?f=199&t=221103&p=805841#p805841
Ernie
bigmax.ch.ch/shop/
PS: Also works, as tested and shown below, with my GrandCMS (Opencart V.2 CMS Derivate Software)
---
MySql MyISAM vs. InnoDB = impressive Performance Boost.
MySqli MyISAM vs. InnoDB = ~similar Performance Results.
Still, Atomix FULL DB Indexing is important, in any Case, it guarantees, that ALL TABLES are indexed, and driven by ONE ENGINE ONLY!
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Hello IP_CAM,IP_CAM wrote:Atomix TURBO does not longer exist on Github.
Atomix InnoDB + Full Indexing Opencart DB Performance MOD!
High Performance, NO PROBLEM, NO RISK, to use it!
Latest Version download here:
viewtopic.php?f=199&t=221103&p=805841#p805841
Ernie
bigmax.ch/shop/
PS: Also works, as tested and shown below, with my GrandCMS (Opencart V.2 CMS Derivate Software)
---
MySql MyISAM vs. InnoDB = impressive Performance Boost.
MySqli MyISAM vs. InnoDB = ~similar Performance Results.
Still, Atomix FULL DB Indexing is important, in any Case, it guarantees, that ALL TABLES are indexed, and driven by ONE ENGINE ONLY!
I tried your script and I changed all my database Opencart 2.1.0.2 in InnoDB
first it has revealed an error in oc_product_description (does not support FULLTEX)
second thing I did not have variation in performance from MyISAM ...
I did this test because I have a problem to First Byte Time ranging from 0.4 to 1.5 seconds.
Can you help me improve it?
Thank you so much
Alessandro
Attachments
2017-01-21_141001.png (13.03 KiB) Viewed 4700 times
but this is not a Problem, and it would not have a real negative impact on Performance.
You could try to find another Extension, if this 'Routine', producing this Error-Message,
is 'done' by an Extension. But I am not a DB-Specialist, I am just speaking from my own
experience with this...
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Thank you for your answare,IP_CAM wrote:well, some socalled "fulltext" DB-Table exist, unable to be changed to work with InnoDB,
but this is not a Problem, and it would not have a real negative impact on Performance.
You could try to find another Extension, if this 'Routine', producing this Error-Message,
is 'done' by an Extension. But I am not a DB-Specialist, I am just speaking from my own
experience with this...
Ernie
ok,
so even you will not be processed?
however the speed of my database is not changed :-)
Thanks!
But the MAIN advantage still is, to INDEX the entire DB, as it can be done by use of
ATOMIX Mod as well.
But don't worry, if you cannot change ONE ONLY Table to InnoDB, it will still function,
just still by use of the MyISAM DB engine, if it's routine is used.
Good Luck !
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
I in my server I need to install MySQLi? I use plesk Onyx, and centos 6.8, it is possible do this?IP_CAM wrote:Only when switching from MyISAM to InnoDB by use of MySql made a dramatic difference in performance, by use of MySqli, no 'visible' performance difference exists anymore.
But the MAIN advantage still is, to INDEX the entire DB, as it can be done by use of
ATOMIX Mod as well.
But don't worry, if you cannot change ONE ONLY Table to InnoDB, it will still function,
just still by use of the MyISAM DB engine, if it's routine is used.
Good Luck !
Ernie
And if not, just change:
Code: Select all
// DB
define('DB_DRIVER', 'mysql');
to
// DB
define('DB_DRIVER', 'mysqli');
and if the Shop does not work any longer, change it back, and ask, or change, the Server Software Provider.
I cannot tell you any more on this, sorry...
Good Luck !
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
yes, it was all set :-)...IP_CAM wrote:If you have SET mysqli as DB-DRIVER in your config.php files, then it already works!
And if not, just change:in BOTH of your config.php Files, in the Shop ROOT and Admin Section in OpenCart,Code: Select all
// DB define('DB_DRIVER', 'mysql'); to // DB define('DB_DRIVER', 'mysqli');
and if the Shop does not work any longer, change it back, and ask, or change, the Server Software Provider.
I cannot tell you any more on this, sorry...
Good Luck !
Ernie
you know how to solve a problem of First Byte Time ranging from 0.4 to 1.5 seconds?
Ernie
My Github OC Site: https://github.com/IP-CAM
5'200 + FREE OC Extensions, on the World's largest private Github OC Repository Archive Site.
Users browsing this forum: No registered users and 47 guests