…_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: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… results without spending too much time on it. I used Ubuntu 12.04 on some old Dell PowerEdge 2850 server. The… is Sysbench command I used: root@dpe01:/mnt/data/sandboxes/msb_5_6_10# sysbench –test=oltp –mysql-socket=/tmp/mysql_sandbox5610.sock –mysql-user=msandbox_rw –mysql-password=msandbox –oltp-table-size…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… 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… performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. Moreover, I have…
Post: Quick look at Ubuntu 6.06
June 13, 2006 By 3 Comments
… of talks around new coming Ubuntu 6.06, so I decided to make quick benchmarks. I used sysbench 0.4.6 oltp… if we are using the same version of MySQL. So I used MySQL 5.0.22 and my box Dual Core Athlon… per sec, more is better): InnoDB threads Ubuntu 6.06 Suse 10.0 Suse/ Ubuntu ratio 1 478.66 536.91 1…
Post: Percona Server and XtraBackup weekly news, March 5th
March 6, 2011 By Leave a Comment
… MySQL 5.1.55, which we estimate will be released on March 9th. This should also update the Maverick repository for Ubuntu… fcntl() calls. This has been shown to double throughput on sysbench benchmarks. News for XtraBackup: Alexey reports that implementation of the…. We have decided to make innobackupex always back up the MySQL system database, even for partial backups; it contains data that…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… 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… full scripts and mysql config files are on Wiki page). There are binaries for CentOS 5.5 and Ubuntu 10.04 if…
