贴下我服务器的TOP PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 30304 mysql 15 0 11.5g 8.3g 5600 S 84.7 70.7 15738:29 mysqld
查询的数据量大吗?是不是sql语句存在效率问题?
mysql 内存使用分为public and private(session)public:innodb_buffer_pool_size,key_buffer_size private(session):tmp_table_size,sort_buffer_size,join_buffer_size,read_buffer_size etc.
30304 mysql 15 0 11.5g 8.3g 5600 S 84.7 70.7 15738:29 mysqld
private(session):tmp_table_size,sort_buffer_size,join_buffer_size,read_buffer_size etc.