… 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: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 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: Filling the tmp partition with persistent connections
August 6, 2012 By 14 Comments
…a typical master-slave replication with ROW based binary log file. The application connects to the database using…you should check the free space on it with a monitoring system like Nagios. Trending graphs from Cacti are also a…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 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…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… needed for OS, File Cache and other applications. For 32bit envinronment you also should keep 32bit limits …a lot of factors). Now you can use “ps aux” to see VSZ – Virtual Memory allocated by MySQL process. You… of swapping – not what you would like to see. Monitor how the value changes so you know …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
…using a script* I put together to make sure I have a consistent snapshot of the MySQL data files…should be able to restore up to before the first DELETE statement above. If you use…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… much more complicated than simply swapping the server. This is exactly…file system level in ZFS. What is about RAID when ? As strange as it may sound but you should… impact and (in particular if you use MySQL Replication for HA) the…. It is also a good question if you need redundant power supplies….
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…a lot of people out where which put it as disk is everything. Remember Paul Tuckfield saying “You should…files on the same partition as well because this makes it very easy to use LVM for backups while assuming you…if there is one) – you do not want your database box to swap actively – if it does your…
Post: Knowing what pt-online-schema-change will do
November 1, 2012 By 1 Comment
…file a…a dry run: Not swapping tables because this is a dry run. Not dropping old table because this is a…a good likelihood that a dry run will reveal them. In summary: before running pt-online-schema-change with –execute, you should…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…should be treated the following way – if you do not allow any access to MySQL Server you…you can use result overload to make MySQL to consume so much memory so it will swap…there is a …used to use disk quotas for MyISAM tables. You can also use similar technique with innodb_file_per_table. However you…
