WordPress database error User 'XXXXXX' has exceeded the 'max_questions'‘

Hi guys
I’ve recently got the following error from my site log:

WordPress database error User ‘XXXXXX’ has exceeded the ‘max_questions’ resource (current value: 75000) for query SHOW TABLES LIKE ‘wp_users’ made by display_setup_form

That causing my website completely goes down. I’ve contacted my hosting provider, they have done the restart(maybe). and it go back to normal now.

Meanwhile, the hosting guy told me this is because my website have exceeded the MySQL query limit.
He suggested i have to make necessary changes to the website and make sure that my website will not exceed the MySQL query limit.

He mentioned wp total cache which lots of people use to fixed the problem.

I am wondering if someone has the same issues as me, and looking forward a solution.

sincerely thanks

Nick Kou