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: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in…(R) CPU E5-2450 0 @ 2.10GHz, 48GB of RAM and SATA SSD: Kingston HyperX 3K 240 GB. Workload: I will use…/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb_adaptive_flushing_method = keep…
Post: Testing the Virident FlashMAX II
March 21, 2013 By 1 Comment
… from the Virident FlashMax 1400M, an MLC PCIe SSD device. Since that time, Virident has released the … performed on a Dell R710 with 192GB of RAM. This is a dual-socket Xeon E5-2660 …we see a read throughput of approximately 2580MiB/sec vs. 1450MiB/sec with the previous generation of hardware, …
Post: Is there benefit from having more memory ?
November 19, 2010 By 10 Comments
….mysqlperformanceblog.com/2010/04/08/fast-ssd-or-more-memory/, caused quite interest, especially on topic SSD vs Memory. That time I used… with 120GB ( as if you have system with 128GB of RAM) and 250GB Buffer_poolread-only, tpsread-write, tps 120GB1866.872547… memory, and it is possible as nowadays systems with 300GB+ RAM already available.
Post: FusionIO - time for benchmarks
December 8, 2009 By 10 Comments
I posted about FusionIO couple times RAID vs SSD vs FusionIO and Testing FusionIO: strict_sync is too strict…. The … fully understand how it works internally (FusionIO does not have RAM on board and takes memory from host, so there is… we can see only 130MB/sec max throughput. Write bandwidth vs filesize: So there I tested how filesize (fill factor) affects…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…1.xx. PZ: I should note MySQL 5.0 vs 4.1 has a lot of performance differences … I’m also wondering if you would recommend using SSD for this purpose, and how much performance gain …(monitoring, backup, cron, syslog, etc). But the ratio of RAM used for these non-mysql processes drops rapidly when…
Post: read_ahead (disabled) as steroid
May 12, 2009 By 4 Comments
… referral program ? ), with RAID10 (8 disks) on ext3, 32GB of RAM. As you see there almost no difference and you may…. For curiosity I run the same benchmarks on ext3 vs xfs on SSD card, the results are: Interesting facts: – xfs is 25% faster ext3 – the gaps on SSD is more visible than on RAID10 – in the same time…
Post: Full Text Search Webinar Questions Followup
August 24, 2012 By 5 Comments
… to increase innodb_buffer_pool_size to 50% of my RAM, and then when I tested MyISAM FT index, I reallocated… 7 tower with an Intel i3 processor, 8GB of RAM, and two SSD drives: one for the Windows partition, and one for… blog post where I announced the webinar: We evaluated MySQL vs Solr. I was able to index all the data from…
