[MDEV-5265] have_innodb should be restored in MariaDB 10 Created: 2013-11-08  Updated: 2022-09-08

Status: Open
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Jorge Manuel Silva Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

I think the have_innodb variable should be restored in MariaDB 10 as there are some PHP applications (tested with Magento) that check for the existance of INNODB storage engine with the contents of that variable.

In their database connector I had to change:

$variables  = $this->_getConnection()
 
            ->fetchPairs('SHOW VARIABLES');
 
        return (!isset($variables['have_innodb']) || $variables['have_innodb'] != 'YES') ? false : true;

To

$engines  = $this->_getConnection()
 
            ->fetchPairs('SHOW ENGINES');
 
		return (!isset($engines['InnoDB']) || $engines['InnoDB'] != 'YES') ? false : true;

And managed it to pass the check.

Still I'd like that the have_innodb removal is reverted in order to restore compatibility with other software.

 Comments   
Comment by Sergei Golubchik [ 2013-11-11 ]

without modifying the server, this can be done with a special "have" daemon plugin that provides missing "have_xxx" variables for whoever needs them.

Comment by Jorge Manuel Silva [ 2013-11-13 ]

And where can I download that?

Comment by Sergei Golubchik [ 2013-11-13 ]

You misunderstood. I didn't say it's done, I only provided a suggestion how it can be fixed without adding obsolete features back to the server.

Comment by Elena Stepanova [ 2014-01-08 ]

It seems to be a good task to contribute code (as a plugin) if somebody wants to do some community work.

Generated at Thu Feb 08 07:02:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.