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

2006-04-21 Thread Samuel Ziegler
at this Samuel? > > http://www.mysql.com/products/tools/administrator/index.html > > Check out the demo in the TRH corner. > > May be of some use to you. > > Regards > > Keith > > In theory, theory and practice are the same; > in practice they are not.

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

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.