private function dbSize() { if ($this->is_added('db_stats')) { Yii::import('application.modules.admin.models.DbStats'); $sql = "SHOW TABLE STATUS"; $command = Yii::app()->db->createCommand($sql); $data = $command->query(); $size = 0; foreach ($data as $row) { $size += $row['Data_length'] + $row['Index_length']; } $size = $this->formatsize($size); $model = new DbStats('search'); $model->size = $size; $model->insert(); } }