Alright, I'm learning :)
A bunch of files get created and updated every 15 minutes!
Follows are first 30 minutes of output from one of my production servers.
How do I go about finding out which queries are doing those 800 table scans?
If one is maximizing performance, what does one look for?
Thank you.
===== #0 at 2003-11-26 13:26:12
* I Runtime version: W32/INTEL 7.5.0 Build 005-121-054-885
CON: 1
VAL: 1
* I Instance is up since 2003-11-21 01:36:50
CON: 1
VAL: 1
* I Configuration: number of CPUs (MAXCPU): 1, max user tasks: 64
CON: 1
VAL: 1
* I Number of data volumes: 1
CON: 1
VAL: 1
* I SQL commands executed: 23613284
CON: SQL_Cmds > 0
VAL: 23613284 > 0
===== #1 at 2003-11-26 13:41:12
* I SQL commands executed: 19612
CON: PureSQL_Cmds > INTERVAL * 5
VAL: 19612 > 900 * 5
* W3 273 table scans, selectivity 0.00%: 466797 rows read, 5 rows qualified
CON: TabScanSel < 0.3
VAL: 0.00 < 0.3
* I Number of physical writes: 14311
CON: PWrites > ( 4 * MAX_IDLE_IO_ALL_DEVS )
VAL: 14311 > ( 4 * 2250 )
===== #2 at 2003-11-26 13:56:13
* I SQL commands executed: 62999
CON: PureSQL_Cmds > INTERVAL * 5
VAL: 62999 > 901 * 5
* W3 800 table scans, selectivity 0.04%: 2373206 rows read, 921 rows
qualified
CON: TabScanSel < 0.3
VAL: 0.04 < 0.3
* I Number of physical reads: 22828
CON: PReads > ( 4 * MAX_IDLE_IO_ALL_DEVS )
VAL: 22828 > ( 4 * 2253 )
-----Original Message-----
From: Stephen General On Behalf Of Stephen Gutknecht (SAPDB)
Sent: Wednesday, November 26, 2003 1:41 PM
To: '[EMAIL PROTECTED]'
Subject: Tutorial on how to use dbanalyzer for basic study of query health?
Can someone give me hints on where to start invoking dbanalyzer?
I found output file DBAN.prt ... But not getting anything other than startup
information.
Yes, I read the documentation, but need "Tutorial" - or samples.
http://www.mysql.com/documentation/maxdb/default.htm
What I would like to find if I have any table scans, etc. Any help / tips
appreciated.
Stephen Gutknecht
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
