Out of memory

acemiyim' Alıntı:

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

Kod:

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

Genişletmek için tıkla ...