tag:blogger.com,1999:blog-2878888158072252134.post2782152769092454830..comments2023-10-30T07:53:04.073-07:00Comments on Rob Young - The Open Product Manager: MySQL Query Analyzer: Tracking query executionsRob Younghttp://www.blogger.com/profile/03969989591358063671noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-2878888158072252134.post-69588886664853151172008-09-03T10:51:00.000-07:002008-09-03T10:51:00.000-07:00David, Monitor 2.0 w/Query Analyzer is available f...David, Monitor 2.0 w/Query Analyzer is available for beta now to Enterprise subscribers <BR/>(https://enterprise.mysql.com) and will be posted for public beta in the next few weeks. GA is targeted for later this year, hopefully before Thanksgiving.<BR/><BR/>RobYRob Younghttps://www.blogger.com/profile/03969989591358063671noreply@blogger.comtag:blogger.com,1999:blog-2878888158072252134.post-28376480329740367842008-09-02T03:26:00.000-07:002008-09-02T03:26:00.000-07:00When is this functionality going to be included in...When is this functionality going to be included in Mysql Enterprise Monitor?David Campbellhttps://www.blogger.com/profile/09921624503228519151noreply@blogger.comtag:blogger.com,1999:blog-2878888158072252134.post-27967054670564919322008-08-29T14:56:00.000-07:002008-08-29T14:56:00.000-07:00As promised, I've blogged on some innards of query...As promised, I've blogged on some innards of query analysis and how it works.<BR/><BR/>http://darren.oldag.net/2008/08/mysql-query-analyzer-peek-under-hood.htmlOldaghttps://www.blogger.com/profile/14242449133322470801noreply@blogger.comtag:blogger.com,1999:blog-2878888158072252134.post-39810494026007026342008-08-29T12:16:00.000-07:002008-08-29T12:16:00.000-07:00MarkC, Exactly! We are using the proxy to collect...MarkC, Exactly! We are using the proxy to collect the statements/stats and aggregating everything in the Service Manager (central server) for analysis.Rob Younghttps://www.blogger.com/profile/03969989591358063671noreply@blogger.comtag:blogger.com,1999:blog-2878888158072252134.post-42589549330351900622008-08-29T11:50:00.000-07:002008-08-29T11:50:00.000-07:00@markindeed. however, ex post facto analysis of t...@mark<BR/><BR/>indeed. however, ex post facto analysis of the various logs (slow query, or general) is on the road map as another source of query data, should the proxy not fit in some people's setups.Oldaghttps://www.blogger.com/profile/14242449133322470801noreply@blogger.comtag:blogger.com,1999:blog-2878888158072252134.post-27625669797956092152008-08-29T11:10:00.000-07:002008-08-29T11:10:00.000-07:00I wanted to know if you were extracting the slow q...I wanted to know if you were extracting the slow query log output from the log file or log table. But I think you are doing neither which should avoid the problem of needing to rotate the slow query log when it gets too big.Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-2878888158072252134.post-52479305585720678542008-08-29T11:08:00.000-07:002008-08-29T11:08:00.000-07:00@mark:I'm in the midst of writing an "insider's vi...@mark:<BR/><BR/>I'm in the midst of writing an "insider's view" blog spilling some gory details. I'll cross post it here when it's done. But it should also show up on planetmysql.org.<BR/><BR/>But I'm not sure I understand your question fully. Do you mean log files/tables on the monitored mysql instance, or log files/tables in the Monitor's repository?<BR/><BR/>Nothing is stored with the agent/proxy or monitored mysql except in memory, until the data is sent to the Monitor. Then, the monitor uses his own storage for further reporting.Oldaghttps://www.blogger.com/profile/14242449133322470801noreply@blogger.comtag:blogger.com,1999:blog-2878888158072252134.post-6563816118416969472008-08-29T09:59:00.000-07:002008-08-29T09:59:00.000-07:00That is even better. Does this require the use of ...That is even better. Does this require the use of log tables or log files? Log tables can be rotated. Log files cannot.Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.comtag:blogger.com,1999:blog-2878888158072252134.post-44179696041995659282008-08-29T08:57:00.000-07:002008-08-29T08:57:00.000-07:00@mark:that's exactly what it does. when 'enabled'...@mark:<BR/><BR/>that's exactly what it does. when 'enabled' it captures all queries, normalizes in a similar fashion as you describe, and reports aggregated stats on that normalized query back to the Monitor on a periodic basis.<BR/><BR/>Once on the monitor side, we can look at any arbitrary time range, and perform additional rollups, stats, etc. on the requested range.Oldaghttps://www.blogger.com/profile/14242449133322470801noreply@blogger.comtag:blogger.com,1999:blog-2878888158072252134.post-2969609577211263782008-08-29T06:14:00.000-07:002008-08-29T06:14:00.000-07:00Can the query analyzer capture all queries over a ...Can the query analyzer capture all queries over a period of time and analyze them? An intermittent problem for us is a large workload spike from fast queries. They don't appear in SHOW PROCESSLIST and using the slow query log is painful (must login to get the output, must run Awk script to aggregate the queries). A tool to automate this is great. One analysis that we do is to normalize queries by removing extra white space and replacing literals and then running the equivalent of 'sort | uniq -c' to find the most popular query.Mark Callaghanhttps://www.blogger.com/profile/09590445221922043181noreply@blogger.com