>> MySQLTuner 1.2.0_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

-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.96-community-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: 3G (Tables: 1218)
[--] Data in InnoDB tables: 47M (Tables: 27)
[!] Total fragmented tables: 15

-------- Performance Metrics -------------------------------------------------
[--] Up for: 12m 35s (35K q [46.934 qps], 3K conn, TX: 1B, RX: 7M)
[--] Reads / Writes: 76% / 24%
[--] Total buffers: 2.1G global + 2.7M per thread (3000 max threads)
[!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!] Maximum possible memory usage: 9.9G (125% of installed RAM)
[OK] Slow queries: 0% (328/35K)
[OK] Highest usage of available connections: 6% (200/3000)
[OK] Key buffer size / total MyISAM indexes: 8.0M/1.4G
[OK] Key buffer hit rate: 98.5% (8M cached / 131K reads)
[OK] Query cache efficiency: 37.7% (9K cached / 24K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 3% (185 temp sorts / 4K sorts)
[!] Joins performed without indexes: 895
[!] Temporary tables created on disk: 29% (1K on disk / 5K total)
[OK] Thread cache hit rate: 93% (200 created / 3K connections)
[!] Table cache hit rate: 3% (782 open / 20K opened)
[OK] Open file limit used: 3% (589/15K)
[OK] Table locks acquired immediately: 99% (48K immediate / 48K locks)
[OK] InnoDB data size / buffer pool: 47.0M/2.0G

-------- Recommendations -----------------------------------------------------
General recommendations:
  Run OPTIMIZE TABLE to defragment tables for better performance
  MySQL started within last 24 hours - recommendations may be inaccurate
  Adjust your join queries to always utilize indexes
  When making adjustments, make tmp_table_size/max_heap_table_size equal
  Reduce your SELECT DISTINCT queries without LIMIT clauses
  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 ***
  join_buffer_size (> 128.0K, or always use indexes with joins)
  tmp_table_size (> 32M)
  max_heap_table_size (> 16M)
  table_cache (> 64)

[mysqld]
#bind-address=127.0.0.1
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql


innodb_buffer_pool_size=2G
innodb_additional_mem_pool_size=20M


query_cache_limit=1M
query_cache_size=32M
query_cache_type=1
max_connections=3000
max_user_connections=600
interactive_timeout=100
wait_timeout=100
connect_timeout=20
thread_cache_size=128


log-bin=/var/log/mysql/bin.log
#log-bin-index=/var/log/mysql/log-bin.index
log-bin-index = /var/log/mysql/log-bin.index
log-error=/var/log/mysql/error.log
relay-log=/var/log/mysql/relay.log
relay-log-info-file=/var/log/mysql/relay-log.info
relay-log-index=/var/log/mysql/relay-log.index
binlog-do-db=rakista_radio
log_slow_queries = /var/log/mysql/mysql-slow.log




[mysqld_safe]
#log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
key_buffer=256M
# 64M for 1GB, 128M for 2GB, 256 for 4GB

join_buffer_size=4M
# 1M for 1GB, 2M for 2GB, 4M for 4GB

max_allowed_packet=32M
table_cache=1024
sort_buffer_size=4M
# 1M for 1GB, 2M for 2GB, 4M for 4GB

read_buffer_size=4M
# 1M for 1GB, 2M for 2GB, 4Mfor 4GB

read_rnd_buffer_size=3072K
# 768K for 1GB, 1536K for 2GB, 3072Kfor 4GB

max_connect_errors=10
thread_concurrency=4
myisam_sort_buffer_size=128M
# 32M for 1GB, 64M for 2GB, 128 for 4GB

skip-locking
server-id=1

[safe_mysqld]
open_files_limit=8192

[isamchk]
key_buffer=256M
# 64M for 1GB, 128M for 2GB, 256M for 4GB

sort_buffer=256M
# 64M for 1GB, 128M for 2GB, 256M for 4GB

read_buffer=64M
# 16M for 1GB, 32M for 2GB, 64M for 4GB

write_buffer=64M
# 16M for 1GB, 32M for 2GB,64M for 4GB

[myisamchk]
key_buffer=256M
# 64M for 1GB, 128M for 2GB, 256M for 4GB

sort_buffer=256M
# 64M for 1GB, 128M for 2GB, 256M for 4GB

read_buffer=64M
# 16M for 1GB, 32M for 2GB, 64M for 4GB

write_buffer=64M
# 16M for 1GB, 32M for 2GB, 64M for 4GB