Should i run compaction after changing column_index_size_in_kb?
Sent using Zoho Mail ---- On Sun, 20 May 2018 15:06:57 +0430 onmstester onmstester <onmstes...@zoho.com> wrote ---- I've increased column_index_size_in_kb to 512 and then 4096 : no change in response time, it even got worse. Even increasing Key cache size and Row cache size did not help. Sent using Zoho Mail ---- On Sun, 20 May 2018 08:52:03 +0430 Jeff Jirsa <jji...@gmail.com> wrote ---- Column index size in the yaml (increase it to trade GC pressure for disk IO) If you’re on anything other than 3.11.x, upgrade to 3.11.newest -- Jeff Jirsa