Re: checking for repetitive queries

2015-05-20 Thread Mogens Melander
https://www.thomas-krenn.com/en/wiki/MySQL_Performance_Tuning#Tuning_Tools On Mon, May 18, 2015 23:44, Reindl Harald wrote: > > Am 18.05.2015 um 23:37 schrieb Steve Quezadas: >> I want to make sure my caching system is working properly and I want >> to make sure my mysql server isnt being held up

Re: checking for repetitive queries

2015-05-18 Thread Andrew Moore
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

Re: checking for repetitive queries

2015-05-18 Thread Andrew Moore
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 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

Re: checking for repetitive queries

2015-05-18 Thread Reindl Harald
Am 18.05.2015 um 23:37 schrieb Steve Quezadas: 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 w

checking for repetitive queries

2015-05-18 Thread Steve Quezadas
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 any