… x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 …which is important if you want to allocate a lot of memory to mysqld. Next I look …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
Comment: Wanted: Better memory profiling for MySQL
May 20, 2008 By 4 Comments
… this area a bit at the MySQL User’s conference. Perhaps you could use the umem memory allocator in some of these cases… you set the right environment variable options, determine where the memory allocations have come from. It’s also designed to not be… was a user space port of the Solaris kernel memory allocator (now copied in Linux/BSD/Windows and others) along with many of…
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… ———————- BUFFER POOL AND MEMORY ———————- Total memory allocated 13917841802; in additional pool allocated 1046272 Buffer pool size … for Christoffer Hall’s work of Linux AIO support to be merged to …I was adviseor in this project from MySQL AB side) – to improve how Innodb…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… for blobs larger than 16K – is exact size allocated or also segment based allocation is used. Q18: Innodb Q: Is Group commit… using most of the system’s memory the kernel can decide (incorrectly) to swap out MySQL. There are two solutions here. Memlock… is global MySQL Server option, though it may have problems on Linux if you lock very large portion of physical memory. There is…
Post: Beware: ext3 and sync-binlog do not play well together
January 21, 2009 By 19 Comments
…controller related we repeated the run on the in memory block device and got very similar results – 2350 … I expect this is because Innodb log is pre-allocated so there is not need to modify meta …file system for Linux. It is also worth to investigate if something can be done on MySQL side – may be…
Comment: To UUID or not to UUID ?
March 15, 2007 By 28 Comments
… to blame something else. It is Linux being guilty ? When why Oracle and PostgreSQL scale on Linux ? In fact sometimes even CPU… 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: MySQL Server Variables - SQL layer or Storage Engine specific.
December 1, 2006 By 14 Comments
… hugetlbfs for mysql all what you need is echo 2000 > /proc/sys/vm/nr_hugepages or equal command for your Linux (what…: 1. Your memory is fragmented, so kernel can not allocated non-fragmented part with requested size, can you try allocate just after reboot…
