N98\Magento\Command\Database\StatusCommand

Complexity

Total Complexity

8

Size/Duplication

Total Lines	162
Duplicated Lines	0 %

Coupling/Cohesion

Components	2
Dependencies	2

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	configure()	0	12	1
B	generateRows()	0	49	4
A	allowRounding()	0	6	1
A	timeElapsedString()	0	4	2

<?php

namespace N98\Magento\Command\Database;

use N98\Util\TimeElapsed;

class StatusCommand extends AbstractShowCommand
{
    protected $showMethod = 'getGlobalStatus';

    /**
     * Add more important status variables
     *
     * @var array
     */
    protected $_importantVars = array(
        'Threads_connected' => array(
            'desc' => 'Total number of clients that have currently open connections to the server.',
        ),
        'Created_tmp_disk_tables' => array(
            'desc' => 'Number of temporary tables that have been created on disk instead of in-memory. Lower is
            better.',
        ),
        'Handler_read_first' => array(
            'desc' => 'Number of times a table handler made a request to read the first row of a table index.',
        ),
        'Handler_read_rnd_next' => array(
            'desc' => 'Number of requests to read the next row in the data file. This value is high if you
                are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or
                that your queries are not written to take advantage of the indexes you have.',
        ),
        'Innodb_buffer_pool_wait_free' => array(
            'desc' => 'Number of times MySQL has to wait for memory pages to be flushed.',
        ),
        'Innodb_buffer_pool_pages_dirty' => array(
            'desc' => 'Indicates the number of InnoDB buffer pool data pages that have been changed in memory,
            but the changes are not yet written (flushed) to the InnoDB data files',
        ),
        'Key_reads' => array(
            'desc' => 'Number of filesystem accesses MySQL performed to fetch database indexes.',
        ),
        'Max_used_connections' => array(
            'desc' => 'Max number of connections MySQL has had open at the same time since the server 
            was last restarted.',
        ),
        'Open_tables' => array(
            'desc' => 'Number of tables that are currently open.',
        ),
        'Select_full_join' => array(
            'desc' => 'Number of full joins MySQL has performed to satisfy client queries.',
        ),
        'Slow_queries' => array(
            'desc' => 'Number of queries that have taken longer than usual to execute.',
        ),
        'Uptime' => array(
            'desc' => 'Time since the server was last restarted.',
        ),
        'Aborted_connects' => array(
            'desc' => 'Total number of failed attempts to connect to MySQL.',
        ),
    );
    /**
     * @var array
     */
    protected $_specialFormat = array(
        'Uptime' => array('N98\Util\TimeElapsed', 'short'),
    );

    protected function configure()
    {
        parent::configure();
        $this
            ->setName('db:status')
            ->setDescription('Shows important server status information or custom selected status values');

        $help = <<<HELP
This command is useful to print important server status information about the current database.
HELP;
        $this->setHelp($help);
    }

    /**
     * @param array $outputVars
     * @param bool $hasDescription
     *
     * @return array
     */
    protected function generateRows(array $outputVars, $hasDescription)
    {
        $rows = parent::generateRows($outputVars, $hasDescription);

        if (false === $hasDescription) {
            return $rows;
        }

        if (isset($this->_allVariables['Handler_read_rnd_next'])) {
            $tableScanRate = (
                (
                    $this->_allVariables['Handler_read_rnd_next'] +
                    $this->_allVariables['Handler_read_rnd']
                )
                /
                (
                    $this->_allVariables['Handler_read_rnd_next'] +
                    $this->_allVariables['Handler_read_rnd'] +
                    $this->_allVariables['Handler_read_first'] +
                    $this->_allVariables['Handler_read_next'] +
                    $this->_allVariables['Handler_read_key'] +
                    $this->_allVariables['Handler_read_prev']
                )
            );
            $rows[] = array(
                'Full table scans',
                sprintf('%.2f', $tableScanRate * 100) . '%',
                $this->formatDesc(
                    'HINT: "Handler_read_rnd_next" is reset to zero when reached the value of 2^32 (4G).'
                ),
            );
        }
        if (isset($this->_allVariables['Innodb_buffer_pool_read_requests'])) {
            $bufferHitRate = $this->_allVariables['Innodb_buffer_pool_read_requests'] /
                ($this->_allVariables['Innodb_buffer_pool_read_requests'] +
                    $this->_allVariables['Innodb_buffer_pool_reads']);

            $rows[] = array(
                'InnoDB Buffer Pool hit',
                sprintf('%.2f', $bufferHitRate * 100) . '%',
                $this->formatDesc(
                    'An InnoDB Buffer Pool hit ratio below 99.9% is a weak indicator that your InnoDB Buffer Pool 
                    could be increased.'
                ),
            );
        }

        return $rows;
    }

    /**
     * @param string $name
     *
     * @return bool
     */
    protected function allowRounding($name)
    {
        $isSize = false !== strpos($name, '_size');

        return $isSize;
    }

    /**
     * borrowed from <http://stackoverflow.com/questions/1416697/>
     *
     * echo time_elapsed_string('2013-05-01 00:22:35');
     * echo time_elapsed_string('@1367367755'); # timestamp input
     * echo time_elapsed_string('2013-05-01 00:22:35', true);
     *
     * @param      $datetime
     * @param bool $full
     * @deprecated since 1.3.2, use callback "N98\Util\TimeElapsed::short" instead
     * @see \N98\Util\TimeElapsed::short()
     *
     * @return string
     */
    protected function timeElapsedString($datetime, $full = false)
    {
        return $full ? TimeElapsed::full($datetime) : TimeElapsed::short($datetime);
    }
}