** I am reposting. ** I am looking for some general rule to determine the innodb_buffer_pool_size and innodb_log_file_size based on number of innodb tables, transactions, etc. Setting these values based on how much of the server resources I am allotted is not adequate. Thanks
<ORIGINAL POST> Hello I am looking to determine the best Innodb Settings for our MySQL Instances. Specifically, the settings for innodb_buffer_pool_size and innodb_log_file_size. I have read the manual and understand how they work. I am looking for additional information that would help me determine their values instance by instance. In other words, if I only have 2 Innodb tables with low data and xaction rates, then I should have them set to x. If there is some additional determining factors beside the number of tables, rows and expected transaction rate, I would like to know them as well. Thanks in advance! Gabe </ORIGINAL POST> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
