We have moved our server from old 8 GB RAM Server to new 16 GB RAM server so that we could have better performance.
The server is still consuming lot of MEMORY.
The tables in the database are not designed for InnoDB. The DB physical file size is approximately 2.8 GB.
my.cnf parameters are :
[client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock skip-locking #skip-bdb#niraj skip-external-locking key_buffer = 128M max_length_for_sort_data = 1024 max_tmp_tables = 32M table_cache = 64 max_allowed_packet = 128M sort_buffer_size = 32M read_buffer_size = 10M join_buffer_size = 256M read_rnd_buffer_size = 64M myisam_sort_buffer_size = 256M thread_cache_size = 64 query_cache_size = 256M thread_concurrency = 8 max_connect_errors = 100 log-bin=mysql-bin server-id = 1 set-variable = max_connections = 10000 set-variable = connect_timeout = 280 set-variable = interactive_timeout = 280 set-variable = net_read_timeout = 300 innodb_buffer_pool_size = 3G innodb_additional_mem_pool_size = 32M innodb_log_file_size = 768M innodb_log_buffer_size = 16M #innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 64M [mysql] no-auto-rehash [isamchk] key_buffer = 64M sort_buffer_size = 256k read_buffer = 256k write_buffer = 256k [myisamchk] key_buffer = 64M sort_buffer_size = 256M read_buffer = 256k write_buffer = 256k [mysqlhotcopy] interactive-timeout
Please any one can validate my.cnf and suggest why taking much memory.