…size and 4k file system block size, here’s how we would create the file system: xfs – mkfs.xfs -b size… let’s assume we have a RAID with 256k stripe element size and a misalignment in partition table – … Recent systems like RHEL6 (not verified) and Ubuntu 10.04 (verified) would by default align to 1MB…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – Scale Factor 1 – Mysql 5.5 …BLOCKS_TIME=0 INNODB_OLD_BLOCKS_TIME=1000 *************************** 1. row ************************************************ 1. row ******* POOL_ID: 0 * POOL_ID: 0 POOL_SIZE: 8192 * POOL_SIZE…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…size including indexes which is way more than buffer pool size…MySQL has about data which will be accessed next – in case of full table scan, index scans etc the information about blocks…RAID…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
… finish file size(MB) Per Char Block Rewrite Per Char Block RAID 10, LVM 16000 83 173 120 101 1670 1629 9’42” RAID 10 16000 88 178 167 97 2777 1630 9’31” RAID… finally chose RAID 5 + LVM for MySQL server. I chose RAID 5 instead of RAID 10 since I didn’t see much gain from RAID 10 in…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…size (minimum/optimal): 512 bytes / 512 bytes Disk identifier: 0x00051fe9 Device Boot Start End Blocks…RAID stripe. 65536 / 512 = 128 sectors per stripe. Get start boundary of our mysql…
Post: FlashCache: more benchmarks
May 18, 2010 By 15 Comments
… and FlashCache. As developers recommend to have 16KB block size in XFS and 16KB block size in FlashCache, I was not able to make it working, there too many moving parts – it’s XFS alignment by RAID… full scripts and mysql config files are on Wiki page). There are binaries for CentOS 5.5 and Ubuntu 10.04 if…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
… stack up and other things block against them. If you create a RAID volume over many EBS volumes, …performance with the combination of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able … bound by either the working set size versus the buffer pool size, or the sheer volume of I/…
Post: Living with backups
November 6, 2008 By 28 Comments
…even with the fastest drives or RAID configurations, the performance gains are … from MySQL data directory will result in a total disaster after MySQL … the file system block size, so usually it means the size has to …Threads_connected”‘); … if ($$row[1] < 10) { $is_running= 1; } if ($$row[1] > 50)…
Post: How much overhead DRDB could cause ?
June 2, 2008 By 4 Comments
…and configuration) more synchronous IO operations – MySQL binary logs are not preallocated … round trip size to send 4096 bytes of data (typical block size for filesystem… overhead can be well below 10% The problem is however such …backed up unit) on your hardware RAID card or something which has same…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…blocking…RAID…mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size…
