sql-log mappings
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
"mappings": { "sql-log": { "properties": { "sql_session_id": { "store": true, "type": "string" }, "sql_duration_min": { "store": false, "index": "not_analyzed", "type": "integer" }, "sql_duration_subsec": { "store": true, "index": "analyzed", "type": "integer" }, "hostname": { "store": true, "type": "string" }, "type": { "type": "string", "store": true }, "message": { "type": "string", "index": "not_analyzed", "store": false }, "sql_statement": { "type": "string", "index": "not_analyzed", "store": false }, "sql_loglevel": { "type": "string", "index": "not_analyzed", "store": false }, "sql_duration_sec": { "type": "integer", "store": false }, "host": { "type": "string", "store": true } } } |
Full template and mapping
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 |
{ "order": 0, "template": "web-sql-log-*", "settings": { "index": { "number_of_shards": "12", "routing": { "allocation": { "require": { "box_type": "hot" } } }, "refresh_interval": "5s" } }, "mappings": { "sql-log": { "properties": { "sql_session_id": { "store": true, "type": "string" }, "sql_duration_min": { "store": false, "index": "not_analyzed", "type": "integer" }, "sql_duration_subsec": { "store": true, "index": "analyzed", "type": "integer" }, "hostname": { "store": true, "type": "string" }, "type": { "type": "string", "store": true }, "message": { "type": "string", "index": "not_analyzed", "store": false }, "sql_statement": { "type": "string", "index": "not_analyzed", "store": false }, "sql_loglevel": { "type": "string", "index": "not_analyzed", "store": false }, "sql_duration_sec": { "type": "integer", "store": false }, "host": { "type": "string", "store": true } } } }, "aliases": {} } |
Leave a Reply