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

[iyinet]

acemiyim´isimli üyeden 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

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

Bu degerler sorun yaratabilir mi acaba?

myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G

[acemiyim]

7 tane database var myisam olan sanırım bir tane.

açıkcası ben onlara hiç bakmamıştım. 100G değeri otomatik geliyor ve olduğu hakkında en ufak fikrim yok.

Sizce ne yapmalıyım bu iki değeri. Teşekkürler

[acemiyim]

Fikri olan yok mu arkadaşlar.