content_image/849981.jpg content_image/849985.jpg
<img src='content_image/849981.jpg'>

This variable indicates the number of digits by which to increase the scale of the result of division operations performed with the /  operator. The default value is 4. The minimum and maximum values are 0 and 30, respectively. The following example illustrates the effect of increasing the default value. 

mysql> SELECT 1/7; +--------+ | 1/7 | +--------+ | 0.1429 | +--------+ mysql> SET div_precision_increment = 12; mysql> SELECT 1/7; +----------------+ | 1/7 | +----------------+ | 0.142857142857 | +----------------+ 

## • dragnet.log_error_filter_rules 

<img src='content_image/849985.jpg'>

The filter rules that control operation of the log_filter_dragnet  error log filter component. If log_filter_dragnet  is not installed, dragnet.log_error_filter_rules is unavailable. If log_filter_dragnet  is installed but not enabled, changes to dragnet.log_error_filter_rules  have no effect. 

The effect of the default value is similar to the filtering performed by the log_sink_internal  filter with a setting of log_error_verbosity=2 . 

As of MySQL 8.0.12, the dragnet.Status  status variable can be consulted to determine the result of the most recent assignment to dragnet.log_error_filter_rules . 

Prior to MySQL 8.0.12, successful assignments to dragnet.log_error_filter_rules  at runtime produce a note confirming the new value: 

mysql> SET GLOBAL dragnet.log_error_filter_rules = ’IF prio <> 0 THEN unset prio.’; Query OK, 0 rows affected, 1 warning (0.00 sec) 

mysql> SHOW WARNINGS\G *************************** 1. row *************************** Level: Note Code: 4569 Message: filter configuration accepted: SET @@GLOBAL.dragnet.log_error_filter_rules= 

