[MCOL-1687] batch update too slow Created: 2018-08-31  Updated: 2019-07-10  Resolved: 2019-07-10

Status: Closed
Project: MariaDB ColumnStore
Component/s: DMLProc
Affects Version/s: 1.1.6
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: blank Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Environment:

centos 6.8

Attachments: File batch_update.sql    
Issue Links:
Blocks
blocks MCOL-1686 batch update too slow Closed

 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.
Generated at Thu Feb 08 02:30:37 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.