Not the answer you need?
Register and ask your own question!

Why these variables do not work from cnf configuration file?

webtrendwebtrend EntrantCurrent User Role Novice
I am trying to set these variables by entering them in mysqld.cnf file on my percona cluster machines but they don't work. Mysql daemon errors out if I have the following parameters in the file. The only way to implement them is through SET GLOBAL directive on a dynamic basis.
According to the PMM manual, I should be able to do it
Can anyone explain, what I might be doing wrong? Is mysqld.cnf correct file for these variables?
log_slow_rate_limit=100
log_slow_rate_type=query
log_slow_verbosity=full
log_slow_admin_statements=on
log_slow_slave_statements=on
slow_query_log_always_write_time=1
slow_query_log_use_global_control=all
userstat=1

Comments

  • PeterPeter Percona CEO Percona Moderator Role

    mysqld.cnf is most likely not correct file for configuration

    The best way is usually to create separate file, such as pmm.cnf and put it to the /etc/mysql/conf.d/ directory

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.