…as the cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating system, although…configuration parameters. For example, given that the front-end device is a very fast PCIe SSD, would it…and combine that with the fact that the best vCache performance results were obtained with the …
Post: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… for space purposes. In this configuration using 600GB disk, we can get 5.5T of useful space Intel drives: Intel 320 SSD 600GB HDD drives: Seagate Cheetah 15K 600GB 16MB Cache SAS Filesystem: XFS, mkfs.xfs -s size=4096, mount -o nobarrier Benchmark: For… allows us to see the best possible scenario for SSD running under MySQL, the final result will show the best possible gain. I do…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… Filesystem mounted with nobarrier option. Tests run with: RAID10 with BBU over 8 disks Intel SSD X25-E 32GB FusionIO 320GB MLC For… arrow is when data fits completely in the buffer pool (best performance). It’s important to point out that once you… I would suggest that adding memory is by far the best thing to do here. The C arrow shows where data…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…AIO. These can also be rendered useless by filesystems that don’t allow parallel writing to the…’ designed for SSD type storage. Running Percona Server and using this method is my go-to setting for managing Checkpoint age. To be clear, the best we have today (IMO)…
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… get the best results using the standard intel host controller which has 6 SATA ports. 4) Switch on AHCI for the disk… formatting to match the SSD (see here: http://thunk.org/tytso/blog/2009/02/20/aligning-filesystems-to-an-ssds-erase-block-size… caches innodb_flush_method=O_DIRECT 9) We get the best results with filepertable. Especially if you find your tables fragment…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…filesystem and SysBench tool. Using 16K read sizes (matches Innodb page size) I could get 1.2GB/sec (80K req/sec) for…Innodb team will put on their roadmap. With SSD coming this will be important. And it …as much data in buffer pool as possible for best performance. Hopefully some time in the future I…
