• 24-10-2010, 00:50:59
    #1
    benim my.ini bu java oyun var mysql ile çalışan online sayısı fazla iken bazen patlıyor makine özelliklerine göre bunu ayarlayabilirmisiniz rica etsem.

    AMD Quad Core 9650
    4 GB Ram
    500 gb disk

    [MySQLD]
    port=3306
    basedir=C:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL
    datadir=C:\\Program Files\\Parallels\\Plesk\\Databases\\MySQL\\Data
    default-character-set=latin1
    default-storage-engine=INNODB
    read_buffer_size=5M
    read_rnd_buffer_size=512K
    sort_buffer_size=512K
    innodb_additional_mem_pool_size=2M
    innodb_flush_log_at_trx_commit=1
    innodb_log_buffer_size=1M
    innodb_buffer_pool_size=160M
    innodb_log_file_size=10M
    innodb_thread_concurrency=8
    max_connections=400000
    old_passwords=1
    max_user_connections=300000
    thread_cache_size=4
    thread_stack=196608
    binlog_cache_size=32768
    net_read_timeout=30
    net_retry_count=10
    net_write_timeout=30
    thread_concurrency=10
    open_files_limit=0
    [client]
    port=3306
  • 28-10-2010, 20:20:50
    #2
    yokmu bilen ?