content_image/661830.jpg content_image/661831.jpg
’IF prio!=ERROR THEN unset prio.’; 

The value displayed by SHOW WARNINGS  indicates the “decompiled”  canonical representation after the rule set has been successfully parsed and compiled into internal form. Semantically, this canonical form is identical to the value assigned to dragnet.log_error_filter_rules , but there may be some differences between the assigned and canonical values, as illustrated by the preceding example: 

•The <>  operator is changed to != . 

•The numeric priority of 0 is changed to the corresponding priority symbol ERROR . 

•Optional spaces are removed. 

For additional information, see Section 5.4.2.4, “Types of Error Log Filtering” , and Section 5.5.3, “Error Log Components” . 

• end_markers_in_json 

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

Whether optimizer JSON output should add end markers. See MySQL Internals: The end_markers_in_json System Variable. 

• eq_range_index_dive_limit 

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

This variable indicates the number of equality ranges in an equality comparison condition when the optimizer should switch from using index dives to index statistics in estimating the number of qualifying rows. It applies to evaluation of expressions that have either of these equivalent forms, where the optimizer uses a nonunique index to look up col_name  values: 

col_name  IN( val1 , ..., valN ) col_name  = val1  OR ... OR col_name  = valN 

In both cases, the expression contains N  equality ranges. The optimizer can make row estimates using index dives or index statistics. If eq_range_index_dive_limit  is greater than 0, the optimizer 

