mysqltuner output

hello!! Why can help me?!! mysqltunnel :

>>  MySQLTuner 1.2.0 - Major Hayden 
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
Please enter your MySQL administrative login: root
Please enter your MySQL administrative password:

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.96-log
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM

-------- Storage Engine Statistics -------------------------------------------
[--] Status: -Archive +BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 7K (Tables: 17)
[--] Data in InnoDB tables: 385M (Tables: 424)
[!!] BDB is enabled but isn't being used
[!!] Total fragmented tables: 1

-------- Security Recommendations  -------------------------------------------
[OK] All database users have passwords assigned

-------- Performance Metrics -------------------------------------------------
[--] Up for: 4d 20h 26m 36s (202M q [482.762 qps], 11M conn, TX: 334M, RX: 1B)
[--] Reads / Writes: 65% / 35%
[--] Total buffers: 1.6G global + 14.5M per thread (500 max threads)
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 8.6G (145% of installed RAM)
[OK] Slow queries: 0% (7K/202M)
[OK] Highest usage of available connections: 49% (246/500)
[OK] Key buffer size / total MyISAM indexes: 8.0M/90.0K
[OK] Key buffer hit rate: 96.4% (5K cached / 217 reads)
[OK] Query cache efficiency: 23.7% (27M cached / 116M selects)
[OK] Query cache prunes per day: 12
[OK] Sorts requiring temporary tables: 0% (830 temp sorts / 23M sorts)
[OK] Temporary tables created on disk: 0% (1K on disk / 8M total)
[OK] Thread cache hit rate: 99% (4K created / 11M connections)
[!!] Table cache hit rate: 1% (256 open / 25K opened)
[OK] Open file limit used: 0% (1/65K)
[OK] Table locks acquired immediately: 99% (137M immediate / 137M locks)
[OK] InnoDB data size / buffer pool: 385.3M/768.0M

-------- Recommendations -----------------------------------------------------
General recommendations:
    Add skip-bdb to MySQL configuration to disable BDB
    Run OPTIMIZE TABLE to defragment tables for better performance
    Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    table_cache (> 32512)

my.cnf :

[mysqld]
default-storage-engine=innodb
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-slow-queries=/var/lib/mysql/slow.log
user=mysql
#innen
skip-name-resolve
thread_concurrency=4
max_connections = 500
innodb_buffer_pool_size = 768M
#innodb_log_file_size = 128M
innodb_log_buffer_size = 16M
innodb_additional_mem_pool_size = 20M
innodb_flush_method=O_DIRECT
#innodb_data_file_path=ibdata1:50M;ibdata2:50M:autoextend
innodb_flush_log_at_trx_commit = 2
join_buffer_size=10M
read_buffer_size=2M
sort_buffer_size=2M
table_cache=51200
#table_definition_cache = 3000
#table_open_cache = 5000
thread_cache_size=64
thread_stack = 256K
interactive_timeout=20
wait_timeout=15
max_allowed_packet=16M
max_connect_errors=10
query_cache_limit=1M
query_cache_size=765M
query_cache_min_res_unit=756K
query_cache_type=1
flush
flush_time=3600
long_query_time = 10
safe-show-database
collation_server=utf8_unicode_ci
character_set_server=utf8

# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit=8192
[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"

Who can help? :\

JaredR.

September 05, 2013 15:19

Friendly Moderator Note Please do not start multiple threads for the same question or problem. You made four (4) almost identical posts for the same problem within just a few minutes. The posts were moderated, so you could not see them until a moderator approved them. I approved all of them. I then merged them all into this thread, and I deleted the other three posts. The single post that is left in this thread should suffice to describe your problem.

September 05, 2013 15:22

Friendly Moderator Note I also updated the subject of this thread, because I think you really mean mysqltuner, not mysqltunnel, based on the output you pasted that mentions "MySQLTuner 1.2.0".

senwar

September 05, 2013 15:38

Re: Friendly Moderator Note [quote="cPanelJared, post: 1457002">I also updated the subject of this thread, because I think you really mean mysqltuner, not mysqltunnel, based on the output you pasted that mentions "MySQLTuner 1.2.0".
Thanks for edit this post

September 06, 2013 20:07

Someone can help for me?

mysqltuner output

Comments

Didn't find what you were looking for?