1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    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...