Web lists-archives.com

Re: checking for repetitive queries




cut short on the previous message but I'm sure you get the gist.

A

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>
> wrote:
>
>> 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
>>
>>
>