mysqlreport and slow_queries

Category: Databases

karen_ratte
Asked:
2012-05-21 9:34 am EST

Hits: 828
I was wondering what kind of SQL queries a shared environment was allowed to run or whether there are log files that would tell me what I would like to know. My status report in PHPAdmin indicates that I have some slow_queries or that I have tables that might not be indexed properly. in a Shared server environment What is possible here, in general.

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

You must login before you can submit an answer.

OTHER ANSWERS

0

Scott
Staff
16,697 Points
2012-05-21 10:27 am EST
Hello karenratte@gmail.com,

Shared servers run the same as any other servers as far as SQL is concerned. You do want to try and limit your slow queries and optimize your databases for performance, however. Shared servers can be adversely affected by slow queries and high queries per second more than VPS and Dedicated servers. Standard optimization rules apply and you want to limit the slow queries as much as possible. If there are any performance issues regarding the MySQL, our Systems team will reach out to you and advise on steps to optimize that where possible to help you keep your account and the server running smoothly.

I hope this answers your question. If you have any further questions please leave a comment below.

Thanks!
- Scott M

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!