Recent Topics

1 Oct 17, 2015 17:54    

Hi,
I wanted to try to install b2evolution (latest stable version) onto my privately used hosting site.
However, i get an error message related to the innodb storage engine
Unknown storage engine 'innodb'(Errno=1286)
The support teal of my hosting company just informed me that they do not support innodb.
Does it mean that I have no chance to use b2 on this infrastructure, or is there a hidden flag allowing to use another storage engine ?

2 Oct 19, 2015 10:54

So it seems that the database b2evo creates is IonnDB if I understand you correctly, as the host doesn't recognise it so it didn't create it.

Hope this may be of some help:

I create my own database via MySQL 5.1 that b2evo then populates. b2evo uses whatever is the default which will be MyISAM not IonnDB on my host

http://stackoverflow.com/questions/3818759/what-is-innodb-and-myisam-in-mysql

"You can specify the type by giving MYISAM OR InnoDB while creating a table in DB."

"InnoDB is a storage engine for MySQL, included as standard in all current binaries distributed by MySQL AB. Its main enhancement over other storage engines available for use with MySQL is ACID-compliant transaction support"

"MyISAM is the default storage engine for the MySQL relational database management system versions prior to 5.5 1. It is based on the older ISAM code but has many useful extensions. The major deficiency of MyISAM is the absence of transactions support. Versions of MySQL 5.5 and greater have switched to the InnoDB engine to ensure referential integrity constraints, and higher concurrency."

4 Oct 21, 2015 22:24

MyISAM is very basic and limited, compared to what InnoDB offers.

InnoDB is required to properly execute transactions, which is necessary to preserve coherence of the data. Additionally, InnoDB allows better performance on sites with heavy traffic (row locking), allows better maintenance of the DB (referential integrity) and also better stability (no corrupted tables).

In the case of b2evolution, we want to take full advantage of the performance and reliability benefits of a modern DBMS.

See also: http://b2evolution.net/man/myisam-vs-innodb

@jevylux who is your webhost? Do they offer different hosting plans?


Form is loading...