…how to run configure command, which needs to be done prior to…mysql‘ ‘–infodir=/usr/share/info’ ‘–includedir=/usr/include’ ‘–mandir=/usr/share/man’ ‘–enable-thread-safe-client’ ‘–with-comment=MySQL Community Edition…to set this to “full_scanâ€, while in order to get only those which use on…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…Community Edition (ICE) images are available in 32 and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on…To get…
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
…to understand about SQL is that it is declarative. That is, you tell the database what you want but not how to get…communication One or more gearman queues are used to…MySQL storage nodes are supported. Amdahl’s law applies to… enabled: ON DUPLICATE KEY UPDATE `origin…_tmp#74082863` ; Edit *MIN…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
…_increment: NULL Create_time: NULL Update_time: NULL Check_time: NULL…, until someone points me how to get real size, and also …on supported distributed syntax or consider changing the InfiniDB Operating Mode (infinidb_vtable_mode). mysql… version: 5.1.39-community InfiniDB Community Edition 0.9.4.0-…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…updated version of the patch. The basic idea is the same as for its predecessor – to get… new edition is free of a tiny bug which was to treat…can see how much time (in seconds) it took InnoDB to …on any important system! The patch is available for MySQL Community 5.0.45 on Linux. May not work on…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
…to actually give Infobright a try. They have an open-source community edition, which is crippled but not enough to…I wanted to see how fast…to; it seemed pretty normal to a MySQL guy. Notes on MonetDB MonetDB was a bit different. I had to be a bit resourceful to get… INSERT/ON DUPLICATE KEY UPDATE.) I…
