49 lines
1.2 KiB
PHP
Executable File
49 lines
1.2 KiB
PHP
Executable File
#!/usr/bin/php
|
|
<?php
|
|
|
|
if (posix_getuid() != 0) {
|
|
echo 'Run as root!' . PHP_EOL;
|
|
exit(1);
|
|
}
|
|
|
|
$mysql_host = 'localhost';
|
|
$mysql_port = '3309';
|
|
$mysql_user = 'root';
|
|
$mysql_password = 'silver';
|
|
$mysql_dir = '/var/lib/mysql';
|
|
|
|
echo 'Querying MySQL.';
|
|
$pdo = new PDO('mysql:host=' . $mysql_host . ';port=' . $mysql_port . ';dbname=information_schema', $mysql_user, $mysql_password);
|
|
echo '.';
|
|
$sql = 'SELECT table_schema, table_name, engine FROM information_schema.tables WHERE engine="InnoDB"';
|
|
$stmt = $pdo->prepare($sql);
|
|
echo '.';
|
|
|
|
$stmt->execute();
|
|
echo '.';
|
|
|
|
$data = $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
echo ' OK' . PHP_EOL;
|
|
|
|
$tbl_file = 0;
|
|
$tbl_ibdt = 0;
|
|
foreach ($data as $table) {
|
|
$filename = $mysql_dir . DIRECTORY_SEPARATOR . encode_filename($table['table_schema']) . DIRECTORY_SEPARATOR . encode_filename($table['table_name']) . '.ibd';
|
|
if (!file_exists($filename)) {
|
|
$tbl_ibdt++;
|
|
echo 'ibdata: ' . $table['table_schema'] . '.' . $table['table_name'] . PHP_EOL;
|
|
} else {
|
|
$tbl_file++;
|
|
}
|
|
}
|
|
|
|
echo 'innodb_file_per_table : ' . $tbl_file . PHP_EOL;
|
|
echo 'Tables in ibdata1 file: ' . $tbl_ibdt . PHP_EOL;
|
|
|
|
|
|
function encode_filename($filename)
|
|
{
|
|
$filename = str_replace('.', '@002e', $filename);
|
|
return $filename;
|
|
}
|