… calculation for OS_THREADS) So InnoDB uses: innodb_buffer_pool innodb_additional_mem_pool_size innodb_log_buffer_size adaptive index hash, size= innodb_…InnoDB will allocate = 1500M + 20M + 8M + 1500/20M + 17.5M = 1620.5M. Take the additional memory into account when you are planning memory usage…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… consider the added memory for InnoDB: specifically, the buffer pool. (There’s also an innodb_additional_mem_… no formula to compute the maximum possible memory usage, and there cannot be because there are …I usually calculate the Big Ones like the buffer pool, query cache etc; leave some memory for …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…memory usage. You can see total memory allocated by Innodb (sometimes it is higher than you anticipated), amount of memory allocated in additional memory…
