[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    AW: db_analyzer results
From:       "Zabach, Elke" <elke.zabach () sap ! com>
Date:       2004-06-30 7:21:04
Message-ID: 235EE6AC8AE9264CBF763FC6749E27013455C0 () dewdfe22 ! wdf ! sap ! corp
[Download RAW message or body]

Si Chen wrote
> 
> Hello.  Sorry for another email today.  I am just starting to learn
> MaxDB and am fascinated by all its features, but unfortunately I don't
> understand all of it.
> 
> May I ask what the results of db_analyzer are telling me?  I ran
> $ ./db_analyzer -d <DB> -u <user>,<passwd> -t 1, 1000
> 
> And I am getting resutls of:
> W1 Catalog cache hitrate (SQL Pages) 87%, 106 of 824 accesses failed
> 
> This is pretty consistent across each run.  I assume that 106/824
> accesses failed is not a good thing.  What about the cache hitrate?  Is
> there some targeted level I should be aiming for?  Is there somewhere in
> the documentation that can explain the results of db_analyzer and also
> how to optimize a database?
> 

Please see the documentation for dbanalyzer which can be found as any docs
below:
http://dev.mysql.com/doc/maxdb/en/default.htm

http://dev.mysql.com/doc/maxdb/en/2b/361e3bd129be04e10000000a114084/frameset.htm

--> messages

Elke
SAP Labs Berlin


> Thank you.
> 
> Si Chen
> 
> 
> --
> MaxDB Discussion Mailing List
> For list archives: http://lists.mysql.com/maxdb
> To unsubscribe:    http://lists.mysql.com/maxdb?unsub=elke.zabach@sap.com

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]