未加星标

Using the loose_ option prefix in my.cnf

字体大小 | |
[数据库(mysql) 所属分类 数据库(mysql) | 发布者 店小二05 | 时间 2016 | 作者 红领巾 ] 0人收藏点击收藏

Using the loose_ option prefix in my.cnf
In this blog post, I’ll look at how to use the loose_ option prefix in my.cnf in mysql.

mysqld throwserrors at startup and refuses to start up if a non-existent options aredefined in themy.cnf file.

For example:

2016-10-05 15:56:07 23864 [ERROR] /usr/sbin/mysqld: unknownvariable 'bogus_option=1'

The MySQLmanual has a solution: use the loose_ prefix option in my.cnf file.

In the priorexample, if we specify loose_bogus_option=1 in the my.cnf file, instead of bogus_option=1 , mysqld starts successfully and ignores that option.

This is useful in threesituations:

Using Percona Server-specific options in a config file that might be used for MySQL Community instances. Includingoptions from a future version of MySQL. Setting options for plugins before they’re loaded. Use Case1:

We can use this feature to make a my.cnf file that will work on both MySQL Community and Percona Server, but contains options that aren’t implemented in MySQL Community. For example:

slow_query_log=ON long_query_time=0 loose_log_slow_rate_limit = 100

Without the loose_ prefix on log_slow_rate_limit , MySQL Community will throw a fatal error (as log_slow_rate_limit is not implemented in MySQL Community).

Use Case 2:

If you push out the same my.cnf file to multiple versions of MySQL, you can still use features that only exist on newer versions:

loose_super_read_only = ON Use Case 3:

Another use case is installing the Percona audit log plugin. If you specify the audit_log options in my.cnf, and then restart the server before running INSTALL PLUGIN , mysqld will fail. If you use the loose_ prefix, mysqld will start up successfull, and the options will be read when you run INSTALL PLUGIN .

loose_audit_log_file = /audit/audit.log loose_audit_log_rotate_on_size = 1073741824 loose_audit_log_rotations = 5 loose_audit_log_format = JSON

This trick also works for options given on the command line, e.g. mysqld --loose-bogus-option .

本文数据库(mysql)相关术语:navicat for mysql mysql workbench mysql数据库 mysql 存储过程 mysql安装图解 mysql教程 mysql 管理工具

主题: SQLMySQL
分页:12
转载请注明
本文标题:Using the loose_ option prefix in my.cnf
本站链接:http://www.codesec.net/view/482593.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 数据库(mysql) | 评论(0) | 阅读(33)