… are optimized for Innodb which does have clustering, this is why I have it with Minus sign. In my opinion Optional clustering is… use of Innodb clustering – users mailbox, clustered by (user_id,message_id). [+] Row compression Falcon uses some nice fast row compression methods, for example… not implemented in MySQL anyway though). Very interesting to see how this one will compare to transparent gzip page compression which is…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
…features, even ones such as page compression which were publicly announced before. … Robin also showed some optimized improvements for subqueries in MySQL 6.0 which …MySQL Cluster – for example quite possible their solution could help a lot to shorten latency dealing with MemCache servers etc. MySQL…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… compression that RLE techniques provide. I have not loaded InnoDB compressed tables yet but since InnoDB compression …throughput over response time, get a good plan optimizer-prune-level=0 partition=ON port=3306 … user=mysql wait-timeout=86400 To be continued You can now set up a cluster from …
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… any limitation in resources in a cluster (cpu, memory, disk, power,etc) …speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’…OPTIMIZATIONS: * Base level table name: `aggregation_tmp#74082863` * IN list optimization enabled * Detected an IN list with 2 items * IN list compression…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…MySQL, you will need to aggregate your data. What you want to do is aggregate in ways that optimize…does this have to do with InnoDB? Data clustering. InnoDB’s primary keys define the physical order …files don’t store as compactly on disk as [Compressed] MyISAM or Archive. These are just some ideas …
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
…a gzip compression potentially compresses the database more than just prefix compression. The … reserves different extents from the clustered index. Q4: Does Innodb … PZ: Another possible area of optimization. I frequently see batch …innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_…
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
… however completely separate problem which can be fixed in MySQL 5.1 Data Clustering This again applies to Innodb tables aspect of… process took over 12 hours and is still going. From MySQL status I can see it is loading about 200 rows… do them pretty efficient by using binary compression. Plus they should be stored in optimized sort order to minimize how random they…
Comment: Countless storage engines
May 4, 2007 By 6 Comments
…. In general PBXT seems to be very optimized for Blobs handling and handling long rows in…) Falcon. It is worth to note MySQL official marketing never position MySQL as such per say (for obvious…adequate. Solid also has clustering by primary key and unlike Innodb has key compression (one of major …
Post: Join performance of MyISAM and Innodb
May 29, 2006 By 6 Comments
…very fast as data is clustered together with index and generally highly optimized Innodb builds hash indexes which…and using hash, which is faster MyISAM does compression for character keys which makes it perform …the index, so there is no need for MySQL to request next row matching index Note: This…
