[Maria-discuss] How to write streaming data to mariaDB columnStorage efficiently?
16 Oct
2020
16 Oct
'20
1:06 p.m.
I just have a try. CREATE TABLE `robotmetrics2` ( `robotid` varchar(16) DEFAULT NULL, `ts` bigint(20) DEFAULT NULL, `xloc` int(11) DEFAULT NULL, `yloc` int(11) DEFAULT NULL, `velocity` int(11) DEFAULT NULL, `angular_velocity` int(11) DEFAULT NULL ) ENGINE=Columnstore DEFAULT CHARSET=utf8 But when i write data to the table with python connector, the qps is only about 10/s. And the cpu is 60%+. And it takes a lot of disk space. Mainly this file: /var/lib/columnstore/data1/versionbuffer.cdf Does i do something wrong? Thanks, Lei wanglei2@geekplus.com
1493
Age (days ago)
1493
Last active (days ago)
0 comments
1 participants
participants (1)
-
wanglei2@geekplus.com