February 22, 2012

Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages

….  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 …

Comment: Modeling InnoDB Scalability on Multi-Core Servers

…: 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…

Post: Is your MySQL Application having Busy IO by Oracle Measures ?

… 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 …

Post: Looking for RAID Controller without Battery Learning problems ?

… 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…

Post: Should we give a MySQL Query Cache a second chance ?

…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…

Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL

…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….

Post: Virident tachIOn: New player on Flash PCI-E cards market

… 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

Post: Level 2 Flash cache is there

… 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 …

Post: Battery Learning still problem many years after

…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…

Post: Percona Server Scales Vertically with Virident tachIOn Drives

… 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….