senwar

Registered
Sep 5, 2013
3
0
1
cPanel Access Level
DataCenter Provider
hello!!

Why can help me?!!

mysqltunnel :
Code:
>>  MySQLTuner 1.2.0 - Major Hayden <[email protected]>
 >>  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 :
Code:
[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.

Well-Known Member
Feb 25, 2010
1,834
23
143
Houston, TX
cPanel Access Level
Root Administrator
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.
 

JaredR.

Well-Known Member
Feb 25, 2010
1,834
23
143
Houston, TX
cPanel Access Level
Root Administrator
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".