- 论坛徽章:
- 0
|
本数据库的只有900MB 没事查询时候就出现如图画面:求解高手解决。谢谢
这是我的MY.NIN配置
[client]
port=3306
[mysql]
default-character-set=gbk
[mysqld]
port=3306
basedir="C:/phpStudy/MySQL/"
datadir="C:/phpStudy/MySQL/data/"
character-set-server=gbk
default-storage-engine=MyISAM
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=1000
query_cache_size=1024M
table_cache=4096
tmp_table_size=4096M
thread_cache_size=32
myisam_max_sort_file_size=64G
myisam_sort_buffer_size=1024M
key_buffer_size=1024M
read_buffer_size=100M
read_rnd_buffer_size=256K
sort_buffer_size=256M
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=8112M
innodb_log_file_size=24M
innodb_thread_concurrency=8
服务器配置 16核 16G内存 250机械硬盘 请问要只能解决这个问题?
|
|