…you for honest acknowledgment and I can’t wait to get hold of further improved versions. Q9: Do you…A read-ahead of a 64 page extent is often done as a single 1 MB file read. PZ: “often” a…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
…_log_file_size – This depends on your recovery speed needs but 256M seems to be a good … reduce swap pressure, in most cases this setting improves performance. Though be careful if you do not have battery backed up RAID cache as when write IO may suffer. innodb_file_per_table – If you do…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…jobs to delete old files in /tmp can do the same thing. If the PID file is missing, then…A runaway server process, or poorly optimized queries, can consume too much memory and cause the server to swap… and help us improve them. If you are a customer and you need help configuring any of the plugins, we…
Comment: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
…a swap partition on disk – On boot, we create a small RAM disk and create a swapfile on it Why on earth do we do…have told me that you need to have at least a handful of MBs …a tiny amount of RAM (like 32MB or something like that) for swap. Yes, I realize how crazy using RAM->RAM disk->swap file->swap…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…only to 1%. So what could you do instead ? First take a look at global buffers which are …easily computed by memory needed for OS, File Cache and other applications. For 32bit envinronment you also should …because of swapping – not what you would like to see. Monitor how the value changes so you know …
Comment: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 10, 2010 By 48 Comments
… memory-mapped files upon need to store them. Indices live as long as needed and their … indeed uses more swap-space then other systems do. A rule of thumb is to have a swap-space …you have instructed the other systems to explicitly check the constraints. For example, to add an ALTER statement after a…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
…and automated handling in mind as Google File System. In particular you want to make sure Error …and make recovery much more complicated than simply swapping the server. This is exactly one of …a lot of money on the server which will be where sitting doing idle. How many spare servers you need – you…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
…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…do not even know you need to check MyISAM tables after crash and have been running for years survining many crashes. If you…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
…you can use result overload to make MySQL to consume so much memory so it will swap… – Happily now there is a limit on total number …You can also use similar technique with innodb_file_per_table. However you…do updates – Innodb only can purge data after oldest transactions needing snapshot commits. You…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…to do this without death-by-swapping, which would be extremely slow on this machine, so we need …RW-latch at 0x2aaaae0b70b8 created in file btr0sea.c line 139 a writer (thread id 1158064464) has …1158064464 which has reserved it. If you hunt through the TRANSACTIONS section, you can see the OS thread…
