php判断mysql数据库是否支持innodb

• 2016-06-13
• 2001 View

SHOW GLOBAL VARIABLES LIKE 'have_innodb';
-- returns empty set

Only affect 5.6x.

How to repeat:
See above.

Suggested fix:
I *guess* that this is an issue with docs and categorize accordingly.  
But I cannot be perfectly sure, of course, if removal of the variable was intentional.

[22 Nov 2011 16:23] Peter Laursen

One should read till the end!

"This variable was removed in MySQL 5.6.1. Use SHOW ENGINES instead!

public function enable_innodb(){
        $status = false;
         $rs = $this->select('show engines');
        foreach($rs as $row){
            if($row['Engine'] == 'InnoDB' && ($row['Support'] == 'YES' || $row['Support'] == 'DEFAULT') ){
                $status = true;
            }
        }
        return $this->_enable_innodb = $status;
    }