…to be withing the reason. Connection Related Allocations Another set of buffers correspond to…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: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
…You want to know that when setting parameters for file system but when RAID is configured, there’s nothing more you can do about it – you just need to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…using swap.) There are a lot of combinations of possible things you can see here, so I will not try to explain it all. Basically you need to…which will actually execute the inner subquery!), and examine the query plan. This is where you need to really know how to write queries and…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…to monitor only some of them, as appropriate, and might need to include others as well. Here’s how you can use our new monitoring plugins to…and/or for too little free memory in general. This plugin requires careful configuration because it uses a threshold for which…
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…used most of the time when to spend a lot of money on the server which will be where sitting doing idle. How many spare servers you need – you…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…and Innodb needs to access one of the pages being fetched does it has to wait for whole read ahead request to…a consecutive set of leftmost columns of any index. Can you describe a real-world use case where it would be useful to have a…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
…you might need to deal with RAID recovery every so often. Sometimes because of…which I was setting up/testing at home for use for backups. I got it doing…to do that, in which case they will be zeroed out and your data potentially corrupted. This is why I prefer to know files…
