Edit file

File name : check_mysql_engines

Content :#!/usr/local/bin/php <?php $output = explode(PHP_EOL, shell_exec('sudo mysql -u root -e \'show engines\' | awk {\'print $1" "$2\'} | tail -n +2')); $engines = ['InnoDB', 'MRG_MYISAM', 'MEMORY', 'MyISAM', 'ARCHIVE']; foreach ($output as $string) { list($k, $v) = explode(' ', $string); $result[ $k ] = $v; } foreach ($engines as $engine) { if ($result[$engine] == 'NO') { $answer[]=$engine; } } if (empty($answer)) { echo "MySQL Engines OK."; exit(0); } else { echo json_encode(['error' => 'true', 'failed_engines' => $answer], JSON_PRETTY_PRINT); exit(2); }

Save