… async IO mode. There are two reasons for that. First, MySQL/InnoDB uses async writes, so this will emulate database load… threads): It seems that InnoDB is not alone with its flashing problems. You can see there periodical stalls in throughput (0… you are interested more in SSD and MySQL questions – I will be giving a webinary “MySQL and SSD” on May-9. It…
Post: Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
March 13, 2012 By 5 Comments
… leverage flash-based storage solutions in MySQL environments Evaluation criteria and techniques for selecting the suitable flash-storage technology for the relevant MySQL workloads Price/performance advantages (ROI) when flash storage is used appropriately for MySQL workloads Approaches for scaling MySQL…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… from IOPs numbers, especially now when we easily can get Flash storage which allows to get well over 10K IOPS without… external storage. 500MB/sec would be exceptional for traditional MySQL as MySQL optimizer with its nested loops joins does not favor sequential… is to continue to be significant difference between MySQL and Oracle deployments, yet as MySQL is getting better and better handling large…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so it is lockless… one to use local memory, Memcache or for example local flash storage for storage. Compression You can see it as a… make it cool again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
…, is that as you add CPUs and increase memory size, MySQL doesn’t scale as well as we would like, and… storage — specifically, the Virident tachIOn drive — has more bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price…. You can read the full details in our Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server white paper…
Post: Virident tachIOn: New player on Flash PCI-E cards market
June 15, 2010 By 19 Comments
… reflects our opinion) In my talk on MySQL Conference and Expo 2010 “An Overview of Flash Storage for Databases” I mentioned that…, but taken from vendor’s specification) As for power failures – flash modules also come with capacitors which guarantees data delivery to… highlight: I am impressed with architecture design with replaceable individual flash modules, I think it establishes new high-end standard for…
Post: Level 2 Flash cache is there
April 27, 2010 By 5 Comments
… two years already. It is also described in ACM article “Flash storage memory” by Adam Leventhal. So I am exciting to… Mohan Srinivasan from Facebook released Flashcache, which allows to use Flash as cache in front of regular hard drives. The implementation….google.com/p/david-mysql-tools/wiki/innodb_secondary_buffer_pool, it allows to use a file on Flash partitions as L2…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 7 Comments
… Learning Cycle problems and its impact to MySQL Performance. Here are couple of links (1,2…-0 (18252) Driver : 1.1-5 (24702) Boot Flash : 5.2-0 (18252) ——————————————————– Controller ZMM Information ——————————————————– Status …
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… many years back. We wrote about it, other people from MySQL Community too. The situation did not get better, at least… use capacitor instead and bundle 512MB cache with 512MB of Flash so when power goes down the cache is stored on… done without server restart with Innodb Plugin, Percona Server and MySQL 5.5. Note it might also be good to increase…
Post: Percona Server Scales Vertically with Virident tachIOn Drives
February 28, 2011 By Leave a Comment
… to stop sharding and start scaling vertically with PCI-E flash drives, specifically the Virident tachIOn drive, which offers consistent, low… great feeling to have an explicitly recommended reference architecture: buy flash storage first, shard as a last resort. From the summary… up” is once again a viable and economical strategy for MySQL, and “scaling out” need no longer be the default database…
