My machines can only hold 12Gig of RAM but the database will quickly grow to 100's of Gigs. But yes, I plan on filling it with RAM as soon as possible.
Are there any particular settings to keep certain tables or indexes in memory so they don't get dropped from cache? Generally the queries return less than 500 result records of 5-15 fields, mostly text. The queries are usually joins of tables with millions of records. Keith -----Original Message----- From: Henrik Hempelmann [mailto:[EMAIL PROTECTED] Sent: Friday, July 15, 2005 2:31 PM To: Maxdb Subject: Re: Maximize Read Performance Am 15.07.2005 um 19:10 schrieb Keith: > We have an application that requires maximum read performance from > the data > base. We have size data and catalog caches to near maximum and have > cache > hit rates of 99.99%. > > Are there any additional parameter configuration settings we should > be look > at? What about parameter configuration measures should we be > taking to > obtain maximum read performance? add memory, add memory and add memory! keep the whole database in memory. Keith, what kind of performance do you need? Do you have lots of selects, selects with large result sets, large scans with a small result set...? Henrik -- 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]
