change show variables to retrieve global instead of session
Merge pull request #539 from hub-cap/update_show_variables_query

change show variables to retrieve global instead of session