The comma goes before.
I am a man. You are a woman.
I am a man, and you are woman.
I am fine but a little bit tired. (note: this is not a compound sentence - hence, no comma.)
I am fine, but I am a little tired. (This is a compound sentence - hence, the comma.)
It is covered here in Grammar Monster.