1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
|
<?php
function showTableStatus($db) {
$size = 0;
$out = "";
start_table();
row1($db, 15);
row_array(array("Name", "Engine", "Version", "Row Format", "Rows", "Avg Row Length (KB)", "Data Length (MB)", "Max Data Length (MB)", "Index Length (MB)", "Data free (MB)", "Create Time", "Update Time", "Check Time", "Create Options", "Comment"));
mysql_select_db($db);
$result = mysql_query("show table status");
while($row = mysql_fetch_array($result)) {
$size += ($row["Data_length"] + $row["Index_length"]);
$engine = $row["Engine"];
if (!$engine) $engine = $row["Type"];
row_array(array(
$row["Name"],
$engine,
$row["Version"] ,
$row["Row_format"] ,
$row["Rows"] ,
round($row["Avg_row_length"]/1024,2) ,
round($row["Data_length"]/(1024*1024),2) ,
round($row["Max_data_length"]/(1024*1024),2) ,
round($row["Index_length"]/(1024*1024),2) ,
round($row["Data_free"]/(1024*1024),2) ,
$row["Create_time"] ,
$row["Update_time"] ,
$row["Check_time"] ,
$row["Create_options"] ,
$row["Comment"]
));
}
$size = round(($size/1024)/1024, 1);
row2("Total Table Sizes (MB)", $size);
end_table();
echo "<BR><BR>";
}
require_once("../inc/db.inc");
db_init();
page_head("MySQL Table Stats");
// add the databases you want to keep track of here
//
showTableStatus("boinc_alpha");
showTableStatus("cplan");
?>
|
