-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.5.48-log
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster

[--] Data in MyISAM tables: 1G (Tables: 134)
[--] Data in InnoDB tables: 48K (Tables: 1)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[!!] Total fragmented tables: 48

-------- Security Recommendations  -------------------------------------------
[!!] User '@localhost' has no password set.
[!!] User '@msdb' has no password set.
[!!] User 'root@127.0.0.1' has no password set.
[!!] User 'root@::1' has no password set.
[!!] User 'root@msdb' has no password set.

-------- Performance Metrics -------------------------------------------------
[--] Up for: 97d 11h 32m 17s (430M q [51.149 qps], 59K conn, TX: 348B, RX: 42B)
[--] Reads / Writes: 95% / 5%
[--] Total buffers: 27.2G global + 3.4M per thread (9999 max threads)
[!!] Maximum possible memory usage: 60.1G (191% of installed RAM)
[OK] Slow queries: 0% (181K/430M)
[OK] Highest usage of available connections: 0% (77/9999)
[OK] Key buffer size / total MyISAM indexes: 7.0G/892.2M
[OK] Key buffer hit rate: 96.9% (13B cached / 413M reads)
[!!] Query cache efficiency: 0.2% (5M cached / 3B selects)
[!!] Query cache prunes per day: 122
[OK] Sorts requiring temporary tables: 10% (1K temp sorts / 9K sorts)
[OK] Temporary tables created on disk: 1% (24K on disk / 2M total)
[OK] Thread cache hit rate: 99% (77 created / 59K connections)
[!!] Table cache hit rate: 0% (128 open / 32M opened)
[OK] Open file limit used: 0% (251/49K)
[OK] Table locks acquired immediately: 97% (4B immediate / 4B locks)
[!!] Connections aborted: 22%
[OK] InnoDB data size / buffer pool: 48.0K/20.0G

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Reduce your overall MySQL memory footprint for system stability
    Increase table_cache gradually to avoid file descriptor limits
    Your applications are not closing MySQL connections properly
Variables to adjust:
  *** MySQL's maximum memory usage is dangerously high ***
  *** Add RAM before increasing MySQL buffer variables ***
    query_cache_limit (> 256M, or use smaller result sets)
    query_cache_size (> 128M)
    table_cache (> 128)

============================================================

#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50


#slave settings
#server-id       = 2
#report-host=10.226.58.222
#report-port=3306
#report-user=root
#report-password=KalsymSys@123987_
#slave_skip_errors=1017, 1396, 1205, 1062, 1007, 1064, 1060, 1146,1032, 1051, 1050, 1213, 1146, 1049, 1054, 1236


basedir=/usr/local/mysql
datadir=/mysql/data
tmpdir=/var/tmp
#replicate-do-db=ms
#replicate-do-db=ms_history
#replicate-do-db=nm
#replicate-do-db=nm_history

innodb_file_per_table=1

# SKIP replication Tables
#replicate-ignore-table=mmp.incoming_prov_tab



#log-bin=mysql-bin
relay-log-space-limit=8G

#innodb_data_file_path=/ibdata/ibdata1:10M:autoextend
max_connections=9999
innodb_lock_wait_timeout=300
innodb_buffer_pool_size=20G

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
#here are the new lines
[mysqladmin]
user = root
password = KalsymSys@123987_;
[mysqlhotcopy]
interactive-timeout