Re: Large DB buffer, low cache hit ratio

From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 22 Jan 2001 21:02:38 -0600
Message-ID: <94is8e$hpr$1@garnet.tc.umn.edu>

You may have some bad SQL beating your DB to a pulp. Check the SQL executed against the database. Did you "ANALYZE" the schema?

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.sofbot.com/


---------------------------------------------------------

Received on Mon Jan 22 2001 - 21:02:38 CST

This message: [ Message body ]
Next message: Mike Krolewski: "To follow responders -- building an FAQ"
Previous message: toddthom: "What ramifications are there for running two Instances on one host server."
In reply to: Howard J. Rogers: "Re: Large DB buffer, low cache hit ratio"
Next in thread: Niall Litchfield: "Re: Large DB buffer, low cache hit ratio"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US