{"template": "mysql-slow-log-*", "settings": {"index": {"refresh_interval": "5s"}},"mappings" : {"my
{"template": "mysql-slow-log-*", "settings": {"index": {"refresh_interval": "5s"}},"mappings" : {"mysql-slow-log" : {"numeric_detection":true, #开启数值类型设置"properties" : {"@timestamp" : {"type" : "date","format" : "strict_date_optional_time||epoch_millis"},"@version" : {"type" : "string"},"Query_time" : {"type" : "double" #修改字段类型为double},"Row_sent" : {"type" : "string"},"Rows_examined" : {"type" : "string"},"clientip" : {"type" : "string"},"envCode" : {"type" : "string"},"host" : {"type" : "string"},"id" : {"type" : "string"},"lock_time" : {"type" : "string"},"message" : {"type" : "string"},"mysqlType": {"type": "string","norms": {"enabled": false},"fielddata": {"format": "disabled"},"fields": {"raw": {"type": "string","index": "not_analyzed","ignore_above": 256}}},"nsCode" : {"type" : "string"},"path" : {"type" : "string"},"sql": {"type": "string","index": "not_analyzed" #默认不分词},"tags" : {"type" : "string"},"timestamp" : {"type" : "string"},"type" : {"type" : "string"},"user" : {"type" : "string"}}}}}
