Hey, there.
Mayer's tone on that album is all over the place, using different guitars, pickups & amounts of volume & gain. If you could specify one particular solo I could try to be specific. But in general, he's using a pretty loud tube amp (Dumble, Two-Rock, or Fender Super Reverb) cranked to get a lot of clean head room on the verge of breakup. So he can clean the tone up by dialing down the volume on his guitar. And when he wants sustain & bite, he turns it up & turns on a mild overdrive (TubeScreamer or similar).
This site might be helpful.
https://www.johnmayergear.com/
I think you've got the gear for it, but you need to use more volume. Or if you need to keep the stage volume down, then add pre-amp gain until your guitar gets a little more power & edge to the natural clean tone. You want it to have a treble chime when your guitar is on 10, clean if you strum lightly, biting if you dig in & singing overdrive sustain when you step on the TubeScreamer. Also, a little reverb might add depth & body to your tone.
But more importantly, work on cleaning up your vibrato. Bend in pitch, with conviction, right on time & with the rhythmic pulse of the song. I get that it's live & you do a good job mostly staying in the pocket & hitting the right notes. But there is a little bit of sloppiness that could stand to be cleaned up a bit to make your playing more solid.
Hope that helps!
Christopher Schlegel
Guitar Tricks InstructorChristopher Schlegel Lesson Directory