…have removed some irrelevant information): # Aspersa System Summary Report ############################## Platform | Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | 2.6…benchmark As the goal was to compare performance with different IO alignment, not different MySQL configurations, I didn’t try …
Post: Percona Server tree with support of Fusion-io atomic writes and DirectFS
September 24, 2012 By Leave a Comment
… Linux filesystems: ext4 and xfs. This requires a support from application, it should use special calls for IO. With help from Fusion-io…-doublewrite”, retain ACID compliance by using atomic writes, and in IO intensive workloads gain an additional 30-50% in throughput when… reduction expected soon. Percona Server 5.5.27 with Fusion-io atomic writes is available from Launchpad repository: lp:~percona-core…
Post: XtraDB benchmarks - 1.5X gain in IO-bound load
December 18, 2008 By 30 Comments
…_size = 2G and innodb_flush_method=O_DIRECT to emulate IO bound load. InnoDB parameters: innodb_additional_mem_pool_size = 16M… = 2G innodb_data_file_path = ibdata1:10M:autoextend innodb_file_io_threads = 4 innodb_thread_concurrency = 16 innodb_flush_log_at… just giant one. And it is important to remember as Linux kernels 2.6.18+ (which are used on CentOS / RedHat…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
….05 System | Supermicro; PDSMi; v0123456789 (Other) Service Tag | 0123456789 Platform | Linux Release | Ubuntu 12.04.1 LTS (precise) Kernel | 3.2… should be getting very close numbers for buffered and unbuffered IO for read only workloads, if anything unbuffered performance should be… very valuable addition. MySQL 5.6 has more changes in IO code including what should be much improved read-ahead and…
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… –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…
Post: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
I mentioned earlier that IO scheduler CFQ coming by default in RedHat / CentOS 5.x … reported that just changing cfq to noop solved their InnoDB IO problems. I ran tpcc scripts against XtraDB on our Dell…_flush_method = O_DIRECT innodb_write_io_threads=4 innodb_read_io_threads=4 innodb_io_capacity=800 innodb_adaptive_checkpoint=1 max…
Post: Fusion-io atomic writes and DirectFS
September 20, 2012 By Leave a Comment
Not so far ago Fusion-io announced SDK which provides direct API access to Fusion ioMemory(… goal to avoid overhead from kernel and regular Linux filesystems: ext4 and xfs. Fusion-io will explain these features during our Percona… too late to register for conference and talk with Fusion-io engineers directly. “PerconaNY” registration will give you 15% discount…
Comment: Is there room for more MySQL IO Optimization?
January 10, 2013 By 11 Comments
Hi Peter, what I meant about buffered I/O on Linux: – reads are fine (as data prefetch on FS is usually… MySQL server start taking over 40min for ex. just because Linux was slow to decide which page to remove from FS… http://dimitrik.free.fr/blog/archives/2012/11/mysql-performance-linux-io-and-fusionio-part-2.html for details).. And in most…
Comment: Linux schedulers in tpcc like benchmark
January 30, 2009 By 19 Comments
I have detailed why this happens at http://dammit.lt/2008/02/05/linux-io-schedulers/ – though it all started simply when we compared how I/O behaves on identical machines ( http://dammit.lt/2007/12/13/io-scheduler-deadline-cfq/ )
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… End Blocks Id System /dev/sda1 2048 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 Several months ago my colleague Aurimas posted two excellent blogs on both the theory of Aligning IO on hardware…
