Disk io wait during select,

[trevor%tribenetwork.com]

Greetings..

 

            Is their a way to list a time breakdown of a select?  Amount of
query waiting on disk-io, in memory, etc...

 I have tried the debug-info option with mysql client but it lists several
memory settings.  I have a 1.2 ultra-sparcIII that is twice as slow as a
xeon 2.4 machine eventhough the sparc has superior memory and disks.

 

Thanks,

 

Trevor