…transaction processing that notably affects MySQL performance – for every transaction InnoDB creates a read view and allocates memory for this structure from … memory allocation for read-view structure is not a direct malloc() call, but rather goes through the InnoDB heap layer – so InnoDB allocates …
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… #1162085 (Alexey Kopytov). Fixed upstream bug #49169 by avoiding the malloc call in the read_view_create_low() in most cases…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory allocators on MySQL performance can be… #1162085 (Alexey Kopytov). Fixed upstream bug #49169 by avoiding the malloc call in the read_view_create_low() in most cases…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… avoid swapping with HA that NDB cluster basically forbids calling malloc after the startup phase and hence its rather complex configuration… to interleave the allocation of memory for the MySQL process using the numactl utility, drop the file cache and pre-allocate the innodb buffer…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
MySQL server intensively uses dynamic memory allocation so a good choice of memory allocator is quite important for the proper utilization of CPU/RAM …_pool_size=52G For every malloc allocator perform the following steps: start Percona server either with LD_PRELOAD=[allocator_lib.so] or glibc…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…,760B) (heap allocation functions) malloc/new/new[], –alloc-fns, etc. ->84.91% (349,404,796B) 0x7A3CB0: my_malloc (in /usr/local/percona/mysql-5.5… ‘too much’) memory is being allocated to the Log_event::read_log_event function. You can also see the memory allocated to the function…
Post: InnoDB memory allocation, ulimit, and OpenSUSE
August 23, 2010 By 7 Comments
… failed malloc() in ut_malloc_low() in ut/ut0mem.c inside InnoDB source code. InnoDB wraps the majority of its memory allocations in ut_malloc_low(), so to get an idea of the pattern of requested allocations I added a…. I tested it with allocating 70 GB concurrently in each process so as to overrun physical memory + swap. Both allocations were successful, one…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… bytes inside a block of size 664 alloc‘d ==9090== at 0x4C28FDF: malloc (vg_replace_malloc.c:236) ==9090== by 0x6B70A62: mem_heap… block of size 800000 alloc‘d ==9090== at 0x4C28FDF: malloc (vg_replace_malloc.c:236) ==9090== by 0x6BE309B: ut_malloc (ut0mem.c:106) ==9090…, I’d consider backporting and using MySQL 5.5 atomic operation primitives with proper memory barriers, so that there is no need…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
…cache->length); 14272 if (!(cache->buff=(uchar*) my_malloc(size,MYF(0)))) 14273 DBUG_RETURN(1); /* …as x2 join…. That should try to allocate 1GB of memory for each join. If you execute this and nothing bad happens, you might be seeing this bug: http://bugs.mysql…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…the amazing MySQL manual, especially the option and variable….commanual shared_memoryblogpercona.commanual shared_memory_base_nameblogpercona.commanual show_slave_…_sizeblogpercona.commanual tmpdirblogpercona.commanual transaction_alloc_block_sizeblogpercona.commanual transaction_isolationblogpercona….
