Percona's MySQL & InnoDB performance and scalability blog
…. Sequential IO trumps Random IO.
However, even today in our modern flash storage world where random IO is significantly less expensive (from a …we see about Innodb log checkpointing and what does it tell us?
mysql> SHOW ENGINE INNODB STATUS\G
—
LOG
—
Log sequence number 9682004056
Log …
…: disabled
120131 16:00:43 [Note] Flashcache setup error is : open flash device failed
120131 16:00:43 [Note] Plugin ‘FEDERATED’ is disabled.
…; log sequence number 1604009568
120131 16:00:44 [ERROR] /usr/local/mysql/bin/mysqld: unknown variable ‘innodb-adaptive-hash-partitions=8′
120131 16:00…
… applications busy from IOPs numbers, especially now when we easily can get Flash storage which allows to get well over 10K IOPS without going to … and this whitepapers you can get a lot better performance with multiple MySQL instances on powerful storage. When you move to multiple instances and …
… have been written about Battery Learning Cycle problems and its impact to MySQL Performance. Here are couple of links (1,2). It is good to…(Zero-Maintenance Cache Protection) does not use battery but instead Capacitor plus flash. Capacitor provides enough energy for contents of DRAM to be flushed to…
…would allow one to use local memory, Memcache or for example local flash storage for storage.
Compression You can see it as a property …Cache to make it cool again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources to…
…solid-state storage — specifically, the Virident tachIOn drive — has more bandwidth than MySQL can fully utilize at present. Therefore, to decrease the price-to-… done.
You can read the full details in our Scaling MySQL With Virident Flash Drives and Multiple Instances of Percona Server white paper….
… reflects our opinion)
In my talk on MySQL Conference and Expo 2010 “An Overview of Flash Storage for Databases” I mentioned that most …I can highlight:
I am impressed with architecture design with replaceable individual flash modules, I think it establishes new high-end standard for flash …
… Paul Saab and Mohan Srinivasan from Facebook released Flashcache, which allows to use Flash as cache in front of regular hard drives.
The implementation is based …://code.google.com/p/david-mysql-tools/wiki/innodb_secondary_buffer_pool, it allows to use a file on Flash partitions as L2 cache for …
…auto learning go many years back. We wrote about it, other people from MySQL Community too. The situation did not get better, at least not with …Innodb transaction logs.
I’m also wondering if this is something where Facebook Flash Cache can be helpful – if it can act instead of hardware BBU…
… how to stop sharding and start scaling vertically with PCI-E flash drives, specifically the Virident tachIOn drive, which offers consistent, low-latency IO… “Scaling up” is once again a viable and economical strategy for MySQL, and “scaling out” need no longer be the default database architecture….
Copyright © Percona Inc. • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.