MySQL Forums
Forum List  »  Performance

Re: Slow response in MY SQL 5.5.1.8
Posted by: Rick James
Date: July 16, 2014 09:04PM

First, let's clarify whether you are talking about
* the response delay for a trivial query (eg, "SELECT 1"), or
* there are lots of queries (not quarries) running and things are "slow", or
* you are running a query that takes a long time, so it is slow.

Suggest you set long_query_time = 1 and turn on the slowlog. Then, after a day or so, run pt_query_digest. Then show us the first one or two "slow" queries, plus SHOW CREATE for the table(s) involved.

Also, please provide
* SHOW VARIABLES LIKE '%buffer%';
* How much ram do you have?

Options: ReplyQuote


Subject
Views
Written By
Posted
1555
July 16, 2014 01:30AM
Re: Slow response in MY SQL 5.5.1.8
861
July 16, 2014 09:04PM


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.