Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.1.6
-
None
-
centos 6.8
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
see https://jira.mariadb.org/secure/attachment/46113/batch_update.sql
I need to optimize the above query to work faster.
Attachments
Issue Links
- blocks
-
MCOL-1686 batch update too slow
- Closed