Soluble\Schema\Source\Mysql\AbstractMysqlDriver

Complexity

Total Complexity

7

Size/Duplication

Total Lines	67
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Test Coverage

Coverage

85%

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	1
A	disableInnoDbStats()	0	20	4
A	restoreInnoDbStats()	0	8	2

<?php

namespace Soluble\Schema\Source\Mysql;

use Soluble\DbWrapper\Adapter\AdapterInterface;

abstract class AbstractMysqlDriver implements MysqlDriverInterface
{
    /**
     * @var AdapterInterface
     */
    protected $adapter;

    /**
     * Schema name.
     *
     * @var string
     */
    protected $schema;

    /**
     * Used to restore innodb stats mysql global variable.
     *
     * @var string
     */
    protected $mysql_innodbstats_value;

    /**
     * @param AdapterInterface $adapter
     * @param string           $schema  database name
     */
    public function __construct(AdapterInterface $adapter, $schema)
    {
        $this->adapter = $adapter;
        $this->schema = $schema;
    }

    /**
     * Disable innodbstats will increase speed of metadata lookups.
     */
    protected function disableInnoDbStats()
    {
        $sql = "show global variables like 'innodb_stats_on_metadata'";
        try {
            $results = $this->adapter->query($sql);
            if (count($results) > 0) {
                $row = $results->offsetGet(0);

                $value = strtoupper($row['Value']);
                // if 'on' no need to do anything
                if ($value != 'OFF') {
                    $this->mysql_innodbstats_value = $value;
                    // disabling innodb_stats
                    $this->adapter->query("set global innodb_stats_on_metadata='OFF'");
                }
            }
        } catch (\Exception $e) {
            // do nothing, silently fallback
        }
    }

    /**
     * Restore old innodbstats variable.
     */
    protected function restoreInnoDbStats()
    {
        $value = $this->mysql_innodbstats_value;
        if ($value !== null) {
            // restoring old variable
            $this->adapter->query("set global innodb_stats_on_metadata='$value'");
        }
    }
}