os:windows server2003
mem:8G
mysql版本5.0.22
17:37:48 [ERROR] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
相关参数
max_connections=300
query_cache_size=256M
table_cache=519
tmp_table_size=32M
thread_cache_size=40
key_buffer_size=60M
read_buffer_size = 256K
read_rnd_buffer_size = 512K
sort_buffer_size = 512K
innodb_additional_mem_pool_size=64M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=800M
innodb_log_file_size=24M
innodb_thread_concurrency=10
innodb_lock_wait_timeout=5
wait_timeout=72000
这些参数我已经调的很保守了,现在还报
Forcing close of thread 88
麻烦各位分析分析!
mem:8G
mysql版本5.0.22
17:37:48 [ERROR] Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
相关参数
max_connections=300
query_cache_size=256M
table_cache=519
tmp_table_size=32M
thread_cache_size=40
key_buffer_size=60M
read_buffer_size = 256K
read_rnd_buffer_size = 512K
sort_buffer_size = 512K
innodb_additional_mem_pool_size=64M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=2M
innodb_buffer_pool_size=800M
innodb_log_file_size=24M
innodb_thread_concurrency=10
innodb_lock_wait_timeout=5
wait_timeout=72000
这些参数我已经调的很保守了,现在还报
Forcing close of thread 88
麻烦各位分析分析!
max_connections = 100
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
query_cache_limit = 1M
query_cache_size = 16M
expire_logs_days = 10
max_binlog_size = 100M
跟我这个比,你的配置的确高了许多
selct col1,
select (col1) from table1 as col2,
select (col1) from table2 as col3,
select (col1) from table3 as col4,
select (col1) from table4 as col5,
col5
from
table where 条件
这样的SQL。
max_connections=300
query_cache_size=256M
innodb_buffer_pool_size=800M建议按提示you may have to use 'ulimit' to allow mysqld 先 改 一下试试。想办法先断定,是物理内存不够了,还是达到你自己设置的MYSQL这些参数的上限了。物理内存不够 则要减小你的这些叁数。
而如果是达到参数的上限,则相反,需要加大 这些叁数
[mysqld]
log=query.log
Win2003 boot.ini
[boot loader]
timeout=0
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /usepmtimer /NoExecute=OptIn /PAE试试有无效果
如果实在不能换系统,还有一办法可以把内存用起来,就是安装一个软件把两G以外的内存虚拟成硬盘,把这部分硬盘设置成MySQL的临时目录(tmpdir = J:/mysql/data/tmp/)