…5 bearing disks) with 64k stripe unit size and 4k file system block size, here’s how we would create…, 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…
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 10 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…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… Innodb Buffer Pool 10% less than your database size you would not loose…size on the big boxes, though it can be even less than that. Besides Operating System needs you also have MySQL… Note it is not enough to block OS from swapping – as I …hurts – when you do not have RAID with BBU and your workload …
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
…RAID 10 + BBU is probably the most common and natural choice for write stressed servers (ps: I asked about RAM size… would allow exposing this to consumers (although MySQL offers INSERT DELAYED). Back to the subject,…spreads writes to emulate some randomness (wrt block device layout) or is it more of …
