… centers, one with Solaris servers and the other one with Linux servers. The Solaris side is cleverly setup using zones and… got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux is available and there… are free, no performance penalty. You can easily run a server with hundreds of snapshots. With LVM, your IO performance drops to 33…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…’t like DRBD with virtual machines. First is the disk IO performance hit that comes with DRBD. When you run a virtual… actual physical volume. So, in effect, you’re adding performance hit to performance hit. The other reason is because virtual machines tend… directly connected from one machine to another and configured with Linux network interface bonding in balance-rr mode; this is the…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we…Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] …4096 #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… been something bad for MySQL performance but it is even more important for HA …of this blog know (or should know) about Linux swappiness setting, which basically controls how important …:03:22 UTC 2013 procs ———–memory———- —swap– —–io—- –system– —–cpu—– Fri Mar 22 10:03:…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…open-source, free MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases….. If there are thousands of tables and slow IO then XtraBackup can spend a lot of … Bug fixed #1169726. For the Debian and the Linux binaries, the –version message which should include the…
Post: Linux IO Schedulers and MySQL
January 30, 2007 By 7 Comments
Found a great article about Linux IO Schedulers today which is quite interesting. It goes in details … was not really significant. This article also points out benchmarking IO schedulers you should look at more numbers than aggregate bandwidth… results for example. It also means you’d better to perform IO scheduler benchmarks on mixed load with different of task, for…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… next graphs show the frequency of IO, and you can see we can get more IO performance with the new patches. Then, how… can parallelize IO accesses to several disks. This patch enables to control the number of the IO threads on Unix/Linux and makes…: size” (like > 1000) may tend to losing the performance. If you have powerful IO system, you might set bigger values. innodb_ibuf…
Post: Disaster: LVM Performance in Snapshot Mode
February 5, 2009 By 55 Comments
…. I used sysbench fileio test as our concern is general IO performance in this case – it is not something MySQL related. I… 159 io/sec which is quite expected for single thread and no BBU. With LVM snapshot enabled the performance was 25 io/sec… might know O_DIRECT often executes quite special path in Linux kernel so I did couple of other runs. First run…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
…-XtraDB template to run in RightScale environment, I noticed that IO performance on EBS volume in EC2 cloud is not quite perfect… –raid-devices=2 /dev/md0 /dev/md1 And also in Linux you can create tricky RAID10,f2 (you can read what… from the results is that if you are looking for IO performance in EC2/EBS environment it’s definitely worth to consider…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… some irrelevant information): # Aspersa System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | …performance improvement is marginal however WB cache brings single thread random write performance close to what 8 threads can do, and IO…
