Richard, sorry, but with that level of understanding you are a liability as an accompanist.

D mixolydian is not G major. It does not centre on G and when accompanying a Dmix tune you will never resolve to a G chord at the finish.

Please go away and read something. This is absolutely basic stuff that you aren't getting.