PhabricatorStorageManagementProbeWorkflow.php
View Options

	<?php

	final class PhabricatorStorageManagementProbeWorkflow
	extends PhabricatorStorageManagementWorkflow {

	protected function didConstruct() {
	$this
	->setName('probe')
	->setExamples('probe')
	->setSynopsis(pht('Show approximate table sizes.'));
	}

	protected function isReadOnlyWorkflow() {
	return true;
	}

	public function didExecute(PhutilArgumentParser $args) {
	$api = $this->getSingleAPI();

	$console = PhutilConsole::getConsole();
	$console->writeErr(
	"%s\n",
	pht('Analyzing table sizes (this may take a moment)...'));

	$patches = $this->getPatches();
	$databases = $api->getDatabaseList($patches, true);

	$conn_r = $api->getConn(null);

	$data = array();
	foreach ($databases as $database) {
	queryfx($conn_r, 'USE %C', $database);
	$tables = queryfx_all(
	$conn_r,
	'SHOW TABLE STATUS');
	$tables = ipull($tables, null, 'Name');
	$data[$database] = $tables;
	}

	$totals = array_fill_keys(array_keys($data), 0);
	$overall = 0;

	foreach ($data as $db => $tables) {
	foreach ($tables as $table => $info) {
	$table_size = $info['Data_length'] + $info['Index_length'];

	$data[$db][$table]['_totalSize'] = $table_size;
	$totals[$db] += $table_size;
	$overall += $table_size;
	}
	}

	asort($totals);

	$table = id(new PhutilConsoleTable())
	->setShowHeader(false)
	->setPadding(2)
	->addColumn('name', array('title' => pht('Database / Table')))
	->addColumn(
	'size',
	array(
	'title' => pht('Size'),
	'align' => PhutilConsoleTable::ALIGN_RIGHT,
	))
	->addColumn(
	'percentage',
	array(
	'title' => pht('Percentage'),
	'align' => PhutilConsoleTable::ALIGN_RIGHT,
	));

	foreach ($totals as $db => $size) {
	list($database_size, $database_percentage) = $this->formatSize(
	$totals[$db],
	$overall);

	$table->addRow(array(
	'name' => tsprintf('%s', $db),
	'size' => tsprintf('%s', $database_size),
	'percentage' => tsprintf('%s', $database_percentage),
	));
	$data[$db] = isort($data[$db], '_totalSize');
	foreach ($data[$db] as $table_name => $info) {
	list($table_size, $table_percentage) = $this->formatSize(
	$info['_totalSize'],
	$overall);

	$table->addRow(array(
	'name' => ' '.$table_name,
	'size' => $table_size,
	'percentage' => $table_percentage,
	));
	}
	}

	list($overall_size, $overall_percentage) = $this->formatSize(
	$overall,
	$overall);
	$table->addRow(array(
	'name' => tsprintf('%s', pht('TOTAL')),
	'size' => tsprintf('%s', $overall_size),
	'percentage' => tsprintf('%s', $overall_percentage),
	));

	$table->draw();
	return 0;
	}

	private function formatSize($n, $o) {
	return array(
	pht('%s MB', new PhutilNumber($n / (1024 * 1024), 1)),
	sprintf('%3.1f%%', 100 * ($n / $o)),
	);
	}

	}

File Metadata

Mime Type: text/x-php
Expires: Jan 19 2025, 23:11 (6 w, 3 d ago)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 1129732
Default Alt Text: PhabricatorStorageManagementProbeWorkflow.php (3 KB)

PhabricatorStorageManagementProbeWorkflow.php
No OneTemporary
Actions

PhabricatorStorageManagementProbeWorkflow.php
View Options

File Metadata

Event Timeline

PhabricatorStorageManagementProbeWorkflow.phpNo OneTemporaryActions

PhabricatorStorageManagementProbeWorkflow.phpView Options

File Metadata

Event Timeline

PhabricatorStorageManagementProbeWorkflow.php
No OneTemporary
Actions

PhabricatorStorageManagementProbeWorkflow.php
View Options