Changeset 35

Timestamp:

04/06/08 15:17:10 (8 months ago)

Author:

major

Message:

Version bump to 0.9.0
Fixed a bug where NULL may appear when enumerating tables on MySQL 5
MySQLTuner now checks for updates and allows the checks to be disabled

Files:

• mysqltuner.pl (modified) (8 diffs)

mysqltuner.pl

@@ -1 +1 @@
-#!/usr/bin/perl -w
-8.9
+9.0
-# High Performance MySQL Tuning Script
-# Copyright (C) 2006-2008 Major Hayden - major@mhtx.net
@@ -38 +38 @@
-
-# Set up a few variables for use in the script
-8.9
+9.0
-my (@adjvars, @generalrec);
-
@@ -48 +48 @@
-                "nocolor" => 0,
-                "skipsize" => 0,
+                "skipversion" => 0,
-        );
-        
@@ -57 +58 @@
-                'nocolor',
-                'skipsize',
+                'skipversion',
-                'help',
-        );
@@ -74 +76 @@
-                "   Performance and Reporting Options\n".
-                "      --skipsize       Don't enumerate tables and their types/sizes\n".
-
+
+
-                "   Output Options:\n".
-                "      --nogood         Remove OK responses\n".
@@ -250 +253 @@
-}
-
+# Checks for updates to MySQLTuner
+sub validate_tuner_version {
+        print "\n-------- General Statistics --------------------------------------------------\n";
+        if ($opt{skipversion} eq 1) {
+                infoprint "Skipped version check for MySQLTuner script\n";
+                return;
+        }
+        my $update;
+        if (-e "/usr/bin/curl") {
+                $update = `/usr/bin/curl --connect-timeout 5 http://mysqltuner.com/versioncheck.php?v=$tunerversion 2>/dev/null`;
+                chomp($update);
+        } elsif (-e "/usr/bin/wget") {
+                $update = `/usr/bin/wget -T 5 -O - http://mysqltuner.com/versioncheck.php?v=$tunerversion 2>/dev/null`;
+                chomp($update);
+        }
+        if ($update eq 1) {
+                badprint "There is a new version of MySQLTuner available\n";
+        } elsif ($update eq 0) {
+                goodprint "You have the latest version of MySQLTuner\n";
+        } else {
+                infoprint "Unable to check for the latest MySQLTuner version\n";
+        }
+}
+
-# Checks for supported or EOL'ed MySQL versions
-my ($mysqlvermajor,$mysqlverminor);
-sub validate_mysql_version {
-        print "\n-------- General Statistics --------------------------------------------------\n";
-        ($mysqlvermajor,$mysqlverminor) = $myvar{'version'} =~ /(\d)\.(\d)/;
-        if ($mysqlvermajor < 5) {
@@ -300 +326 @@
-        if ($mysqlvermajor eq 5) {
-                # MySQL 5 servers can have table sizes calculated quickly from information schema
-
+HAVING SUM(DATA_LENGTH) > 0 
-                foreach my $line (@templist) {
-                        my ($engine,$size,$count);
@@ -714 +740 @@
-mysql_setup;                                    # Gotta login first
-get_all_vars;                                   # Toss variables/status into hashes
+validate_tuner_version;                 # Check current MySQLTuner version
-validate_mysql_version;                 # Check current MySQL version
-check_architecture;                             # Suggest 64-bit upgrade