June 18, 2013

Post: Quick look at Ubuntu 6.06

… of talks around new coming Ubuntu 6.06, so I decided to make quick benchmarks. I used sysbench 0.4.6 oltp… per sec, more is better): InnoDB threads Ubuntu 6.06 Suse 10.0 Suse/ Ubuntu ratio 1 478.66 536.91 1….30 357.09 1.04 MyISAM threads Ubuntu 6.06 Suse 10.0 Suse / Ubuntu ration 1 466.13 429.89 0…

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

… was disabled. The tool I used was sysbench 0.4.10 that came with this Ubuntu system. I have run every fileio… spike in OS buffers during “prepare” phase of sysbench. I found out that sysbench would not honor –file-extra-flags during “prepare… Kopytov fixed this in the sysbench trunk immediately, though I didn’t want to recompile sysbench on this system so I’ve…

Post: Virtualization and IO Modes = Extra Complexity

…_DIRECT and fsync() single page writes to 1MB file using SysBench on Ubuntu, ext4 running on VirtualBox 4.0.4 running on…. I’m however getting rather bizarre results: Using fsync() pz@ubuntu:~/test$ sysbench –num-threads=1 –test=fileio –file-num=1 –file…. Now lest see how it looks using O_DIRECT pz@ubuntu:~/test$ sysbench –num-threads=1 –test=fileio –file-num=1 –file…

Post: FlashCache: more benchmarks

… to standard for filesystems 4K blocks. For benchmark I used sysbench oltp with 300 mln rows, which gives about 70GB of… are there http://www.percona.com/docs/wiki/benchmark:flashcache:sysbench:300mln_rows:start And short results: buffer_pool, GBRAID10 FlashCache…-194.el5.tar.gz http://percona.com/downloads/TESTING/FlashCache/ubuntu.10.04.kernel-2.6.32-21-server.tar.gz…

Post: NILFS - may be not yet

… quick tests to see how it performs. Installation on our Ubuntu 8.10 with SSD disk (Intel X25-E, 32GB) was… 8; do echo PARAMS $size $mode $threads > sysbench-size-$size-mode-$mode-threads-$threads ./sysbench –test=fileio –file-total-size=$size –file… –file-fsync-freq=0 run \ >> sysbench-size-$size-mode-$mode-threads-$threads 2>&1 done ./sysbench –test=fileio –file-total-size=$size…

Post: Is MySQL 5.6 slower than MySQL 5.5?

… results without spending too much time on it. I used Ubuntu 12.04 on some old Dell PowerEdge 2850 server. The… or lower with high concurrency compared to single thread ? Note Sysbench is simple enough it does not take advantage of any….6 performance. Here is Sysbench command I used: root@dpe01:/mnt/data/sandboxes/msb_5_6_10# sysbench –test=oltp –mysql-socket…

Post: Percona Server and XtraBackup weekly news, March 5th

… March 9th. This should also update the Maverick repository for Ubuntu users. If you’re waiting for the innodb_lazy_drop… fcntl() calls. This has been shown to double throughput on sysbench benchmarks. News for XtraBackup: Alexey reports that implementation of the…