1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

my.ini configuration on windows 2003 server

Discussion in 'Plesk for Windows - 8.x and Older' started by igoldman, Aug 20, 2005.

  1. igoldman

    igoldman Regular Pleskian

    26
    23%
    Joined:
    Sep 14, 2004
    Messages:
    212
    Likes Received:
    0
    Hello,

    I have setup the my.ini file configuration for mysql and I would like to know if the current settings are good or you recommend me to change something.
    My server specification is:
    Pentium 4 3000 MHZ socket 775
    2 GB of memory (DDR 400 mhz)

    start of my.ini
    ---------------------------------------
    [MySQLD]
    port=3306
    basedir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL
    datadir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL\\Data
    default-character-set=latin1
    default-storage-engine=INNODB
    query_cache_size = 512M
    query_cache_type = 1
    query_prealloc_size = 16384
    query_alloc_block_size = 16384
    table_cache = 1500
    tmp_table_size = 128M
    thread_cache_size = 128
    myisam_max_sort_file_size=100G
    myisam_max_extra_sort_file_size=100G
    myisam_sort_buffer_size=64M
    key_buffer_size=2M
    read_buffer_size=1M
    read_rnd_buffer_size = 524288
    sort_buffer_size = 2M
    innodb_additional_mem_pool_size=2M
    innodb_flush_log_at_trx_commit=1
    innodb_log_buffer_size=1M
    innodb_buffer_pool_size=16M
    innodb_log_file_size=10M
    innodb_thread_concurrency=8
    max_connections=650
    key_buffer=96M
    max_allowed_packet = 16M
    sort_buffer=256K
    net_buffer_length=4K
    old_passwords=1
    join_buffer_size = 1M
    wait_timeout = 900
    connect_timeout = 10
    max_connect_errors = 10
    bulk_insert_buffer_size = 8M
    [client]
    port=3306
    -------------------------
    end of my.ini
     
  2. igoldman

    igoldman Regular Pleskian

    26
    23%
    Joined:
    Sep 14, 2004
    Messages:
    212
    Likes Received:
    0
Loading...