Wlad These SSD reviews of yours are just superb. My favourite on the MySQL Performace blog! You can also do a review on the best available hardware raid-sets and give your advise.
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 54 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: Intel 320 SSD random write performance
June 23, 2011 By 1 Comment
I have posted results for Intel 320 SSD on our ssdperformanceblog.com blog. To not duplicate content, there is link on original post:http://www.ssdperformanceblog.com/2011/06/intel-320-ssd-random-write-performance/ Follow my twitter @VadimTk for further results.
Post: My talks on PL MySQL Conference (+free book inside)
February 14, 2012 By Leave a Comment
…. There I will cover XtraDB Cluster features and usage scenarios. MySQL and SSD: usage and tuning. This talk I’ve been giving…-hall to chat on all kind of topics related to MySQL, XtraBackup, XtraDB Cluster, etc. More interesting, by the time of conference we will have published our new book: High Performance MySQL: Optimization, Backups, Replication, and More If you plan to attend…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… a cadre of the core MySQL developers to submit talks about what is new in MySQL, the MySQL roadmap for the future, and…, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, Big Data, SSD storage, data warehousing…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
… and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
… cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD versus…
Post: RAID vs SSD vs FusionIO
May 1, 2009 By 17 Comments
… all three devices (RAID was on board; Intel X25-E SSD connected to HighPoint controller, FusionIO card) on our working horse… IO-bound workload on all devices. For tests I used MySQL 5.4/InnoDB, and all other parameters are the same… (see my post http://www.mysqlperformanceblog.com/2009/03/02/ssd-xfs-lvm-fsync-write-cache-barrier-and-lost-transactions/). While…
