… IO configuration I chose 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL… used: ## InnoDB options innodb_buffer_pool_size = 55G innodb_log_file_size = 1G innodb_log_files_in_group = 4 innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb…
Post: fsyncs on software raid on FusionIO
March 23, 2010 By 6 Comments
… relies on OS tools there. So for Linux we have software RAID and LVM, I tried to followup on my post How… LVM on cards, so I’ve finished tests only for software RAID0 and RAID1. I used XFS filesystem mounted with “-o… seems we can’t use innodb transactional log files with innodb_flush_log_at_trx_commit=1 on software RAID1 over FusionIO. For…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 13 Comments
… as device in your OS, so you can easily make software RAID from several volumes. So I created 4 volumes ( I used…-write). And sysbench uses 16KB pagesize to emulate work of InnoDB with 16KB pagesize. Raw results you may find in Google… EC2/EBS environment it’s definitely worth to consider some RAID setup. RAID5 does not show benefits comparing with others, and…
Post: Innodb Double Write
August 4, 2006 By 23 Comments
One of very interesting techniques Innodb uses is technique called “doublewrite” It means Innodb will write data twice when it performs table… if software RAID is used page may come on the stripe border requiring multiple IO requests. Same happens with Hardware RAID on power… term log file allocated inside Innodb tablespace – it contains space for 100 pages. When Innodb flushes pages from Innodb buffer pool it does…
Post: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
January 18, 2010 By 15 Comments
… (software) each card connected as individual card to Adaptec, so in OS we see 8 individual cards. Card configured in software RAIDs: RAID0… some serialization in Linux software raid or Linux scheduler or on Adaptec hardware level. 2. Cards connected in hardware raids show worse results… your load requires sequential writes (e.g. like I put InnoDB transactional logs on rotation based drives instead of SSD in…
Post: Review of Virident FlashMAX MLC cards
November 10, 2011 By 14 Comments
… needs to use a software RAID. For Virident all 1400GB shows up as one single drive so no software RAID is necessary. To compare… for two settings. I tested combinations of innodb_buffer_pool_size=120GB, 174GB and innodb_flush_log_at_trx_commit=1, 2… results in this post are for case innodb_buffer_pool_size=174GB and innodb_flush_log_at_trx_commit=1 As in…
Post: How multiple disks can benefit for single client workload ?
April 26, 2008 By 4 Comments
…. Let us first look how single query is executed for Innodb storage engine to be more specific. Lets look at update… request can only be issued after previous request is completed. Innodb tries to optimize these reads a bit – there is sequential… RAID level for write intensive database systems, you will have 2 hard drives to pick reading any block. RAID controller (and even software RAID…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… which can be very well taken care of RAID Battery Backed Up cache and when sequentially written… go with SCSI interface both in hardware and software. I’m still surprised with databases being so … up in “show innodb statusâ€. select * from table where id=5 show innodb status: Hash table size …
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… update to make sure its 3) Make sure you use software raid. Raid cards these days are rarely as good as linux in… writes to the log files are. innodb_log_group_home_dir=/var/lib/mysqlnonssd/ innodb_log_arch_dir=/var/lib/mysqlnonssd/ 8… filepertable. Especially if you find your tables fragment a lot. innodb_file_per_table=1 I’m sure other people can…
Comment: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
…! Though if partition table is aligned properly, after you create software RAID, there’s little difference what is the physical sector size… – while this depends a lot on the workload and the RAID controller, I think it’s fine to have a relatively… (but not smaller than your working block size – 16k in InnoDB by default). When misaligned, larger stripe may make a bit…
