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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
|
<?php
/*
ex: set tabstop=4 shiftwidth=4 autoindent:
+-------------------------------------------------------------------------+
| Copyright (C) 2004-2016 The Cacti Group |
| |
| This program is free software; you can redistribute it and/or |
| modify it under the terms of the GNU General Public License |
| as published by the Free Software Foundation; either version 2 |
| of the License, or (at your option) any later version. |
| |
| This program is distributed in the hope that it will be useful, |
| but WITHOUT ANY WARRANTY; without even the implied warranty of |
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |
| GNU General Public License for more details. |
+-------------------------------------------------------------------------+
| Cacti: The Complete RRDTool-based Graphing Solution |
+-------------------------------------------------------------------------+
| This code is designed, written, and maintained by the Cacti Group. See |
| about.php and/or the AUTHORS file for specific developer information. |
+-------------------------------------------------------------------------+
| http://www.cacti.net/ |
+-------------------------------------------------------------------------+
*/
/* do NOT run this script through a web browser */
if (!isset($_SERVER["argv"][0]) || isset($_SERVER['REQUEST_METHOD']) || isset($_SERVER['REMOTE_ADDR'])) {
die("<br><strong>This script is only meant to run at the command line.</strong>");
}
$no_http_headers = true;
include("../site/include/global.php");
/* process calling arguments */
$parms = $_SERVER["argv"];
array_shift($parms);
global $debug;
$debug = FALSE;
$size = 300000;
$rebuild = FALSE;
foreach($parms as $parameter) {
@list($arg, $value) = @explode("=", $parameter);
switch ($arg) {
case "-d":
case "--debug":
$debug = TRUE;
break;
case "-r":
case "--rebuild":
$rebuild = TRUE;
break;
case "-s":
case "--size":
$size = $value;
break;
case "-h":
case "-v":
case "-V":
case "--version":
case "--help":
display_help();
exit;
default:
print "ERROR: Invalid Parameter " . $parameter . "\n\n";
display_help();
exit;
}
}
echo "Converting All Non-Memory Cacti Database Tables to Innodb with Less than '$size' Records\n";
$engines = db_fetch_assoc("SHOW ENGINES");
foreach($engines as $engine) {
if (strtolower($engine["Engine"]) == "innodb" && strtolower($engine["Support"] == "off")) {
echo "InnoDB Engine is not enabled\n";
exit;
}
}
$file_per_table = db_fetch_row("show global variables like 'innodb_file_per_table'");
if (strtolower($file_per_table["Value"]) != "on") {
echo "innodb_file_per_table not enabled";
exit;
}
$tables = db_fetch_assoc("SHOW TABLE STATUS");
if (sizeof($tables)) {
foreach($tables AS $table) {
if ($table["Engine"] == "MyISAM" || ($table["Engine"] == "InnoDB" && $rebuild)) {
if ($table["Rows"] < $size) {
echo "Converting Table -> '" . $table['Name'] . "'";
$status = db_execute("ALTER TABLE " . $table['Name'] . " ENGINE=Innodb");
echo ($status == 0 ? " Failed" : " Successful") . "\n";
}else{
echo "Skipping Table -> '" . $table['Name'] . " too many rows '" . $table["Rows"] . "'\n";
}
}else{
echo "Skipping Table ->'" . $table['Name'] . "\n";
}
}
}
/* display_help - displays the usage of the function */
function display_help () {
print "Cacti Database Conversion Tool v1.0, Copyright 2010 - The Cacti Group\n\n";
print "usage: convert_innodb.php [-d] [-h] [--form] [--help] [-v] [-V] [--version]\n\n";
print "-d | --debug - Display verbose output during execution\n";
print "-s | --size=N - The largest table size in records to convert\n";
print "-v -V --version - Display this help message\n";
print "-h --help - display this help message\n";
}
?>
|
