Take the 2-minute tour ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.

My website is hosted on a shared hosting and I'd like to know how much SQL queries it is using per hour. I tried to navigate through cPanel and I find nothing to check or monitor the amount of SQL queries per hour. I tried to ask my host and they said it is not possible to do manually.

However I found this http://forum.powweb.com/archive/index.php/t-49937.html and another one on Stackoverflow: http://stackoverflow.com/questions/9842094/sql-how-can-i-get-the-number-of-executed-queries-per-database-or-hour-or And since this exists, I assume that it is actually possible. Problem is I can't execute that in my phpmyAdmin.

Can someone here guide me through the process?

share|improve this question
add comment

closed as not constructive by John Conde Nov 18 '12 at 20:31

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers

I'm really far from an expert on anything SQL / database related, but I think New Relics analytics may have something that can monitor this.

share|improve this answer
add comment

It is possible to do via mySql configuration, but in a shared hosting environment, you should not be able to discover that information unless the server admin made a very big mistake.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.