Your question is very broad! For an answer about just one particular place and time, check out an older answer of mine about mental health in early medieval Ireland.