… comparison. Given the apparent differences in time-based flushing in vCache and FlashCache, both cache devices were set up so that time-based… volume where the dirty ratio is only 10%, such as might be the case where a deployment has a massive data set size in relation to both the working set and the cache device…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… names explain their content. Index id in our example is 1679: mysql> SELECT * FROM SYS_FIELDS WHERE INDEX_ID = 1679; +———-+—–+———-+ | INDEX_ID…_id` SMALLINT UNSIGNED NOT NULL, `first_name` VARCHAR(45) CHARACTER SET ‘utf8′ COLLATE ‘utf8_general_ci’ NOT NULL, `last_name` VARCHAR…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 2, 2013 By 10 Comments
…, I would like to see that as well, in my mind, the cache settings allow for two distinctly different modes of operation and use cases. ‘innodb_only’ appears to be handlersocket like, where it… is ‘innodb_only’ which is something to keep in mind. Mike, what setting did you use for your benchmark? based on this…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… is to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query result…/cmd 0.0802 ms range per/cmd Keep in mind that the entire data set fits into the buffer pool, so there… * FROM memcached.container WHERE id=’key_id’”); id is PK of the container table While there are increases in both operations, there…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… of the swapping issues but… I recently ended up in a situation where, after having done all that, a server was swapping… was causing the problem. It happened that the setting vm.dirty_ratio was set to 20 on a 48GB server, allowing nearly….dirty_bytes”, but keep in mind that only one is used; setting one to a non-zero value sets the other to zero.
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… a mixed cluster where some have SSL and some do not. This is best configured when you are setting up a new… default Other questions Will IST be encrypted if I set the above settings? Yes, according to Codership, IST transfers use the same… difficult to add. We’d welcome some open source contribution in this space for encrypted versions of (or just enhancements to…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… feature-set comparison between vCache and FlashCache and also to conduct some benchmarks for the use case where the MySQL working set is…; vCache does not. This is something that could prove useful in certain situations. Winner: FlashCache. Operational Monitoring: Both solutions offer plenty…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
… to come from licenses – OEM licenses. I do not know where this number is now but it is not zero. We… software as there is no choice. I think this is where the advantages of TokuDB might have not been enough as… to the large data sets you will not see large benefits. The Cloud might change a lot in this game on many…
Comment: Implications of Metadata Locking Changes in MySQL 5.5
March 27, 2013 By 9 Comments
… from going through. So you are facing a different scenario in that you have row locks blocking the ALTER, while the… by setting innodb_lock_wait_timeout to 1 and then issuing the ALTER: — session 1 start transaction; select * from t1 where id=3 for update; — session 2 set innodb_lock_wait_timeout=1; alter table…
Comment: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… is to put some data in flash and much more data on disk. Where/what are the disks in this benchmark? The benchmark… much larger than the flashdevice with a working set that doesn’t completely fit in flash. So you need a database that…
