chaoyli edited a comment on issue #555: Meaningless saving tablet_meta leads to too many sync URL: https://github.com/apache/incubator-doris/issues/555#issuecomment-455420833 I have deploy an cluster with only one fe node, one be node. Start 20 threads to ingest into Storage Engine in parallel. If opening sync option of RocksDB, create new table will at 10+ second latency. IOPS of disk in stall on write tablet meta into RocksDB. ``` CREATE TABLE `test` ( `k1` tinyint(4) COMMENT "", `k2` smallint(6) COMMENT "", `k3` int(11) COMMENT "", `k4` bigint(20) COMMENT "", `k5` decimal(9, 3) COMMENT "", `k6` char(5) COMMENT "", `k10` date COMMENT "", `k11` datetime COMMENT "", `k7` varchar(20) COMMENT "", `k8` double MAX COMMENT "", `k9` float SUM COMMENT "" ) ENGINE=OLAP AGGREGATE KEY(`k1`, `k2`, `k3`, `k4`, `k5`, `k6`, `k10`, `k11`, `k7`) DISTRIBUTED BY HASH(`k1`) BUCKETS 10 PROPERTIES ( "storage_type" = "COLUMN", "replication_num" = "1" ); ```
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
