MySQL Users Conference 2008 has number of Storage Engines presented which claim to Kick Ass. Walking in exhibition hall … makes it hard to get independent product evaluation. Many of storage engines will indeed offer you benefits they promise but, but you…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…with existing MySQL data sets and queries. Another advantage is that it works with all MySQL storage engines. This … rewritten to conform to the new schema, and additionally two new test queries have been added. …using (date_id) WHERE Year BETWEEN 2000 AND 2008 GROUP BY DayOfWeek ORDER BY c DESC; — …
Post: MySQL and IBM
April 6, 2009 By 17 Comments
…MYSQL_STORAGE_ENGINE([ibmdb2i], [], [IBM DB2 for i Storage Engine], [IBM DB2 for i Storage Engine], [max,max-no-ndb]) MYSQL…Storage Engine Enablement Copyright IBM Corporation 2007,2008…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… was something new but it was good to hear about release plans for MySQL 5.1 (Q1 2008) and MySQL 6.0 (Q4 2008) – which… default transactional storage engine in MySQL 6.0 – I did not truly understand if it will be recommended transactional storage engine or just default storage engine will…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…how to get it. Most distributed engines work with rows. They break …speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s … to the source query. Adding a new storage node SQL dialect is almost trivial…date_id where dim_date.Year IN (2008,2009) group by 1; –PARALLEL OPTIMIZATIONS: …
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 3 Comments
… lack of these features in the MEMORY storage engine (also known as HEAP) in MySQL has been one of the long-standing limitations… variable-length records were not supported by the engine. This is true for all MySQL versions, including the latest 5.6 development… when using this new feature (and these points are probably the reason why it was not included in MySQL in 2008): The key…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…new binary to be as close to the original one as possible (e.g. to have the same set of storage engines…storage-engine‘ ‘–with-federated-storage-engine‘ ‘–without-bench’ ‘–with-zlib-dir=bundled’ ‘–with-big-tables’ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…combined together for efficient storage: CREATE TABLE `bbool` ( `b1` bit(…ENGINE=MyISAM mysql> show table status like ‘bbool’ \G *************************** 1. row *************************** Name: bbool Engine…_increment: NULL Create_time: 2008-04-24 00:… base approach for new applications. However in…
