…, which stores data, like this comment. In this case it might be helpful to compress this table to save some storage and do not have a big performance hit. That’s why Facebook has their own InnoDB compression, which is available in MySQL 5.6. So we may test MySQL 5.6 more to see what kind…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… more sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? After creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL (configuration… be the case where a deployment has a massive data set size in relation to both the working set and the cache…
Comment: Percona Server 5.5.30 with TokuDB for MySQL
April 29, 2013 By 26 Comments
… TokuDB for MySQL or TokuDB for MariaDB, I consistently get failure in ./configure: CMake Error: The following variables are used in this project… “tokudb” in directory /data/tmp/mariadb-5.5.30-tokudb-7.0.1/storage/tokudb TOKUPORTABILITY_LIB linked by target “tokudb” in directory /data/tmp…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… SSD is an SLC-based PCIe solid-state storage device which claims to provide the highest read …let’s take a look at the data. With the sysbench fileIO test in asynchronous mode, read performance is … For example, in the graph below we compare the performance of the P320h on a standard TPCC-MySQL test …
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
What does working with large data sets in mySQL teach you ? Of course you have to learn a lot … working with large data things in MySQL is patience and careful planning. Both of which relate two single property of large data sets – it… TABLE make take days or even weeks depending on your storage engine and set of indexes, Batch Jobs can take quite…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… need to run storage powerful enough to achieve this. In MySQL world we very often run our CPUs very underutilized while storage is completely…. Finally at MySQL we often start “sharding” or splitting data other way because operationally working with large table and data sizes in MySQL can be…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
… in Conversions – Each storage engine has its own data storage format so MySQL has to do a lot of copying and conversions while accessing the data… being run for different storage engines, but really this is not enough as MySQL allows you using multiple storage engines in the query you…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…in MySQL have very large number of queries doing updates through primary key and use primary key for selects. I believe in…Storage Engines MySQL Query Cache now stores queries in local memory, which is great however memory amount might be limited especially in…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
… stored on the row page. This decision also causes strange data storage “bugs” – you can store 200K BLOB easily, however you can… external storage. May be one day we’ll come to implementing this in XtraDB 
So BLOB storage was not very efficient in REDUNDANT (MySQL 4.1 and below) and COMPACT (MySQL 5.0 and…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… in many cases MySQL is not used to process the data, at least not on the large scale – instead it is used for data storage and light duty data retrieval. Even in this case however the cache (ie memcache) is often implemented to offload MySQL. When… node. May be MySQL Cluster will evolve and data storage nodes will be able to perform all kinds of operations, in which case it…
