… Inodes per group: 2048 Inode blocks per group: 128 RAID stride: 8 RAID stripe width: 80 Flex block group size: 16 Filesystem… is not worth tradeoff. Even more if you’re running Innodb chances are you will not buy you more “up time” either as Innodb is very sensitive to corruptions and if any of file system errors are reported back to MySQL/Innodb it will…
Post: The perils of uniform hardware and RAID auto-learn cycles
November 16, 2010 By 16 Comments
… went sharply up, the buffer pool got more dirty pages, InnoDB started creating more pages, and the percentage of dirty pages… the buffer pool went up. In addition, samples of SHOW INNODB STATUS showed a long pending flush list (hundreds), and usually… simultaneously pretty recently. I asked the customer to check the RAID controller quickly on one of the failing machines. The result…
Post: MySQL Users Conference Presentation Proposals
October 24, 2007 By 12 Comments
… with MySQL. MySQL Performance Landscape This presentation compares MySQL Performance with different CPUs, Operation systems, RAID Configuration…MySQL – Innodb, Falcon, SolidDB, PBXT and analyzing how things have changed since last summer. Using Slave Server Without Breaking User Experience MySQL…
Post: Intel SSD 910 vs HDD RAID in tpcc-mysql benchmark
September 11, 2012 By 6 Comments
… HDD RAID, but the result is taken only for last 1h to remove warm-up phase Parameters to vary: we vary innodb…. Or in text form: BP sizeHDD RAIDIntel SSD 910Ratio (i910/raid) 25 GB22816207.1 50 GB55231825.76 75 GB109457295.24 So…: the card of itself or MySQL internals + flushing logic. Now, all these results are received with innodb_flush_log_at_trx_commit…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… showing benchmark results on Amazon EC2 servers with RAID‘ed EBS volumes and MySQL, versus RDS machines. For reasons that won’t… inside InnoDB, or to the Threads_running SHOW STATUS counter, without much loss of generality. The Amazon cloud platform with a RAID… performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to get…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… say you have a server with standard hardware RAID setup running conventional HDDs. RAID setup For the sake of simplicity you create… /var/lib/mysql into here when you setup mysql) Are there alternatives? Yes. Can you have separate partitions for Innodb log volumes, etc… sectors fit in a RAID stripe. 65536 / 512 = 128 sectors per stripe. Get start boundary of our mysql partition from fdisk: 27344896…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… it, other people from MySQL Community too. The situation did not get better, at least not with Dell RAID controllers, H700 and… Dell product line ? (Which is using LSI chips) Are there RAID controllers which do not have this problem ? For many installations… server restart with Innodb Plugin, Percona Server and MySQL 5.5. Note it might also be good to increase innodb_write_io_threads…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… little known new features in MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty… group commit being broken. Most do not have RAID with BBU. With good RAID with BBU you can get 2000 fsync/sec… serialization. MySQL‘s binlog and InnoDB‘s log must have the transactions in the same order, for a recovery based on MySQL‘s…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend? I’ve been staying at 4.1… and sequential which can be very well taken care of RAID Battery Backed Up cache and when sequentially written to the… this matter the other day – choosing innodb_buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
…And sysbench uses 16KB pagesize to emulate work of InnoDB with 16KB pagesize. Raw results you may find … environment it’s definitely worth to consider some RAID setup. RAID5 does not show benefits comparing with … from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may…
