… should be just swapped out and when never needed again. So if you see swap file used space gradually growing and there are “swap outs” but a lot less “swap…
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
…arises if you should have swap file enabled or disable it ? I’ve seen production successfully running on boxes both with and without swap file so…really used. These would be first valid candidates to swap out. Second if you have swap file you get a bit more flexibility. What happens if you miscounted…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
… that different file systems (and different versions of them) might be using different units for these options so you should refer to a manual on… 9767488+ 83 Linux /dev/sda2 19535040 27342629 3903795 82 Linux swap / Solaris /dev/sda3 27342630 2339835119 1156246245 8e Linux LVM sda1…
Post: Why Swapping is bad for MySQL Performance ?
January 18, 2010 By 11 Comments
…using more memory for cache and pushing application to the swap. This causes swapping…swap file. The bottom line: You should configure system so no swapping activity is going on during normal operations. The swap file itself may be justified – if you…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… is a dedicated master server). The machine has a lot of swap, but basically none is used. This isn’t all that relevant, as you… the machine swapping actively? (This is more important than whether it’s using swap.) There are a lot of combinations of possible things you can… it in a text file, and explain what I’m seeing to the client. Anything I see that looks wrong should be explained…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
… starts swapping between its buffer pool and the tablespace on disk. Most seriously, if something should …what you should expect for B-Tree indexes. The two curves on the Cacti graph actually show both files…overall. I also used ‘time’ to run the Perl fifo script, and it used a few minutes of …
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… errors are discovered etc. You should not think about this … what you would expect from database server and saves you from a lot…you have decent myisam_sort_buffer_size and large myisam_max_sort_file…swapping. Second – table will be locked while repair is going. If this is frequently used table you…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… it is Dedicated MySQL Server you may not have a good use for that memory anyway. Another thing you should keep into account is Innodb… you may have is making your OS happy and avoiding swapping out MySQL Process or other important processes to make room for file… of percent. Some people try to solve it with disabling swap file but it can hurt another way – OS may kill MySQL…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…file read. PZ: “often” a bit stikes me here. I thought it would be always single read, typically 1MB in size. I should… WHERE condition in a search. Please use this with care: you MUST use row-based binlogging and…is using most of the system’s memory the kernel can decide (incorrectly) to swap out…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…you try to create or drop a table, or the database itself. Likewise, if a system administrator leaves a temporary file…uses a threshold for which there is no good one-size-fits-all value. This plugin, perhaps more than any other, should…
