MySQL Forums
Forum List  »  General

Re: How to solve these three steps as my hosting company told me?
Posted by: Rick James
Date: May 24, 2016 09:56AM

What is your application? Are you using some third-party software? Do you know what query is performing poorly?

Can you do SHOW PROCESSLIST; if so, look for some query that has a large "Time".

Is the slowlog turned on?

That is, we can help you solve the problem if you can provide the query that is being "naughty". Also provide the definition of the table(s) that the query uses. Preferably provide SHOW CREATE TABLE.

Options: ReplyQuote


Subject
Written By
Posted
Re: How to solve these three steps as my hosting company told me?
May 24, 2016 09:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.