Problem still occurs, I have replied in Github.
@mikes41720
After I create this post, I tried deleting Yoast and installing it back.
I tried for some time but still the same. Then I deactivate the plugin since I am about to go to sleep last night.
And upon reading your reply in the noon, i activate Yoast (at that time server load around 0.3). I wait for a while and the server load is fine for me and no high queries from mysql.
Then I leave it activated and for the past 15 minutes the load average is 1.08.
I am still monitoring
I installed Query Monitor, in the beginning there is no Yoast slow query.
But Just now I do see slow query ( https://pasteboard.co/JaCi1c1.jpg ).