… from one machine to another and configured with Linux network interface bonding in balance-rr mode; this … watch your MySQL server’s memory usage and you see that it’s starting to swap, that might …ever want to use MySQL on top of something like that? I can’t imagine the performance being all …
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
Swapping has always been something bad for MySQL performance but it is even more important for HA systems. It is so important to avoid swapping with HA… most readers of this blog know (or should know) about Linux swappiness setting, which basically controls how important is the file…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…_64 x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 (…there’s a full explanation in our book, High Performance MySQL 2nd Edition (it’s not in the first … be: is the disk saturated? Is the machine swapping actively? (This is more important than whether it…
Post: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
…’re running dedicated MySQL Linux box with plenty of memory, so the good question arises if you should have swap file enabled or… 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 75 Comments
… operating system. We still see people running 32bit Linux on 64bit capable boxes with plenty of memory… OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones…innodb performance tunings you will be better of when majority of Innodb users which take MySQL with …
Post: Impact of the sort buffer size in MySQL
October 25, 2010 By 8 Comments
…Ronald Bradford (here), I decide to verify and benchmark performance while varying the size of the sort_buffer. …verified that during the whole process, the computer never swapped and I pre-warmed the file cache before …Apr 16 09:39:35 UTC 2010 i686 GNU/Linux MySQL: 5.1.41-3ubuntu12.6-log P.S.: …
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… to make MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may have other performance benefits as well. Tuning your VM to be less eager to swap things by echo 0… the swap. Make sure however the swapping is not happening ie your VMSTAT “si/so” columns are zero on Linux. Couple of swaps per…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… (incorrectly) to swap out MySQL. There are two solutions here. Memlock and O_DIRECT. Memlock is apparently unstable on Linux. O_DIRECT is… in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent… you’re scaling out you can get better performance by using couple of MySQL Servers on single node. You can make them…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… configurations. Are there ways to squeeze more performance out of a server by dividing the …Linux swap / Solaris Partition 1 does not end on cylinder boundary. /dev/sda2 * 7813120 27344895 9765888 83 Linux…Linux systems for this to be off? Maybe not, but here’s how you check. We want to use mysql…
Post: Are PHP persistent connections evil ?
November 12, 2006 By 32 Comments
…MySQL others were beaten by older Linux problems of not being able to have more than 1024 connections with MySQL…memory and get crash or have MySQL starting to swap aggressively. This is where connection … could misuse persistent connections and get poor performance that was not the reason. The real …
