Lately i am seeing some select queries timing out, data modelling to blame for but not in a situation to redo it.
Does increasing heap will help ?? currently using 1GB new_heap, I analysed the GC logs not having any issues with major GC's . Using G1GC , does increasing new_heap will help ?? currently using JVM_OPTS="$JVM_OPTS -XX:MaxGCPauseMillis=500", even if i increase heap to lets say 2GB is that effective b/c young GC's will kick in more frequently to complete in 500ms right ?? Thanks Pranay.