Re: Slow response in MY SQL 5.5.1.8
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?
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
891
July 21, 2014 05:02AM
815
July 23, 2014 12:19AM
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.