Re: checking for repetitive queries
- Date: Mon, 18 May 2015 23:25:47 +0100
- From: Andrew Moore <eroomydna@xxxxxxxxx>
- Subject: Re: checking for repetitive queries
cut short on the previous message but I'm sure you get the gist.
On Mon, May 18, 2015 at 11:25 PM, Andrew Moore <eroomydna@xxxxxxxxx> wrote:
> pt-query-digest will help here. You can use a slow query log or tcpdump to
> track what the application is asking of the db. The report provided by the
> tool can be per db if you wish or the complete schema. It will provide a
> summary of the collection and you'll see how often yo
> On Mon, May 18, 2015 at 10:37 PM, Steve Quezadas <steve@xxxxxxxxxxxxxxxxx>
>> I want to make sure my caching system is working properly and I want
>> to make sure my mysql server isnt being held up by repetitive queries
>> (ie like the side "products table" that appears on every web page).
>> I'm pretty sure I cached the site pretty well, but want to make sure
>> that I didn't miss anything.
>> Is there some sort of tool that allows me to check for repetitive queries?
>> - Steve
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/mysql