MySQL Query Rules

Here is the statement used to create the mysql_query_rules table:

創(chuàng)新互聯(lián)公司服務(wù)項目包括睢寧縣網(wǎng)站建設(shè)、睢寧縣網(wǎng)站制作、睢寧縣網(wǎng)頁制作以及睢寧縣網(wǎng)絡(luò)營銷策劃等。多年來，我們專注于互聯(lián)網(wǎng)行業(yè)，利用自身積累的技術(shù)優(yōu)勢、行業(yè)經(jīng)驗、深度合作伙伴關(guān)系等，向廣大中小型企業(yè)、政府機構(gòu)等提供互聯(lián)網(wǎng)行業(yè)的解決方案，睢寧縣網(wǎng)站推廣取得了明顯的社會效益與經(jīng)濟效益。目前，我們服務(wù)的客戶以成都為中心已經(jīng)輻射到睢寧縣省份的部分城市，未來相信會繼續(xù)擴大服務(wù)區(qū)域并繼續(xù)獲得客戶的支持與信任！

• rule_id - the unique id of the rule. Rules are processed in rule_id order  唯一的規(guī)則id編號，規(guī)則按照rule_id的順序執(zhí)行的
• active - only rules with active=1 will be considered by the query processing module active=1 的時候，查詢模塊才會考慮這一條規(guī)則
• username - filtering criteria 準(zhǔn)確的 matching username. If is non-NULL, a query will match only if the connection is made with the correct username username 用來匹配精確的用戶名，如果它是一個非空的值，查詢將會只匹配從這個username發(fā)起的查詢
• schemaname - filtering criteria matching schemaname. If is non-NULL, a query will match only if the connection uses schemaname as default schema 用來指定連接進來匹配的shcemaname
• flagIN, flagOUT, apply - these allow us to create "chains of rules" that get applied one after the other. An input flag value is set to 0, and only rules with flagIN=0 are considered at the beginning. When a matching rule is found for a specific query, flagOUT is evaluated and if NOT NULL the query will be flagged with the specified flag in flagOUT. If flagOUT differs from flagIN , the query will exit the current chain and enters a new chain of rules having flagIN as the new input flag. If flagOUT matches flagIN, the query will be re-evaluate again against the first rule with said flagIN. This happens until there are no more matching rules, or apply is set to 1 (which means this is the last rule to be applied) 這三個是重要的配置。它們是用來創(chuàng)建各個規(guī)則之間的規(guī)則鏈的，也就是用來進行連接多個規(guī)則的。如果一條規(guī)則中定義的輸入標(biāo)識符為0，那么只有包含輸入標(biāo)識符為0 的規(guī)則才會在一開始就應(yīng)用這條規(guī)則。當(dāng)被匹配到的規(guī)則被發(fā)現(xiàn)是一個特定的查詢，在輸出標(biāo)識符是非空的情況下，這個查詢會被打上對應(yīng)的輸出標(biāo)識符。如果輸出標(biāo)識符和輸入標(biāo)識符不一致，查詢將離開當(dāng)前的規(guī)則鏈并且進入到下一個規(guī)則中（這個規(guī)則的輸入標(biāo)識符和前面的輸出標(biāo)識符一致），它將會成為下一條規(guī)則的輸入標(biāo)識符。如果輸出標(biāo)識符和輸入標(biāo)識符一致，查詢將會回到前面標(biāo)記有同樣標(biāo)識符的規(guī)則中。這種情形會循環(huán)發(fā)生，直到?jīng)]有更多的匹配規(guī)則，如果apply被設(shè)置為1，就意味著這是規(guī)則鏈中的最后一條規(guī)則，規(guī)則將在這里被終止。
• client_addr - match traffic from a specific source 匹配發(fā)起查詢的應(yīng)用的IP
• proxy_addr - match incoming traffic on a specific local IP 匹配查詢指定的本地的proxysql的IP
• proxy_port - match incoming traffic on a specific local port 指定本地proxysql的查詢端口
• digest - match queries with a specific digest, as returned bystats_mysql_query_digest.digest 匹配查詢指定的摘要，可以在stats_mysql_query_digest.diges列中查到，不指定的化會被自動分配一個
• match_digest - regular expression that matches the query digest. See also mysql-query_processor_regex 匹配查詢摘要的正則表達式 類型有兩種 PCRE 和 RE2  默認是PCRE
• match_pattern - regular expression that matches the query text. See also mysql-query_processor_regex 匹配文本內(nèi)容的正則表達式
• negate_match_pattern - if this is set to 1, only queries not matching the query text will be considered as a match. This acts as a NOT operator in front of the regular expression matching against match_pattern or match_digest 如果這個參數(shù)被設(shè)置為1，只有沒有被匹配到的查詢規(guī)則的查詢會被執(zhí)行。它是一個正則相反的操作，和match_pattern or match_digest兩個參數(shù)相對應(yīng)。
• re_modifiers - comma separated list of options to modify the behavior of the RE engine. WithCASELESS the match is case insensitive. With GLOBAL the replace is global (replaces all matches and not just the first). For backward compatibility, only CASELESS is the enabled by default. See also mysql-query_processor_regex for more details.逗號隔開的列表選項來用來修改正則引擎的操作。caseless 選項表明不進行遞歸，只能夠匹配到查詢中的第一個匹配到的字符串。global選項下，也就是全局選項下，能夠替換到查詢語句中所有的陪匹配到的文本。為了向后兼容，默認設(shè)置的是 caseless.
• replace_pattern - this is the pattern with which to replace the matched pattern. It's done using RE2::Replace, so it's worth taking a look at the online documentation for that:https://github.com/google/re2/blob/master/re2/re2.h#L378. Note that this is optional, and when this is missing, the query processor will only cache, route, or set other parameters without rewriting. 被替換成為的字符。根據(jù)規(guī)則，將被匹配到的內(nèi)容替換成為這個參數(shù)下面的內(nèi)容。這是一個可選項目，如果沒有值，查詢過程將被緩存、路由或者設(shè)置為其他沒有重寫的參數(shù)，就是不進行任何的替換。
• destination_hostgroup - route matched queries to this hostgroup. This happens unless there is a started transaction and the logged in user has the transaction_persistent flag set to 1 (seemysql_users table). 指定目的組的編號，只有在起了事務(wù)和登錄的用戶ransaction_persistent flag被設(shè)置為1 的時候才生效。ransaction_persistent flag 默認就是被設(shè)置為1
• cache_ttl - the number of milliseconds for which to cache the result of the query. Note: in ProxySQL 1.1 cache_ttl was in seconds 緩沖查詢結(jié)果的毫秒數(shù) proxysql是按秒為單位的
• reconnect - feature not used 現(xiàn)在還沒有使用 
• timeout - the maximum timeout in milliseconds with which the matched or rewritten query should be executed. If a query run for longer than the specific threshold, the query is automatically killed. If timeout is not specified, global variable mysql-default_query_timeoutapplies 匹配或者重定向能夠占用的最大的超時時間。如果一個查詢執(zhí)行了超過設(shè)置閾值的大小，它會被自動kill。如果時間沒有被設(shè)置，會默認使用mysql-default_query_timeout；默認10個小時  mysql-default_query_timeout            | 36000000
• retries - the maximum number of times a query needs to be re-executed in case of detected failure during the execution of the query. If retries is not specified, global variable mysql-query_retries_on_failure applies 當(dāng)一個查詢失敗后，它重新去執(zhí)行的最大次數(shù)。如果沒有設(shè)置，默認是 1 | mysql-query_retries_on_failure | 1              |
• delay - number of milliseconds to delay the execution of the query. This is essentially 基本上 a throttling 壓制 mechanism and QoS, allowing to give priority to some queries instead of others. This value is added to the mysql-default_query_delay global variable that applies to all queries. Future version of ProxySQL will provide a more advanced throttling mechanism.延遲執(zhí)行查詢的毫秒數(shù)。這是一個限制機制，用來提高某些查詢的優(yōu)先級別。默認是0，以后的版本會更高級的延遲機制。
• mirror_flagOUT and mirror_hostgroup - setting related to mirroring .  沒查到這個，沒文檔
• error_msg - query will be blocked, and the specified error_msg will be returned to the client 查詢被阻斷后，返回給客戶端的錯誤信息
• sticky_conn - not implemented yet 未使用
• multiplex - If 0, multiplex will be disabled. If 1, multiplex could be re-enabled if there are is not any other conditions preventing this (like user variables or transactions). Default is NULL, thus not modifying multiplexing policies 如果是0 會禁止多路復(fù)用，如果是1，會使用多路復(fù)用（當(dāng)其他的條件和多路復(fù)用沒有沖突的時候，比如用戶變量或者事務(wù)）。
• log - query will be logged  是否寫入日志
• comment - free form text field, usable for a descriptive comment of the query rule 對規(guī)則的語言描述，說明它的功能

名稱欄目：proxysqlmysql_query_rules翻譯
地址分享：http://jinyejixie.com/article38/pgegsp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供電子商務(wù)、Google、網(wǎng)站建設(shè)、App設(shè)計、外貿(mào)建站、企業(yè)網(wǎng)站制作

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)