PHP DatabaseUtil::getOptimizeTable示例

 public function actionOptimize()
 {
     $formSubmit = EnvUtil::submitCheck("dbSubmit");
     if ($formSubmit) {
         $tables = $_POST["optimizeTables"];
         if (!empty($tables)) {
             DatabaseUtil::optimize($tables);
         }
         $this->success(Ibos::lang("Operation succeed", "message"));
     } else {
         $list = DatabaseUtil::getOptimizeTable();
         $totalSize = 0;
         foreach ($list as $table) {
             $totalSize += $table["Data_length"] + $table["Index_length"];
         }
         $data["list"] = $list;
         $data["totalSize"] = $totalSize;
         $this->render("optimize", $data);
     }
 }