change values of innodb_flush_log
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)
-
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 -
mysql takes alot of %cpu how do we optimize mysql 0 -
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 -
[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.
Comments
4 comments