Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
None
-
None
Description
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
Attachments
Issue Links
- is blocked by
-
MCOL-1687 batch update too slow
- Closed