change values of innodb_flush_log

[mojamoi]

How do I change values for 'innodb_flush_log_at_trx_commit' to 2.

mysql> SHOW VARIABLES LIKE 'innodb_flush_log_at_trx_commit';
+--------------------------------+-------+
| Variable_name | Value |
+--------------------------------+-------+
| innodb_flush_log_at_trx_commit | 1 |
+--------------------------------+-------+
1 row in set (0.00 sec)

 

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

 

[mojamoi]

mysql takes alot of %cpu

how do we optimize mysql

 

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

 

[cPanelMichael]

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.