Alıntı:
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
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
|
Bu degerler sorun yaratabilir mi acaba?
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G