Mysql 内存占用过高 有没有办法优化

htop

my.cnf

[client] #password = your_password port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 socket = /tmp/mysql.sock datadir = /data/mysql/var skip-external-locking key_buffer_size = 256M max_allowed_packet = 40M #默认为 1M （ 2016-09-20 09:59 ） table_open_cache = 1024 sort_buffer_size = 4M net_buffer_length = 8K read_buffer_size = 4M read_rnd_buffer_size = 512K myisam_sort_buffer_size = 64M thread_cache_size = 128 query_cache_size = 128M tmp_table_size = 128M #skip-networking max_cOnnections= 500 max_connect_errors = 100 open_files_limit = 65535 log-bin=mysql-bin binlog_format=mixed server-id = 1 expire_logs_days = 10 default_storage_engine = InnoDB innodb_data_home_dir = /data/mysql/var innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /data/mysql/var innodb_buffer_pool_size = 1024M innodb_additional_mem_pool_size = 2M innodb_log_file_size = 256M innodb_log_buffer_size = 8M innodb_flush_log_at_trx_commit = 1 innodb_lock_wait_timeout = 50 [mysqldump] quick max_allowed_packet = 25M [mysql] no-auto-rehash [myisamchk] key_buffer_size = 256M sort_buffer_size = 4M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout