Monitor MySQL DB Queries

Category: How To

hiya83
Asked:
2012-05-06 3:19 am EST

Hits: 678
Hi,

I am trying to find a way to monitor all queries that are passed into my DB. I know you can easily change the mysql config file to output everything to the log, but how do I accomplish that inside inmotion's cpanel?

Thanks

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

BradM
Staff
5,399 Points
2012-05-07 9:01 am EST
Hi hiya83,

Within the mysql configuration file, you can configure MySQL to log all queries to a file. This logging can only be done server wide, meaning we can't log all SQL queries from only one account. Because this logging can be quite taxing on the server, it is unavailable to users on the shared platform. If you were on a VPS or dedicated hosting server, we would be able to set this up for you.

I looked at your website, and based upon your source code it appears that you are running Joomla 1.7. There may be a way to update the core MySQL calls in Joomla so that it logs all the queries either before or after they're ran, but this would involve editing source code which may cause unforeseen problems.

Is there a specific reason you're trying to log all queries? If you wanted to post a comment at the bottom of this page with a bit more information, we may be able to find a viable solution for you.

Thanks!
- Brad

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!