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

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...