… data+indexes) XFS Filesystem mounted with nobarrier option. Tests run with: RAID10 with BBU over 8 disks Intel SSD X25-E 32GB… 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: Benchmarks of Intel 320 SSD 600GB
February 22, 2012 By 2 Comments
… have a chance to test a system with Intel 320 SSD drives (NewRelic provided me with an access to the server… space Intel drives: Intel 320 SSD 600GB HDD drives: Seagate Cheetah 15K 600GB 16MB Cache SAS Filesystem: XFS, mkfs.xfs -s size… us to see the best possible scenario for SSD running under MySQL, the final result will show the best possible gain. I do…
Comment: 5.0.83-build17 Percona binaries
August 6, 2009 By 19 Comments
… throughput, even the PCI-E x8 variants. We get the best results using the standard intel host controller which has 6… 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
…Quad Core Xeon running CentOS5 was tested using ext2 filesystem and SysBench tool. Using 16K read sizes (matches … Innodb team will put on their roadmap. With SSD coming this will be important. And it is… this workload avoiding to avoid contention. In the best conditions I got about 13.5K queries/sec …
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…AIO. These can also be rendered useless by filesystems that don’t allow parallel writing to the…’estimate’ (good default) and ‘keep_average’ designed for SSD type storage. Running Percona Server and using …for managing Checkpoint age. To be clear, the best we have today (IMO) is using innodb_…
