… X5650 @2.7GHz, 96GB of RAM and a very fast LSI MegaRaid backed storage with SSD Cache. Aurimas worked on that machine…
Comment: Virident vCache vs. FlashCache: Part 1
May 17, 2013 By 3 Comments
… it becomes the bottleneck. Also, keep in mind that while SSDs are a lot faster than regular spinning disk, a PCIe… in TPCC-MySQL performance between that card and a traditional SSD – the PCIe card is about 3x faster. By using a… in memory (not actual RAM, that’s true, but much closer to memory speed than a regular SSD or HDD RAID), I…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…(R) CPU E5-2450 0 @ 2.10GHz, 48GB of RAM and SATA SSD: Kingston HyperX 3K 240 GB. Workload: I will use… easily fill TokuDB tables with 1bln of rows on this SSD, and projected InnoDB performance on this size will be the…/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
The point at 685 sec when InnoDB performance drops, is that when data doesn’t fit all in RAM anymore? I would in general expect to see benefits from TokuDB when workload is diskbound. You could artificially reduce InnoDB buffer pool (and corresponding Tokutek setting) to have more SSD vs RAM.
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
The Micron P320h SSD is an SLC-based PCIe solid-state storage device which … to provide the highest read throughput of any server-grade SSD, and at Micron’s request, I recently took some time… were performed primarily on a Dell R720 with 192GB of RAM and two Xeon E5-2660 processors that yield a total…
Post: Testing the Virident FlashMAX II
March 21, 2013 By 1 Comment
… test results from the Virident FlashMax 1400M, an MLC PCIe SSD device. Since that time, Virident has released the FlashMAX II… benchmarks were performed on a Dell R710 with 192GB of RAM. This is a dual-socket Xeon E5-2660 machine with…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… performance by about five times (or 2x with an Intel SSD). To get the same improvement with memory, you would… easily add another 32G RAM (are your memory slots already filled?) Does your budget allow to install SSD cards? (You may still… are already appliances on the market which use 8 Intel SSD devices). Is a 2x or 5x improvement enough? There…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
February 7, 2012 By 57 Comments
… sql_calc_rows on a high traffic large server (16gb ram ssd, yada yada, high availability setup with multiple slaves, etc) and…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… algorithm. I’m also wondering if you would recommend using SSD for this purpose, and how much performance gain there might… that the number varied more, depending on the availability of RAM? On a dedicated server for Mysql you will still need… running (monitoring, backup, cron, syslog, etc). But the ratio of RAM used for these non-mysql processes drops rapidly when you…
Comment: Heikki Tuuri answers to Innodb questions, Part II
November 7, 2007 By 13 Comments
… to Q34 about SSD. There are vendors that have onboard RAM cache incorporated into their SSD. The first vendor of SSD we looked at… onboard RAM cache. We are planning on benchmarking this. So I wouldn’t offload my log files to SSD unless the SSD incorporated an onboard RAM cache. Otherwise, as Peter and Heiki say…
