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/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
