Re: Upgrade from 5.5 to 5.6

2015-05-18 Thread Larry Martell
On Fri, May 15, 2015 at 8:27 PM, Reindl Harald h.rei...@thelounge.net wrote: Am 15.05.2015 um 23:27 schrieb Larry Martell: I am upgrading my server from 5.5 to 5.6. This is on CentOS 6.5. I removed 5.5 like this: yum remove mysql-libs MySQL-client MySQL-devel MySQL-shared and I installed

ANN: SQL Maestro for MySQL 15.5 released

2015-05-18 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of SQL Maestro for MySQL 15.5, a powerful Windows GUI solution for MySQL administration and database development. The new version is immediately available for download at http://www.sqlmaestro.com/products/mysql/maestro/ Top 10 new features

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 eroomy...@gmail.com 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

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

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