Wow, I pulled all the 300GB drives out of my MySQL servers years ago. I don’t need the space of… as fast as older SSDs. But the newer SSDs are as big, and much faster than the 300GB HDDs, on MySQL type loads.
Comment: ZFS on Linux and MySQL
June 7, 2013 By 17 Comments
… not hitting a bottleneck caused by compression. If I use SSD for L2ARC, I’ll need to do the same for… you posted. It is not an easy move for a MySQL dba to steal 20GB memory from the Innodb buffer pool…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… different sets of MySQL configuration parameters. For example, given that the front-end device is a very fast PCIe SSD, would it make more sense to configure MySQL as if it were using SSD storage or to just…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run…
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 flash card is still massively faster than an SSD, both in terms of throughput and in terms of latency…, but there’s a comparison in TPCC-MySQL performance between that card and a traditional SSD – the PCIe card is about 3x…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on….2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor_pages = none innodb… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… to provide the highest read throughput of any server-grade SSD, and at Micron’s request, I recently took some time… latency just over 3ms. How well does it perform with MySQL? Exact results vary, depending upon the usual factors (read/write… compare the performance of the P320h on a standard TPCC-MySQL test to the original FusionIO and the Intel i910 with…
Comment: Testing the Micron P320h
April 16, 2013 By 7 Comments
… you recommend EXT4 over XFS for MySQL on SSD? What about Btrfs or ZFS? Seems like with SSD the newer file systems could…
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
… look what a lifetime we can expect under a tpcc-mysql workload. I put 32 users threads against 5000W dataset (about…/sec, which corresponds to write throughput 273.45MB/sec from MySQL to disk. And it helps to calculate the lifetime of… what your throughput will be when you put workload on SSD. (function() { var po = document.createElement(‘script’); po.type = ‘text/javascript…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… already know that benchmarks are unrealistic, and we know that SSDs would win. I’d rather look at real systems and see how they behave. Are the theoretical advantages of SSDs really a big advantage in practice? I will show the… ratio for the database as compared to a handful of SSDs (or traditional disks, for that matter, which would show writes…
Post: MySQL and SSD | Percona XtraDB Cluster talks
September 13, 2012 By Leave a Comment
… for MySQL“. I will give introduction in MySQL clustering and show how Percona XtraDB Cluster solves HA and scalability problems. MySQL and SSD: usage and tuning. If you follow this blog, you know that I do quite a bit experiments with SSD / Flash… Rate prices end this Saturday. If you are working with MySQL and you are in New York on 1-2 Sep…
