xingrui/docker/mysql/data/performance_schema/accounts_186.SDI

{
    "sdi_version": 1,
    "dd_version": 1,
    "dd_object_type": "Table",
    "dd_object": {
        "name": "accounts",
        "mysql_version_id": 80000,
        "created": 20170330100056,
        "last_altered": 20170330100056,
        "options": "avg_row_length=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;",
        "columns": [
            {
                "name": "USER",
                "type": 29,
                "is_nullable": true,
                "is_zerofill": false,
                "is_unsigned": false,
                "is_auto_increment": false,
                "is_virtual": false,
                "hidden": false,
                "ordinal_position": 1,
                "char_length": 96,
                "numeric_precision": 0,
                "numeric_scale": 0,
                "datetime_precision": 0,
                "has_no_default": false,
                "default_value_null": true,
                "default_value": "",
                "default_option": "",
                "update_option": "",
                "comment": "",
                "generation_expression": "",
                "generation_expression_utf8": "",
                "options": "interval_count=0;",
                "se_private_data": "",
                "column_key": 4,
                "column_type_utf8": "char(32)",
                "elements": [],
                "collation_id": 83
            },
            {
                "name": "HOST",
                "type": 29,
                "is_nullable": true,
                "is_zerofill": false,
                "is_unsigned": false,
                "is_auto_increment": false,
                "is_virtual": false,
                "hidden": false,
                "ordinal_position": 2,
                "char_length": 180,
                "numeric_precision": 0,
                "numeric_scale": 0,
                "datetime_precision": 0,
                "has_no_default": false,
                "default_value_null": true,
                "default_value": "",
                "default_option": "",
                "update_option": "",
                "comment": "",
                "generation_expression": "",
                "generation_expression_utf8": "",
                "options": "interval_count=0;",
                "se_private_data": "",
                "column_key": 1,
                "column_type_utf8": "char(60)",
                "elements": [],
                "collation_id": 83
            },
            {
                "name": "CURRENT_CONNECTIONS",
                "type": 9,
                "is_nullable": false,
                "is_zerofill": false,
                "is_unsigned": false,
                "is_auto_increment": false,
                "is_virtual": false,
                "hidden": false,
                "ordinal_position": 3,
                "char_length": 20,
                "numeric_precision": 19,
                "numeric_scale": 0,
                "datetime_precision": 0,
                "has_no_default": true,
                "default_value_null": false,
                "default_value": "AAAAAAAAAAA=",
                "default_option": "",
                "update_option": "",
                "comment": "",
                "generation_expression": "",
                "generation_expression_utf8": "",
                "options": "interval_count=0;",
                "se_private_data": "",
                "column_key": 1,
                "column_type_utf8": "bigint(20)",
                "elements": [],
                "collation_id": 33
            },
            {
                "name": "TOTAL_CONNECTIONS",
                "type": 9,
                "is_nullable": false,
                "is_zerofill": false,
                "is_unsigned": false,
                "is_auto_increment": false,
                "is_virtual": false,
                "hidden": false,
                "ordinal_position": 4,
                "char_length": 20,
                "numeric_precision": 19,
                "numeric_scale": 0,
                "datetime_precision": 0,
                "has_no_default": true,
                "default_value_null": false,
                "default_value": "AAAAAAAAAAA=",
                "default_option": "",
                "update_option": "",
                "comment": "",
                "generation_expression": "",
                "generation_expression_utf8": "",
                "options": "interval_count=0;",
                "se_private_data": "",
                "column_key": 1,
                "column_type_utf8": "bigint(20)",
                "elements": [],
                "collation_id": 33
            }
        ],
        "schema_ref": "performance_schema",
        "hidden": false,
        "se_private_id": 18446744073709551615,
        "engine": "PERFORMANCE_SCHEMA",
        "comment": "",
        "se_private_data": "",
        "row_format": 1,
        "partition_type": 0,
        "partition_expression": "",
        "default_partitioning": 0,
        "subpartition_type": 0,
        "subpartition_expression": "",
        "default_subpartitioning": 0,
        "indexes": [
            {
                "name": "ACCOUNT",
                "hidden": false,
                "is_generated": false,
                "ordinal_position": 1,
                "comment": "",
                "options": "flags=2;",
                "se_private_data": "",
                "type": 2,
                "algorithm": 4,
                "is_algorithm_explicit": false,
                "is_visible": true,
                "engine": "PERFORMANCE_SCHEMA",
                "elements": [
                    {
                        "ordinal_position": 1,
                        "length": 96,
                        "order": 1,
                        "column_opx": 0
                    },
                    {
                        "ordinal_position": 2,
                        "length": 180,
                        "order": 1,
                        "column_opx": 1
                    }
                ]
            }
        ],
        "foreign_keys": [],
        "partitions": [],
        "collation_id": 33
    }
}