… memory for cache and pushing application to the swap. This causes swapping and causes performance problems. This much is obvious. But how bad… having or is it worse than that ? Swapping is going to impact your performance more than just normal IO and here are… consumption spike you may prefer to see slowdown instead of MySQL being killed because of out of memory but do react…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… these, there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first edition). From… problems might be: is the disk saturated? Is the machine swapping actively? (This is more important than whether it’s using… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… they have” on MySQL UC2008 Scalability Panel ? Indeed disks MAY be the most important part in your system performance or it may… transaction in case your data RAID volume was trashed. Regarding SWAP – I tend to have it but not optimize for it… swap actively – if it does your’re in trouble anyway so it is better to fix the things rather than optimize swap performance…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… write-through mode which can cause serve performance degradation. Configuration Changes Have you changed MySQL configuration ? OS Configuration or Hardware configuration or… good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the… as swapping active and passive masters in Master-Master setup is often cause of the problem for similar reason as MySQL Restart…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… for others it is many month projects. Why is that ? Performing MySQL upgrade two things should normally worry you. It is Regressions… with different result and performance regressions when performance (in a broad sense) is negatively affected. In general even minor MySQL version upgrade can… boxes for time of upgrade. Swapping master. Finally as you have your slave running on new MySQL version you want to promote…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of …consume too much memory and cause the server to swap until it is unresponsive and has to be …that list, there are several others that can be performed with existing plugins, so there was no need …
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… – if you keep swap enabled you may have hard time keeping MySQL in memory because Kernel would love to swap it out. Recent… without swap file. If on the contrary you want to use as much memory as possible to get last bit of performance…. Myself I tend to keep swap enabled on MySQL server but of course ensure there is not swapping happening (si/so columns in…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 70 Comments
… sure you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb… option has some performance benefits, especially in locking in 5.0 and even more to come with MySQL 5.1 and row… these basic innodb performance tunings you will be better of when majority of Innodb users which take MySQL with defaults run it…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… understandable. If you configure MySQL Server so it uses too small amount of memory it will likey perform suboptimally. If you however… be crashing , failing to execute queries or make operation to swap seriously slowing down. On now legacy 32bit platforms you could… MySQL process. You can also look at “Resident Memory” but I find it less helpful as it may down because of swapping…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… can use result overload to make MySQL to consume so much memory so it will swap badly until it runs out of… appropriate operations heavily you can reduce system performance beyond being functional. General Overload As MySQL does not have much of resource utilization… system and wipe off both MySQL and OS caches which can cause other users queries to perform order of magnitude slower than…
