Post by TedoNedev » Sun Sep 06, 2015 10:19 pm

Здравейте колеги, проблем ли е Opencart да работи с InnoDB engine? Доста четох и реших да мина на InnoDB. Минах и за сега не виждам абсолютно никакъв проблем. Но по форумите в теми от 2011г. се казва, че Opencart не може да работи с този енджин. Моля помагайте! Има ли такъв проблем наистина и защо?

Newbie

Posts

Joined
Sat Mar 14, 2015 7:59 pm

Post by IP_CAM » Mon Sep 07, 2015 12:32 am

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.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.


User avatar
Legendary Member

Posts

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

Post by bonny3 » Sat Jan 21, 2017 9:23 pm

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!
Hello IP_CAM,
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

2017-01-21_141001.png (13.03 KiB) Viewed 4700 times


New member

Posts

Joined
Wed Nov 11, 2015 7:20 am

Post by IP_CAM » Sat Jan 21, 2017 10:08 pm

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... :D
Ernie
inno_db_message.jpg

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.


User avatar
Legendary Member

Posts

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

Post by bonny3 » Sun Jan 22, 2017 12:27 am

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... :D
Ernie
inno_db_message.jpg
Thank you for your answare,
ok,
so even you will not be processed?
however the speed of my database is not changed :-)
Thanks!

New member

Posts

Joined
Wed Nov 11, 2015 7:20 am

Post by IP_CAM » Sun Jan 22, 2017 1:44 am

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

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.


User avatar
Legendary Member

Posts

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

Post by bonny3 » Sun Jan 22, 2017 2:23 am

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
I in my server I need to install MySQLi? I use plesk Onyx, and centos 6.8, it is possible do this?

New member

Posts

Joined
Wed Nov 11, 2015 7:20 am

Post by IP_CAM » Sun Jan 22, 2017 3:38 am

If you have SET mysqli as DB-DRIVER in your config.php files, then it already works!
And if not, just change:

Code: Select all

// DB
define('DB_DRIVER', 'mysql');
to
// DB
define('DB_DRIVER', 'mysqli');
in BOTH of your config.php Files, in the Shop ROOT and Admin Section in OpenCart,
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.


User avatar
Legendary Member

Posts

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

Post by bonny3 » Sun Jan 22, 2017 5:35 am

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:

Code: Select all

// DB
define('DB_DRIVER', 'mysql');
to
// DB
define('DB_DRIVER', 'mysqli');
in BOTH of your config.php Files, in the Shop ROOT and Admin Section in OpenCart,
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
yes, it was all set :-)...
you know how to solve a problem of First Byte Time ranging from 0.4 to 1.5 seconds?

New member

Posts

Joined
Wed Nov 11, 2015 7:20 am

Post by IP_CAM » Sun Jan 22, 2017 7:57 am

No, I don't know, it may be your Server, or then something as complicated as a Journal Theme, with it's whole bunch of different Header Stylesheets and Scripts. But better don't worry about it, 0.4-1.5 Sec is not that bad.
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.


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 47 guests