Skip to main content

change values of innodb_flush_log

Comments

4 comments

  • cPanelMichael
    Hello :) Add the following line to your /etc/my.cnf file: innodb_flush_log_at_trx_commit=2
    Then, restart MySQL via: service mysql restart
    Thank you.
    0
  • mojamoi
    mysql takes alot of %cpu how do we optimize mysql
    0
  • ndzsupport
    You can use the command " mysqladmin proc stat" to see what all mysql processes causing the load. Might need to optimize / repair that particular table/ database or query level optimization needed. Will need to find the actual problem before start optimizing.
    0
  • cPanelMichael
    [quote="mojamoi, post: 1549291">mysql takes alot of %cpu how do we optimize mysql
    Please open separate threads when the question or subject differs from the original post. You can post to our Optimization forum for assistance with optimizing your MySQL configuration. Thank you.
    0

Please sign in to leave a comment.