maria-discuss team mailing list archive

["wanglei2@xxxxxxxxxxxx" <wanglei2@xxxxxxxxxxxx>]

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@xxxxxxxxxxxx