Re: Per query DB stats... ideally for InnoDB

2006-04-21 Thread Samuel Ziegler
> > On Wed, 19 Apr 2006, Samuel Ziegler wrote: > > > To: [EMAIL PROTECTED] > > From: Samuel Ziegler <[EMAIL PROTECTED]> > > Subject: Re: Per query DB stats... ideally for InnoDB > > > > Those functions do give useful information, but as you point out, the

Re: Per query DB stats... ideally for InnoDB

2006-04-19 Thread mysql
: > To: [EMAIL PROTECTED] > From: Samuel Ziegler <[EMAIL PROTECTED]> > Subject: Re: Per query DB stats... ideally for InnoDB > > Those functions do give useful information, but as you point out, the > trick is associating that information with a specific query. For my >

Re: Per query DB stats... ideally for InnoDB

2006-04-19 Thread Samuel Ziegler
> administrators should always be able to connect and check > the system (assuming that you are not giving this privilege > to all your users). > > Regards > > Keith > > In theory, theory and practice are the same; > in practice they are not. > > On Wed, 19 Apr

Re: Per query DB stats... ideally for InnoDB

2006-04-19 Thread mysql
ql.com > From: Samuel Ziegler <[EMAIL PROTECTED]> > Subject: Per query DB stats... ideally for InnoDB > > Is there any way to retrieve per SQL query stats from MySQL? > Specifically for my need, the ability to determine the amount of system > resources required to perform the

Per query DB stats... ideally for InnoDB

2006-04-19 Thread Samuel Ziegler
Is there any way to retrieve per SQL query stats from MySQL? Specifically for my need, the ability to determine the amount of system resources required to perform the query, ie CPU, disk usage, etc... I poked through the docs & did some net searching, but couldn't find anything that I could use.