Package: mysqltuner
Version: 0.9.0
Severity: minor
When running this (otherwise excellent) script, I get this:
...
[!!] Table cache hit rate: 3%
Use of uninitialized value $myvar{"table_cache"} in concatenation (.) or string
at /usr/bin/mysqltuner line 661 (#1)
(W uninitialized) An undefined value was used as if it were already
defined. It was interpreted as a "" or a 0, but maybe it was a mistake.
To suppress this warning assign a defined value to your variables.
To help you figure out what was undefined, perl will try to tell you the
name of the variable (if any) that was undefined. In some cases it cannot
do this, so it also tells you what operation you used the undefined value
in. Note, however, that perl optimizes your program and the operation
displayed in the warning may not necessarily appear literally in your
program. For example, "that $foo" is usually optimized into "that "
. $foo, and the warning will refer to the concatenation (.) operator,
even though there is no . in your program.
[OK] Open file limit used: 10%
...
Looking at the code, I suspect that this is due to MySQL 5.1 not having a
"table_cache" system variable:
mysql> show global variables like '%table%';
+-----------------------------+----------+
| Variable_name | Value |
+-----------------------------+----------+
| big_tables | OFF |
| innodb_file_per_table | OFF |
| innodb_table_locks | ON |
| lower_case_table_names | 0 |
| max_heap_table_size | 33554432 |
| max_tmp_tables | 32 |
| ndb_use_copying_alter_table | OFF |
| old_alter_table | OFF |
| sql_big_tables | OFF |
| table_definition_cache | 256 |
| table_lock_wait_timeout | 50 |
| table_open_cache | 64 |
| table_type | MyISAM |
| tmp_table_size | 33554432 |
| updatable_views_with_limit | YES |
+-----------------------------+----------+
15 rows in set (0.01 sec)
whereas 5.0.51a does:
mysql> show global variables like 'table%';
+-------------------------+--------+
| Variable_name | Value |
+-------------------------+--------+
| table_cache | 64 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
+-------------------------+--------+
3 rows in set (0.00 sec)
-- System Information:
Debian Release: lenny/sid
APT prefers testing
APT policy: (500, 'testing'), (400, 'experimental')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.25-2-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_GB, LC_CTYPE=en_GB (charmap=ISO-8859-1)
Shell: /bin/sh linked to /bin/bash
Versions of packages mysqltuner depends on:
ii perl 5.10.0-11.1 Larry Wall's Practical Extraction
Versions of packages mysqltuner recommends:
ii mysql-server 5.1.26rc-1 MySQL database server (meta packag
ii mysql-server-5.1 [mysql-serve 5.1.26rc-1 MySQL database server binaries
mysqltuner suggests no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
