… number of processor cores have on different memory allocators and what difference we will see in MySQL performance in this scenario? Let me… increase memory footprint. Conclusion: – if your box has 8 cores or less – there is almost no difference between glibc malloc and alternative allocators…
Post: Read Buffers, mmap, malloc and MySQL Performance
September 12, 2007 By 8 Comments
… up with 2 posts on mmap allocation. Indeed allocating with mmap is much slower than allocating from memory memory pool which process already “owns” and… tune you malloc settings so more buffers are allocated from the pools rather than mmap. This though will at least increase memory consumptions… in the pool you could just grab one having allocation very quick. Also MySQL should get smarter in terms of which buffer…
Post: How much memory Innodb Dictionary can take ?
May 6, 2010 By 3 Comments
… limit. So how much memory can it really take ? Here is some production stats from real system: mysql> select count(*) from INNODB…) In this case The memory stats from SHOW INNODB STATUS look like: Total memory allocated 1101004800; in additional pool allocated 0 Internal hash tables… not included in “Total Memory Allocated” in SHOW INNODB STATUS any more, as that allocations were moved to use malloc() and so Innodb does…
Post: MySQL, AIX5L and malloc()
November 3, 2008 By 11 Comments
… run MySQL database on AIX 5L operating system. You compiled it successfully, configured and.. unluckily database didn’t start due to memory allocation…, to make your MySQL working fine: export LDR_CNTRL=’MAXDATA=0×80000000′ It allows database to allocate 2GB of memory ( 8*256MB…
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
…allocate it. innodb_additional_mem_pool_size is just a handy way to avoid repeated malloc()… stored code (triggers, stored routines, etc) uses memory to execute; so do temporary tables. The…100); Query OK, 0 rows affected (2.34 sec) mysql> select get_lock(@a, 1); +—————–+ | get_lock(@a, 1) …
Comment: To UUID or not to UUID ?
March 15, 2007 By 28 Comments
… on the Malloc tests. It is interesting it changes well with Google Malloc as in fact we’ve benchmarked number of malloc alternatives… not surprising especially as MySQL does internal memory management. On this high query rate however even few per thread allocations MySQL does may matter.
Comment: Impact of the number of idle connections in MySQL
December 18, 2010 By 21 Comments
… really expensive memory sanity check that has quadratic cost in the number of active malloc() allocations. (Note that a “debug build” in MySQL is… you know of any particular lists of idle connections that MySQL needs to traverse?
Comment: InnoDB memory allocation, ulimit, and OpenSUSE
August 31, 2010 By 7 Comments
… system starts hurting for memory, it is possible to segfault while writing to a successfully allocated block that malloc() returned! However, if we… the thread stacks. Some for other internal needs of MySQL. Some waste from memory space fragmentation. It would all add up eventually…
