Alain,
I am not sure what to you mean by “performance of SSD drive with MySQL“, but I may try to interpreter it as
Performance of MySQL on SSD against HDD.
In this case yes, generally the MySQL performance on SSD is better.
Comment: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
February 15, 2012 By 15 Comments
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 4 Comments
… we see about Innodb log checkpointing and what does it tell us?
mysql> SHOW ENGINE INNODB STATUS\G
—
LOG
—
Log sequence number 9682004056
Log … here would be ‘estimate’ (good default) and ‘keep_average’ designed for SSD type storage. Running Percona Server and using this method is my go-…
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 for few … time of conference we will have published our new book:
High Performance MySQL: Optimization, Backups, Replication, and More
If you plan to attend conference, …
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… a while back that we were going to continue the traditional MySQL conference in Santa Clara, because O’Reilly wasn’t doing it …, security, using MySQL with NoSQL, geospatial functionality, cloud computing, Cluster, search, sharding, memcached, high availability, DevOps, Big Data, SSD storage, data …
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 6 Comments
… have been written about Battery Learning Cycle problems and its impact to MySQL Performance. Here are couple of links (1,2). It is good … hard drive connections they provide.
Some Newer Adaptec Controllers also offer using SSD as a cache with technology called MaxIQ. Namely Adaptec 5805ZQ might …
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
…libeat-my-data for a reason.
Without libeatmydata and using the default options for the MySQL test suite, I noticed that I was only creating about 10-15 tables every… language that’s for sure). After a “I’m glad this isn’t a SSD” killer amount of fsync() activity, it took a total of 14.5 minutes. …
Post: Benchmarks of new innodb_flush_neighbor_pages
January 17, 2012 By 6 Comments
…_flush_neighbor_pages also accepts values “area” (default) and “none” (recommended for SSD).
What kind of effect does it have ? Let’s run some benchmarks… with default innodb_flush_neighbor_pages, Percona Server has smaller dips than MySQL.
So this is to show effect of “sync fix”, let’s compare…
Comment: Benchmarks of new innodb_flush_neighbor_pages
January 17, 2012 By 6 Comments
… flushing algorithm it is never ending battle.
I am sure even we have SSD storage, and a lot of memory, say ~2TB, then
we may see such … in this configuration. Such configuration is however a far-far future for most MySQL deployments,
so I hope by that time we will have decent flushing algorithm …
Comment: Fast storage: 8 SSD Intel X-25M 80GB benchmarks
February 15, 2012 By 15 Comments
Hi vadim,
thanks for putting ou those test.
I was wondering though. Do you consider the performance of SSD drive with Mysql better than regular HDD?
(seems like a too basic question may be, sorry 
Thanks a lot
Alain
Post: MLC SSD card lifetime and write amplification
November 15, 2011 By 8 Comments
… as Write Amplification, which is very well described on WikiPedia, but basically SSD cards, due an internal organization, write more data than it comes from…,500 deletes/sec, which corresponds to
write throughput 273.45MB/sec from MySQL to disk.
And it helps to calculate the lifetime of the card…
