MySQL slow query log analysis
Locked
MySQL slow query log analysis
 
|
Hello,
I would like a mysql slow query log parser / analyzer that generates a graph with most time consuming requests. Someone already done it with Moose / Roassal ? Cheers,
Laurent
_______________________________________________ Moose-dev mailing list [hidden email] https://www.iam.unibe.ch/mailman/listinfo/moose-dev |
Re: MySQL slow query log analysis
|
|
I guess not. The first step would be to write a parser for the output
and build a model out of it. Afterwards we can visualize it. But, where is the graph in this structure? Cheers, Doru On Tue, Oct 9, 2012 at 9:19 AM, laurent laffont <[hidden email]> wrote: > Hello, > > I would like a mysql slow query log parser / analyzer that generates a graph > with most time consuming requests. Someone already done it with Moose / > Roassal ? > > Cheers, > > Laurent > > _______________________________________________ > Moose-dev mailing list > [hidden email] > https://www.iam.unibe.ch/mailman/listinfo/moose-dev > -- www.tudorgirba.com "Every thing has its own flow" _______________________________________________ Moose-dev mailing list [hidden email] https://www.iam.unibe.ch/mailman/listinfo/moose-dev |
Re: MySQL slow query log analysis
|
|
On Tue, Oct 9, 2012 at 9:25 AM, Tudor Girba <[hidden email]> wrote: I guess not. The first step would be to write a parser for the output I want to group same queries, how many times they are run, mean / max execution time. Group by database. Time distribution.
This is a server with +100 mysql databases (same structure), I want to know on which queries we should work to improve performance. Laurent
_______________________________________________ Moose-dev mailing list [hidden email] https://www.iam.unibe.ch/mailman/listinfo/moose-dev |
Re: MySQL slow query log analysis
|
|
Sounds interesting.
Do you have sample logs? Cheers, Doru On Tue, Oct 9, 2012 at 12:19 PM, laurent laffont <[hidden email]> wrote: > > On Tue, Oct 9, 2012 at 9:25 AM, Tudor Girba <[hidden email]> wrote: >> >> I guess not. The first step would be to write a parser for the output >> and build a model out of it. Afterwards we can visualize it. >> >> But, where is the graph in this structure? > > > > I want to group same queries, how many times they are run, mean / max > execution time. Group by database. Time distribution. > > This is a server with +100 mysql databases (same structure), I want to know > on which queries we should work to improve performance. > > Laurent > > >> >> >> Cheers, >> Doru >> >> >> On Tue, Oct 9, 2012 at 9:19 AM, laurent laffont >> <[hidden email]> wrote: >> > Hello, >> > >> > I would like a mysql slow query log parser / analyzer that generates a >> > graph >> > with most time consuming requests. Someone already done it with Moose / >> > Roassal ? >> > >> > Cheers, >> > >> > Laurent >> > >> > _______________________________________________ >> > Moose-dev mailing list >> > [hidden email] >> > https://www.iam.unibe.ch/mailman/listinfo/moose-dev >> > >> >> >> >> -- >> www.tudorgirba.com >> >> "Every thing has its own flow" >> _______________________________________________ >> Moose-dev mailing list >> [hidden email] >> https://www.iam.unibe.ch/mailman/listinfo/moose-dev > > > > _______________________________________________ > Moose-dev mailing list > [hidden email] > https://www.iam.unibe.ch/mailman/listinfo/moose-dev > -- www.tudorgirba.com "Every thing has its own flow" _______________________________________________ Moose-dev mailing list [hidden email] https://www.iam.unibe.ch/mailman/listinfo/moose-dev |
Re: MySQL slow query log analysis
|
|
Yes. I'll send you via private email.
Laurent
On Tue, Oct 9, 2012 at 12:48 PM, Tudor Girba <[hidden email]> wrote: Sounds interesting. _______________________________________________ Moose-dev mailing list [hidden email] https://www.iam.unibe.ch/mailman/listinfo/moose-dev |
Re: MySQL slow query log analysis
|
|
In reply to this post by Tudor Girba-2
Yes laurent could you send a sample?
Stef > Sounds interesting. > > Do you have sample logs? > > Cheers, > Doru > > > On Tue, Oct 9, 2012 at 12:19 PM, laurent laffont > <[hidden email]> wrote: >> >> On Tue, Oct 9, 2012 at 9:25 AM, Tudor Girba <[hidden email]> wrote: >>> >>> I guess not. The first step would be to write a parser for the output >>> and build a model out of it. Afterwards we can visualize it. >>> >>> But, where is the graph in this structure? >> >> >> >> I want to group same queries, how many times they are run, mean / max >> execution time. Group by database. Time distribution. >> >> This is a server with +100 mysql databases (same structure), I want to know >> on which queries we should work to improve performance. >> >> Laurent >> >> >>> >>> >>> Cheers, >>> Doru >>> >>> >>> On Tue, Oct 9, 2012 at 9:19 AM, laurent laffont >>> <[hidden email]> wrote: >>>> Hello, >>>> >>>> I would like a mysql slow query log parser / analyzer that generates a >>>> graph >>>> with most time consuming requests. Someone already done it with Moose / >>>> Roassal ? >>>> >>>> Cheers, >>>> >>>> Laurent >>>> >>>> _______________________________________________ >>>> Moose-dev mailing list >>>> [hidden email] >>>> https://www.iam.unibe.ch/mailman/listinfo/moose-dev >>>> >>> >>> >>> >>> -- >>> www.tudorgirba.com >>> >>> "Every thing has its own flow" >>> _______________________________________________ >>> Moose-dev mailing list >>> [hidden email] >>> https://www.iam.unibe.ch/mailman/listinfo/moose-dev >> >> >> >> _______________________________________________ >> Moose-dev mailing list >> [hidden email] >> https://www.iam.unibe.ch/mailman/listinfo/moose-dev >> > > > > -- > www.tudorgirba.com > > "Every thing has its own flow" > _______________________________________________ > Moose-dev mailing list > [hidden email] > https://www.iam.unibe.ch/mailman/listinfo/moose-dev _______________________________________________ Moose-dev mailing list [hidden email] https://www.iam.unibe.ch/mailman/listinfo/moose-dev |
«
Return to Moose
|
1 view|%1 views
| Free forum by Nabble | Edit this page |