Inventing mycology allows tribe to eat all mushrooms without any worry. Mycology has farming requirements to unlock, and is not available early in the game. If you constantly find yourself low on food, mycology is a good upgrade for you.
Mycology is nice to have if you need food, because it does not depend on job. Any minion can pick mushrooms. It also eliminates the need of hunter and farmer to gather food.