Out of memory

[acemiyim]

080320 18:37:12 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Out of memory (Needed 1676960 bytes)
080320 18:37:12 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Out of memory (Needed 1676960 bytes)
080320 18:37:12 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Out of memory (Needed 1676960 bytes)


Sürekli bu hatayı alıyorum.

Windwos 2 işlemci 8 çekirdek. 4GB ram

Server X.Y\my.ini"

[client]

port=3306

[mysql]

default-character-set=latin1

[mysqld]

port=3306


#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"

#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1

# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=800

query_cache_size=256M

table_cache=1520

tmp_table_size=30M

thread_cache_size=250

myisam_max_sort_file_size=100G

myisam_max_extra_sort_file_size=100G

myisam_sort_buffer_size=30M

key_buffer_size=1024M

read_buffer_size=2M
read_rnd_buffer_size=8M

sort_buffer_size=1M

innodb_additional_mem_pool_size=10M

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=5M

innodb_buffer_pool_size=1024M

innodb_log_file_size=95M

innodb_thread_concurrency=18
query_cache_limit=1M

max_allowed_packet=16M

query_cache_type=1

log-error=hatali_SQL.txt

log-slow-queries=yavas_SQL.txt

long_query_time=2

expire_logs_days=3

[vampire]

şu anki ini dosyanızı restore edip eski halde bir kaç test yapın hata verecekmi hata vermezse serverınızın tam limitlerine değilde biraz daha alt limitlerine göre yeniden bi yapılandırma yapın ayrıca bu limit sorununu hangi işlem sırasında görüyorsunuz bunuda yazarsanız dahada farklı çözümler oluşturabiliriz