… | . . . +——————————+————+ 18 rows in set (0.00 sec) mysql> SET expand_fast_index_creation=ON; Query OK, 0 rows affected (0.00… an almost 8x speedup. having tmpdir on a fast storage is essential for expand_fast_index_creation, because temporary files for merge-sorting…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… what room we now have to scale up – cheap memory, fast storage, better power efficiency. There certainly are a lot of… would have preferred to buy memory instead, and use the storage device for writes. Here’s the benchmark I came up…). To start with, we have a test on the RAID10 storage to establish a baseline. The Y axis is transactions…
Post: InnoDB, InnoDB-plugin vs XtraDB on fast storage
January 13, 2010 By 12 Comments
…) on my workhourse Dell PowerEdge R900 ( details about box ). On storage configuration: FusionIO 160GB SLC and 320GB MLC cards are configured…
Post: Countless storage engines
May 3, 2007 By 6 Comments
… bought InnoDB, MySQL did one step – announced MySQL supports Plugginable Storage Architecture. In that time nobody was able to predict what…, but currently we all see it. Let me list Transactional Storage Engines I heard of on Conference and main impression about… marketing materials: NitroEDB The engine promises to handle in very fast way aggregative functions on massive data sets. As I understood…
Comment: How much overhead DRDB could cause ?
May 19, 2009 By 4 Comments
…… ………. “If you’re looking for less overhead for DRBD with fast storage (ie BBU) you should be looking at low latency network… we have used DRBD with Dolphin Interconnect/Fast Storage (using our new PCI Express based flash storage product called StorExpress). The combination of… set of block sizes. Dolphin Interconnect along with StorExpress based storage provides the best replication performance for DRBD. For more details…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… chance to take look TokuDB (the name of the Tokutek storage engine), and run some benchmarks. Tuning of TokuDB is much… case, as TokuDB is a disk-based, read-write transactional storage engine that is based on special “fractal tree indexesâ… decompress big portion of data. – Despite Inserts and Deletes are fast, updates are not expected to show the same performance gain…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… opinion this however should have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical order… (user_id,message_id). [+] Row compression Falcon uses some nice fast row compression methods, for example using only as many bytes… changing default value needs table rebuild even though for other storage engines it often could be done simply by changing meta…
Post: Trying Archive Storage Engine
November 12, 2006 By 6 Comments
… I thought it is great to try how much archive storage engine could help me in this case. Original Table: *************************** 1… gzip. I wish Archive storage engine would specify archiving method and compression level. Some people may like fast compression while others would… by MyISAM. Summary: Archive storage engine does compresses your data and should be good for log storage or storing something which needs…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… may need 4GB+ log files to get more performance on fast storage systems SHOW TEMPORARY TABLES, patch from Venu Anuganti INFORMATION_SCHEMA… it is right now: Performance improvements Improved buffer_pool scalability Fast recovery Improved IO path Improved rollback segment scalability Separate purge…
Post: MySQL: Data Storage or Data Processing
November 18, 2007 By 9 Comments
… on the large scale – instead it is used for data storage and light duty data retrieval. Even in this case however… not minutes used processing your request, but you get reply fast because hundreds and thousands of CPUs were handling data for… Cluster at this point is a cluster in terms of Storage – only minor aspects such as data filtering can be offloaded…
