Windows Server 2012 Sunucu özellikleri:
İşlemci: Quad 3.30 GHz Intel Core i5-2500
Bellek: 7168 MB
Disk: 100 GB SSD
My.ini ayarları aşağıdaki gibidir. İdeal performans alabilmem için ayarlarda optimizasyon önerileriniz nelerdir?
[client] port=3306 [mysql] default-character-set=latin1 [mysqld] port=3306 basedir="C:/Program Files/MySQL/MySQL Server 5.5/" datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/" character-set-server=latin1 default-storage-engine=INNODB sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=100 query_cache_size=0 table_cache=256 tmp_table_size=35M thread_cache_size=8 myisam_max_sort_file_size=100G myisam_sort_buffer_size=69M key_buffer_size=55M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K innodb_additional_mem_pool_size=3M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=2M innodb_buffer_pool_size=1024M innodb_log_file_size=54M innodb_thread_concurrency=10
