….conf # Enable locking Huge Pages for MySQL user root soft memlock 2883584 root hard memlock 3932160 #mysql soft memlock unlimited #mysql hard memlock unlimited
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… swap out MySQL. There are two solutions here. Memlock and O_DIRECT. Memlock is apparently unstable on Linux. O_DIRECT is an…. In distant future, I would like to have the memlock also. PZ: memlock already works – it is global MySQL Server option, though…
Comment: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… kB My limits.conf looks like this: mysql soft memlock unlimited mysql hard memlock unlimited My my.cnf looks like this: large…
Comment: Heikki Tuuri to answer your in depth Innodb questions
September 28, 2007 By 51 Comments
Just an FYI for readers at home. The –memlock command line option calls the memlock system call to keep the process in memory. O_DIRECT bypasses the kernel to do IO directly. I’m not sure if it works either for keeping the process locked into memory.
Comment: Heikki Tuuri to answer your in depth Innodb questions
September 28, 2007 By 51 Comments
… swap out MySQL. There are two solutions here. Memlock and O_DIRECT. Memlock is apparently unstable on Linux. O_DIRECT is an…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
I am constantly referring to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on variables, or look for content in the Percona documentation or forums. So I present to you what is now my newest Firefox toolbar …
Comment: Why Swapping is bad for MySQL Performance ?
January 19, 2010 By 11 Comments
CYTech, There is “memlock” option which locks MySQL process in memory. The danger with it is increased change of MySQL Server being killed if no memory is available. It also not very commonly used and people reported problems with some Linux kernel versions.
Comment: Should you have your swap file enabled while running MySQL ?
April 9, 2008 By 31 Comments
Set memlock (max locked memory) for mysql user in /etc/security/limits….
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
…/swappiness =0. You can lock MySQL in memory by using –memlock option but it opens its own can of worms. If…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…. Finally you can try locking MySQL in memory by using –memlock – just be careful as in case you have memory usage…
