Matt, ----- Original Message ----- From: ""Matt Solnit"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, January 07, 2003 8:45 PM Subject: Calculating innodb_additional_mem_pool_size?
> Is there a good way of calculating the size for > innodb_additional_mem_pool_size? I would like to calculate based on the > number of tables, rows, or whatever else I can use to pre-determine a > value so that the warning message "allocating memory from the OS" does > not appear. the easiest fix is that I remove the message altogether :). I have now removed it from 4.0.9 and 4.1.0. Modern OS'es have a fast enough malloc so that it does not hit performance if InnoDB has to allocate using the OS malloc(). Some old malloc implementations were so slow that I wrote my own buddy algorithm -based malloc. The InnoDB additional mem pool still has its use in debugging, because InnoDB can trace its use thoroughly. Most of the additional mem pool usage goes to tables in the data dictionary, and connections. A rough estimate is that it is proportional to number of tables + number of concurrent connections. > -- Matt Solnit > [EMAIL PROTECTED] > > P.S. This is just here to satisfy the spam filter: MySQL Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php