…_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 70 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 38 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 17 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 31 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 …
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… bug on this. So what was performance mysql> select count(*) cnt,c from gt… 5.51 sec) VMSTAT: procs ———–memory———- —swap– —–io—- –system– —–cpu—— r b swpd…performance to avoid OS writes OS Write cache is not as efficient as I would hope, at least on Linux Performance…
