/**
* For Mysql only
*/
public function repair()
{
if (get_opinion('DB_TYPE') != 'mysql' && get_opinion('DB_TYPE') != 'mysqli') {
$this->error('当前数据库类型不被支持');
}
$M = M();
if (IS_POST) {
$System = new \Common\Event\SystemEvent();
$System->postIntegrity();
if (empty($_POST['table']) || count($_POST['table']) == 0) {
$this->jsonReturn(0, "请选择要处理的表");
}
$table = implode(',', $_POST['table']);
if ($_POST['act'] == 'repair') {
if ($M->query("REPAIR TABLE {$table} ")) {
$this->jsonReturn(1, "修复表成功", U('Admin/Data/repair'));
}
} elseif ($_POST['act'] == 'optimize') {
if ($M->query("OPTIMIZE TABLE {$table}")) {
$this->jsonReturn(1, "优化表成功", U('Admin/Data/repair'));
}
}
$this->jsonReturn(0, "请选择操作");
} else {
$tabs = $M->query('SHOW TABLE STATUS');
$total_size = array('table' => 0, 'index' => 0, 'data' => 0, 'free' => 0);
$tables = array();
foreach ($tabs as $k => $table) {
$table['size'] = File::byteFormat($table['Data_length'] + $table['Index_length']);
$total_size['table'] += $table['Data_length'] + $table['Index_length'];
$total_size['data'] += $table['Data_length'];
$table['Data_length'] = File::byteFormat($table['Data_length']);
$total_size['index'] += $table['Index_length'];
$table['Index_length'] = File::byteFormat($table['Index_length']);
$total_size['free'] += $table['Data_free'];
$table['Data_free'] = File::byteFormat($table['Data_free']);
$tables[] = $table;
}
$total_size['table'] = File::byteFormat($total_size['table']);
$total_size['free'] = File::byteFormat($total_size['free']);
$total_size['table'] = File::byteFormat($total_size['table']);
$total_size['data'] = File::byteFormat($total_size['data']);
$total_size['index'] = File::byteFormat($total_size['index']);
$this->assign("list", $tables);
$this->assign("totalsize", $total_size);
$this->display();
}
}
