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

2006-04-21 Thread Samuel Ziegler
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 use, there will most likely be other SQL activity

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.

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

2006-04-19 Thread mysql
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 query, ie CPU, disk usage, etc... I

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

2006-04-19 Thread Samuel Ziegler
In theory, theory and practice are the same; in practice they are not. On Wed, 19 Apr 2006, Samuel Ziegler wrote: To: mysql@lists.mysql.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

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 use, there will most likely be other