innodb_buffer_pool_size + key_buffer_size + max_connections*(sort_buffer_size + read_buffer_size + binlog_cache_size) + max_connections*2MB
is what I was told recently on this list. -Sheeri Kritzer On 1/16/06, Grant Giddens <[EMAIL PROTECTED]> wrote: > I don't know if I still fully understand. > > Say I have a database with a good mix of myisam and innodb type tables. > If my server has 1 gig of ram and I set key_buffer_size=256M and > innodb_buffer_pool_size=256M then wouldn't mysql be constrained to 512M of > the ram and leave the remaining 512M to the other server services? > > For a large database, are they any guides that I can use to determine how > much ram would be optimal for my particular database? > > Thanks, > Grant > > Eric Bergen <[EMAIL PROTECTED]> wrote: The difference in recommendation size > comes from the different > techniques each storage engine uses for caching data. myisam > (key_buffer_size) only stores indexes where innodb_buffer_pool_size > stores both indexes and data. mysiam relies on the operating system to > cache data in ram which is why you don't want to use all available > memory for the key buffer. > > > On 1/14/06, Grant Giddens wrote: > > Hi, > > > > After reading through the example my.cnf files (large, huge, etc), I > > started to wonder what the difference was between the isam key_buffer_size > > and the innodb innodb_buffer_pool_size. > > > > I realize that they are two different table types, but some of the docs > > says to set the key_buffer_size to 25%-50% of the overall system memory. > > The comments for the innodb_buffer_pool_size say that it can be set to > > 50%-80% of the overall system memory. > > > > Maybe I don't understand exactly the difference between the two because I > > don't understand why they have different memory recommendations. > > > > Is there any FAQs on the my.cnf file? How would you set these two > > variables if you had an even mix of isam and innodb tables? Where can I > > learn more about tweaking the my.cnf file? The mysql online documentation > > is good, but I need a more basic description of these two variables and > > all the other my.cnf settings. > > > > Thanks, > > Grant > > > > > > > > --------------------------------- > > Yahoo! Photos > > Got holiday prints? See all the ways to get quality prints in your hands > > ASAP. > > > > > -- > Eric Bergen > [EMAIL PROTECTED] > http://www.ebergen.net > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > --------------------------------- > Yahoo! Photos – Showcase holiday pictures in hardcover > Photo Books. You design it and we'll bind it! >