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 innodb settings

Discussion in 'Plesk 10.x for Windows Issues, Fixes, How-To' started by Shaka, Jun 22, 2012.

  1. Shaka

    Shaka New Pleskian

    22
    73%
    Joined:
    May 3, 2005
    Messages:
    23
    Likes Received:
    0
    I want to improve the perfomance of our MySQL databases .
    Every article says that we should adjust some settings in my.ini

    Original settings:

    innodb_flush_log_at_trx_commit=1
    innodb_log_buffer_size=1M
    innodb_buffer_pool_size=16M
    innodb_log_file_size=10M

    intended changes:

    innodb_flush_log_at_trx_commit=2
    innodb_log_buffer_size=4M
    innodb_buffer_pool_size=2GB
    innodb_log_file_size=128M


    But every time we change this settings MySQL stops working and doesnt restart
    What is the problem? what we should do to optimize settings?

    Thanks
     
  2. Shaka

    Shaka New Pleskian

    22
    73%
    Joined:
    May 3, 2005
    Messages:
    23
    Likes Received:
    0
    As asked here is our server info:

    PRODUCT, VERSION, VERSION OF MICROUPDATE, OPERATING SYSTEM, ARCHITECTURE
    Windows 2008 server R2 , plesk 10

    PROBLEM DESCRIPTION...refer to previous post

    STEPS TO REPRODUCE
    Change My.ini as explained previously

    ACTUAL RESULT
    Mysql doesnt work

    EXPECTED RESULT
    Improved MySQL perfomance

    ANY ADDITIONAL INFORMATION
    refer to previous post
     
  3. Shaka

    Shaka New Pleskian

    22
    73%
    Joined:
    May 3, 2005
    Messages:
    23
    Likes Received:
    0
    Nobody? Not even a single answer?
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
    How it is related to Plesk? Looks like it is common MySQL question. Did you try to investigate mysql logs at least?
     
  5. Shaka

    Shaka New Pleskian

    22
    73%
    Joined:
    May 3, 2005
    Messages:
    23
    Likes Received:
    0
    I think It's related with plesk because is plesk that installs 2 instances of MySQL and sets everything to work with the panel

    Besides I could not finddocumentacion on where to find the MySQL logs for the clients

    As you seem to have more knowledge than me , can you help pointing me so I can find these logs?
    Thanks
     
  6. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,547
    Likes Received:
    1,241
    Location:
    Novosibirsk, Russia
Loading...