1、TABLE COUNT
MariaDB [xxxx]> select count
from cdn_domain_province;
----------
| count |
----------
| 829097 |
----------
1 row in set (0.06 sec)
2、TABLE INFO
CREATE TABLE `cdn_domain_province` (
`did` int(11) NOT NULL DEFAULT 0,
`protocol` varchar(6) NOT NULL DEFAULT '',
`province` varchar(32) NOT NULL DEFAULT '',
`isp` varchar(32) NOT NULL DEFAULT '',
`bytes` bigint(20) NOT NULL DEFAULT 0,
`reqs` bigint(20) NOT NULL DEFAULT 0,
`tpr` int(11) NOT NULL DEFAULT 0,
`time` bigint(20) NOT NULL DEFAULT 0,
`channel` tinyint(4) NOT NULL DEFAULT 0 COMMENT ''
) ENGINE=Columnstore DEFAULT CHARSET=utf8 COMMENT='' |
3、QUERY