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















Reply via email to