Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP

Loading…

InnoDB is being used but MySQLTuner reports that it isn't. #1

Closed
jgarber opened this Issue · 5 comments

3 participants

@jgarber
$ perl mysqltuner.pl
>>  MySQLTuner 1.1.1 - Major Hayden <major@mhtx.net>
>>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
>>  Run with '--help' for additional options and output filtering
[!!] Successfully authenticated with no password - SECURITY RISK!

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.51a-3ubuntu5.4-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster 
[!!] InnoDB is enabled but isn't being used
[OK] Total fragmented tables: 0

-------- Security Recommendations  -------------------------------------------
ERROR 1142 (42000) at line 1: SELECT command denied to user ''@'localhost' for table 'user'
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 1d 2h 19m 2s (354K q [3.738 qps], 67 conn, TX: 886M, RX: 39M)
[--] Reads / Writes: 98% / 2%
[--] Total buffers: 296.0M global + 24.2M per thread (6 max threads)
[!!] Maximum possible memory usage: 441.1M (86% of installed RAM)
[OK] Slow queries: 0% (0/354K)
[OK] Highest usage of available connections: 83% (5/6)
[!!] Cannot calculate MyISAM index size - re-run script as root user
[OK] Query cache efficiency: 59.6% (208K cached / 349K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 68K sorts)
[!!] Temporary tables created on disk: 43% (816 on disk / 1K total)
[OK] Thread cache hit rate: 92% (5 created / 67 connections)
[OK] Table cache hit rate: 88% (45 open / 51 opened)
[OK] Open file limit used: 0% (23/8K)
[OK] Table locks acquired immediately: 100% (143K immediate / 143K locks)

-------- Recommendations -----------------------------------------------------
General recommendations:
  Add skip-innodb to MySQL configuration to disable InnoDB
  Reduce your overall MySQL memory footprint for system stability
  When making adjustments, make tmp_table_size/max_heap_table_size equal
  Reduce your SELECT DISTINCT queries without LIMIT clauses
Variables to adjust:
  tmp_table_size (> 128M)
  max_heap_table_size (> 64M)

Yet

$ mysql -uroot -Bse "SHOW TABLE STATUS FROM osr_production" | awk '{print $2,$7,$10}'
InnoDB 1589248 0
InnoDB 16384 0
InnoDB 16384 0
InnoDB 49152 0
InnoDB 7864320 0
InnoDB 2637824 0
InnoDB 16384 0
InnoDB 16384 0
InnoDB 16384 0
InnoDB 16384 0
InnoDB 16384 0
InnoDB 32768 0
InnoDB 16384 0
InnoDB 294912 0
InnoDB 16384 0
InnoDB 18366464 0

Can you help? Running Ubuntu 8.04 or 8.10.
mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (x86_64) using readline 5.2

@jgarber

Ah, I needed to run it with a username and password. The root account didn't have a password, so I had to make one. Sorry! Thanks.

@jgarber

Trying to close...

@jgarber

This ticket won't close. A little help here...?

@major
Owner

I've got it. ;-)

@ryanjbonnell

I had the same problem. For posterity, here's the command that worked for me:

$ sudo mysqltuner.pl --user root --pass

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.