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

I would like to configure MYSQL for best performance

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

  1. igoldman

    igoldman Regular Pleskian

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

    I would like to know how to configure MYSQL to work in better performance ?
    which value did you type in the my.ini configure file ?
     
  2. Mr.Incredible

    Mr.Incredible Guest

    0
     
    SWsoft has configured MySQL for Plesk capability, so I don't think you have to reconfigure it :)
     
  3. igoldman

    igoldman Regular Pleskian

    26
    23%
    Joined:
    Sep 14, 2004
    Messages:
    212
    Likes Received:
    0
    I am not talking about the MYSQL which serv Plesk Control Panel.
    I am talking about the MYSQL for clients databases
     
  4. vekna

    vekna Guest

    0
     
    Very strange question... You have a many little databases or one HUGE database or something other... every variant have a different settings... but default MySQL configured to separate variant.
     
  5. igoldman

    igoldman Regular Pleskian

    26
    23%
    Joined:
    Sep 14, 2004
    Messages:
    212
    Likes Received:
    0
    you probably didn't understand my question.

    I will give example about which MYSQL I am talking about.
    lets say that customer ordered from me web hosting package.
    this customer have the abilitly to open through Plesk Control Panel MYSQL databases.

    what I would like to do ?
    I would like to configure MYSQL to work faster and stop to crush !!!
    because I have some customer that use MYSQL databases and their web sites are very big and make use of MYSQL.

    now , there is a file , which called my.ini
    thats file located in:
    C:\Program Files\SWsoft\Plesk\Databases\MySQL\Data

    the current configuration is :

    [MySQLD]
    port=3306
    basedir=C:\\Program Files\\SWsoft\\Plesk\\Databases\\MySQL
    datadir=D:\\mysqldata
    default-character-set=latin1
    default-storage-engine=INNODB
    query_cache_size=8M
    table_cache=32
    tmp_table_size=7M
    thread_cache=32
    myisam_max_sort_file_size=100G
    myisam_max_extra_sort_file_size=100G
    myisam_sort_buffer_size=2M
    key_buffer_size=2M
    read_buffer_size=1M
    read_rnd_buffer_size=256K
    sort_buffer_size=256K
    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=300
    key_buffer=4M
    max_allowed_packet=1M
    sort_buffer=256K
    net_buffer_length=4K
    old_passwords=1
    [client]
    port=3306


    I would like to know which value I need to change that the MYSQL will stop to crush. it's defently because MYSQL not configured correctly. I have alots of RAM in my server , 2 GB
    where do I config that MYSQL will be able to use more RAM ?
    what about cache memory ?
    and so on , what do you suggest me ?
     
Loading...