June 18, 2013

Comment: ZFS on Linux and MySQL

… don’t think the Linux port is that inferior to make a sizeable difference. Seems very consistent with Solaris at least. @Raghavendra… gzip-6. I may have found the main performance bottleneck (benchmark in progress), if I am right, I’ll write another…

Post: Interesting MySQL and PostgreSQL Benchmarks

… better on this picture Linux vs Solaris comparison is also pretty interesting. With MySQL Linux has higher peak but Solaris suffers less with increased concurrency. Note: I have not validated these benchmarks and as I…

Post: MyISAM mmap feature (5.1)

… OS is not always good in this task, my benchmarks show Linux/Solaris aren’t scalable on intensive pread calls (I believe the…/pwrite functions. To approve effectiveness of memory mapping several benchmarks: For benchmarks I used the sysbench tool and tested different workloads: SELECT…

Post: Aligning IO on a hard disk RAID – the Theory

… the partition table. On the system that I have been benchmarking, defaults worked out just fine because I was using a… /dev/sda1 * 2048 19531775 9764864 83 Linux /dev/sda2 19531776 27920383 4194304 82 Linux swap / Solaris Partition 2 does not end on cylinder… 19535039 9767488+ 83 Linux /dev/sda2 19535040 27342629 3903795 82 Linux swap / Solaris /dev/sda3 27342630 2339835119 1156246245 8e Linux LVM sda1 and sda3…

Post: thread_concurrency doesn't do what you expect

…it does nothing on GNU/Linux :) Some of the biggest GNU/Linux distributions includes the variable thread…only works on old Solaris versions < 9 The idea of thread_concurrency for Solaris is using thr_… benefits. As we always say, set up benchmark tests to identify which tuning parameters provide …

Post: Heikki Tuuri answers to Innodb questions, Part II

… and it well can affect your workload. So benchmark to be sure. In Innodb besides scalability changes … 16Gig help the write performance of Innodb on Solaris? HT: Yes, if your ‘write working set’ fits … of system memory. We just deployed a new Linux/Mysql server for a client, upgrading their main …

Post: Intel Woodcrest vs AMD Opteron for MySQL

… match to Opteron performance in MySQL workloads. As benchmark used in this article is very different from … As you can see MySQL could be slower on Linux with many connections with increasing number of CPUs. …it looks like it is not the case with Solaris. The scalability is not perfect but at least …

Post: Setting up XFS on Hardware RAID -- the simple edition

… 7813119 3905536 82 Linux swap / Solaris Partition 1 does not end on cylinder boundary. /dev/sda2 * 7813120 27344895 9765888 83 Linux /dev/sda3 27344896 856422399 414538752 83 Linux… good benchmarks to emphasize the point, go read those if you need the theory here.  Is it common on modern Linux systems…

Post: Alternatives of PHP ?

… – Fast in terms of performance and development – multiplatform, at least Linux, Windows, Solaris necessary – under active development and wide community – web binding… impressive me So I went to The Computer Language Shootout Benchmarks and walked through wide list of proposed languages: D, Ocaml…

Post: Box for some tests anyone ?

… makes it not good for benchmark. Could anyone lend us access to the box with at least 4 cores running Linux or Solaris ?