Eric Lam
Eric Lam
fast sql CPU profile Recall: 0.8260, Total Duration: 6.0623s, Avg Latency: 0.0121, QPS: 82.6419
heap profile for slow test
Same plan but different running time ( 143ms vs 12ms) SQL: SELECT `__mo_index_pri_col`, `__mo_index_centroid_fk_entry` FROM `a`.`__mo_index_secondary_0195f094-f18e-7a0a-9a81-dca5bff76b21` WHERE `__mo_index_centroid_fk_version` = 0 AND `__mo_index_centroid_fk_id` IN (2517,2478,2230,128,936,2225,1979,1506,723,2782,2117,2780,64,1252,1510,1980,747,2789,1227,2489,2992,980,2070,1819,2595)
it is about cache. After reboot, run explain analyze will be around 150ms and it read from file. After that, the time is fast around 12ms which don't read from...
set cache config in etc/launch/cn.toml will fix the issue. Default cache size is 512M. [[fileservice]] name = "LOCAL" backend = "DISK" [[fileservice]] name = "SHARED" backend = "DISK" data-dir =...
slow create index may cause by the issue https://github.com/matrixorigin/matrixone/issues/21456
@fengttt there are more than 60 files changes. I think it is too much changes. Isn't it?
please verify after the 2.1-dev after code merged.
file data is actually loaded into the memory but memory pool inside the vector returns error.
The highlighted code raised error. Seems nothing we can do if limit of memory pool is 2G.